On Mar 29, 2010, at 12:03 PM, Jay A. Kreibich wrote: > On Mon, Mar 29, 2010 at 09:15:45AM +0530, Roger Binns scratched on > the wall: > >> I believe the btree/paging layer is replaced with BDB. > > Didn't SQLite "1" use a dbm library for the storage layer? > > The more things change.... >
SQLite version 1 used gdbm for storage. There were many problems with that approach: (1) gdbm is a hash-based system so it could not do range queries (2) gdbm is GPL, (3) Each table and index is in a separate file so your "database" was a directory full of files instead of a single file, (4) there is no support for transactions, (5) gdbm is highly vulnerable to corruption if a power loss occurs while it is being updated. So after less than a year of SQLite 1, I wrote my own b-tree library and hooked it up to SQLite, changed the license from GPL to Public Domain, and called the result "SQLite version 2". That was in 2001, starting on http://www.sqlite.org/src/timeline? c=2001-04-17+20%3a09%3a11 and continuing through http://www.sqlite.org/src/timeline?c=2001-09-13+13%3A46%3A56 and beyond. > -j > > -- > Jay A. Kreibich < J A Y @ K R E I B I.C H > > > "Our opponent is an alien starship packed with atomic bombs. We have > a protractor." "I'll go home and see if I can scrounge up a ruler > and a piece of string." --from Anathem by Neal Stephenson > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users D. Richard Hipp d...@hwaci.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
