Re:Show HN: SPyQL – SQL with Python in the middle
by BeefWellington on Thursday January 27, 2022 @08:54AM
(#30100555)
Yes, but similar to Python on Postgresql, it comes with a bunch of security warnings attached.
I should have clarified in my original post but I'm envisioning more of: database server has a parser that understands python/javascript/c#/etc but projects a subset of library functions to avoid security dangers.
Essentially, expose the same functionality stored procedures already have but in a more accessible syntax.
What vendors mostly seem to have opted for is embedding the full language parsers directly into the database servers, which yields a lot of power and a lot of risk.
I should have clarified in my original post but I'm envisioning more of: database server has a parser that understands python/javascript/c#/etc but projects a subset of library functions to avoid security dangers.
Essentially, expose the same functionality stored procedures already have but in a more accessible syntax.
What vendors mostly seem to have opted for is embedding the full language parsers directly into the database servers, which yields a lot of power and a lot of risk.