News for hackers. Stuff that matters.

A comment on How does a relational database work? (2017).

Re:How does a relational database work? (2017) by Golfkid2Gadfly on Wednesday April 17, 2019 @02:54AM (#19680382)
Very good indeed, Quite the explanation, the storage part would be an interesting thing to see, for instance in SQLite, what is this binary file created in the filesystem, or how is it’s data organized.
[ Parent | on HN ]
Re:How does a relational database work? (2017) by bionoid on Wednesday April 17, 2019 @03:38AM (#19680553)
SQLite documentation covers this quite well, see "Database File Format" [0] or have a look at pager.c source code [1]. SQLite database is actually recommended by Library of Congress for archiving [2]

0: https://www.sqlite.org/fileformat.html

1: https://sqlite.org/src/artifact/422fd8cfa59fb917

2: https://www.loc.gov/preservation/resources/rfs/data.html

[ Parent | on HN ]