Conversation

Each file would have varying schema. Or: calling a database a "file" does not make it not a database
Quote Tweet
Replying to @ben_mathes @gordonbrander and @stefanomaz
There is a gradual line between "Files with proper metadata" and "a database". A database has the potential to be much more seamless but also much more locked down and inflexible. Files are the QWERTY keyboards of data, they are just good enough
1
2
I'm mostly thinking this: twitter.com/andy_matuschak and also how SQLite is considered a long-term archival format for data by the US Library of Congress. sqlite.org/locrsf.html
Quote Tweet
Maybe someday automerge’s serialization format will be as durable and universal as SQLite’s, but in the meantime, it’s certainly not amenable to casual concurrent local access in some user script.
Show this thread
1
1
Point well made, and well taken. I've read your post so I know where you're coming from. I suppose I'm just playing around with this idea that we need not worry so much about designing file formats — which is difficult! — if we just use SQLite + a plain txt schema + versioning.
1