|
|
Every computer system needs a database to store/retrieve the information. The primary reason for the invention of computer is to store, retrieve and process information and do all these very quickly. The most popular database systems are based on the International Standard Organisation (ISO) SQL specifications which are also based on ANSI SQL (american) standards. Current specifications generally used are ANSI SQL 92 and ANSI SQL 89. Popular database like Oracle, Sybase and Informix systems are based on these standards.
The world's most popular FREE Database which is ISO SQL, ANSI SQL/92 and ANSI SQL/89 compliant RDBMS is PostgreSQL, also known as pgsql (pronounced as "pee-gee-sequel"). PostgreSQL is the only free RDBMS in the world which supports ANSI SQL standards. This document will tell you how-to install the database and also all the packages related to databases, how to set up the Web database, application database, front end GUIs and interface programs. It is strongly advised that you MUST write your database applications 100 % compliant to standards of ISO/ANSI SQL, ODBC, JDBC so that your application is portable across multiple databases like PostgreSQL, Oracle, Sybase, Informix etc.