tag:blogger.com,1999:blog-7476449567742726187.post3981868842242235456..comments2023-12-18T12:25:52.296-08:00Comments on Database Soup: PostgreSQL New Development Priorities 3: Pluggable ParserJosh Berkushttp://www.blogger.com/profile/09671139717468724246noreply@blogger.comBlogger8125tag:blogger.com,1999:blog-7476449567742726187.post-67479992005133931412013-05-20T21:05:58.509-07:002013-05-20T21:05:58.509-07:00I will note here that said -hackers thread is stil...I will note here that said -hackers thread is still going on, and I just contributed a post to it myself. In brief, I believe that my work in designing Muldis D, a homoiconic language whose native source code form is structured data, would be a good foundation for designing Postgres' whole pluggable language/parser system, and being an intermediary for arbitrary language translation or generation besides.Darren Duncanhttps://www.blogger.com/profile/14457831481137852460noreply@blogger.comtag:blogger.com,1999:blog-7476449567742726187.post-83222391368949944062013-05-20T17:50:33.421-07:002013-05-20T17:50:33.421-07:00I agree with Hannu Krosing's last comment, &qu...I agree with Hannu Krosing's last comment, "pluggable top-level language". This is exactly the kind of thing I need to most effectively make my new Muldis D language run in a DBMS.Darren Duncanhttps://www.blogger.com/profile/14457831481137852460noreply@blogger.comtag:blogger.com,1999:blog-7476449567742726187.post-56022349689031722492013-05-19T09:07:06.645-07:002013-05-19T09:07:06.645-07:00I would not do it as "pluggable parser" ...I would not do it as "pluggable parser" but rather a "pluggable top-level language", so in addition to pl/v8 we could also have tl/v8 - "tl" for top-level - which then has possibility to directly construct/manipulate parse trees and pass them to planner or even directly construct execution plans bypassing the optimizer.<br />Then you could do "ALTER USER bob SET main_language = tlv8" to always switch to new language on connectHannu Krosinghttps://www.blogger.com/profile/05300950192185747437noreply@blogger.comtag:blogger.com,1999:blog-7476449567742726187.post-20048003935230088372013-05-19T09:02:39.698-07:002013-05-19T09:02:39.698-07:00My main concern is that SQL allows you only a limi...My main concern is that SQL allows you only a limited subset of all possible parse / execution trees and everything not expressible via SQL has got no testing. Hannu Krosinghttps://www.blogger.com/profile/05300950192185747437noreply@blogger.comtag:blogger.com,1999:blog-7476449567742726187.post-70960204823136303122013-05-19T08:59:56.364-07:002013-05-19T08:59:56.364-07:00I had a (rejected) talk proposal on these (and the...I had a (rejected) talk proposal on these (and then some) pluggability features presented to last years European PostgreSQL conference.<br /><br />Nice you have taken up elaborating on these much needed issues ;)Hannu Krosinghttps://www.blogger.com/profile/05300950192185747437noreply@blogger.comtag:blogger.com,1999:blog-7476449567742726187.post-90944016234375427132013-05-19T06:59:14.451-07:002013-05-19T06:59:14.451-07:00Antony T. Curtis had a proof-of-concept plugable p...Antony T. Curtis had a proof-of-concept plugable parser implementation for MySQL ready as far back as around 2005 or so AFAIR ... <br /><br />Unfortunately he was never given the time or resources to finish this ... and unlike his pluggable procedure language work that will now finally emerge in MariaDB i haven't head of any plans to revive the pluggable parser stuff yet ... but he might be able to provide some insight in his implementation plans from back then nonetheless ...Hartmuthttps://www.blogger.com/profile/04699518177282504742noreply@blogger.comtag:blogger.com,1999:blog-7476449567742726187.post-8834610022098880512013-05-19T02:36:30.467-07:002013-05-19T02:36:30.467-07:00Academic Postgres has direct API for bypassing par...Academic Postgres has direct API for bypassing parser - our FastCall API is strongly reduced descendant - but actually it is hard task, probably we need expandable parser and rewriter. You will not would write complete SQL parser to support some feature. Pavel Stěhulehttps://www.blogger.com/profile/01996484227228696817noreply@blogger.comtag:blogger.com,1999:blog-7476449567742726187.post-10889757813469100902013-05-18T23:12:30.679-07:002013-05-18T23:12:30.679-07:00Having an ability not to fork postgres and plug di...Having an ability not to fork postgres and plug different storage,parser is my dream. Good point, Josh ! Oleg Bartunovhttps://www.blogger.com/profile/03096674393459633701noreply@blogger.com