Database-SQL-RDBMS HOW-TO document for Linux (PostgreSQL Object Relational Database System)
v8.0, 29 July 1998
This document is a "practical guide" to very quickly setup a SQL Database
engine and
front end tools on a Unix system. It also discusses the International standard
language ANSI/ISO SQL and reviews about the merits/advantages of the SQL database engine developed by the world-wide internet in an "open development" environment.
It is about HOW-TO setup a next generation Object Relational SQL Database "PostgreSQL" on Unix system which can be used as Application Database
Server or as Web Database Server. PostgreSQL implements subset of
International standard ISO and ANSI SQL 1998,92,89. This document also gives information on the interface programs for the database like Front End GUIs, RAD tools (Rapid Application Development), programming languages interfaces ("C", "C++", Java, Perl), ODBC, JDBC drivers and Web Database Tools and
Interface programs. Information given here applies to all Unix platforms and other databases and will be very useful for people who are new to
Databases, SQL language and PostgreSQL.
This document also has SQL tutorial, SQL syntax which would be very helpful
for beginners. Experienced people will find this document useful as a handy reference guide. For students, the information given here will enable them
to get the source code for PostgreSQL relational database system, from which they can learn how a RDBMS SQL database engine is written.
Appendix