Jump to content

Structured Query Language: Difference between revisions

From EDM2
Ak120 (talk | contribs)
mNo edit summary
Ak120 (talk | contribs)
Line 8: Line 8:


==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
Line 32: Line 33:


;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

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

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 - 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