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.calla...@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@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > >
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
