we sanitize during the serialization to string, i'd like to think of it as an issue of serialization to string format and not an issue of our in-memory data structures i.e (-> some-obj json/generate-string strip-unicode-nulls)

Does anyone know when it’s right to reuse connections with SQLite? Some sources say don’t reuse, some say do, hard to find like a definitive answer that weighs the pros and cons

SQLite doesn’t actually have connections, does it? It’s just opening a file?

IIRC, you can read concurrently from sqlite, but writing concurrently may be dangerous.

Concurrency largely depends on the journal_mode used as far as I understand

But yeah, I’m not sure how the concept of connections maps to SQLite at all 🙈

At the risk of remembering wrong, I think you can have even multiple processes accessing SQLite concurrently.

I’ve used SQLite in the past from Python etc, which was using of course the C api. I’m not sure how SQLite is used from JVM…

I would highly recommend looking at one of the jvm embedded databases like derby over using sqlite from the jvm

the sqlite jdbc driver situation may have improved recently (I am not sure), but it was really bad at one point

regardless of if sqlite could support concurrent access, the jdbc driver wouldn't let you do that at one point