Jump to content

Structured Query Language: Difference between revisions

From EDM2
← Older edit
Ak120 (talk | contribs)
35,819 edits
mNo edit summary
Ak120 (talk | contribs)
35,819 edits
mNo edit summary
 
(5 intermediate revisions by the same user not shown)
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.
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==
==OS/2 SQL implementations, tools and utilities==
* [[DB2]] - Commercial - Discontinued
* [[Borland Paradox]] - Had an optional SQL/DB2 compatibility module
* [[Borland Paradox]] - Had an optional SQL/DB2 compatibility module - Commercial - Discontinued
* Gupta SQLBase
* Gupta SQLBase Server - Commercial - Discontinued
* IBM [[DB2]]
* [[Microsoft SQL Server]] - Commercial - Discontinued
* [[Microsoft SQL Server]]
* [[mSQL]] - Open source - Discontinued
* Oracle Server
* [[MySQL]] - Open Source - Current
* [[Sybase SQL Anywhere]]
* Oracle Server - Commercial - Discontinued
''Open source''
* [[PostgreSQL]] - Open Source - Current
* [[mSQL]]
* [[SQLite]] - Open Source - Current
* [[MySQL]]
* [[Sybase SQL Anywhere]] - Commercial - Discontinued
* [[PostgreSQL]]
* [[SQLite]]


===SQL Development systems===
;SQL Development systems
* [[Oracle Pro*C]] - Commercial - Discontinued
* [[Oracle Pro*C]]


===Front ends and front end generators===
;Front ends and front end generators
* Easel Workbench - Commercial - Discontinued
* [[Easel Workbench]]
* ENFIN/2 SQL Workbench - Commercial - Discontinued
* ENFIN/2 SQL Workbench
* [[General Application Workbench]] - Commercial - Discontinued
* [[General Application Workbench]]


===Database access systems===
;Database access systems
*MDI Database Gateway
*MDI Database Gateway
*unixODBC
*unixODBC


===Libraries and bindings===
;Libraries and bindings
* [[OREXX/SQL]] - SQL extension for [[Object REXX]] - Open source - Discontinued
* [[OREXX/SQL]] - SQL extension for [[Object REXX]]
* [[REXX/SQL]] - SQL extension for [[REXX]] - Open source - Current
* [[REXX/SQL]] - SQL extension for [[REXX]]


===Text editors with SQL support===
;Text editors with SQL support
* [[FTE]] - Has support for syntax highlighting, code folding and syntax-aware autoindent. - Open source - Current
* [[FTE]] - Has support for syntax highlighting, code folding and syntax-aware auto-indent.
* [[Lugaru Epsilon]] - SQL syntax highlighting and autoindent available as a seperate download. - Commercial
* [[Lugaru Epsilon]] - SQL syntax highlighting and auto-indent available as a separate download.


==DOS SQL implementations and tools==
==DOS SQL implementations and tools==
*[[Empress]] - SQL front end to an alien database system - Commercial - Discontinued
*[[Empress]] - SQL front end to an alien database system
*Gupta SQLBase - Commercial - Discontinued
*Gupta SQLBase
 
===SQL Development systems===
*[[Oracle Pro*C]] - Commercial - Discontinued
 
===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


==Publications==
==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
* 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==
==Links==
* [http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt SQL-92]
* [http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt SQL-92]


[[Category:Programming Languages]] [[Category:SQL]]
[[Category:Programming Languages]] [[Category:Data modeling language]]

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

Open source

SQL Development systems
Front ends and front end generators
Database access systems
  • MDI Database Gateway
  • unixODBC
Libraries and bindings
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

Links

Retrieved from "https://www.edm2.com/index.php?title=Structured_Query_Language&oldid=76960"