| 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: | Whole Thread | Raw Message | 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
| 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 |