Embedding Postgres/MySQL is a bad idea, they're huge and designed specifically not to be embedded. There are other embedded databases besides SQLite, but you should state exactly what your issue is with SQLite.

SQLite doesn't enforce column datatypes. The code has to enforce the datatypes, which is error-prone.

Not used yet, but Sugar ORM might help when interacting with the SQLLite by automatically creating tables and query generation.

tarhalda‭ Is enforcing types the only problem, or are there others?

matthewsnyder‭ that's the main issue for my current application. I've also had issues with reading and writing simultaneously causing the database to lock instead of queuing the read.

Hmm. Well, I would solve the concurrency issue by something like a semaphore (I assume you have multiple threads here). SQLite also supports write-ahead logging to deal with concurrent writes (I haven't used WAL though).

The typing I would solve by handling types in my app. If you are using an ORM that should take care of types.

I get that you've made up your mind that you want to look for something else though :)

If the lacking type rigidity is your main grip you might be interested in strict tables supported since sqlite 3.37.0 which enforce their column's type on any insert.

@cafce25 that would solve my problem, thank you!