On 29 Oct 2012, at 6:44pm, "Rose, John B" <jbr...@utk.edu> wrote:
> 1) We are looking for simple examples, with source code, of a UI using HTML5 > to query and add data to an SQLite database > > 2) We are also looking for examples using Javascript to query an existing > SQLite database. And maybe add data to an existing database. We do not care > of the database is on a server or local. We just want to put together a > simple mechanism using javascript as a query interface to an SQLite database. > > We have read a bit about WebSQL, Web Storage and IndexedDB. We are a bit > confused. > > Are one of those a requirement to interact with SQLite via Javascript? After > a reasonable bit of googling we have not found a simple javascript/SQLite > example. Because there's no mechanism that lets JavaScript talk specifically to a SQLite database. The HTML5 specification talks about SQL not specifically SQLite. Nevertheless, you may find this useful: <http://developer.apple.com/library/safari/#documentation/iPhone/Conceptual/SafariJSDatabaseGuide/UsingtheJavascriptDatabase/UsingtheJavascriptDatabase.html> In current technology with pages running from a server, accessing a SQLite database is usually done using a shim: a little program running on the server which receives an AJAX call, executes an SQLite command, then returns the result. These shims can be written in PHP or any number of other languages which can be run within a server process. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users