Structured Query Language: Difference between revisions
Appearance
mNo edit summary |
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 | |||
* [[Oracle Pro*C]] - Commercial - Discontinued | * [[Oracle Pro*C]] - Commercial - Discontinued | ||
;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 | |||
*MDI Database Gateway | *MDI Database Gateway | ||
*unixODBC | *unixODBC | ||
;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 | |||
* [[FTE]] - Has support for syntax highlighting, code folding and syntax-aware auto-indent. | * [[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. | * [[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 | ||
==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
- Oracle Pro*C - Commercial - Discontinued
- 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
- OREXX/SQL - SQL extension for Object REXX - Open source - Discontinued
- REXX/SQL - SQL extension for REXX - Open source - Current
- 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
- Gradiance SQL Tutorial - Paid for on-line (but partly downloadable) tutorial