Is there a comparison table showing differences between MySQL, SQLite, and PostgreSQL SQL implementations?

views:

answers:

+3 Q:

Is there a comparison table showing differences between MySQL, SQLite, and PostgreSQL SQL implementations?

I believe I my understanding is correct that there is a standard SQL. I'm assuming that MySQL, SQLite, and PostgreSQL all have variable support for the standard. Can anyone point me to a comprehensive comparison table that shows the differences?

+2 A:

Believe it or not, Wikipedia actually does an O.K. job at detailing the differences between the three (As well as other database programs).

dmags 2010-08-26 23:20:56

+3 A:

You may be interested in checking out:

Comparison of different SQL implementations

It's a very comprehensive comparison between PostgreSQL, DB2, MS SQL Server, MySQL, Oracle, Informix and the standard. However they did not include sqlite.

Daniel Vassallo 2010-08-26 23:21:04

Sqlite's site has a pretty exhaustive explanation of what parts of standard SQL it does and does not implement. I would suggest determining whether you want to use it versus a standard SQL server and then use the link @Daniel provided to determine which server you want if you elect to go that route.

Chris Thompson 2010-08-26 23:27:35

Note that it's Postgres, PostgreSQL or simply pg. Never ever PostGre ;)

I also like this comparison (though it doesn't cover SQLite)

http://www.postgresonline.com/journal/archives/130-Cross-Compare-of-PostgreSQL-8.4,-SQL-Server-2008,-MySQL-5.1.html

a_horse_with_no_name 2010-08-27 06:53:31

ansaurus

tags:

views:

answers:

Is there a comparison table showing differences between MySQL, SQLite, and PostgreSQL SQL implementations?

related questions