loading...

What's your embedded database of choice?

patarapolw profile image Pacharapol Withayasakpunt ・1 min read

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

pic
Editor guide
Collapse
pjotre86 profile image
pjotre86

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?