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

2009-12-21 Thread 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?

2009-12-21 Thread 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 kamaual...@gmail.com wrote:

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



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

2009-12-21 Thread Allan Kamau
On Mon, Dec 21, 2009 at 1:59 PM, Andre Lopes lopes80an...@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 kamaual...@gmail.com wrote:

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

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

2009-12-21 Thread 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].
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: awill...@whitemice.org
http://whitemiceconsulting.blogspot.com/
OpenGroupare  Cyrus IMAPd documenation @
http://docs.opengroupware.org/Members/whitemice/wmogag/file_view


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

2009-12-21 Thread 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?

2009-12-21 Thread 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


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

2009-12-20 Thread 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é.


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

2009-12-20 Thread 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?

2009-12-20 Thread 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