Structured Query Language: Difference between revisions

Latest revision as of 19:45, 22 October 2021

Database reporting language, although originally shipped as a separate product with databases such as Oracle and DB2 it is by now always shipped as an integral part of database systems.

Standards

IBM SQL Version 1
ANSI X3.135.1992
ISO 9075-1992
FIPS 127-2

OS/2 SQL implementations, tools and utilities

Borland Paradox - Had an optional SQL/DB2 compatibility module
Gupta SQLBase
IBM DB2
Microsoft SQL Server
Oracle Server
Sybase SQL Anywhere

Open source

SQL Development systems

Oracle Pro*C

Front ends and front end generators

Database access systems

MDI Database Gateway
unixODBC

Libraries and bindings

OREXX/SQL - SQL extension for Object REXX
REXX/SQL - SQL extension for REXX

Text editors with SQL support

FTE - Has support for syntax highlighting, code folding and syntax-aware auto-indent.
Lugaru Epsilon - SQL syntax highlighting and auto-indent available as a separate download.

DOS SQL implementations and tools

Empress - SQL front end to an alien database system
Gupta SQLBase

Publications

C. J. Date: A Guide to the SQL Standard - Addison-Wesley 1987, ISBN 0-201-05777-8
- Second Edition - 1989, ISBN 0-201-50209-7
- Third Edition - 1993, ISBN 0-201-55822-X
- Fourth Edition - 1996, ISBN 0-201-96426-0
John L. Viescas: Quick Reference Guide to SQL - Microsoft Press 1989, ISBN 1-55615-198-5
Konrad King; Kris A. Jamsa: SQL Tips & Techniques - Premier Press 2002, ISBN 1931841454

Tutorials

Gradiance SQL Tutorial - Paid for on-line (but partly downloadable) tutorial

Links

SQL-92

@@ Line 1: / Line 1: @@
 Database reporting language, although originally shipped as a separate product with databases such as [[Oracle]] and [[DB2]] it is by now always shipped as an integral part of database systems.
-==A list of OS/2 SQL implementations, tools and utilities==
+==Standards==
-* [[DB2]] - Commercial - Discontinued
+*IBM SQL Version 1
-* [[Borland Paradox]] - Had an optional SQL/DB2 compatibility module - Commercial - Discontinued
+*ANSI X3.135.1992
-* [[Gupta SQLBase Server]] - Commercial - Discontinued
+*ISO 9075-1992
-* [[Microsoft SQL Server]] - Commercial - Discontinued
+*FIPS 127-2
-* [[mSQL]] - Open source - Discontinued
-* [[MySQL]] - Open Source - Current
-* [[Oracle Server]] - Commercial - Discontinued
-* [[PostgreSQL]] - Open Source - Current
-* [[SQLite]] - Open Source - Current
-* [[Sybase SQL Anywhere]] - Commercial - Discontinued
-====SQL Development systems====
+==OS/2 SQL implementations, tools and utilities==
-* [[Oracle Pro*C]] - Commercial - Discontinued
+* [[Borland Paradox]] - Had an optional SQL/DB2 compatibility module
+* Gupta SQLBase
+* IBM [[DB2]]
+* [[Microsoft SQL Server]]
+* Oracle Server
+* [[Sybase SQL Anywhere]]
+''Open source''
+* [[mSQL]]
+* [[MySQL]]
+* [[PostgreSQL]]
+* [[SQLite]]
-====Front ends and front end generators====
+;SQL Development systems
-* [[Easel Workbench]] - Commercial - Discontinued
+* [[Oracle Pro*C]]
-* [[Enfin/2]] - Commercial - Discontinued
-* [[General Application Workbench]] - Commercial - Discontinued
-====Database access systems====
+;Front ends and front end generators
-* [[MDI Database Gateway]]
+* [[Easel Workbench]]
-* [[unixODBC]]
+* ENFIN/2 SQL Workbench
+* [[General Application Workbench]]
-====Libraries and bindings====
+;Database access systems
-*
+*MDI Database Gateway
+*unixODBC
-====Text editors with SQL support====
+;Libraries and bindings
-* [[FTE]] - Has support for syntax highlighting, code folding and syntax-aware autoindent. - Open source - Current.
+* [[OREXX/SQL]] - SQL extension for [[Object REXX]]
-* [[Lugaru Epsilon]] - SQL syntax highlighting and autoindent available as a seperate download. - Commercial.
+* [[REXX/SQL]] - SQL extension for [[REXX]]
-==A list of DOS SQL implementations and tools==
+;Text editors with SQL support
-* [[Empress]] - SQL front end to an alien database system - Commercial - Discontinued
+* [[FTE]] - Has support for syntax highlighting, code folding and syntax-aware auto-indent.
-* [[Gupta SQLBase Server]] - Commercial - Discontinued
+* [[Lugaru Epsilon]] - SQL syntax highlighting and auto-indent available as a separate download.
-====SQL Development systems====
+==DOS SQL implementations and tools==
-* [[Oracle Pro*C]] - Commercial - Discontinued
+*[[Empress]] - SQL front end to an alien database system
+*Gupta SQLBase
-====Front ends and front end generators====
-* [[Easel Workbench]]
-====Text editors with SQL support====
-* [[FTE]] - Has support for syntax highlighting, code folding and syntax-aware autoindent. - Open source - Current.
-==A list of SQL implementations and tools that run under WinOS/2==
-*
-====Front ends and front end generators====
-* [[Easel Workbench]]
-==A list of SQL implementations and tools that run under Java==
-==A list of SQL implementations and tools that run under JavaScript==
-*
 ==Publications==
-*
+* C. J. Date: ''A Guide to the SQL Standard'' - Addison-Wesley 1987, ISBN 0-201-05777-8
-====Local articles====
+** Second Edition - 1989, ISBN 0-201-50209-7
-*
+** Third Edition - 1993, ISBN 0-201-55822-X
+** Fourth Edition - 1996, ISBN 0-201-96426-0
+* John L. Viescas: ''Quick Reference Guide to SQL'' - Microsoft Press 1989, ISBN 1-55615-198-5
+* Konrad King; [[Kris A. Jamsa]]: ''SQL Tips & Techniques'' - Premier Press 2002, ISBN 1931841454
-====Tutorials and other learning material====
+;Tutorials
-* [http://www.gradiance.com/STwelcomeAWS.html Gradiance SQL Tutorial] - Paid for on-line (but partly downlodable) tutorial.
+* [http://www.gradiance.com/STwelcomeAWS.html Gradiance SQL Tutorial] - Paid for on-line (but partly downloadable) tutorial
 ==Links==
-*
+* [http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt SQL-92]
-====USENET====
-*
-==Standards==
+[[Category:Programming Languages]] [[Category:Data modeling language]]
-*
-[[Category:Programming Languages]] [[Category:SQL]]