Re: What Programs Do You Use For PG?

You can have a look at my project on sourceforge:
http://sourceforge.net/projects/proghelp builds applications with PG as a backend automatically. It uses a modified create table sql grammar as an input.

1. It automatically  generates stored procedures to insert and retrieve data
2. a database api layer to access the data in C++
3. a user interface using the Wt C++ library
    i.   search keys marked in the input file automatically become search keys in the user interface which correctly invoke the generated stored procedures.
    ii.  Foreign key references automatically become dialog boxes.
    iii. Any search keys in the referenced tables become will become search keys in the dialog box - again with correct invocations.
    iv. Any tables marked as "references multi" in the input file automatically become master details tables - using a tabview widget for details tables. The details tables automatically use the primary key from the master table to do their inserts/retrieval of data from the system.

4. Random data for testing.
5. scripts to create tables in topological order (when there are foreign key references the referenced tables are output first, for the master/details tables the master tables are output first), and drop tables and stored procedures ( when you want to prevent clutter). All the scripts are collected in a unified script generator to save you the trouble of running them individually.
6. Automatic creation of authorization and authentication modules - with fine grained control on view, add, edit and view summary.

The input file is about 200 lines, the generated code is about 15,000 lines of c++, and about 12,000 lines of stored procedures.

Whats not yet implemented

1. Paging of records.
2. Automatic edit for records.
3. Currently the search is properly implemented for varchar fields, need to fix it for dates and int/float data
4. A better random data generator.
5. god knows what else


You can see a sample application developed using the code generator here:

 http://173.230.133.34:8080/

User logins and passwords are below.

user_login_code | user_login_name | user_password | employee_code
-----------------+-----------------+---------------+---------------
               1 | zenond          | zenond123     |             1
               2 | atuld           | atul123       |             2
               3 | michaeld        | michael123    |             3
               4 | nxd             | nxd123        |             4
               5 | veerad          | veerad123     |             5
               6 | chanchud        | chanchud123   |             6
               7 | wilburd         | wilburd123    |             7
               8 | abhishekc       | abhishekc123  |             8

If it crashes - please mail me and I will restart it.

Kind Regards,
Neil