🔍
sqlitedatabasesqlmigrationschema

Schema Migration Script for SQLite to Rename and Change Column Type

Rename SQLite columns and change data types safely with migration scripts. Step-by-step guide with backup strategies. Preserve existing data during schema changes.

29-Jan-2024 Read more →
sqlitedatabasemigrationssqlzero-downtime

Zero-downtime Database Migrations in SQLite

Learn zero-downtime SQLite migrations with expand-migrate-contract pattern. Step-by-step guide with SQL examples. Keep your app running during schema changes.

16-Jan-2024 Read more →
sqlitedatabasesqldatetime

Dealing with datetime in SQLite

Handle datetime in SQLite efficiently with Unix epoch timestamps. Save storage space and convert to local timezone when needed. Complete examples included.

15-Jan-2024 Read more →
pythonsqlitesqlalchemybcryptsecurity

Store Password Securely in SQLite: Python, SQLAlchemy, and Bcrypt

Shielding User Passwords: Safeguarding SQLite Databases with Robust Encryption

9-Jul-2023 Read more →