Structured Query Language: Difference between revisions
Appearance
mNo edit summary |
|||
Line 8: | Line 8: | ||
==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 | ;SQL Development systems | ||
* [[Oracle Pro*C]] | * [[Oracle Pro*C]] | ||
;Front ends and front end generators | ;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 | ;Database access systems | ||
Line 32: | Line 33: | ||
;Libraries and bindings | ;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 | ;Text editors with SQL support |
Revision as of 03:58, 14 December 2019
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 - 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