Page History
- 2006-Dec-03 09:56 anonymous
- 2006-Jul-11 12:42 anonymous
- 2006-Jun-17 10:24 drh
- 2005-Aug-29 17:51 drh
- 2005-Aug-06 14:11 anonymous
- 2005-Aug-05 18:55 anonymous
- 2005-Aug-03 17:53 anonymous
- 2005-May-25 15:47 anonymous
- 2005-May-22 07:16 anonymous
- 2005-May-22 07:04 anonymous
- 2005-May-18 17:49 anonymous
- 2005-May-16 02:21 drh
- 2005-May-10 14:00 anonymous
- 2005-May-10 13:08 anonymous
- 2005-Feb-13 11:13 anonymous
- 2004-Aug-27 04:58 anonymous
- 2004-Aug-26 09:39 anonymous
- 2004-Aug-26 05:18 anonymous
- 2004-Aug-25 23:47 anonymous
- 2004-Aug-25 15:56 anonymous
- 2004-Aug-14 13:59 drh
This page provides links to comparisons between SQLite and other database engines. The information that this page links to is intended to provide designers with information to help them choose the best database for their particular situation. If you find additional comparision information, please add a link to this page.
- SqliteVersusDerby - A comparision of SQLite and the CloudScape/Derby database recently open-sourced by IBM.
- SqliteVersusDbstar - A comparision of SQLite and the db.* database engine recently open-sourced by ITTIA.
- What about EmbeddedMySQL?: (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
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?: (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 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.