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 1ruUvR-005mTm-ST for pgsql-general@arkaria.postgresql.org; Wed, 10 Apr 2024 10:11:31 +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 1ruUvR-000YVK-2z for pgsql-general@arkaria.postgresql.org; Wed, 10 Apr 2024 10:11:29 +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 1ruUvQ-000YPj-74 for pgsql-general@lists.postgresql.org; Wed, 10 Apr 2024 10:11:28 +0000 Received: from mail-vi1eur05olkn2027.outbound.protection.outlook.com ([40.92.90.27] helo=EUR05-VI1-obe.outbound.protection.outlook.com) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ruUvM-000Azp-RX for pgsql-general@lists.postgresql.org; Wed, 10 Apr 2024 10:11:27 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=BV/6pq5kg9cPuMQ+jhW1Bgn0Pcz4qeavEFmJd6H/ifgOJY5M2KhVPdNR0s75kORMVnpRmYUA203YdF/dq7LOOc4v0E2I93FjK9tr4IIaKWCZxMBLFLls5dPDI83VrIaFZcwe3U6K69BbnU1GP4GAbdidFn3JzY23LUmU5lE8opniBdu5Seq5PD+hVnI3ZSpZFhYxUeRmygbK2odJ1ayFcKvuFrZh1TMQBFDdQ8ViDlUf6YLG9EBhiShdffFiOatBNDmHpXqyyMFzzDIQ0xejij0kDNzf2S+ncfRkp9DsXEPwXATtvFZHviHv2tLzYSlzTLj/qCZeJeuhyftXjNZ9ng== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=vDNVqsie5H4b4HB+Zx55pjfQSpaKJeTqNg4GM2EkLDw=; b=iYwnEAcAQCMpxsZgb5RtUnBdXXtaeV4b3npYffxNinO6v97n3UIkXvLoZV4AoJeBBHpigZ3lgPhyLX0gxsLiIIxrIUOKOCANH+efjmL8jW/sDUerhO523ZQDwXs+xEaPyDanglgr5DCShirp9WVWJrK8dQWSEEUOQnOsBhqBr6bbZs0ci3cTpfr73XAvTgSQU15OmCQlPfu++2GrraZIgy0X0TKIBJgzW1rCKieRJQGzxg2UjyVY9S3JjFR77VtCukbTgFdeHhgniHt+cb2IfnKpgjb75e+nJGTxk/DuNzH/w/zXzBVl30mob+1ZUvSkX9y7DavQVfItN8sffM2sPA== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=none; dmarc=none; dkim=none; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=outlook.com; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=vDNVqsie5H4b4HB+Zx55pjfQSpaKJeTqNg4GM2EkLDw=; b=VYsIXmDX6ELAf9cGm05r4zuAj2r52Oka9W9yxHpo9fooEetC2CJ2KaNG9gSll1iuQKE6xxa2ky8EWY5f63usvoxhQ/2XpgtqDNvda/mfvbHcO7jCiqd6nIrXahBOJOeeK7VScNad/Ib1UgLO1ttcVAA3suwQj8GDmFllWPf8Be8rufQckWbdJVXEtPAmnGM0qspnFczaKKvcjlBaara0sdYvPcl0MxMlcuAGryY8hqQqb4VoiAqRUclAsmktBPgaDNalg2hF3nGwtmD0uoyxYl1yAObDMPdgLqifcGaAli5XkP+NkseybjTvrBLuJ8lvd+UiqB+BMjOakh2mHO2c0A== Received: from PR3PR10MB3946.EURPRD10.PROD.OUTLOOK.COM (2603:10a6:102:41::22) by VI0PR10MB9169.EURPRD10.PROD.OUTLOOK.COM (2603:10a6:800:235::6) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.7409.46; Wed, 10 Apr 2024 10:11:21 +0000 Received: from PR3PR10MB3946.EURPRD10.PROD.OUTLOOK.COM ([fe80::46a:71e4:727e:e13a]) by PR3PR10MB3946.EURPRD10.PROD.OUTLOOK.COM ([fe80::46a:71e4:727e:e13a%2]) with mapi id 15.20.7409.053; Wed, 10 Apr 2024 10:11:21 +0000 From: John Bateson To: "pgsql-general@lists.postgresql.org" Subject: Some advice need after a 20 year gap after Ingres/GUIs Thread-Topic: Some advice need after a 20 year gap after Ingres/GUIs Thread-Index: AdqLK4kLhzKq9ozlRKSySxdBl3jfXA== Date: Wed, 10 Apr 2024 10:11:21 +0000 Message-ID: Accept-Language: en-GB, en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-ms-exchange-messagesentrepresentingtype: 1 x-tmn: [CQqxi6E/msEoyV6Ik1UKbZOUT2UBNsGl5emnkZET9I8R2Xu1MJg00EYTwWZYBwc+vMGIpvrnKls=] x-ms-publictraffictype: Email x-ms-traffictypediagnostic: PR3PR10MB3946:EE_|VI0PR10MB9169:EE_ x-ms-office365-filtering-correlation-id: 3b37c4f9-bbd1-4ddc-4886-08dc594691ff x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: hkGdnhe3kNTPF4YOOSEjwvs0O51eVRXdHWy9WrAuhcNc+mX2oA9cdJLO1FpYbwN6/Xwv4i5m6CyfqPFRyEdRGQU8Cgm9nU9Lco5ycOD67SeAj39RfF2ZpzDBLkkYOQIRczC9vqIRKZ9ahJNEFBO5SnlmGJt0hrFPw+0/VQzAZ0bNhkkazM8j9GjECQ6vMlnzDEbpseHGYylQaEtv3B5mfjm2TgGjl+/emXZde77ZTHYqdj0JDXgzDzuvstC4dMs/ixU7BYTrjDmOw5ZIAq5PMZkot77vKpMH7gPYUNVa4OzjOB2TN4DjnF5sI0E3rJyeeFjBv1JL5tBgNck7Wk0MFlrml3a+jMxUsqiWiaeCDhFz8I6VbgMTf7V+fD0otQlf5B+mOac5EmaXumi8xKKZiOWVMhGlC1/nK32ECwgD3DpHhoZzh6BFlmK8vEX43LvejkTG3I1SMWsm0HVkEfLzQeBAzvHPNmehc021WJ7Wu/7D7GC6I4HnmZFheOq5KOUKhUKuZdJrnKKbPjSaIIiIDebY2TLdEGQb8yq4iZm+6m5PlxI5oYLYVcgcQkUxIaeI x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?us-ascii?Q?+t3aQMCpq4RDCQrAR1d+M26lmB5pyfOo+rVsYtCTwcKIcDoCPnLSMIMbm0gB?= =?us-ascii?Q?JGgVQIQ2SPavMYf3z0Rf/OOe3C+7Xq6yRxMRYWFp/ONrimlRodFGIv+o977R?= =?us-ascii?Q?qCsGhbULqSEjdrrC19lzscFrlRQvRZbQ68JcoqiwBdRBqxJsUmp+LOS0rmtd?= =?us-ascii?Q?43mmEpdEWncer6cAoUE4m4fIzI2hqYGJG3CvkE59J5+iaGE9YDwG0Qvt86Jo?= =?us-ascii?Q?8PMDxlxZgb4SNsBKVM0SxazR69b660Um/QYBH8unl7yXP80k8uM21O0rOwc/?= =?us-ascii?Q?LeKHr2uw2oD5InQkkv9MA4PfWBjNuL13HveWR61kAC8WqVbX9WRhDhY1bB2w?= =?us-ascii?Q?7tqFXcuES2+yem8aaLOl3Tu2ic7tr834XaFkSmPptUTMl40ju4XXSbEiFHHg?= =?us-ascii?Q?ACOL8ZLXugsSGGZ5NhdzX5sQq8Y8A3F2vUNqMwZQqo7wKy8PmzS4tOVyUgmr?= =?us-ascii?Q?ZBK4aSQqdGK96earezzUnNDLI6IU8FJOlwKT2lr/sLIuYPHLuu7NWeDcM+dq?= =?us-ascii?Q?/X+3iRLwdx9bfJO4B0am48HPLtSs3nfFlLOIjaUVQ8EO1EWIOBGwF9Hp8AUE?= =?us-ascii?Q?tg+GsZ9sf4ql1KQ9CAaHwwvX9MnozKePOjPoyoC/IHp3tGNTRF6EsJqgzZs1?= =?us-ascii?Q?cPGGJtTv85HvfamQ2w8Q6DSAabPOVP5h/8GS+9dNidL+iulM2jRYcvNxHHh7?= =?us-ascii?Q?pyam+LhlCKVlVpj7wSuHR3hIlJg9Wi/FwmQ70Mi30hxsdAmeCwcXYdqQeZLv?= =?us-ascii?Q?VpzXhCT1JvTii4RzkSh03uGv8X/xery2U64tsT0J4PpANnTloTpGA8MyPuKF?= =?us-ascii?Q?glEQAWtnEMG0PAfNYQafoeE+JJ+RxMXKg9ZeGFIY1w5fqMUl9sfvHq7S3gSZ?= =?us-ascii?Q?u+nh7FgHr5NCso4ny+dbpyWFKvtG1ob9cje2L62z6kImLDdm5xu1s/zGl95U?= =?us-ascii?Q?Td9ooAAl3GgCIe2CctITIPT5+HIxw5nxdU98q8jnV+IF6mjzm7ObvN7sQ/dJ?= =?us-ascii?Q?ejKrrvN0VJOJ8w3dcm5aQbquVn0gNFzGfUeNWTfNXzwEzMLjtWkq1j8jHnZu?= =?us-ascii?Q?9Wi2qopS9mtJn6CGwFCx3a8ty874jkD4uKsjsJliup2ow7R/DohBXvGXw/Xy?= =?us-ascii?Q?3Oj3I0wildE1hs1jq6beScPbynAZHpVIDlX4RFlX2xyryET9LgVHmLEzvYWz?= =?us-ascii?Q?A6llrudZt/y+YBGttDzuei7YELt+vWYP5RWnr2it8MeoOnKtmq8zn/Ros1Xl?= =?us-ascii?Q?w1ANZMrGsQZkkr+2GFP3lbc0RojLBj1GBqyVJRF2Gm3e7iQ3zU6W02lllbNJ?= =?us-ascii?Q?qH5+jtU0Y88uD9SS/EXnFKCT?= Content-Type: multipart/alternative; boundary="_000_PR3PR10MB39463C6F138AE367D393D9D0B7062PR3PR10MB3946EURP_" MIME-Version: 1.0 X-OriginatorOrg: outlook.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: PR3PR10MB3946.EURPRD10.PROD.OUTLOOK.COM X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-CrossTenant-Network-Message-Id: 3b37c4f9-bbd1-4ddc-4886-08dc594691ff X-MS-Exchange-CrossTenant-originalarrivaltime: 10 Apr 2024 10:11:21.1654 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa X-MS-Exchange-CrossTenant-rms-persistedconsumerorg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-Transport-CrossTenantHeadersStamped: VI0PR10MB9169 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_PR3PR10MB39463C6F138AE367D393D9D0B7062PR3PR10MB3946EURP_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Good morning, The end of my working life was taken up with developing and supporting a Sc= ientific Research establishment near Warrington in the UK. I had a small te= am of programmer who did an excellent job for me and with me. The software was Ingres and the main program supporting user administration= on a Synchrotron was built under OpenROAD with other developments around = the on-site stores and finance using ABF since the stores workers found th= is much faster than a GUI! There was also some web development use .Net pra= ctises. This was a quite complex system in the end with nearly 200 tables. We ended up using Ingres Replicator with the intention of running it from t= wo sites 180 miles apart - at the time it was a pile of notquitegoodenough!= This was early this century so Actian may have made some improvements sinc= e then... So much for the background to establish that I am not a complete newbie, ju= st out of the loop for a while. Using Postgres and PGAdmin -4. So, 20 years later I am developing, (unpaid) a new project for some histori= c railways in the UK and linking these to the development and design of a r= ange of kits for those interested in model railways. This is getting toward= s 20 tables so far. What I really need is a recommendation for the current and best practice fo= r an easy GUI that will allow me to press a button without opening up PGAdm= in or a black screen, i.e. the traditional .EXE file I can put on a button = on the screen on the screen on a Windows 11 based system. While my programming history goes back to MDBS-4 and beyond I know I have s= ome catching up to do and while not a complete newbie, need something I can= work on quickly and intuitively and inexpensively! So, recommendation and possibly some consensus would be very much appreciat= ed. And apologies if I have taken up too much of your time or have placed this = in the wrong forum. John --_000_PR3PR10MB39463C6F138AE367D393D9D0B7062PR3PR10MB3946EURP_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Good morning,

