Re: Pg CRUD for joined tables

From: Wolfgang Keller <feliphil(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Pg CRUD for joined tables
Date: 2012-07-12 13:35:10
Message-ID: 20120712153510.639eb205033acc092d678c66@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> I'm looking for FOSS PostgreSQL CRUD software, preferably
> Perl-compatible, which will enable me to design input forms which can
> handle input to tables which reference other tables by foreign key.
> Most CRUD applications I have seen so far only deal with direct, form
> field to table field input but I want to build forms which have the
> same fields as a VIEW derived from multiple table joins. In other
> words, I want the CRUD to handle the the joins.
>
> Any suggestions?

Not for Perl, but Python: SQLalchemy. An ORM that allows you to have
(nearly) arbitrarily complex mappings between your object model and the
database tables. GUI frameworks that use SQlalchemy are: Sqlkit,
Pypapi, Camelot, Qtalchemy.

Sincerely,

Wolfgang

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2012-07-12 13:44:35 Re: PostgreSQL limitations question
Previous Message Adrian Klaver 2012-07-12 13:31:41 Re: PostgreSQL limitations question