2 ms·
SQL 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 an
by nojvek 3y ago
SQL 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