tag:blogger.com,1999:blog-5541296000399974369.post6917075564869560428..comments2024-03-09T02:51:27.612-05:00Comments on Peter Eisentraut's Blog: plpydbapi: DB-API for PL/PythonAnonymoushttp://www.blogger.com/profile/02849480732923051923noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-5541296000399974369.post-39126594388763137242011-12-10T12:36:42.361-05:002011-12-10T12:36:42.361-05:00@mike: Sounds awesome.@mike: Sounds awesome.Anonymoushttps://www.blogger.com/profile/02849480732923051923noreply@blogger.comtag:blogger.com,1999:blog-5541296000399974369.post-79167398036240570332011-12-10T12:24:51.825-05:002011-12-10T12:24:51.825-05:00@Adrian Klaver: Yes, only 9.1+. And yes, cursor.d...@Adrian Klaver: Yes, only 9.1+. And yes, cursor.description is mostly unimplemented/(-able).Anonymoushttps://www.blogger.com/profile/02849480732923051923noreply@blogger.comtag:blogger.com,1999:blog-5541296000399974369.post-14625857651384592032011-12-06T10:53:17.481-05:002011-12-06T10:53:17.481-05:00What we'd do here is to embed an ORM (for me t...What we'd do here is to embed an ORM (for me that would be SQLAlchemy, since I wrote it and all...) into Postgresql, enabled via this DBAPI. Then you'd have to construct some clever kind of marshaling system that can serialize a Python object on the outside into a stored procedure call, which calls into a SQLAlchemy-enabled/PG-embedded system. I've no idea how feasible this would be, but it would allow a fully stored-procedure approach, without the need to actually hand-code two individual persistence layers (i.e. INSERT/UPDATE/DELETE statements on the DB side, type-specific object->procedure marshaling on the app side), which is typically why the SP approach is entirely not worth it.mike bayerhttps://www.blogger.com/profile/01417862951114999907noreply@blogger.comtag:blogger.com,1999:blog-5541296000399974369.post-3455497893094905502011-12-05T19:09:10.779-05:002011-12-05T19:09:10.779-05:00Great news.
Two questions:
So this works only with...Great news.<br />Two questions:<br />So this works only with 9.1+ correct?<br />When you say metadata are you talking about cursor.description?Adrian Klaverhttps://www.blogger.com/profile/09632095365606250299noreply@blogger.com