<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.6001.18470" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=837515316-05082010>John,</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=837515316-05082010></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=837515316-05082010>For
the web solution I use WaveMaker with but haven't done anything too fancy
with it yet. <A
href="http://www.wavemaker.com/">http://www.wavemaker.com/</A></SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=837515316-05082010>SQL
Workbench might be another option. <A
href="http://www.sql-workbench.net/">http://www.sql-workbench.net/</A> </SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=837515316-05082010></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=837515316-05082010>Eric</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<P><FONT size=2>Eric Randall<BR>GIS DB Admin/Analyst<BR>County of Erie<BR>140 W
6th St<BR>Room 111<BR>Erie, PA 16501<BR><BR>ph. 814-451-6063<BR>fx.
814-451-7000<BR></FONT></P>
<BLOCKQUOTE>
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net]<B>On Behalf Of </B>John
Callahan<BR><B>Sent:</B> Thursday, August 05, 2010 9:54 AM<BR><B>To:</B>
PostGIS Users Discussion<BR><B>Subject:</B> [postgis-users] postgres data
tables package (ORACLE Formsreplacement?)<BR><BR></FONT></DIV>Brief
background: We're currently using Oracle for our main database. Nothing
too big, 15 - 20 tables and the largest table has about 100K
records. We use Oracle Forms as a web-based option for inserting
and updating records.<BR><BR>I am using Postgres/PostGIS for a couple of other
projects. I would like to use Postgres for our main database as
well. However, I would need to come up with a solution for
inserting/updating the data tables within our group (a replacement for Oracle
Forms). Preferably, a web-based solution (PHP, Python, etc...) but it
could be a Windows desktop solution installed on each staff members
machine. Something that maintains the data integrity (e.g., forcing
users to enter a date when Date is required, etc...)<BR><BR>Does anyone know
of a FOSS package that can be used to manage data tables within a Postgres
database? Updating data records is the highest priority since the
built-in Admin tool can be used for managing users, creating new tables,
etc..., and will be done only by a database manager. Thanks for any
advice or guidance you can provide.<BR><BR><BR>-
John<BR><BR></BLOCKQUOTE></BODY></HTML>