SQLite has 1 main issue for me specifically: it is written in C++ so if I try and ship an OSS tool which uses SQLite, there's a chance that users of the tool will be unable to build the SQLite portions. This brought me to SQL.js, but there I found that the entire DB is held in-memory, which defeats the purpose of having a DB in the first place from my perspective. I wish someone would have a SQL.js alternative which actually writes to disk instead of storing everything in-memory.
But SQLite is already available for many platforms and if a client asks you for a new platform you can compile it for that too: sqlite.org/download.html
Programming languages enthusiast. Author of Learn Type Driven Development: https://www.packtpub.com/application-development/learn-type-driven-development
SQLite has 1 main issue for me specifically: it is written in C++ so if I try and ship an OSS tool which uses SQLite, there's a chance that users of the tool will be unable to build the SQLite portions. This brought me to SQL.js, but there I found that the entire DB is held in-memory, which defeats the purpose of having a DB in the first place from my perspective. I wish someone would have a SQL.js alternative which actually writes to disk instead of storing everything in-memory.
What if you ship SQLite precompiled with the tool you distribute?
You you compile SQLite you have to compile it for a specific platform. I wouldn't be able to anticipate all the possible client platforms.
But SQLite is already available for many platforms and if a client asks you for a new platform you can compile it for that too: sqlite.org/download.html
Would that work?
SQLite is written in C, not C++. sqlite.org/whyc.html