Re: Web GUI for PG table ?

On 9/12/19 7:56 AM, David Gauthier wrote:
> Many good visualization options but I need one that runs on the web AND
> allows insert/update/delete records.

I do that using Django as the framework behind it.

See callbacks:
http://tabulator.info/docs/4.4/callbacks

In particular cell and data callbacks.

>
>
> On Thu, Sep 12, 2019 at 10:42 AM Adrian Klaver
> <adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>> wrote:
>
> 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(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com