Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





On 7 Mar 2024, at 4:56 PM, Achilleas Mantzios - cloud <a.mantzios@xxxxxxxxxxxxxxxxxxxx> wrote:

Hello

I notice both my kids struggling with either C or Python as first programming languages. I believe both are unsuitable for use as introductory languages to college juniors.

https://scratch.mit.edu/ would be more suitable, maybe ? 


Python IMHO is too advanced, too rich, weird indentation rules, no simple for loop etc.

C, ok, punishing little kids with segmentation faults, calling by value VS by reference and 3ple pointers is pure sadism.

So this brings me to memory good old PASCAL from the time I was junior, circa 1986. PL/SQL resembles PASCAL heavily. Everything seems well defined, strong typing, simplicity, I think it has everything a programming language should have in order to be taught as an introductory language. But it lacks IO and file handling.

So, I ask, have there been any efforts to bring PL/PGSQL to the terminal?

Imho the best you can do is bash + psql + pl/pgsql , via heredocs .
pql <<EOF
<pgsql code.
EOF
It does require lot’s of care with variables  though https://www.depesz.com/2023/05/28/variables-in-psql-how-to-use-them/

But one can get fairly creative. 


Thanks!





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux