Postgres data/form entry tool

Started by Dave Pottsalmost 19 years ago10 messagesgeneral
Jump to latest
#1Dave Potts
dave.potts@pinan.co.uk

Can any body recommend a generic opensource data entry tool that can be
used to make some simple forms for entering data in to postgres?

#2Richard Huxton
dev@archonet.com
In reply to: Dave Potts (#1)
Re: Postgres data/form entry tool

David Potts wrote:

Can any body recommend a generic opensource data entry tool that can be
used to make some simple forms for entering data in to postgres?

For the web? *nix console? GTK? Mac?

--
Richard Huxton
Archonet Ltd

#3Dave Potts
dave.potts@pinan.co.uk
In reply to: Richard Huxton (#2)
Re: Postgres data/form entry tool

David Potts wrote:

Any platform !

ie Web ,X, , L/Unix console, Mac or even Weandozz

Show quoted text

Can any body recommend a generic opensource data entry tool that can be
used to make some simple forms for entering data in to postgres?

For the web? *nix console? GTK? Mac?

--
Richard Huxton
Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

#4Richard Huxton
dev@archonet.com
In reply to: Dave Potts (#3)
Re: Postgres data/form entry tool

David Potts wrote:

David Potts wrote:

Any platform !

ie Web ,X, , L/Unix console, Mac or even Weandozz

pgadmin, phppgadmin - although these are pitched more towards admin,
they let you edit table data.

There are also lots of commercial admin/data tools that will work with
PG - check the announcements list and website.

MS-Access can link to PG via the ODBC drivers if you're interested in
Windows.

If you're interested in something slightly more custom, look at
ruby-on-rails or one of the other custom web-building systems. They all
let you do basic data editing quite quickly.

There's also the gnuenterprise.org project which is supposed to be
web+gui, but I've never looked at it in detail.

--
Richard Huxton
Archonet Ltd

#5Kenneth Downs
ken@secdat.com
In reply to: Dave Potts (#1)
Re: Postgres data/form entry tool

If you want end-users to be doing the data entry, Andromeda may be what
you want.

http://www.andromeda-project.org/

The project is aimed at more complicated cases and may carry too much
overhead for what you want, but perhaps not.

David Potts wrote:

Can any body recommend a generic opensource data entry tool that can be
used to make some simple forms for entering data in to postgres?

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

--
Kenneth Downs
Secure Data Software, Inc.
www.secdat.com www.andromeda-project.org
631-379-7200 Fax: 631-689-0527

#6Tony Caduto
tony_caduto@amsoftwaredesign.com
In reply to: Dave Potts (#1)
Re: Postgres data/form entry tool

David Potts wrote:

Can any body recommend a generic opensource data entry tool that can be
used to make some simple forms for entering data in to postgres?

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

For Desktop applications on win32

Lazarus :http://www.lazarus.freepascal.org/

Delphi Turbo Explorer: http://www.turboexplorer.com (use with ODBC or
Zeoslib http://www.zeoslib.net)

Sharp Develop: http://www.icsharpcode.com (use with npgsql .net data
provider)

For web based:

PHP and use NVU (http://www.nvu.com) to design the forms.

Netbeans IDE

There are probably many more

--
Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
Home of PG Lightning Admin for Postgresql
Your best option for Postgresql Administration

#7Reid Thompson
Reid.Thompson@ateb.com
In reply to: Tony Caduto (#6)
Re: Postgres data/form entry tool

On Thu, 2007-04-19 at 10:05 -0500, Tony Caduto wrote:

David Potts wrote:

Can any body recommend a generic opensource data entry tool that can be
used to make some simple forms for entering data in to postgres?

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

For Desktop applications on win32

Lazarus :http://www.lazarus.freepascal.org/

Delphi Turbo Explorer: http://www.turboexplorer.com (use with ODBC or
Zeoslib http://www.zeoslib.net)

Sharp Develop: http://www.icsharpcode.com (use with npgsql .net data
provider)

For web based:

PHP and use NVU (http://www.nvu.com) to design the forms.

Netbeans IDE

There are probably many more

http://www.gnome-db.org/

#8Alvaro Herrera
alvherre@2ndquadrant.com
In reply to: Reid Thompson (#7)
Re: Postgres data/form entry tool

Reid Thompson wrote:

On Thu, 2007-04-19 at 10:05 -0500, Tony Caduto wrote:

http://www.gnome-db.org/

Glom (www.glom.org) would seem to fit the bill.

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

#9Chris Browne
cbbrowne@acm.org
In reply to: Dave Potts (#1)
Re: Postgres data/form entry tool

ken@secdat.com (Kenneth Downs) writes:

If you want end-users to be doing the data entry, Andromeda may be
what you want.

http://www.andromeda-project.org/

The project is aimed at more complicated cases and may carry too much
overhead for what you want, but perhaps not.

Their choice of "something like CSS" (e.g. - the HTML 'cascading style
sheets' language) as the language for representing data models seems
bizarre to me, but their goal of making the whole thing declarative
seems mighty attractive.

Is anyone using this for interesting applications?
--
(format nil "~S@~S" "cbbrowne" "linuxfinances.info")
http://linuxfinances.info/info/nonrdbms.html
--Kill Running Inferiors--

#10Brent Wood
b.wood@niwa.co.nz
In reply to: Richard Huxton (#4)
Re: Postgres data/form entry tool

Richard Huxton wrote:

David Potts wrote:

David Potts wrote:

Any platform !

ie Web ,X, , L/Unix console, Mac or even Weandozz

pgadmin, phppgadmin - although these are pitched more towards admin,
they let you edit table data.

PGAccess provides a spreadsheet like view of tables which users can type
data into, & works pretty well, it
does not have the admin functionality of pgadmin, which might be a good
thing in your case.

Perhaps a simple PHP data entry form for a web based tool.

I haven't tried these, but they may also work OK (on a Linux/KDE platform):

knoda http://www.knoda.org/
rekall http://www.thekompany.com/projects/rekall/

Maybe someome who has actually tried these could comment?

Cheers,

Brent Wood