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

On Mon, Dec 20, 2010 at 8:39 PM, Carlos Mennens <carlos(dot)mennens(at)gmail(dot)com>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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>