From: Date: June 11 2008 6:07am
Subject: Re: Stored Procedures in C++? (and direct access to storage engine API)
List-Archive: http://lists.mysql.com/internals/35679
Message-Id: <47608607-EB93-47A7-8A4C-4D391F267FF4@tangent.org>
MIME-Version: 1.0 (Apple Message framework v924)
Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes
Content-Transfer-Encoding: 7bit

Hi!

You should look at Antony Curtis'es tree for this sort of support. Him  
and Eric Herman have been working on this sort of API for a while now.

Cheers,
	-Brian

On Jun 10, 2008, at 9:02 PM, Kazuho Oku wrote:

> 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
>
> -- 
> MySQL Internals Mailing List
> For list archives: http://lists.mysql.com/internals
> To unsubscribe:    http://lists.mysql.com/internals?unsub=brian@stripped
>

--
_______________________________________________________
Brian "Krow" Aker, brian at tangent.org
Seattle, Washington
http://krow.net/                     <-- Me
http://tangent.org/                <-- Software
_______________________________________________________
You can't grep a dead tree.