Next Previous Contents

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

Al Dev (Alavoor Vasudevan) alavoor@yahoo.com

v45.0, 27 Jan 2001


This document is a "practical guide" to very quickly setup a SQL Database engine and front end tools on an 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 an 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 an 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. Performance Tuning of PostgreSQL server

9. PostgreSQL Supports Extremely Large Databases greater than 200 Gig

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

11. Security of Database

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

13. Interface Drivers for PostgreSQL

14. Perl Database Interface (DBI) Driver for PostgreSQL

15. PostgreSQL Management Tools

16. CPUs for PostgreSQL

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

18. Web-Application-Servers for PostgreSQL

19. Applications and Tools for PostgreSQL

20. Database Design Tool - Entity Relation Diagram Tool

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

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

23. Python Interface for PostgreSQL

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

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

26. Japanese Kanji Code for PostgreSQL

27. PostgreSQL Port to Windows 95/Windows NT

28. Mailing Lists

29. Documentation and Reference Books

30. Technical support for PostgreSQL

31. Economic and Business Aspects

32. List of Other Databases

33. Internet World Wide Web Searching Tips

34. Conclusion

35. FAQ - Questions on PostgreSQL

36. Other Formats of this Document

37. Copyright and License

Appendix

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

39. Appendix B - SQL Tutorial for beginners

40. Appendix C - Linux Quick Install Instructions

41. Appendix C - Midgard Installation


Next Previous Contents