Re: What Programs Do You Use For PG? - Mailing list pgsql-general

On Tue, Dec 21, 2010 at 1:32 AM, Neil D'Souza
<neil.xavier.dsouza@gmail.com> wrote:
> 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

interesting project.  do you have any documentation describing how it works?

merlin