[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-general
Subject: RE: Some advice need after a 20 year gap after Ingres/GUIs
From: John Bateson <johnbateson1944 () outlook ! com>
Date: 2024-04-26 9:28:48
Message-ID: PR3PR10MB3946DDE79C565650796EDA3EB7162 () PR3PR10MB3946 ! EURPRD10 ! PROD ! OUTLOOK ! COM
[Download RAW message or body]
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
[Attachment #3 (text/html)]
<html xmlns:v="urn:schemas-microsoft-com:vml" \
xmlns:o="urn:schemas-microsoft-com:office:office" \
xmlns:w="urn:schemas-microsoft-com:office:word" \
xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" \
xmlns="http://www.w3.org/TR/REC-html40"> <head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Aptos;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
font-size:11.0pt;
font-family:"Aptos",sans-serif;
mso-ligatures:standardcontextual;
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
span.EmailStyle22
{mso-style-type:personal-reply;
font-family:"Aptos",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;
mso-ligatures:none;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:938224307;
mso-list-template-ids:-1686489640;}
@list l0:level1
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:36.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:72.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:"Courier New";
mso-bidi-font-family:"Times New Roman";}
@list l0:level3
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:108.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level4
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:144.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level5
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:180.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level6
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:216.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level7
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:252.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level8
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:288.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level9
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:324.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
ol
{margin-bottom:0cm;}
ul
{margin-bottom:0cm;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-GB" link="blue" vlink="purple" style="word-wrap:break-word">
<div class="WordSection1">
<p>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.<o:p></o:p></p> <p>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.<o:p></o:p></p> <p>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)<o:p></o:p></p> <p><o:p> </o:p></p>
<p>Again, thank you. <o:p></o:p></p>
<p><o:p> </o:p></p>
<p>John<o:p></o:p></p>
<p><o:p> </o:p></p>
<p><o:p> </o:p></p>
<p>Additional resources:<br>
<br>
Python Tutorial: <a href="https://www.youtube.com/watch?v=eWRfhZUzrAc&list=PLWKjhJtqVAbnqBxcdjVGgT3uVR10bzTEB">
https://www.youtube.com/watch?v=eWRfhZUzrAc&list=PLWKjhJtqVAbnqBxcdjVGgT3uVR10bzTEB</a><br>
Python & Tkinter: <a \
href="https://www.youtube.com/watch?v=yQSEXcf6s2I&list=PLCC34OHNcOtoC6GglhF3ncJ5rLwQrLGnV">
https://www.youtube.com/watch?v=yQSEXcf6s2I&list=PLCC34OHNcOtoC6GglhF3ncJ5rLwQrLGnV</a><br>
Python & Postgres: <a \
href="https://www.youtube.com/watch?v=miEFm1CyjfM">https://www.youtube.com/watch?v=miEFm1CyjfM</a><br>
<br>
<br>
Greetings and luck!<o:p></o:p></p>
<div>
<p class="MsoNormal">El 10/04/2024 a las 06:11, John Bateson escribió:<o:p></o:p></p>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal">Good morning,<o:p></o:p></p>
<p class="MsoNormal">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.<o:p></o:p></p> \
<p class="MsoNormal">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.<o:p></o:p></p> <p class="MsoNormal">This was a quite complex system \
in the end with nearly 200 tables.<o:p></o:p></p> <p class="MsoNormal">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 <b>notquitegoodenough</b>! This was early \
this century so Actian may have made some improvements since \
then…<o:p></o:p></p> <p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">So much for the background to establish that I am not a complete \
newbie, just out of the loop for a while.<o:p></o:p></p> <p \
class="MsoNormal"> <o:p></o:p></p> <p class="MsoNormal"><b>Using Postgres and \
PGAdmin -4</b>.<o:p></o:p></p> <p class="MsoNormal">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.<o:p></o:p></p>
<p class="MsoNormal">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.<o:p></o:p></p>
<p class="MsoNormal">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!<o:p></o:p></p> <p \
class="MsoNormal"> <o:p></o:p></p> <p class="MsoNormal">So, recommendation and \
possibly some consensus would be very much appreciated.<o:p></o:p></p> <p \
class="MsoNormal"> <o:p></o:p></p> <p class="MsoNormal">And apologies if I have \
taken up too much of your time or have placed this in the wrong forum.<o:p></o:p></p> \
<p class="MsoNormal"> <o:p></o:p></p> <p class="MsoNormal" \
style="mso-margin-top-alt:0cm;margin-right:36.0pt;margin-bottom:5.0pt;margin-left:36.0pt">
John<o:p></o:p></p>
</blockquote>
</div>
</body>
</html>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic