Re: Web GUI for PG table ? - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Web GUI for PG table ?
Date
Msg-id f25f901a-173f-8636-9035-d18dc50c6d52@aklaver.com
Whole thread Raw
In response to Re: Web GUI for PG table ?  (David Gauthier <davegauthierpg@gmail.com>)
List pgsql-general
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.klaver@aklaver.com <mailto:adrian.klaver@aklaver.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.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Strange Behaviour with multicolumn indexes
Next
From: "Peter J. Holzer"
Date:
Subject: Re: Strange Behaviour with multicolumn indexes