6 ms·
Some of the SQLite utilities let you dump the tables out of the SQLite file as CSV or .sql if you want. It would probably be easier if dB vendors just made a S
by bane 12y ago
Some of the SQLite utilities let you dump the tables out of the SQLite file as CSV or .sql if you want.
It would probably be easier if dB vendors just made a SQLite importer/exporter that turned any given SQLite file into a full database in their RBDM and visa-versa (or for some subset). It's not really that hard of a problem to do it and seems like a better way than shuffling around csv files or .sql files. At least then if you want to probe the files a little to see what's in them without loading them up you can just use one of the dozen or so SQLite utilities that are out there.
The hardest part might be type inference on schemas that don't define the attribute types (SQLite ignores those and so they're optional) and converting over the full-text indexing and other extensions. But it's not exactly rocket science.