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 1s0Ht5-002jvQ-6d for pgsql-general@arkaria.postgresql.org; Fri, 26 Apr 2024 09:28:59 +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 1s0Ht1-008gI9-Ns for pgsql-general@arkaria.postgresql.org; Fri, 26 Apr 2024 09:28:56 +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 1s0Ht0-008gDI-VK for pgsql-general@lists.postgresql.org; Fri, 26 Apr 2024 09:28:56 +0000 Received: from mail-am7eur03olkn2026.outbound.protection.outlook.com ([40.92.59.26] helo=EUR03-AM7-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 1s0Hsx-0009Jz-Pz for pgsql-general@lists.postgresql.org; Fri, 26 Apr 2024 09:28:55 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=PqBLyOE0HgyrylA0ySAy512xmNjEa/inizpZdzf5oVDV2q9gK/84w1xryMJdw/2o1ofFSWO/fcKT7ikQ1CZKIA+1Zn6jBbAjP64XXREO8IsoErU7mcGCuI/u+7GamzT3fab43VgzYOWSrcItS2Kbm3LqYhSrVxD9yqGHAbYBHVgYh81jiZ4C8IZ3Mv/wzpYpH6obuhIlUW2U3LLmIxwmFawILeFt8lYqBvWs82oLZW1039hj7337V3p8/ExlXa78u/F5k99IMDRNrR7YWsLOzbw1iZJmFQH2LFgAGOClZp1En8jVkq/vvUwI3d11wsKLnn3tsglWUZc+cXEPbxzULQ== 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=DIfA2TZ4UtTx9GUj0fRuo52MKyfnFX+oAVDBWLWsHZw=; b=c882t5fEtQEnd1OnD6TKLQhLA+XP+ZVsdoSEZlhFlnDreCJ1w5ZvRjzcfqqoJnMESwOSpT+/Ju/hA1CSeofUtsOU9GbK79boTJ3DiBIHAe1bRVmSvOuQzrAIiRi1MTELoDCE8qo3Mp8YGqpGlyza5yCzOI37Mc7NkV06nlUWaQSFqr9gqe8Ume7abyKdrfrTZOd70GQ26VVjURAhO3R/nAEvfSAISqy70+Gi1henwafC4QTJddJS38AXUzih42on1WVheUT3mrOmkQy83RzzJJokiBG5EuIqnJjX1NLKXVvlJpF34k3bTG3BEMezSt+hz9amcii+F4+hR5fU9K9fSQ== 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=DIfA2TZ4UtTx9GUj0fRuo52MKyfnFX+oAVDBWLWsHZw=; b=a1Rc0EnDnWgCvwnTxLmrUSMo9f4JTYTdEZm6cRggfc3qYY5+x2LOXvutpVh4S5Sb3jltEOPqzU+/sGxjtmB59uTk8fPM1ASBexBkCRfpg5rzF2vjvLx7bhUeWJ+nkjKRAV3bqBPCX/xgwqy2kfoR1Lxcdo+A9Ej5RL3gEbT/x8ulJoZKOrD4MMnrkx8f0wxW6s1QEREi3MgTtWbOvjGrb5LOV8hv81kM6KfoATPljihbTdF3zwHKYbTMfG8vDS4I0m22pN1fX11TA/kgn2Hhw1TgpNj3Kf4roM5yo9KnsZAnfL5adPYjSYSISEQEzu/z8xDFHP0M3COYBarsipHHkQ== Received: from PR3PR10MB3946.EURPRD10.PROD.OUTLOOK.COM (2603:10a6:102:41::22) by PAXPR10MB5232.EURPRD10.PROD.OUTLOOK.COM (2603:10a6:102:28d::9) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.7519.22; Fri, 26 Apr 2024 09:28:48 +0000 Received: from PR3PR10MB3946.EURPRD10.PROD.OUTLOOK.COM ([fe80::777f:5546:cfb7:ba67]) by PR3PR10MB3946.EURPRD10.PROD.OUTLOOK.COM ([fe80::777f:5546:cfb7:ba67%5]) with mapi id 15.20.7519.021; Fri, 26 Apr 2024 09:28:48 +0000 From: John Bateson To: Francisco Prado , "pgsql-general@lists.postgresql.org" Subject: RE: 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: AdqLK4kLhzKq9ozlRKSySxdBl3jfXAAIMjuAAxuObCA= Date: Fri, 26 Apr 2024 09:28:48 +0000 Message-ID: References: In-Reply-To: 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: [yab8MhK+vskChLlxHFG7vm9HVCnn+MF0tQ54FSWPLlHYdZUpja0OhabSnqhEoEt7pUgwG17IcCU=] x-ms-publictraffictype: Email x-ms-traffictypediagnostic: PR3PR10MB3946:EE_|PAXPR10MB5232:EE_ x-ms-office365-filtering-correlation-id: 94ba35a1-aeea-49a4-52bc-08dc65d34740 x-microsoft-antispam: BCL:0;ARA:14566002|461199019|9400799015|1602099003|102099023|56899024|3412199016|440099019; x-microsoft-antispam-message-info: +ovTffb1OKG2eyYhSrACPhx+vkUC8+tiQUeVTrX4nAj/XgypL0qVnCzAyY2H8Vqq6EesWr0J5M9JCYL4ly7HvqlS5l68yc734YRAjoOt4Gkwpyy17S0SXMrmtvOtPlFLJMdIIeNo7du0xY5xxFZMhw4xiDXJ0bx3jgdvJr8rCbayZtLvCxUFbaG9bqHJ6m2CCnHfI5Qu+yM/auTn2EEMAxk9bZvcfrluJMKeXbJW8kKqwD9vAa2+TfJYdbRLgOdYCNwGa0z5P0YBHiYFypeuzh0H4F3+Yvdw7nFWszIBBnerEd6pyvhK47ETr4Hoa6RAJUeicnwbmNsxQttSAwiKr6vVydZ9GadL5mh7XIU/ZMzhyqWjBR1iAAaMpW98vx/NXHUB1E5iT88vWUIHCUvxAlXTnDb3+9jgJRT2fIZRR59HUZ+pHWoJ1au1xsx4bZ1gaGcceVysWglPnlavOJDFZGjYEHN5JRzQRYzWLQCzj++FjDSpbbun8PIj0O/IZsW08hKDA9PkpIhb29UxJNsn5JCwTmVgDULNecLS7KMoYUS/Ow54m1XQfhFPQT7IhfR7JURjyXIKo3Ev78RsUxaNmaK5tNsub0YSbtgLH/m9arxZk5ffbjYLVFvp9ybFKlYEsdKhqgIPR+ETuBTrA1ogCYqLYSY5zVtQt3EMizdl/GyxG9Qu4DXtEgpYaSgEgZWJpheHfquN9AYn24sC+5L3zg== x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?iso-8859-1?Q?7rPahYw2fi3PgBV8FWdtWiu31VvZywpPjFLWnZ+I3X8Lzg0MAJzvxouDXI?= =?iso-8859-1?Q?D1GpVfQu+/G51AJ8AxS4cVMInT1Uc9viyYGmbIwOvSu6seO65STlcdg+hk?= =?iso-8859-1?Q?1c9MtkdIl9T38MiGdaaZElTJXpcnCNzO5bWwqGrJhDQHWVDQJRjjnzadoO?= =?iso-8859-1?Q?AAx8t39jsOhbYBwliXPH8ZCNnxXZpdvzUpLMnPV5vrDwhGqhmLWLcvfDHr?= =?iso-8859-1?Q?MbYDOs0ZbwzOMforiuKGmWW/hSxtDleKyMx/UwbhQchWePFyyErjetB7kC?= =?iso-8859-1?Q?GiiWm2qQ6uMg9G9NTt6/uR4y5n8JsiK3/0QH/MBtwPDbgonYS/8DhEL3uy?= =?iso-8859-1?Q?NqGqLUUYqLCvGEh2F4uaimfde4GKFXunTS/7X0k1I82DEhcYBDqlq2MkEx?= =?iso-8859-1?Q?eDlavpxqhtxnejAzew7QxLNRAI7UxDKu59kMFt4I1R3LTOTzeg+2a2PU/T?= =?iso-8859-1?Q?64OA/masWvEg0d6PEwlI82oWgrdFo5PrcO4J/3tG0pzN3+RnZrPRsrjpZq?= =?iso-8859-1?Q?b9wBTrNjPU4gXWXoAtynZZCKEh8eiOqllw9Y/hzY7q4ylvnvQifqsX/cqf?= =?iso-8859-1?Q?tfHjdRIf+8R0OkhY9FJIsv+1/JEA0HWmUCpiczrZe/vdpDQRk3c3yF3t5A?= =?iso-8859-1?Q?626J4nwManNXxJ9dZEgZOdU/se1SVGd02Sos8kswtSEEvA7yP0SXzjUz7m?= =?iso-8859-1?Q?WghrXq9LQmFjFrl1pdvTsmH3It/WmbF0DqkTNvIctnqXEqcBqqOZ4pC+8Y?= =?iso-8859-1?Q?LnObXTyBfDl6c7BIDOTmg98wG1v6fD802fbMrhtYfx3nIUKcDApYwF4TpH?= =?iso-8859-1?Q?HoA5FW/cSmw1zDvqmOK7Qw0Dl7h1RkoE0shCJjAJrDfkzpqHf7WN0xeHID?= =?iso-8859-1?Q?0xv1AIziqMLkbKUAyBhC1S6ivftIVE844XhOw0UhzFGZZhMeqNAF1R6Z+E?= =?iso-8859-1?Q?HbMyV5sMyO8nqmuKIkJf41wMQVBdjQRU3q1pmhuJiLhbOpUX+pbzbQhM1B?= =?iso-8859-1?Q?cCFCR02HTs10OcLX5Fs2O8jh/n7L3c27tLodjr5MFSCitiDmAiRmAhUgiq?= =?iso-8859-1?Q?opmYaED01LOFsrmiZbmAH3yHgHcdpjV13ZhkU52oGuPK9wSkahoOG2obub?= =?iso-8859-1?Q?0hhwBg6oha+VyMj/3NbHBdAqaOZYiULT0MUrb01sKjpNnnQYLtk8LTF/oN?= =?iso-8859-1?Q?Pp6RVJZJj4iZ/icxNsAdTxDf0+s9VTOqzvF+z6AqJuJgfDsJcTB9NHFukJ?= =?iso-8859-1?Q?quLPFv9YaBQzerRrMAGcLTDmWr/KzmOgPzp4kn/pYVXxc4mlw71Av3Dc9o?= =?iso-8859-1?Q?tBLeMw0Vqrac3SX6Dku0tXA0ZCNXDQ3MIOyNdYdzTV2wTskkMJnvUxPc4t?= =?iso-8859-1?Q?IpGql5moe+?= Content-Type: multipart/alternative; boundary="_000_PR3PR10MB3946DDE79C565650796EDA3EB7162PR3PR10MB3946EURP_" 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: 94ba35a1-aeea-49a4-52bc-08dc65d34740 X-MS-Exchange-CrossTenant-originalarrivaltime: 26 Apr 2024 09:28:48.7336 (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: PAXPR10MB5232 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_PR3PR10MB3946DDE79C565650796EDA3EB7162PR3PR10MB3946EURP_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I had a few responses to my request for advice posted on 10 April, for whic= h it is time that I registered my many thanks. It seems that I am now well sorted with a solution, parts of which I was ab= le to test very quickly, and now it is time to build a project structure. T= he Youtube offerings were very helpful and there are plenty of code section= s 'out there' which I have found are a good basis for some of the things I = need to do. So, Windows 11 Pro on a 32GB machine, stand-alone for now, with Postgres, P= GAdmin-4, TKinter and the embedded IDLE text editor. (OK - IDLE is free!, s= ome of the better ones are not) Again, thank you. John Additional resources: Python Tutorial: https://www.youtube.com/watch?v=3DeWRfhZUzrAc&list=3DPLWKj= hJtqVAbnqBxcdjVGgT3uVR10bzTEB Python & Tkinter: https://www.youtube.com/watch?v=3DyQSEXcf6s2I&list=3DPLCC= 34OHNcOtoC6GglhF3ncJ5rLwQrLGnV Python & Postgres: https://www.youtube.com/watch?v=3DmiEFm1CyjfM Greetings and luck! El 10/04/2024 a las 06:11, John Bateson escribi=F3: 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_PR3PR10MB3946DDE79C565650796EDA3EB7162PR3PR10MB3946EURP_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

I had a few responses to my request for advice posted on 10 April, for w= hich it is time that I registered my many thanks.

It seems that I am now well sorted with a solution, parts of which I was= able to test very quickly, and now it is time to build a project structure= . The Youtube offerings were very helpful and there are plenty of code sect= ions ‘out there’ which I have found are a good basis for some of the things I need to do.

So, Windows 11 Pro on a 32GB machine, stand-alone for now, with Postgres= , PGAdmin-4, TKinter and the embedded IDLE text editor. (OK – IDLE is= free!, some of the better ones are not)

 

Again, thank you.  

 

John

 

 

Additional resources:

Python Tutorial: https://www.youtube.com/watch?v=3DeWRfhZUzrAc&list=3DPLWKjhJtqVAbnqBxcd= jVGgT3uVR10bzTEB
Python & Tkinter: https://www.youtube.com/watch?v=3DyQSEXcf6s2I&list=3DPLCC34OHNcOtoC6Ggl= hF3ncJ5rLwQrLGnV
Python & Postgres: https://www.youtube.com/watch?v=3DmiEFm1CyjfM


Greetings and luck!

El 10/04/2024 a las 06:11, John Bateson escribi=F3:<= o:p>

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_PR3PR10MB3946DDE79C565650796EDA3EB7162PR3PR10MB3946EURP_--