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.