*** 15,40 **** *: SqliteVersusDbstar - A comparision of SQLite and the db.* database engine recently open-sourced by ITTIA. ! *: What about EmbeddedMySQL?: ({link: ! http://dev.mysql.com/doc/mysql/en/libmysqld_overview.html description}) I don't know enough to do a comparison myself, but it seems to have a lot of overlap. ! A big turn off for EmbeddedMySQL is their license - here's an extract: ! _:"The MySQL source code is covered by the GNU GPL license (see section G GNU General Public License). One result of this is that any program which includes, by linking with libmysqld, the MySQL source code must be released as free software (under a license compatible with the GPL)." (added by {link:http://www.smartpethealth.com DV}) ! Another turn off is its size: when i link SQLite into my app the difference is barely noticed not so with EmbeddedMySQL. *: What about SimpleSQL?: ({link: http://www.simplesql.org/ for description}) *: Sqlite Versus {link: http://firebird.sourceforge.net/ Firebird} - Firebird is open source, cross platform, embeddable, has wrappers for many language. Firebird is a full featured database and has a footprint of 2-3 MByte. A good choice when SQLite is too lite. Firebird can be used free of charge even for closed source projects. --- 15,55 ---- *: SqliteVersusDbstar - A comparision of SQLite and the db.* database engine recently open-sourced by ITTIA. ! *: What about EmbeddedMySQL?: ({link: http://dev.mysql.com/doc/mysql/en/libmysqld_overview.html description}) I don't know enough to do a comparison myself, but it seems to have a lot of overlap. ! _::A big turn off for EmbeddedMySQL is their license - here's an extract: ! ! _:::"The MySQL source code is covered by the GNU GPL license (see section G GNU General Public License). One result of this is that any program which includes, by linking with libmysqld, the MySQL source code must be released as free software (under a license compatible with the GPL)." (added by {link:http://www.smartpethealth.com DV}) ! _::Another turn off is its size: when i link SQLite into my app the difference is barely noticed not so with EmbeddedMySQL. *: What about SimpleSQL?: ({link: http://www.simplesql.org/ for description}) + _:: SimpleSQL is only sparsely documented. The code is uncommented except + for a boiler-plate header comment on each file. There are some test cases + but the testing seems to be much less rigorous than SQLite. SimpleSQL uses + the LGPL license. + *: Sqlite Versus {link: http://firebird.sourceforge.net/ Firebird} - Firebird is open source, cross platform, embeddable, has wrappers for many language. Firebird is a full featured database and has a footprint of 2-3 MByte. A good choice when SQLite is too lite. Firebird can be used free of charge even for closed source projects. + + + *: SQLite versus {link: http://www.sleepycat.com/ Berkeley DB}: + + _:: Berkeley DB (BDB) is just the data storage layer - it does not support + SQL or schemas. In spite of this, BDB is twice the size of + SQLite. A comparison between BDB and SQLite is similar to a comparison + between assembly language and a dynamic language like Python or Tcl. + BDB is probably much faster if you code it carefully. But it is much more + difficult to use and considerably less flexible.