On 12/13/22 13:20, Shaozhong SHI wrote:
> What is brilliant about plpython? Any brilliant examples to look at?
>
1) It is actually plython(3)u where the u means untrusted. This means
you can reach outside the database and do things. That can seen as
brilliant or dangerous.
2) You have no end of Python libraries you can work with. Again combined
with 1) up you whether that is brilliant or dangerous.
3) Python is more dynamic then plpgsql so you can get more adventurous
with doing dynamic SQL.
Downside is that plpython(3)u is not tied as closely to SQL as plpgsql
so it very often takes you many more lines of code to get something done.
--
Adrian Klaver
adrian.klaver@aklaver.com