Re: [sqlite] Does sqlite support stored procedure?

Of John Stanton Sent: Tuesday, July 29, 2008 4:16 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Does sqlite support stored procedure? I wrote an Sqlite module which links into Spidermonkey and connects to Sqlite using the Sqlite API. Stephen Woodbridge wrote: > John Stan

Re: [sqlite] Does sqlite support stored procedure?

I wrote an Sqlite module which links into Spidermonkey and connects to Sqlite using the Sqlite API. Stephen Woodbridge wrote: > John Stanton wrote: > >>Adding Javascript to Sqlite as a stored procedure language was a fairly >>simple operation. Try it if you need stored procedures. > > >

Re: [sqlite] Does sqlite support stored procedure?

I just added an Sqlite interface into Spidermonkey. I can send you the code if you are interested. We used Javascript instead of PL/SQL because it is so well known and the backend code which executes in the DB matches the frontend stuff running in the browser and there is less learning

Re: [sqlite] Does sqlite support stored procedure?

Can you send examples? Thanks Woody from his pda -Original Message- From: John Stanton <[EMAIL PROTECTED]> Sent: Tuesday, July 29, 2008 11:39 AM To: General Discussion of SQLite Database <sqlite-users@sqlite.org> Subject: Re: [sqlite] Does sqlite support stored proced

Re: [sqlite] Does sqlite support stored procedure?

John Stanton wrote: > Adding Javascript to Sqlite as a stored procedure language was a fairly > simple operation. Try it if you need stored procedures. This sounds really interesting. How to you make access to the sqlite3 api in javascript? Would you need to? Seems like you would need to at

Re: [sqlite] Does sqlite support stored procedure?

On Tue, Jul 29, 2008 at 11:39 AM, John Stanton <[EMAIL PROTECTED]> wrote: > Adding Javascript to Sqlite as a stored procedure language was a fairly > simple operation. Try it if you need stored procedures. Woah - that sounds neat and something interesting to the Mozilla project. Care to

Re: [sqlite] Does sqlite support stored procedure?

Adding Javascript to Sqlite as a stored procedure language was a fairly simple operation. Try it if you need stored procedures. BareFeet wrote: > Hi John, > > >>I would like to know if SQLite supports stored procedures. > > > Technically, no it doesn't. > > For what purpose do you want to

Re: [sqlite] Does sqlite support stored procedure?

Hi BareFeet, >> I would like to know if SQLite supports stored procedures. >Technically, no it doesn't. >For what purpose do you want to store procedures? We have an application (open source Jaxer) that provides a support layer for the server-side DB, so users can access it in their

Re: [sqlite] Does sqlite support stored procedure?

Thanks Donald! Just want I needed! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Griggs, Donald Sent: Thursday, July 24, 2008 7:50 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Does sqlite support stored procedure? Hi, John

Re: [sqlite] Does sqlite support stored procedure?

Hi John, > I would like to know if SQLite supports stored procedures. Technically, no it doesn't. For what purpose do you want to store procedures? You can store some procedures in triggers, if you want to have SQLite trigger a task when some data is changed. You can simply create a

Re: [sqlite] Does sqlite support stored procedure?

Hi, John, Regarding: "I would like to know if SQLite supports stored procedures. This should be a simple question, but I did not find a clear answer on the SQLite website." In a word -- no, it does not. HOWEVER, it DOES: -- support a TRIGGER feature, with limitations. -- allow the creation