What don't you like about SQLite views or foreign keys?
For example you can’t insert or update a SQLite view.
I don’t even think SQLite lets you fully update a table schema.
If you start trying to use it for sql and not just storing rows you run into these everywhere. SQLite is not serving the same needs as Postgres.
alt Hacker News
For example you can’t insert or update a SQLite view.
I don’t even think SQLite lets you fully update a table schema.
If you start trying to use it for sql and not just storing rows you run into these everywhere. SQLite is not serving the same needs as Postgres.