From: | Achilleas Mantzios <a(dot)mantzios(at)cloud(dot)gatewaynet(dot)com> |
---|---|
To: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, Christophe Pettus <xof(at)thebuild(dot)com> |
Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: pl/pgsql outside the DB, (i.e. on the terminal) possible ? |
Date: | 2024-03-07 18:10:18 |
Message-ID: | ac742e1e-26b3-4d59-bc76-de656630efdb@cloud.gatewaynet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Στις 7/3/24 18:25, ο/η Pavel Stehule έγραψε:
>
>
> čt 7. 3. 2024 v 16:59 odesílatel Christophe Pettus <xof(at)thebuild(dot)com>
> napsal:
>
>
>
> > On Mar 7, 2024, at 06:56, Achilleas Mantzios - cloud
> <a(dot)mantzios(at)cloud(dot)gatewaynet(dot)com> wrote:
> > So, I ask, have there been any efforts to bring PL/PGSQL to the
> terminal?
>
> Strictly speaking, of course, you can use PL/pgSQL from the
> terminal already: just use psql, connect to the database, and
> create and run functions and procedures as much as you like.
>
> If the question is, "Have there been any efforts to implement a
> PL/pgSQL interpreter without PostgreSQL?", that's a different and
> much more complex problem. PL/pgSQL uses the PostgreSQL query
> execution machinery to run pretty much anything that is not a
> control structure, and the language is very focused on interacting
> with the database. I doubt it would be worth anyone's time to try
> to build some kind of minimal framework that implements the SPI to
> allow PL/pgSQL to operate without PostgreSQL.
>
>
> yes
>
> plpgsql cannot exist without Postgres. PL/pgSQL is strongly reduced
> interpreted Ada language. The gcc compiler supports Ada language.
>
> I found https://bush.sourceforge.net/bushref.html - it is interpret
> with Ada syntax, but it is better to learn Python - it is easy - with
> a pretty big library.
Cool, thank you.
>
> free pascal https://www.freepascal.org/ is good compiler and you can
> write terminal applications too - with Turbo Vision
Too bad, PASCAL is now neglected by most UNIs :(
>
> Regards
>
> Pavel
--
Achilleas Mantzios
IT DEV - HEAD
IT DEPT
Dynacom Tankers Mgmt (as agents only)
From | Date | Subject | |
---|---|---|---|
Next Message | Achilleas Mantzios | 2024-03-07 18:13:11 | Re: pl/pgsql outside the DB, (i.e. on the terminal) possible ? |
Previous Message | Achilleas Mantzios | 2024-03-07 18:04:21 | Re: pl/pgsql outside the DB, (i.e. on the terminal) possible ? |