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.
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
