Jump to content

Structured Query Language: Difference between revisions

From EDM2
Ak120 (talk | contribs)
mNo edit summary
Ak120 (talk | contribs)
mNo edit summary
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==
Line 13: Line 19:
* [[Sybase SQL Anywhere]] - Commercial - Discontinued
* [[Sybase SQL Anywhere]] - Commercial - Discontinued


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


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


===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]] - Open source - Discontinued
* [[REXX/SQL]] - SQL extension for [[REXX]] - Open source - Current
* [[REXX/SQL]] - SQL extension for [[REXX]] - Open source - Current


===Text editors with SQL support===
;Text editors with SQL support
* [[FTE]] - Has support for syntax highlighting, code folding and syntax-aware auto-indent. - Open source - Current
* [[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. - 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 - Commercial - Discontinued
*Gupta SQLBase - Commercial - Discontinued
*Gupta SQLBase - Commercial - Discontinued
===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


==Publications==
==Publications==

Revision as of 23:34, 23 March 2018

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

  • DB2 - Commercial - Discontinued
  • Borland Paradox - Had an optional SQL/DB2 compatibility module - Commercial - Discontinued
  • Gupta SQLBase Server - Commercial - Discontinued
  • Microsoft SQL Server - Commercial - Discontinued
  • 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
Front ends and front end generators
  • Easel Workbench - Commercial - Discontinued
  • ENFIN/2 SQL Workbench - Commercial - Discontinued
  • General Application Workbench - Commercial - Discontinued
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 - Commercial - Discontinued
  • Gupta SQLBase - Commercial - Discontinued

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