Re: Some advice need after a 20 year gap after Ingres/GUIs - Mailing list pgsql-general

From Dominique Devienne
Subject Re: Some advice need after a 20 year gap after Ingres/GUIs
Date
Msg-id CAFCRh--_ZZcu2-KK5L7a-JXGk-_f0bfg_BtDdWZWkhnW1vZHOg@mail.gmail.com
Whole thread Raw
In response to [MASSMAIL]Some advice need after a 20 year gap after Ingres/GUIs  (John Bateson <johnbateson1944@outlook.com>)
List pgsql-general
On Wed, Apr 10, 2024 at 12:11 PM John Bateson <johnbateson1944@outlook.com> wrote:

Using Postgres and PGAdmin -4.

[...]. This is getting towards 20 tables so far.

[...] i.e. the traditional .EXE file I can put on a button on the screen on a Windows 11 based system.


John,

Are you aware of SQLite or DuckDB?
Unlike PostgreSQL, which is an (excellent) client-server RDBMS,
the former two are "embedded" disk-based databases, which are quite capable.
"Deployment" is trivial. And their SQL engine are more sophisticated than most people realize.
Not that I want to turn you away from PostgreSQL, but they do have advantages, FWIW.
Having DBs be a single file on disk easily shared is quite convenient.

The reason I mention it here, is that SQLite for example has tons of ready-made GUIs,
with some of the Windows one being just 1 .exe indeed. Most allow to view the tables
in "Grid UI controls", some allow modifications too. They are not MS Access like, in the
sense that they don't allow writing custom UIs on top of the DB, just view and edit DB
tables. But maybe that's enough for your hobby project?

My $0.02. --DD

pgsql-general by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: mystery with postgresql.auto.conf
Next
From: Adrian Klaver
Date:
Subject: Re: Some advice need after a 20 year gap after Ingres/GUIs