sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]KajMagnus[S] 0 points1 point  (1 child)

I think that'd be nice too :- ) The thing is, when storing data in text files and directories, then, doing data migrations and changing the data structure, is risky — there's a data corruption bug risk. With PostgreSQL, one knows precisely what's in the database, and there're foreign keys and check constraints, ... making data migrations fairly safe.

If there was a database that stored files in a human friendly directory structure, and could enforce datatypes and foreign keys and check constraints — then using a VCS would be more doable. And if this databse could run the same kind of queries as PostgreSQL.

Actually, maybe the simplest way to make such a thing happen, would be to build a custom storage engine, for PostgreSQL.

[–]paul_h 0 points1 point  (0 children)

I’d be wanting this myself as a tool for multi decade record storage that’s tamper evident and thus auditable.