Thread: Data Entry and Query forms

---

Try the all-new Yahoo! Mail . "The New Version is radically easier to use" – The Wall Street Journal

Hi, Anthony,

Anthony Kinyage wrote:

> Before continuing our Plans, I need to know how can I do with PostgreSQL
> in order to have Data Entry and Query Forms on clients side (How can I
> design Data Entry and Query Forms).

PostgreSQL itsself is a database server, not a front-end form designer.

However, using the PostgreSQL ODBC driver, you should be able to
continue using your current front-ends (like Access).

If you don't like this, maybe you can look at GNU Enterprise,
OpenOffice.org database module, Delphi/Kylix or others. (I admit I've
used none of those yet, we use PostgreSQL as backend for "real"
applications.)

HTH,
Markus

-- 
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org

I agree, using ODBC is probably a good first step.  Especially for M$Access.

For developers I recommend the EMS Manager tools.  They are a commercial product but I have been very pleased with them and we use the tools every day.  They are not exactly like SQL Manager but they serve the same purpose.  See http://www.sqlmanager.net/ .

Are there any web based management tools for PostgreSQL (like Mysql PHP Admin except for PostgreSQL)?  I thought I saw a post sometime back about one but don't remember the name.

-Aaron

Aaron Bono wrote:
> Are there any web based management tools for PostgreSQL (like Mysql PHP 
> Admin except for PostgreSQL)?  I thought I saw a post sometime back 
> about one but don't remember the name.

Yes, that's phpPgAdmin (http://phppgadmin.com).

Joe

> Hi 
>   I am new in PostgreSQL, I have just installed and
> created a database, I use MS-SQL 2000 and planning
> to  Migrate to Open Source.
>    
>   PostgreSQL  is installed  on Linux Redhat Server.
> We have 50 Clients PC using WinXP.
>    
>   Before continuing our Plans, I need to know how
> can I do with PostgreSQL in order to have Data Entry
> and Query Forms on clients side (How can I design
> Data Entry and Query Forms).
>    
>   If you can advice me the open source Software to
> add on PostgreSQL to solve my problem will be
> better.
>    
>   This will help the Management to accept PostgreSQL
> and plan Migration from 
>   MS-SQL 2000.
>    
>   Thanx
>    
>   Anthony Kinyage

Anthony, welcome to the world of open source!

you can continue to use windows programs (like
msaccess) as your front end by connecting with odbc.

however, i chose to use php (open source, too), html
and css.  it has worked out well.

i use two php classes that have pretty dramatically
increased my productivity.

1. Manuel Lemos' forms class (phpclasses.org) - this
is a powerful class that enables lots of useful forms
features.
2. adodb db abstraction layer

php is relatively easy to pick up if someone has a
desire to do so.  i could even send you sample scripts
to help guide you get started with adodb, the forms
class and the code layout structure.

i'm seriously looking into migrating my skills over to
ruby on rails.  you can review some screencasts here:

http://www.rubyonrails.org/screencasts

i'll be using postgresql as my db for any rails
projects, too (many people use mysql).  once one
becomes proficient in ruby (language) and rails
(framework), development becomes more efficient for
many apps.  many of the concepts (including object
oriented programming) are more complex and require
more up front planning - which may be more difficult
for someone new to OO programming.

so, i think php and ruby on rails would both likely
work as front end programming languages / frameworks. 
of course, you'd need to work in html and css to
display a layout.  cross browser css code is
difficult, but if you were interested, i will let you
know about a resource that will help you a lot.

good luck.

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

> 
> Before continuing our Plans, I need to know how can I do with
> PostgreSQL in order to have Data Entry and Query Forms on clients side
> (How can I design Data Entry and Query Forms).
>  

Hy. You could try using BOND framework which works for both linux and
win32. It is rather bad documented but is also very simple to use, and
there are examples. 

Mailing list is low traffic, but if you ask you will get your anwser
quick. The BOND developers are great guys, really :)

The link is http://www.treshna.com/bond/

the is also gnue, which is longer in production, and offers more
features at the moment, but requires some python knowledge
http://www.gnuenterprise.org/

Hope this helps and welcome to the wonderful world of opensource,

Jure