Well, PL/pgSQL is compiled but there is no semantics checking at compile time. So while you may have better performance depending on use case etc. it can be a b

Well, PL/pgSQL is compiled but there is no semantics checking at compile time. So while you may have better performance depending on use case etc. it can be a bit hard to work with. I wrote a lot of Oracle PL/SQL at my last job* and I will say if you're not familiar with that kind of database language I would highly recommend Python over it. First think about whether you really want to have business logic in your database and then choose what you know best. *: It was messy and I am glad that that job is over.