Re: Web GUI for PG table ?

["Basques, Bob (CI-StPaul)" <bob.basques@xxxxxxxxxxxxxxx>]

David,

You should find a fit in here somewhere:

https://pgdash.io/blog/postgres-gui-tools.html

https://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools

Also, we’ve done some interesting things with building an interface inside of LibreOffice as well. It’s still a separated approach though.   You can start quickly enough automatically, then keep tweaking the data forms as needed over time.  Use SQL for populating pull downs, etc.  Works real slick.

bobb

On Sep 12, 2019, at 9:08 AM, David Gauthier <davegauthierpg@xxxxxxxxx> wrote:

Think Before You Click: This email originated outside our organization.

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.