[postgis-users] postgres data tables package (ORACLE Forms replacement?)

[Mike Toews]

Hi John,

For the desktop, the best I've seen is MS Access, but it is certainly not
FOSS. It is well used, documented, supported, easy form development, etc. A
runner up is OpenOffice.org, but I haven't been able to develop too much on
it, because I run into odd GUI behaviours that are deal-breakers (e.g., the
scroll-wheel of the mouse can "accentually" modify numeric data if it hovers
over a numeric field ... although this is in the process of being fixed).
Kexi (from KOffice) is yet another app, but I haven't looked at it in a few
years and I don't know if it is available for Windows anymore.

For the web, there is WaveMaker, which is very web 2.0 with lots of
JavaScript to make it appear like a desktop application. I've only had
limited work with it, so I can't say too much about it. (I recall having a
poor impression due to problems with bad permission assumptions and some
other data type issues). There are others out there, but I'm interested to
see what other people use.

-Mike


On 5 August 2010 06:53, John Callahan <john.callahan at udel.edu> wrote:

> 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.
>
> 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...)
>
> 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.
>
>
> - John
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100805/e0e61abd/attachment.html>