On 9/12/19 9:08 AM, David Gauthier wrote:
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.
There was a long thread last month titled "Recomended front ends?".
https://www.postgresql.org/message-id/20190807185708.GA19765%40panix.com--
Angular momentum makes the world go 'round.