Next Previous Contents

Database-SQL-RDBMS HOW-TO document for Linux (PostgreSQL Object Relational Database System)

Al Dev (Alavoor Vasudevan)

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.

1. Introduction

2. Other Formats of this Document

3. Laws of Physics applies to Software!

4. What is PostgreSQL ?

5. Where to get it ?

6. PostgreSQL Supports Extremely Large Databases greater than 200 Gig

7. How can I trust PostgreSQL ? Regression Test Package builds customer confidence

8. GUI FrontEnd Tool for PostgreSQL (Graphical User Interface)

9. Integrated Development Environment Tools for PostgreSQL (GUI IDE)

10. Interface Drivers for PostgreSQL

11. Perl Database Interface (DBI) Driver for PostgreSQL

12. PostgreSQL Management Tools

13. Setting up multi-boxes PostgreSQL with just one monitor

14. Applications and Tools for PostgreSQL

15. Web Database Design/Implementation tool for PostgreSQL - EARP

16. PHP/FI Server-side html-embedded scripting language for PostgreSQL

17. Python Interface for PostgreSQL

18. Gateway between PostgreSQL and the WWW - WDB-P95

19. "C", "C++", ESQL/C language Interfaces and Bitwise Operators for PostgreSQL

20. Japanese Kanji Code for PostgreSQL

21. PostgreSQL Port to Windows 95/Windows NT

22. Mailing Lists and Newsgroups

23. Documentation and Reference Books

24. Technical support for PostgreSQL

25. Economic and Business Aspects

26. List of Other Databases

27. Internet World Wide Web Searching Tips

28. Conclusion

29. FAQ - Questions on PostgreSQL

30. Copyright Notice


31. Appendix A - Syntax of ANSI/ISO SQL 1992

32. Appendix B - SQL Tutorial for beginners

Next Previous Contents