From: | Robert Treat <rob(at)xzilla(dot)net> |
---|---|
To: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
Cc: | Christophe Pettus <xof(at)thebuild(dot)com>, Achilleas Mantzios - cloud <a(dot)mantzios(at)cloud(dot)gatewaynet(dot)com>, 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 16:44:14 |
Message-ID: | CABV9wwOKuMQ-L5zRhtxAy4jLvu8RPyhOAAb3KM0nOkvYQbmfcA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Thu, Mar 7, 2024 at 11:26 AM Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> wrote:
> č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
>
Of course there's a certain amount of personal preference with all
this stuff. I started with basic and really liked it, and then had to
learn pascal and hated it so much that I decided to eschew programming
for years. If you are just trying to learn for fun, I see no reason
why SQL, paired with data in a database, wouldn't be worth spending
time on. Once you're comfortable with that, I like ruby on the command
line and it interacts nicely with databases, and also works well
within the rails console. That said, my son liked lua when he was a
kid, so yeah, there's lots of options, even if plpgsql on the command
line isn't strictly one of them.
Robert Treat
https://xzilla.net
From | Date | Subject | |
---|---|---|---|
Next Message | Achilleas Mantzios | 2024-03-07 18:04:21 | Re: pl/pgsql outside the DB, (i.e. on the terminal) possible ? |
Previous Message | Markur Sens | 2024-03-07 16:38:54 | Re: pl/pgsql outside the DB, (i.e. on the terminal) possible ? |