On 9/12/19 7: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.
I've been using Tabulator(http://tabulator.info/) a JavaScript library for displaying data in tabular form. It does not care about the backend just that it gets data.