Jump to content

Structured Query Language

From EDM2
Revision as of 23:34, 23 March 2018 by Ak120 (talk | contribs)

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