pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedData Entry and Query forms
6+ messages / 6 participants
[nested] [flat]
* Data Entry and Query forms
@ 2006-06-29 13:40 Anthony Kinyage <kinyage_tony@yahoo.com>
0 siblings, 3 replies; 6+ messages in thread
From: Anthony Kinyage @ 2006-06-29 13:40 UTC (permalink / raw)
To: pgsql-sql
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
---------------------------------
Try the all-new Yahoo! Mail . "The New Version is radically easier to use" – The Wall Street Journal
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Data Entry and Query forms
@ 2006-06-29 13:50 Markus Schaber <schabi@logix-tt.com>
parent: Anthony Kinyage <kinyage_tony@yahoo.com>
2 siblings, 1 reply; 6+ messages in thread
From: Markus Schaber @ 2006-06-29 13:50 UTC (permalink / raw)
To: Anthony Kinyage <kinyage_tony@yahoo.com>; +Cc: pgsql-sql
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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Data Entry and Query forms
@ 2006-06-29 15:41 Aaron Bono <postgresql@aranya.com>
parent: Markus Schaber <schabi@logix-tt.com>
0 siblings, 1 reply; 6+ messages in thread
From: Aaron Bono @ 2006-06-29 15:41 UTC (permalink / raw)
To: Markus Schaber <schabi@logix-tt.com>; +Cc: Anthony Kinyage <kinyage_tony@yahoo.com>; pgsql-sql
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
On 6/29/06, Markus Schaber <schabi@logix-tt.com> wrote:
>
> 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
>
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Data Entry and Query forms
@ 2006-06-29 15:57 Joe <dev@freedomcircle.net>
parent: Aaron Bono <postgresql@aranya.com>
0 siblings, 0 replies; 6+ messages in thread
From: Joe @ 2006-06-29 15:57 UTC (permalink / raw)
To: Aaron Bono <postgresql@aranya.com>; +Cc: Markus Schaber <schabi@logix-tt.com>; Anthony Kinyage <kinyage_tony@yahoo.com>; pgsql-sql
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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Data Entry and Query forms
@ 2006-06-29 18:02 operationsengineer1@yahoo.com
parent: Anthony Kinyage <kinyage_tony@yahoo.com>
2 siblings, 0 replies; 6+ messages in thread
From: operationsengineer1@yahoo.com @ 2006-06-29 18:02 UTC (permalink / raw)
To: Anthony Kinyage <kinyage_tony@yahoo.com>; pgsql-sql
> 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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Data Entry and Query forms
@ 2006-06-30 09:51 Jure Kodzoman <jure@plsavez.hr>
parent: Anthony Kinyage <kinyage_tony@yahoo.com>
2 siblings, 0 replies; 6+ messages in thread
From: Jure Kodzoman @ 2006-06-30 09:51 UTC (permalink / raw)
To: Anthony Kinyage <kinyage_tony@yahoo.com>; +Cc: pgsql-sql
>
> 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
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2006-06-30 09:51 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-06-29 13:40 Data Entry and Query forms Anthony Kinyage <kinyage_tony@yahoo.com>
2006-06-29 13:50 ` Markus Schaber <schabi@logix-tt.com>
2006-06-29 15:41 ` Aaron Bono <postgresql@aranya.com>
2006-06-29 15:57 ` Joe <dev@freedomcircle.net>
2006-06-29 18:02 ` operationsengineer1@yahoo.com
2006-06-30 09:51 ` Jure Kodzoman <jure@plsavez.hr>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox