3 ms·
I am sensing some interesting capabilities here, but also get the impression that this is more about denormalized views of data (JSON/CSV/etc) than anything els
by bob1029 6y ago
I am sensing some interesting capabilities here, but also get the impression that this is more about denormalized views of data (JSON/CSV/etc) than anything else. It's also in the name - 'Flat'.
Perhaps it is actually supported and I can't read properly, but I feel like you are just 1 tiny step away from allowing someone to write one of these things such that it can ETL any arbitrary data source into a SQLite database (i.e. many tables). There's not a whole lot of difference between CSV and SQLite when it comes to repository file management. Granted, SQLite databases would present as opaque blobs at code review time, but this is something we can tolerate because you still get all of the nice versioning & project consistency. Hell, you could probably write a special GitHub-branded diff viewer that allows you to compare 2 different SQLite databases, schema & all.
SQLite in general is such a force to be reckoned with. You could do a lot of damage (in a good way) with product features built up around the most popular database engine on earth.
- simonw 6y agoI have an experiment from a while ago around this idea: sqlite-diffable is a tool for dumping out a SQLite database to disk in a format that is designed to live in a git repository and produce readable diffs: https://github.com/simonw/sqlite-diffable https://github.com/simonw/sqlite-diffable