News for hackers. Stuff that matters.
Re:In Praise of PostgreSQL by mdaniel on Thursday August 05, 2021 @05:23PM (#28080066)
It most certainly is not just in-memory; it can do in-memory, but also has file and server options: https://h2database.com/html/features.html#connection_modes

Exact same story for its HyperSQL and Derby friends: http://hsqldb.org/doc/2.0/guide/running-chapt.html#rgc_hsqld... https://db.apache.org/derby/#What+is+Apache+Derby%3F

Re:In Praise of PostgreSQL by 411111111111111 on Saturday August 07, 2021 @02:47AM (#28096365)
It's jdbc only, with the main usage being in-memory.

Redis is considered an in memory store as well, even though it can persist it's data on disk too. And the capability isn't what makes it in-memory either, as you can store a SQLite db only in-memory too, and nobody would consider it to be an in-memory database. You could technically do the same for PostgreSQL, though that's not officially supported and needs a little effort on the users part.

I guess my phrasing was poor if you misunderstood me there, but I do stand by what I said: while H2 is a great project in Java-Land, it's very different to what I understood the parents goal to be.