I had a few responses to my request for advice posted on 10 April, for which 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 sections ‘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=eWRfhZUzrAc&list=PLWKjhJtqVAbnqBxcdjVGgT3uVR10bzTEB
Python & Tkinter:
https://www.youtube.com/watch?v=yQSEXcf6s2I&list=PLCC34OHNcOtoC6GglhF3ncJ5rLwQrLGnV
Python & Postgres: https://www.youtube.com/watch?v=miEFm1CyjfM
Greetings and luck!
El 10/04/2024 a las 06:11, John Bateson escribió:
Good morning,
The end of my working life was taken up with developing and supporting a Scientific Research establishment near Warrington in the 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 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 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 nearly 200 tables.
We ended up using Ingres Replicator with the intention 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 made some improvements since then…
So much for the background to establish that I am not 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 project for some historic railways in the UK and linking these to the development 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 current and best practice for an easy GUI that will allow me to press a button without 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 newbie, need something I can work on quickly and intuitively and inexpensively!
So, recommendation and possibly some consensus would be very much appreciated.
And apologies if I have taken up too much of your time or have placed this in the wrong forum.
John
