Structured Query Language: Difference between revisions

Revision as of 18:20, 12 March 2017

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.

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 autoindent. - Open source - Current
Lugaru Epsilon - SQL syntax highlighting and autoindent available as a seperate download. - Commercial

DOS SQL implementations and tools

Empress - SQL front end to an alien database system - Commercial - Discontinued
Gupta SQLBase - Commercial - Discontinued

SQL Development systems

Oracle Pro*C - Commercial - Discontinued

Front ends and front end generators

Easel Workbench

Text editors with SQL support

FTE - Has support for syntax highlighting, code folding and syntax-aware autoindent. - Open source - Current

A list of SQL implementations and tools that run under WinOS/2

Front ends and front end generators

Easel Workbench

Publications

Konrad King; Kris A. Jamsa: SQL Tips & Techniques - Premier Press 2002, ISBN 1931841454

Tutorials and other learning material

Gradiance SQL Tutorial - Paid for on-line (but partly downlodable) tutorial

Links

SQL-92

@@ 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.
-==A list of 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 - Commercial - Discontinued
-* [[Gupta SQLBase Server]] - Commercial - Discontinued
+* Gupta SQLBase Server - Commercial - Discontinued
 * [[Microsoft SQL Server]] - Commercial - Discontinued
 * [[mSQL]] - Open source - Discontinued
 * [[MySQL]] - Open Source - Current
-* [[Oracle Server]] - Commercial - Discontinued
+* Oracle Server - Commercial - Discontinued
 * [[PostgreSQL]] - Open Source - Current
 * [[SQLite]] - Open Source - Current
@@ Line 17: / Line 17: @@
 ===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
@@ Line 33: / Line 33: @@
 * [[Lugaru Epsilon]] - SQL syntax highlighting and autoindent available as a seperate download. - Commercial
-==A list of DOS SQL implementations and tools==
+==DOS SQL implementations and tools==
 *[[Empress]] - SQL front end to an alien database system - Commercial - Discontinued
 *Gupta SQLBase - Commercial - Discontinued