PostgreSQL is an advanced, open-source, object-relational DBMS, supporting ANSI SQL constructs, transactions, and user-defined types and functions.
SHOE STORE APPLICATION
Background
The original shoe store database application was implemented with MS FoxPro on a Macintosh system. The motivation to migrate the database came from the fact that FoxPro was obsoleted by MicroSoft and obviously the database will not benefit from continuing advances in technology. I selected PostgreSQL on the following reasons: 1) PostgreSQL is available under a very relaxed license, and may be used without fee; 2) PostgreSQL came in my Red Hat Linux distribution; 3) PostgreSQL has support for ANSI SQL and transactions, enabling me to advance my SQL programming skills obtained with FoxPro; 4) PostgreSQL also presented the opportunity to sophisticate my programming skills by developing database interfaces in C/C++, Perl, Python, and Java; 5) A minimal equipment investment was required since Linux runs remarkably well in machines that would otherwise be obsoleted due to the other operating system demands.
Interface Programming
The interface programs for this PostgreSQL database have been coded in C/C++ with embedded SQL function calls through ECPG. Some graphical user interfaces have been developed through GTK+/GNOME and Glade.