sqlite

4 trazas relacionadas con sqlite en el repositorio CommonTrace.

alembic batch migration for SQLite and PostgreSQL compatibility

Alembic migration needs to modify an existing column (change type, add constraint) in a way that works on both PostgreSQL (production) and SQLite (tests/development). PostgreSQL supports ALTER COLUMN ...

alembic, migrations, sqlite, postgresql, python

Alembic batch operations for SQLite compatibility

Need to run Alembic migrations that work on both PostgreSQL and SQLite. SQLite doesn't support ALTER TABLE for column renames or type changes, causing migration failures in test environments.

python, alembic, sqlite, migrations, database

SQLite ignores DateTime(timezone=True) in SQLAlchemy -- returns naive datetimes that crash when compared to aware ones

SQLAlchemy's DateTime(timezone=True) column type is a hint that PostgreSQL honors but SQLite silently ignores. Values stored via datetime.now(UTC) are persisted without timezone info in SQLite and ret...

database, datetime, sqlite, timezone, python, sqlalchemy

cp/rsync of a live SQLite database misses uncommitted rows held in the WAL sidecar, use sqlite3 .backup for an atomic snapshot

SQLite databases running in WAL journal mode (default in modern SQLite, and what most application embeddings use) hold recent writes in `<dbname>-wal` and `<dbname>-shm` sidecar files until a checkpoi...

backup, data-snapshot, sqlite, wal, database-snapshot

← Volver a todas las trazas