Previous Next Contents

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

Al Dev (Alavoor Vasudevan)

v4.0, 21 December 1997

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. Kanchenjunga - Java RAD Tool for PostgreSQL

11. Interface Drivers for PostgreSQL

12. Perl Database Interface (DBI) Driver for PostgreSQL

13. PostgreSQL Management Tools

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

15. Problem/Project Tracking System Application Tool for PostgreSQL

16. Convert dbase dbf files to PostgreSQL

17. PostgreSQL 4GL for web database applications - AppGEN Development System

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

19. WWW Web interface for PostgresSQL - DBENGINE

20. Apache Webserver Module for PostgreSQL - NeoSoft NeoWebScript

21. HEITML server side extension of HTML and a 4GL language for PostgreSQL

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

23. Python Interface for PostgreSQL

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

25. "C" language Interface for PostgreSQL

26. "C++" language Interface for PostgreSQL

27. ESQL/C for PostgreSQL

28. BitWise Operators for PostgreSQL

29. Japanese Kanji Code for PostgreSQL

30. PostgreSQL Port to Windows 95/Windows NT

31. Mailing Lists and Newsgroups

32. Documentation and Reference Books

33. Technical support for PostgreSQL

34. Economic and Business Aspects

35. List of Other Databases

36. Internet World Wide Web Searching Tips

37. Conclusion

38. FAQ - Questions on PostgreSQL

39. FAQ Linux-PostgreSQL

40. FAQ IRIX-PostgreSQL

41. Copyright Notice

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

43. Appendix B - Syntax of ANSI/ISO SQL 1998

44. Appendix C - SQL Tutorial for beginners

Previous Next Contents