DEV Community

loading...

Discussion on: A stable alternative to SQLite for offline desktop app?

Collapse
alexleung profile image
Alex Leung

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.

Collapse
rhymes profile image
rhymes

What if you ship SQLite precompiled with the tool you distribute?

Thread Thread
alexleung profile image
Alex Leung

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.

Thread Thread
rhymes profile image
rhymes

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?