3 ms·
Not really a problem if you go from sqlite to postgres. Which sqlite feature is missing from Postgres?
by victorbjorklund 3y ago
Not really a problem if you go from sqlite to postgres. Which sqlite feature is missing from
Postgres?
- cnity 3y agoThis is saying: "just don't try to solve hard data storage problems". Not all applications are CRUD.
- dns_snek 3y agoYou're missing the point. Most software doesn't need to scale or solve hard data storage problems, and if it ends up having to, you can always upgrade to Postgres with minimal effort. That makes SQLite an attractive option if you won't immediately benefit from Postgres' rich features.
- cnity 3y agoWe're just going to be speaking past each other, I think. GP clearly stated they lean heavily on Postgres technologies (by calling out specifics like pgvector). Stating that the applications that don't need those technologies, indeed don't need them, is tautological!
- SJC_Hacker 3y agoAll SQLite queries are not just going to straight up work in Postgres. e.g handling of dates is a big one. In SQLite they are just strings(kludgy IMO), where as Postgres has the timestamp data type.