On Thu, 7 Oct 2004, Cena, Resty wrote: >How do single-file databases handle multi-table databases? Do they simply >pack separate physical table files into a single file, or have they found >a way to store in one table all the definition and data values of a >database? Can someone un-curious-ify me? Thanks. >
The SQLite high level architecture can be found at: http://www.sqlite.org/arch.html In SQLite, each table or index is represented by a btree. The btree is managed using fixed sized pages. As a btree is described by a root page, you can reference many btrees in the same file using a different root page for each btree. Christian -- /"\ \ / ASCII RIBBON CAMPAIGN - AGAINST HTML MAIL X - AGAINST MS ATTACHMENTS / \
