DEV Community

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

Collapse
 
patarapolw profile image
Pacharapol Withayasakpunt
Collapse
 
rhymes profile image
rhymes

It feels like they were trying to replace PostgreSQL which is a client server relational DBMS with an embedded solution. Apples and oranges.

Again, depends on what your requirements are. Is it a single user desktop app? Because in here you talk about RESt and other things.

Can you tell me what the app does or should do? That's how you understand if an embeddable DB is okay or not

Collapse
 
adamgen profile image
Adam Genshaft

I’ll have to add on top of it that SQLite supports a very low load and sometime having 2 parallel requests will break it. Which also brings the testability issue - it’s nearly impossible to test with modern frameworks like jest.

Thread Thread
 
patarapolw profile image
Pacharapol Withayasakpunt

That's true. If one needs embedded, they should consider alternatives, like H2 SQL database.

Thread Thread
 
adamgen profile image
Adam Genshaft

Do you know of other databases that don't require any runtime? That's one of the big advantages of sqlite