Next Previous Contents

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

Al Dev (Alavoor Vasudevan) alavoor@yahoo.com

v30.0, 29 July 2000
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 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 a Application Database Server or as a Web Database Server. PostgreSQL attempts to implement current and future International ISO/ANSI SQL standards. This document also gives information on the database interface programs like Front End GUIs, RAD tools (Rapid Application Development), ODBC, JDBC drivers, "C", "C++", Java, Perl programming interfaces and Web Database Tools. Information given here applies to all Unix/Windows NT platforms and to all other SQL databases. It 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 as a useful 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 as to how a RDBMS SQL database engine is created.

1. Introduction

2. Laws of Physics apply to Software!

3. What is PostgreSQL ?

4. Which one? PostgreSQL or MySQL ?

5. Where to get it ?

6. PostgreSQL Quick-Installation Instructions

7. Quick Start Guide

8. PostgreSQL Supports Extremely Large Databases greater than 200 Gig

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

10. Security of Database

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

12. Interface Drivers for PostgreSQL

13. Perl Database Interface (DBI) Driver for PostgreSQL

14. PostgreSQL Management Tools

15. CPUs for PostgreSQL

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

17. Web-Application-Servers for PostgreSQL

18. Applications and Tools for PostgreSQL

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

20. PHP Hypertext Preprocessor - Server-side html-embedded scripting language for PostgreSQL

21. Python Interface for PostgreSQL

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

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

24. Japanese Kanji Code for PostgreSQL

25. PostgreSQL Port to Windows 95/Windows NT

26. Mailing Lists

27. Documentation and Reference Books

28. Technical support for PostgreSQL

29. Economic and Business Aspects

30. List of Other Databases

31. Internet World Wide Web Searching Tips

32. Conclusion

33. FAQ - Questions on PostgreSQL

34. Other Formats of this Document

35. Copyright and License

Appendix

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

37. Appendix B - SQL Tutorial for beginners

38. Appendix C - Linux Quick Install Instructions


Next Previous Contents