Thread: 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/