public inbox for [email protected]  

help / color / mirror / Atom feed

From: Dominique Devienne <[email protected]>
To: John Bateson <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: Some advice need after a 20 year gap after Ingres/GUIs
Date: Wed, 10 Apr 2024 16:48:42 +0200
Message-ID: <CAFCRh--_ZZcu2-KK5L7a-JXGk-_f0bfg_BtDdWZWkhnW1vZHOg@mail.gmail.com> (raw)
In-Reply-To: <PR3PR10MB39463C6F138AE367D393D9D0B7062@PR3PR10MB3946.EURPRD10.PROD.OUTLOOK.COM>
References: <PR3PR10MB39463C6F138AE367D393D9D0B7062@PR3PR10MB3946.EURPRD10.PROD.OUTLOOK.COM>

On Wed, Apr 10, 2024 at 12:11 PM John Bateson <[email protected]>
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

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Some advice need after a 20 year gap after Ingres/GUIs
  In-Reply-To: <CAFCRh--_ZZcu2-KK5L7a-JXGk-_f0bfg_BtDdWZWkhnW1vZHOg@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox