Structured Query Language: Difference between revisions
Appearance
mNo edit summary |
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== | ||
* [[Borland Paradox]] - Had an optional SQL/DB2 compatibility module | |||
* [[Borland Paradox]] - Had an optional SQL/DB2 compatibility module | * Gupta SQLBase | ||
* Gupta SQLBase | * IBM [[DB2]] | ||
* [[Microsoft SQL Server]] | * [[Microsoft SQL Server]] | ||
* [[ | * Oracle Server | ||
* [[ | * [[Sybase SQL Anywhere]] | ||
''Open source'' | |||
* [[ | * [[mSQL]] | ||
* [[ | * [[MySQL]] | ||
* [[ | * [[PostgreSQL]] | ||
* [[SQLite]] | |||
;SQL Development systems | |||
* [[Oracle Pro*C]] | * [[Oracle Pro*C]] | ||
;Front ends and front end generators | |||
* Easel Workbench | * [[Easel Workbench]] | ||
* ENFIN/2 SQL Workbench | * ENFIN/2 SQL Workbench | ||
* [[General Application Workbench]] | * [[General Application Workbench]] | ||
;Database access systems | |||
*MDI Database Gateway | *MDI Database Gateway | ||
*unixODBC | *unixODBC | ||
;Libraries and bindings | |||
* [[OREXX/SQL]] - SQL extension for [[Object REXX]] | * [[OREXX/SQL]] - SQL extension for [[Object REXX]] | ||
* [[REXX/SQL]] - SQL extension for [[REXX]] | * [[REXX/SQL]] - SQL extension for [[REXX]] | ||
;Text editors with SQL support | |||
* [[FTE]] - Has support for syntax highlighting, code folding and syntax-aware | * [[FTE]] - Has support for syntax highlighting, code folding and syntax-aware auto-indent. | ||
* [[Lugaru Epsilon]] - SQL syntax highlighting and | * [[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 | *[[Empress]] - SQL front end to an alien database system | ||
*Gupta SQLBase | *Gupta SQLBase | ||
==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 | |||
* [http://www.gradiance.com/STwelcomeAWS.html Gradiance SQL Tutorial] - Paid for on-line (but partly | * [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: | [[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
- 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
- Front ends and front end generators
- Easel Workbench
- ENFIN/2 SQL Workbench
- General Application Workbench
- 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