Hctree is an experimental high-concurrency database back end for SQLite

Re:Hctree is an experimental high-concurrency database back ... by switchbak on Wednesday January 18, 2023 @09:26PM (#34436017)

I use an embedded postgres testing library for the JVM that does something along those lines.

Well no actually it just unpacks the tar file in a temp dir and runs the full postgres, but it mostly feels like what you describe (minus the single file part) and starts surprisingly fast. That would totally work for a little proof of concept (https://github.com/zonkyio/embedded-postgres)

[ Parent | on HN ]

Re:Hctree is an experimental high-concurrency database back ... by hot_gril on Wednesday January 18, 2023 @09:45PM (#34436141)

That's pretty neat, but not the same level of portability as SQLite.

[ Parent | on HN ]

Re:Hctree is an experimental high-concurrency database back ... by prpl on Thursday January 19, 2023 @01:00AM (#34437192)

I used hypersql/hsqldb for unit tests. The Oracle mode was usually close enough. It’s pretty close for postgres. Sometimes there’s small issues (I think using “INSERT INTO … RETURNING” required column name in caps for some reason) but overall it’s almost always what you want for unit testing with java.

[ Parent | on HN ]

Re:Hctree is an experimental high-concurrency database back ... by kitd on Thursday January 19, 2023 @03:28AM (#34438001)

H2db has a Postgres-compatibility mode too that would work for local testing.

https://www.h2database.com/html/features.html#compatibility

[ Parent | on HN ]