3 ms·
I personally would not make this choice for new projects. I only use technology that is appropriate for the domain I'm using it in. Although, I am hoping this
by alphanumeric0 6y ago
I personally would not make this choice for new projects. I only use technology that is appropriate for the domain I'm using it in. Although, I am hoping this trend encourages better tooling and more modernization of SQL.
As others stated, my concerns are primarily that SQL lacks a lot of general-purpose language features (modules, namespacing, composability, no easy way to debug, etc.) which seem to be ideal for writing applications.
I would be interested to see a project written with PL/Python + PL/SQL stored functions in Postgres. PL/Python functions would be the interface between API calls and the database, and SQL would do what it is currently designed to do: straight-forward data manipulation.
- steve-chavez 6y agoHere's an OSS project that makes heavy use of plpython3u: https://github.com/Delibrium/delibrium-postgrest/blob/master/database/rpc/add_school.sql https://github.com/Delibrium/delibrium-postgrest/blob/master...