From: Date: June 11 2008 6:02am Subject: Stored Procedures in C++? (and direct access to storage engine API) List-Archive: http://lists.mysql.com/internals/35678 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit 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