3 ms·
But other databases cannot access sqlite databases, because the file format is internal...
by orra 3y ago
But other databases cannot access sqlite databases, because the file format is internal...
- bane 3y agohttps://github.com/pgspider/sqlite_fdw https://github.com/pgspider/sqlite_fdw
- orra 3y agoI'll admit, that's a fantastic third party effort. But there definitely isn't the same level of first party support as there is for zip files.
- nojvek 3y agoSQL file format is very well documented. In some universities it is an assignment to directly read and write sqllite files from disk and understand the paged and blocks structure. You don’t need sql for any of it. https://www.sqlite.org/fileformat.html https://www.sqlite.org/fileformat.html
- avinassh 3y ago> In some universities it is an assignment to directly read and write sqllite files from disk and understand the paged and blocks structure. do you have any links?
- dunham 3y agoIt's interesting that this is a classroom assignment, like the sibling comment, I'd curious which university / class this was. I did the read part (+ query planning) on my own as an exercise, but I haven't gotten around to implementing writing yet. You do need to parse DDL to get the column names, they're stored as a "CREATE TABLE" string. But you don't have to if you want to dump the file without names. https://github.com/dunhamsteve/sqljs https://github.com/dunhamsteve/sqljs
- hot_gril 3y agoThey can if they want to, using the standard SQLite lib or their own implementation.