The end of my working life was taken up with develop= ing and supporting a Scientific Research establishment near Warrington in t= he UK. I had a small team of programmer who did an excellent job for me and= with me.

The software was Ingres and the main program support= ing user administration on a Synchrotron was built  under OpenROAD wit= h other developments around the on-site stores and finance  using ABF = since the stores workers found this much faster than a GUI! There was also some web development use .Net practises.

This was a quite complex system in the end with near= ly 200 tables.

We ended up using Ingres Replicator with the intenti= on of running it from two sites 180 miles apart – at the time it was = a pile of notquitegoodenough! This was early this century so Actian may have m= ade some improvements since then…

 

So much for the background to establish that I am no= t a complete newbie, just out of the loop for a while.

 

Using Postgres and PGAdmin -4.

So, 20 years later I am developing, (unpaid) a new p= roject for some historic railways in the UK and linking these to the develo= pment and design of a range of kits for those interested in model railways.= This is getting towards 20 tables so far.

What I really need is a recommendation for the curre= nt and best practice for an easy GUI that will allow me to press a button w= ithout opening up PGAdmin or a black screen, i.e. the traditional .EXE file= I can put on a button on the screen on the screen on a Windows 11 based system.

While my programming history goes back to MDBS-4 and= beyond I know I have some catching up to do and while not a complete newbi= e, need something I can work on quickly and intuitively and inexpensively!<= o:p>

 

So, recommendation and possibly some consensus would= be very much appreciated.

 

And apologies if I have taken up too much of your ti= me or have placed this in the wrong forum.

 

John

--_000_PR3PR10MB39463C6F138AE367D393D9D0B7062PR3PR10MB3946EURP_--