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 
<davegauthie...@gmail.com<mailto:davegauthie...@gmail.com>> 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.

Reply via email to