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
On Mon, Dec 20, 2010 at 8:39 PM, Carlos Mennens <carlos.mennens@xxxxxxxxx> wrote:
I'm just wondering what programs you guys / girls are using PostgreSQL
for. So far I've installed PG 9 on my Debian Linux server and manually
created all my databases, schema's, and tables for my personal email /
address book. It's very basic and small but I was wondering if you
guys know of any programs that I can install that I could beef up my
PG database with? Just looking for basic applications that use PG as a
back-end so I can see how different programs are developed to create
tables and schema's. I tried looking on line for an open source email
address book that would use PostgreSQL as a back end but couldn't find
one. Anyone have any recommendations?
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
