Hi:
We're considering replacing a windows AccessDB based system with PG. Access was chosen because of it's GUI to its tables (looks and behaves like a SS). But performance can be volatile given the fact that the AccessDB front-ends and back-end are at different sites 1000+ miles apart. The belief is that a web-based approach where the DB server and web server are at the same site would be better.
Question is, would such a "spreadsheet-like" GUI have to be built from scratch or is there something that can be leveraged? Things to consider are record locking, constraint pull-downs, triggers updating values, etc... . We already have a nice PG server doing other work for us and would like to use that if possible.