3 ms·
SQLite isn't a replacement for postgresql (or vice versa). SQLite is a replacement for fopen. Among its many advantages in that situation: a database is contai
by dnr 13y ago
SQLite isn't a replacement for postgresql (or vice versa). SQLite is a replacement for fopen.
Among its many advantages in that situation: a database is contained in a single file with minimal overhead, the source is shipped as one .c file and encouraged to be statically linked, and the code size is relatively small (compared to something like postgresql).
- mamcx 13y agoI hope sqlite someday add functions and/or store procedures. Plus better error messages (like when a foreign key is violated)
- kevingadd 13y agoWhy exactly do you need stored procedures in sqlite? You can just write code. Are you using it in a scenario where you can't write code to interact with sqlite?
- mamcx 13y agoFor the same reason are used in others DBs. Some things are better expressed in the DB native language. Help to abstract and share implementation of DBs that are used by different languages.