Oh, I should add that Drizzle already has support to execute
JavaScript code by way of the JS plugin. However there is not yet an
api to manipulate any data inside Drizzle, you can just do JavaScript
functions that return a value based on the given input parameters.
(This is already useful for some things, for instance for manipulating
JSON data.)
So to create JavaScript stored procedures, one just needs to bind the
Drizzle Execute API to be accessible from the JavaScript environment,
for instance via calls like db.execute("SELECT * FROM MyTable");
henrik
On Mon, Mar 5, 2012 at 10:14 AM, Henrik Ingo <[email protected]> wrote:
> On Mon, Mar 5, 2012 at 2:31 AM, Me Myself and I
> <[email protected]> wrote:
>>
>> I have read that drizzle right now lacks some core stuff.
>>
>>
>> -Are there going to be
>>
>> triggers
>>
>> authorable procedures/functions
>>
>> introduced to drizzle later on?
>
> Related to my work with HTTP JSON Server plugin, I'm interested to
> introduce a trigger-like functionality. And triggers of course imply
> that there is a way to write the procedures that they trigger.
>
> However, I'm probably not going to implement SQL standard like
> procedures and triggers. Most likely these procedures would be written
> in JavaScript, and they would use the Execute API to do SQL queries
> into drizzle tables.
>
> I'm not actively working on this functionality yet and probably won't
> before the Summer. If someone is interested in implementing triggers
> (of any kind) then I'm open to mentoring such work too.
>
>
> henrik
>
> --
> [email protected]
> +358-40-8211286 skype: henrik.ingo irc: hingo
> www.openlife.cc
>
> My LinkedIn profile: http://www.linkedin.com/profile/view?id=9522559
--
[email protected]
+358-40-8211286 skype: henrik.ingo irc: hingo
www.openlife.cc
My LinkedIn profile: http://www.linkedin.com/profile/view?id=9522559
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
