Difference between different types of SQL?

Question

What are the differences between all of the different types of SQL? I hear of PostgreSQL, SQLite, MySQL, SQL, .... What are the differences between them?

Real answer is found here: https://www.quora.com/Why-there-are-so-many-types-of-SQL-What-is-the-difference-between-all-of-them — Andrew, Aug 30 '17 at 15:35

score 23 · Accepted Answer · answered Aug 25 '09 at 06:05

23

SQL is Structured Query Language is a database computer language designed for managing data in relational database management systems (RDBMS).

PostgreSQL is an object-relational database management system (ORDBMS).1 It is released under a BSD-style license and is thus free software. As with many other open-source programs, PostgreSQL is not controlled by any single company, but has a global community of developers and companies to develop it.

SQLite is an ACID-compliant embedded relational database management system contained in a relatively small (~225 KB1) C programming library. The source code for SQLite is in the public domain.

MySQL (pronounced /maɪˌɛskjuːˈɛl/1 My S-Q-L, or "My sequel" /maɪˈsiːkwəl/) is a relational database management system (RDBMS)2 which has more than 6 million installations. 3 MySQL stands for "My Structured Query Language". The program runs as a server providing multi-user access to a number of databases.

answered Aug 25 '09 at 06:05

rahul

184,426
49
232
263

1

One small other question: do you say PostgreSQL like this? "Postgres-ql"? – RCIX Aug 25 '09 at 06:10
4

@RCIX, http://www.postgresql.org/community/survey.33 – Svish Aug 25 '09 at 06:23
3

This answers the question but it's reaaaallly surfacey... – Andrew Aug 30 '17 at 15:30
I've heard POST G R E SQL, and postgres-ql before. – Super Fighting Robot Apr 15 '19 at 12:53
I've only ever heard "Postgres", but I assume that's because it was clear from context and isn't how it's supposed to be pronounced... – CoffeeTableEspresso Jun 17 '20 at 03:27

score 12 · Answer 2 · answered Aug 25 '09 at 08:07

12

If you want to know about different dialects of SQL (Structured Query Language)
Have a look here :

http://en.wikibooks.org/wiki/SQL_dialects_reference

answered Aug 25 '09 at 08:07

Nifle

11,745
10
75
100

1

While this link may answer the question, it is better to include the essential parts of the answer here and provide the link for reference. – Martin Jun 28 '16 at 13:20

score 11 · Answer 3 · answered Aug 25 '09 at 06:05

11

PostgreSQL, SQLite, MySQL, MS SQL are just database management systems from different vendors

answered Aug 25 '09 at 06:05

Prashant Cholachagudda

13,012
23
97
162

score 6 · Answer 4 · edited Aug 25 '09 at 06:20

6

Comparison of relational database management systems

edited Aug 25 '09 at 06:20

Svish

152,914
173
462
620

answered Aug 25 '09 at 06:05

x2.

9,554
6
41
62

score 3 · Answer 5 · answered Aug 25 '09 at 06:57

PostgreSQL, SQLite, MySQL, MSSQL, Sybase = relational database management systems (RDBMSes).

SQL, TSQL = the actual languages used by the aforementioned database systems. Although (in theory) SQL is standardised, in practice each vendor has their own "extensions" (variations) on the language - which means that SQL written for MySQL may not work under Sybase, for example.

score 1 · Answer 6 · answered Aug 25 '09 at 11:44

1

Different Vendors= Different Ideas and Concepts. Like every other Programming Problem...every developer solutes it differently and thats great. :-) Learing about this little differences or sometimes big "Messed up" is good.

answered Aug 25 '09 at 11:44

bastianneu

2,059
2
18
31

Difference between different types of SQL?

6 Answers6

Linked

Related