On Mon, Dec 21, 2009 at 1:59 PM, Andre Lopes <lopes80andre@gmail.com> wrote:
> Hi,
>
> What I need is some CRUD app that allows me to be quick in developp forms to
> insert, update and delete information in the database. I will be using this
> in a website database, but for now I don't have time to develop the forms
> and the admin side on the website, so I need to use an temporary solution
> for this...
>
> With .NET should be quick to develop some CRUD interface? What alternatives
> I have to .NET? there are Open Source GUI frameworks that do the same that
> .NET?
>
>
> Best Regads,
> André.
>
>
> On Sun, Dec 20, 2009 at 10:06 PM, Allan Kamau <kamauallan@gmail.com> wrote:
>>
>> On Mon, Dec 21, 2009 at 12:13 AM, Andre Lopes <lopes80andre@gmail.com>
>> wrote:
>> > Hi,
>> >
>> > I need to know if there is something like Oracle Forms in the Open
>> > Source
>> > world that works with PostgreSQL.
>> >
>> > If do you know something, please let me know.
>> >
>> > Best Regards,
>> > André.
>> >
>>
>> IMHO moving towards traditional GUI or other desktop application user
>> interface application paradigm may present significant challenges,
>> from deployment, upgrades, screen resolution issues, scalabilities and
>> so on, and may be difficult to design n-tier or even two tier
>> applications using the proposed concepts. But you may have a unique
>> good reason to go that route. Or maybe I misunderstood your question.
>>
>> Allan.
>>
>> --
>> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-general
>
>
Aha, a possible solution (and probably cleaner, consistant and leaner
than Forms <something>) to allow for insert, delete and update data in
the db manually as you have described above is pgadmin3.
Since pgAdmin3 may not provide you the flexibility beyond modifying a
single table a time, you may need to create some secondary tables to
which you'd write triggers and program the triggers update the
matching records in multiple tables that you would like to have
updated. Or make use of the Rules engine.
Then use pgAdmin3 to make make modifications to this secondary tables,
depending on the operation, the appropriate trigger you've written
will get triggered and perform the updates you'd instructed them to
do.
Allan.