Re: [GENERAL] Something like Oracle Forms, but Open Source to use with PostgreSQL?

[Scott Bailey]

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Something like Oracle Forms, but Open Source to use with PostgreSQL?

[Alban Hertroys]

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

I am quite impressed with the Django framework for things like this. It uses 
the Python language, but if that's no problem for you then I heartily recommend 
it. I understand it's quite popular with Java developers too, apparently they 
use Django 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!



-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Something like Oracle Forms, but Open Source to use with PostgreSQL?

[Adam Tauno Williams]

On Mon, 2009-12-21 at 10: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 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].


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

-- 
OpenGroupware developer: awill...@whitemice.org

OpenGroupare & Cyrus IMAPd documenation @



-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Something like Oracle Forms, but Open Source to use with PostgreSQL?

[Allan Kamau]

On Mon, Dec 21, 2009 at 1:59 PM, 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, 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  wrote:
>>
>> On Mon, Dec 21, 2009 at 12:13 AM, 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.
>> >
>> > 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 ) 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.

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Something like Oracle Forms, but Open Source to use with PostgreSQL?

[Andre Lopes]

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  wrote:

> On Mon, Dec 21, 2009 at 12:13 AM, 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.
> >
> > 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
>

Re: [GENERAL] Something like Oracle Forms, but Open Source to use with PostgreSQL?

[Ivan Voras]

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.



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Something like Oracle Forms, but Open Source to use with PostgreSQL?

[Guy Rouillier]

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Something like Oracle Forms, but Open Source to use with PostgreSQL?

[John R Pierce]

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.






--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Something like Oracle Forms, but Open Source to use with PostgreSQL?

[Allan Kamau]

On Mon, Dec 21, 2009 at 12:13 AM, 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.
>
> 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

[GENERAL] Something like Oracle Forms, but Open Source to use with PostgreSQL?

[Andre Lopes]

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