Обсуждение: SQLite-PostgreSQL comparison
Does anyone know of a document comparing SQLite and PostgreSQL ? Thanks in advance. -- André Majorel http://www.teaser.fr/~amajorel/
On 5 Jun 2011, at 17:17, Andre Majorel wrote: > Does anyone know of a document comparing SQLite and PostgreSQL ? Indirectly, yes: http://en.wikipedia.org/wiki/Apples_and_oranges Alban Hertroys -- If you can't see the forest for the trees, cut the trees and you'll see there is no forest. !DSPAM:737,4debb4cc12091533215432!
On Sunday, June 05, 2011 8:17:30 am Andre Majorel wrote: > Does anyone know of a document comparing SQLite and PostgreSQL ? > As part of a more general comparison: http://en.wikipedia.org/wiki/Comparison_of_relational_database_management_systems The thumbnail version based on my experiences: 1) File layout. SQLite is single file, embeddable. Postgres is multi file client/server architecture. 2) Data typing SQLite uses manifest typing(adaptative typing) Postgres has strict typing. 3) SQL SQLite, especially later versions has fairly extensive SQL support given its size. The one area I find lacking is ALTER TABLE operations Postgres has extensive SQL support. There are occasional discussions on just how extensive. 4) Licensing SQLite is in the Public Domain Postgres license is here: http://wiki.postgresql.org/wiki/FAQ#What_is_the_license_of_PostgreSQL.3F It is derived from the BSD license. > Thanks in advance. -- Adrian Klaver adrian.klaver@gmail.com
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Sun, Jun 05, 2011 at 05:17:30PM +0200, Andre Majorel wrote: > Does anyone know of a document comparing SQLite and PostgreSQL ? Just google around a bit: <http://en.wikipedia.org/wiki/Comparison_of_SQL_database_management_systems> <http://kiwitobes.com/wiki/Comparison_of_relational_database_management_systems.html> Problem is that doing such comparisons tends to be tedious, so those docs tend to be outdated (or do you want to volunteer to make the next one ;-) But PostgreSQL and SQLite are such different beasts that it makes very little sense to compare them seriously. Like a truck and a bicycle. I wouldn't like to have to carry a load of bricks by bicycle -- but I wouldn't like to have to shoulder a truck. Regards - -- tomás -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFN7GUUBcgs9XrR2kYRAkDlAJ9QK73+8zQrbjUMkFEQhSuWcgR00wCfcguP UDWB6+2ZVMqSVTW8907A7RU= =GT6r -----END PGP SIGNATURE-----
On 5/06/2011 11:17 PM, Andre Majorel wrote: > Does anyone know of a document comparing SQLite and PostgreSQL ? It'd help a lot if you explained your use case. What do you need a database for? In what environment? With what hardware? Who will be running it? etc. -- Craig Ringer Tech-related writing at http://soapyfrogs.blogspot.com/