Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ruZFz-006AKs-UZ for pgsql-general@arkaria.postgresql.org; Wed, 10 Apr 2024 14:49:00 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1ruZFz-003jj4-4I for pgsql-general@arkaria.postgresql.org; Wed, 10 Apr 2024 14:48:59 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ruZFy-003jiw-Py for pgsql-general@lists.postgresql.org; Wed, 10 Apr 2024 14:48:58 +0000 Received: from mail-oa1-x36.google.com ([2001:4860:4864:20::36]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1ruZFw-000DCX-AZ for pgsql-general@lists.postgresql.org; Wed, 10 Apr 2024 14:48:58 +0000 Received: by mail-oa1-x36.google.com with SMTP id 586e51a60fabf-23319017c4cso326354fac.2 for ; Wed, 10 Apr 2024 07:48:55 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1712760534; x=1713365334; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=m0qtPoKe73z/OyrOcRLLOieIQSp9rpADPY4M2dpW0YM=; b=G9SM5e/g6F6WaKLV2eEyHxneEqL2DaDR5L2ZjxoWyZoxRjKnZmaakZVxCoIL029uIN iRZyDtfIh+BnDPGSasdW4WflziIiC1CVPSGGE+x1QAR4RN34hoF6EkhRBkNFDY5iVTLw 4toDpCfpjXAkgclaqxL0Lp9F3qBXu1RR/BS1jw7E+TnremZYCCFSIGe5tN6x7Vt7Yr9r OYPMTBHJn/qByyI9JkvXPleaM6Z4xYtV+L/ZNkS+TcJgavK5gXysg6XDfQ3byRMNrWcb 7Ya7PEcY8br08Ri8dWf50T9LOIblhuHKW0rWrU2zMDAsoN41R3HeNkFBByUivNJ9sebF pbBg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1712760534; x=1713365334; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=m0qtPoKe73z/OyrOcRLLOieIQSp9rpADPY4M2dpW0YM=; b=koBd+v1FErBezfXZAMLponsjXO59WZo/i4QFHKWOThmgaeqlm1Ob06WTmcV58kuLo/ NDUp0tIqUSthzF4m9SS9Fi+DtT+/N51ITnl5ahMDDJCb8C1XUlH7goJr52ckh+FKKAPT coPONhjnYKXlMG14pn2stxpp3tPsddeCADHnu4vBI+U+ZZ4ZIKiCqghIlZ247uoIk+xE M0OzgzntGOX6575xStDCv9xAai74qjXefwAsn5YOvTzBInSW/mNymyikYXjIKcrdih3O o8Ep1v3kwVN+fyiXqe49FZhZEvaTvhTTgvy8wfmeY3lR7gHnSvoUSdzz9KFDIOVl6RTk UOWA== X-Gm-Message-State: AOJu0Yzou8yl2rlSuGgzdvYJHBGv0y++VJz9yVq0Dh09fXwF9+dLNZBe s2QnNhoqhWy/eMiqmJFcrz0blDsqXlvv+E0aggHZO/tTORFuiBdRmNXu+Xpb55TeSnDhToM3GvU shFtwdojIyE8nd6/5GHduP0YNGBs= X-Google-Smtp-Source: AGHT+IGSAc2sd95shH9uhOLYALp+jf78T7K8lQHDchpSGHXvnxi5rWVbf/QXJX/Nn06LqaJAMUuUohMkw87CFIYYBkQ= X-Received: by 2002:a05:6870:c6a4:b0:229:e422:4ff9 with SMTP id cv36-20020a056870c6a400b00229e4224ff9mr2897677oab.18.1712760533949; Wed, 10 Apr 2024 07:48:53 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Dominique Devienne Date: Wed, 10 Apr 2024 16:48:42 +0200 Message-ID: Subject: Re: Some advice need after a 20 year gap after Ingres/GUIs To: John Bateson Cc: "pgsql-general@lists.postgresql.org" Content-Type: multipart/alternative; boundary="00000000000036237a0615bf2325" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000036237a0615bf2325 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Wed, Apr 10, 2024 at 12:11=E2=80=AFPM John Bateson 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 --00000000000036237a0615bf2325 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Wed, Apr 10, 2024 at 12:11=E2=80=AFPM = John Bateson <johnbateson= 1944@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) c= lient-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 re= alize.
Not that I want to turn you away from PostgreSQL, but they= do have advantages, FWIW.
Having DBs be a single file on disk ea= sily shared is quite convenient.

The reason I ment= ion it here, is that SQLite for example has tons of ready-made GUIs,
<= div>with some of the Windows one being just 1 .exe indeed. Most allow to vi= ew the tables
in "Grid UI controls", some allow modific= ations too. They are not MS Access like, in the
sense that they d= on'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?
<= div>
My $0.02. --DD
--00000000000036237a0615bf2325--