List:Internals« Previous MessageNext Message »
From:Kazuho Oku Date:June 11 2008 4:02am
Subject:Stored Procedures in C++? (and direct access to storage engine API)
View as plain text  
Is it possible to write stored procedures in C++?  Or is anybody
working on something alike?

What I am looking for is a way to implement stored procedures in C++
that can be loaded / unloaded dynamically, like UDFs or pluggable
storage engines.  And within the stored procedure, I would like to
call the methods of storage engines directly, so that the overhead of
SQL parsing and building execution plans can be bypassed.

For example, it is difficult to implement a fast SQL query to obtain a
timeline (like that of twitter, please see see
http://labs.cybozu.co.jp/blog/kazuhoatwork/2008/06/implementing_timeline_in_web_s.php
for more detail).
IMHO, direct access to storage engine APIs would be of great help in such cases.

-- 
Kazuho Oku
Thread
Stored Procedures in C++? (and direct access to storage engine API)Kazuho Oku11 Jun
  • Re: Stored Procedures in C++? (and direct access to storage engine API)Brian Aker11 Jun
    • Re: Stored Procedures in C++? (and direct access to storage engine API)Kazuho Oku12 Jun
      • Re: Stored Procedures in C++? (and direct access to storage engine API)Brian Aker12 Jun
        • Re: Stored Procedures in C++? (and direct access to storage engineAPI)Sergei Golubchik12 Jun
          • Re: Stored Procedures in C++? (and direct access to storage engine API)Brian Aker12 Jun
        • Re: Stored Procedures in C++? (and direct access to storage engine API)Kazuho Oku13 Jun
          • Re: Stored Procedures in C++? (and direct access to storage engine API)Kazuho Oku13 Jun