Re: pl/pgsql outside the DB, (i.e. on the terminal) possible ?

č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.

free pascal https://www.freepascal.org/ is good compiler and you can write
terminal applications too - with Turbo Vision

Regards

Pavel