Open azertyfun opened 6 years ago
The project currently uses SQLite as its database engine, however according to Katharine it will likely use Postgres in prod.
This means that we have to change (at the very least) all the data types (as SQLite only uses NULL, INTEGER, REAL, TEXT and BLOB).
NULL
INTEGER
REAL
TEXT
BLOB
We should also consider how to implement schema changes in the future.
PostgreSQL PR at #37
azertyfun
commented
6 years ago azertyfun
commented
6 years ago
The project currently uses SQLite as its database engine, however according to Katharine it will likely use Postgres in prod.
This means that we have to change (at the very least) all the data types (as SQLite only uses
NULL,INTEGER,REAL,TEXTandBLOB).We should also consider how to implement schema changes in the future.