Content-Type: multipart/alternative;
 boundary="------------Ry0Ycw80MccSQrAfFJGXs8J4"
Message-ID: <dd57fa57-d65c-4c0a-96b5-0c05d791d1f3@gmail.com>
Date: Wed, 10 Apr 2024 09:38:07 -0400
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Some advice need after a 20 year gap after Ingres/GUIs
To: pgsql-general@lists.postgresql.org
References: <PR3PR10MB39463C6F138AE367D393D9D0B7062@PR3PR10MB3946.EURPRD10.PROD.OUTLOOK.COM>
Content-Language: es-ES
From: Francisco Prado <fprado.lcds@gmail.com>
Disposition-Notification-To: Francisco Prado <fprado.lcds@gmail.com>
In-Reply-To: <PR3PR10MB39463C6F138AE367D393D9D0B7062@PR3PR10MB3946.EURPRD10.PROD.OUTLOOK.COM>
Archived-At: <https://www.postgresql.org/message-id/dd57fa57-d65c-4c0a-96b5-0c05d791d1f3%40gmail.com>
Precedence: bulk

This is a multi-part message in MIME format.
--------------Ry0Ycw80MccSQrAfFJGXs8J4
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

Hi,

To start I had to find out what MDBS IV is, since it caught my attention 
and I ended up learning a few things about the history of databases ;-).

Regarding your concern:

First you must be clear that there are many alternatives to develop 
graphical interfaces to work with Postgres.

So, first of all:

  * You must choose and master a programming language that you feel
    comfortable with, Python is the one that most developers choose.
  * Use a development environment suitable for the language you have
    chosen, there are several, but the best known is possibly Visual
    Studio Code.
  * Choose which operating system you are going to develop with:
    Windows, Linux, macOS, generally most people choose Windows since
    you can integrate a Linux like Ubuntu using WSL.
  * After you master your favorite programming language, you must select
    a framework that allows you to generate a graphical interface, in
    Python there are several such as Tkinter, wxPython or Qt among others.
  * If the development is via the web, the options are many, the best
    known in Python would be Django for the web and FastAPI for the
    development of APIs via REST
  * You must also have a library that allows you to connect with
    Postgres, in Python there is pyODBC, psycopg2 among others.


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
>
-- 
Saludos,

Francisco Prado

--------------Ry0Ycw80MccSQrAfFJGXs8J4
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<!DOCTYPE html>
<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <p>Hi,<br>
      <br>
      To start I had to find out what MDBS IV is, since it caught my
      attention and I ended up learning a few things about the history
      of databases ;-).<br>
      <br>
      Regarding your concern:<br>
      <br>
      First you must be clear that there are many alternatives to
      develop graphical interfaces to work with Postgres.<br>
      <br>
      So, first of all:<br>
      <br>
    </p>
    <ul>
      <li>You must choose and master a programming language that you
        feel comfortable with, Python is the one that most developers
        choose.</li>
      <li>Use a development environment suitable for the language you
        have chosen, there are several, but the best known is possibly
        Visual Studio Code.</li>
      <li>Choose which operating system you are going to develop with:
        Windows, Linux, macOS, generally most people choose Windows
        since you can integrate a Linux like Ubuntu using WSL.</li>
      <li>After you master your favorite programming language, you must
        select a framework that allows you to generate a graphical
        interface, in Python there are several such as Tkinter, wxPython
        or Qt among others.</li>
      <li>If the development is via the web, the options are many, the
        best known in Python would be Django for the web and FastAPI for
        the development of APIs via REST</li>
      <li>You must also have a library that allows you to connect with
        Postgres, in Python there is pyODBC, psycopg2 among others.</li>
    </ul>
    <p><br>
      Additional resources:<br>
      <br>
      Python Tutorial:
<a class="moz-txt-link-freetext" href="https://www.youtube.com/watch?v=eWRfhZUzrAc&amp;list=PLWKjhJtqVAbnqBxcdjVGgT3uVR10bzTEB">https://www.youtube.com/watch?v=eWRfhZUzrAc&amp;list=PLWKjhJtqVAbnqBxcdjVGgT3uVR10bzTEB</a><br>
      Python &amp; Tkinter:
<a class="moz-txt-link-freetext" href="https://www.youtube.com/watch?v=yQSEXcf6s2I&amp;list=PLCC34OHNcOtoC6GglhF3ncJ5rLwQrLGnV">https://www.youtube.com/watch?v=yQSEXcf6s2I&amp;list=PLCC34OHNcOtoC6GglhF3ncJ5rLwQrLGnV</a><br>
      Python &amp; Postgres: <a class="moz-txt-link-freetext" href="https://www.youtube.com/watch?v=miEFm1CyjfM">https://www.youtube.com/watch?v=miEFm1CyjfM</a><br>
      <br>
      <br>
      Greetings and luck!<br>
    </p>
    <div class="moz-cite-prefix">El 10/04/2024 a las 06:11, John Bateson
      escribió:<br>
    </div>
    <blockquote type="cite"
cite="mid:PR3PR10MB39463C6F138AE367D393D9D0B7062@PR3PR10MB3946.EURPRD10.PROD.OUTLOOK.COM">
      <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
      <meta name="Generator"
        content="Microsoft Word 15 (filtered medium)">
      <style>@font-face
	{font-family:"Cambria Math";
	panose-1:2 4 5 3 5 4 6 3 2 4;}@font-face
	{font-family:Aptos;}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;}span.EmailStyle17
	{mso-style-type:personal-compose;
	font-family:"Aptos",sans-serif;
	color:windowtext;}.MsoChpDefault
	{mso-style-type:export-only;
	font-size:11.0pt;
	mso-fareast-language:EN-US;}div.WordSection1
	{page:WordSection1;}</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]-->
      <div class="WordSection1">
        <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">John<o:p></o:p></p>
      </div>
    </blockquote>
    <pre class="moz-signature" cols="72">-- 
Saludos,

Francisco Prado</pre>
  </body>
</html>

--------------Ry0Ycw80MccSQrAfFJGXs8J4--