3 ms·
Rather than taking the data out of the database, how about plugging your programming language of choice into the database? For Postgres, for example, you can
by derefr 9y ago
Rather than taking the data out of the database, how about plugging your programming language of choice into the database?
For Postgres, for example, you can write stored procedures using any of these: https://www.postgresql.org/docs/9.1/static/external-pl.html https://www.postgresql.org/docs/9.1/static/external-pl.html
- memco 9y agoThe PHP version looks like it hasn't been touched since 2011 and the Python link is dead. Doesn't give much confidence that this is a viable and supported pathway to Db <-> Application communication.
- atwebb 9y agoNot positive in PostGres, in MSSQL you still wind up copying the data and using additional resources, it's just handled for you. I'm a big fan of scripting in DBs becoming a thing (and a little scared) but it's not all roses (yet). You would also loose optimizer "fixes" right?
- ianamartin 9y agoAWS RDS doesn't support any of the PL extensions for Postgres. And unfortunately, that's a real killer for a lot of people. But when I've been able to use Python functions directly inside my SQL code, it is a thing of absolute beauty.