DEV Community

Pacharapol Withayasakpunt
Pacharapol Withayasakpunt

Posted on

What's your embedded database of choice?

For stability (i.e. ACID), it used to be SQLite. But SQLite has an issue that is bugging me -- case-insensitive LIKE (or case-sensitive only for ASCII).

Later on, I have found that h2 database which indeed (supposed to) can only normally run through JVM's JDBC, can also run in server mode, as well as there are bindings in Python and Node.js.

But I chose to code in JVM (using Kotlin)...

I also know that there is embedded Neo4j, only in JVM.

Discussion (1)

pjotre86 profile image

For sql databases I think h2 is probably really the most used one.

Are you looking for something to use in production or do you want to use it for development/testing?