News for hackers. Stuff that matters.
Re:The database I wish I had by dgrin91 on Monday August 31, 2020 @10:01PM (#24337819)
> An embedded, immutable, syncable relational database.

Sounds like he wants a blockchain?

A blockchain probably isn't really what OP wants. But funnily enough it does meet all those criteria.

> what I’m after is a database to be embedded on client-side applications itself, be it desktop, browser, mobile, etc. Thats how most Blockchain clients work - on the client side, with APIs (usually RPCs) to chat with other programs

> Being immutable means that only new information is added, no in-place update ever happens, and nothing is ever deleted.

Immutability is exactly what blockchains were designed for.

> Syncable

Since blockchains are decentralized by nature, this also comes out of the box.

Of course if you choose a blockchain you have to deal with a host of other issues... performance, no SQL (in most clients), harder to debug, etc. But still a fun thought experiment

Re:The database I wish I had by haggy on Monday August 31, 2020 @10:10PM (#24337872)
How is blockchain relational?
Re:The database I wish I had by xvolter on Monday August 31, 2020 @10:21PM (#24337932)
I do not think it is.

Blockchains are meant as a data store. Archival, verifiable. But not easily searchable. There is no design on blockchain for advanced query languages/logic.

It seems like the OP is going after something like blockchain that adds querying. But I don't think blockchain syncing is designed well enough for client-side use, and the OP seems to want to use this database client-side in JavaScript. I think it would be possible to implement blockchain syncing with WebRTC, but WebRTC has some security risks for users (IP leakage mostly) so I am not sure I would start off with that as a primary communication channel.

Re:The database I wish I had by dgrin91 on Tuesday September 01, 2020 @05:20PM (#24347213)
Most blockchain clients have a DB with a cached version of the chain. This is typically done with a typical, off the shelf DB. For example Bitcoin Core uses LevelDB, but other implementations use SQL lite.

As I said at the end, blockchain isn't really what OP wants. It meets his requirements mostly via technicalities.

Re:The database I wish I had by tdonovic on Tuesday September 01, 2020 @02:28AM (#24339075)
Hyperledger fabric gets around this by storing a copy of the data up to the last block in some other db, like couchDB. That way, you get (supposedly) the best of both worlds