Thread: Something like Oracle Forms, but Open Source to use with PostgreSQL?

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é.

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.

Andre Lopes 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.

perhaps OpenOffice Data could do what you need.  I'm not real familiar
with Oracle Forms, but I know OOo Data can connect to most any database
including postgres, and it can be used to build 'forms' based database
applications with queries and reports...    its somewhat akin to
Microsoft Access in basic functionality.

On 12/20/2009 4:13 PM, Andre Lopes 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.
>

Some quick Googling found this if you are looking for a desktop solution:

http://groups.fsf.org/wiki/Oracle_Forms

or this if you are looking for a web solution:

http://stackoverflow.com/questions/179849/best-solution-for-migration-from-oracle-forms-6i-to-the-web

--
Guy Rouillier

John R Pierce wrote:
> Andre Lopes 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.
>
> perhaps OpenOffice Data could do what you need.  I'm not real familiar
> with Oracle Forms, but I know OOo Data can connect to most any database
> including postgres, and it can be used to build 'forms' based database
> applications with queries and reports...    its somewhat akin to
> Microsoft Access in basic functionality.

Only in the sense that stone tablets are akin to e-ink. OOo Base is
buggy and unusable.

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 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.

On Mon, 2009-12-21 at 10:59 +0000, Andre Lopes 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,

What do you mean by "website database"?  A database is a database.  Do
you mean you need a WebUI?  Or do you need a GUI?

> 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?

With MVC you could make something very quickly [WebUI] ; assuming you
know C# & ASP.NET.  Or with Monodevelop you could easily make a GTK#
interface [GUI].
<http://monodevelop.com/Documentation/Stetic_GUI_Designer>

> What alternatives I have to .NET?

Mono.

> there are Open Source GUI frameworks that do the same that .NET?

Mono.  Monodevelop is fabulous.  PostgreSQL support in Mono is
top-notch.

Some members of the local PUG use Dabo, <http://dabodev.com/>

--
OpenGroupware developer: awilliam@whitemice.org
<http://whitemiceconsulting.blogspot.com/>
OpenGroupare & Cyrus IMAPd documenation @
<http://docs.opengroupware.org/Members/whitemice/wmogag/file_view>

On 21 Dec 2009, at 11:59, Andre Lopes 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
thedatabase. I will be using this in a website database, but for now I don't have time to develop the forms and the
adminside 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
frameworksthat do the same that .NET? 

I am quite impressed with the Django framework for things like this. It uses the Python language, but if that's no
problemfor you then I heartily recommend it. I understand it's quite popular with Java developers too, apparently they
useDjango for quick prototyping and translate the result to Java. 

Alban Hertroys

--
Screwing up is the best way to attach something to the ceiling.


!DSPAM:737,4b2f8402228051702912349!

Ivan Voras wrote:
> John R Pierce wrote:
>> Andre Lopes 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.
>>
>> perhaps OpenOffice Data could do what you need.  I'm not real familiar
>> with Oracle Forms, but I know OOo Data can connect to most any
>> database including postgres, and it can be used to build 'forms' based
>> database applications with queries and reports...    its somewhat akin
>> to Microsoft Access in basic functionality.
>
> Only in the sense that stone tablets are akin to e-ink. OOo Base is
> buggy and unusable.

Oracle Forms are stone tablets! Come on over to this side of the 90's.
Adobe Flex is really nice for building both web 2.0 and cross platform
desktop apps. It is especially nice for databases like Oracle, DB2 and
Postgres that handle XML well.

You'll have to write your own CRUD procedures. We extract the data as
XML, use bi-directional binding on the Flex app, and send the same XML
back to the database to save. Super easy, and minimal middle tier
coding. The Flex framework is open source. But the Flex Builder/Flash
Builder IDE is not.

Scott Bailey