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 least provide some interface to the 
DB functions so you can do things like INSERT, UPDATE, DELETE, SELECT, 
and step through the results, etc.

-Steve

> 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 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 "Procedures" table like this:
>>
>> create table "Procedures" (Name, SQL);
>>
>> and populate it with SQL procedures. You can call those procedures  
>> later from within your program and sqlite3 command line and execute  
>> them.
>>
>> Tom
>> BareFeet
>>
>>   --
>> Comparison of SQLite GUI applications:
>> http://www.tandb.com.au/sqlite/compare/
>>
>> _______________________________________________
>> sqlite-users mailing list
>> sqlite-users@sqlite.org
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> 
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to