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. > > > 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 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
