Remix.run Logo
radarroark 2 days ago

People are slow to realize the benefit of immutable databases, but it is happening. It's not just auditability; immutable databases can also allow concurrent reads while writes are happening, fast cloning of data structures, and fast undo of transactions.

The ones you mentioned are large backend databases, but I'm working on an "immutable SQLite"...a single file immutable database that is embedded and works as a library: https://github.com/radarroark/xitdb-java

SahAssar a day ago | parent | next [-]

How do you deal with deletion requirements in a immutable database? Like how do you delete personal data when requested?

radarroark 10 hours ago | parent | next [-]

The fastest approach is to just zero out the data. Alternatively you can rebuild the entire database while preserving only the data accessible in the latest copy of the db (kinda similar to SQLite's VACUUM command).

mwarkentin a day ago | parent | prev [-]

Crypto shredding?

j16sdiz a day ago | parent | prev [-]

Are there any new big research/development in immutable database?

I know they are great... but i don't see many news around them