SQLite and JayData

Question

Is it possible to use jaydata to read a sqlite database directly in a html 5 css js page? This whitout the use of a php or asp.net engine?

EDIT: http://jaydata.org/

• Jon Cram: What is JayData and what facilities does it provide for reading from databases regardless of the context?
• Peter Aron Zentai: It provides a provider agnostic data access layer with JavaScript Language Query and JavaScript CRUD capabilities. You can issue the same statements to query or store data regardless of its origin: a local webSql or a remote YQL table.

Answer 1

Since it claims to support webSQL (right at the top of the homepage)...

JayData is the unified data access library for JavaScript developers to query and update data from different sources like webSQL, indexedDB, OData, Facebook or YQL.

... — yes (since all known implementations of webSQL use SQLite under the hood ... which is why work on the W3C recommendation for it stopped).

(Although it should be noted that webSQL runs in the browser and is not a shared database that lives on the server. Exposing database servers directly to the WWW is generally a Very Bad Idea™, and SQLite is a plain file database, not one with a server, so it would require giving direct access to the server's filesystem to the WWW, which goes beyond insane).

• Lunatikzx: Since i need offline access i wil lhave to use SQLite but i will dimb down the offline db to only get the data i need.
• Lunatikzx: They do not replace the browser support for sqlite , they just use it... gonna have to find another solution
• Quentin: @PeterAronZentai — I think the intended question might have been "Can I use jaydata to create a client side database on a browser that doesn't support WebSQL?"
• Lunatikzx: @Quentin thanks your spot on , (sorry sometimes i cant explain myself clearly in english)

Answer 2

An HTML page in a browser can not access local databases, simply because it can not access the local file system. If you wanna do such a thing like opening an sqLite database file from an HTML page, you have to embed your HTML5 application into a native shell like phonegap. With that you can handle sqLite databases with JayData from within a HTML page just by using JavaScript.

• Peter Aron Zentai: There is an alternative way: have your JavaScript code execute in nodeJS. That way you can access arbitrary sqLite files. This can be done on the client, but you have to deploy nodeJS requirements. Whould this be an approach you could take?
• Lunatikzx: i dont have any knowledge of nodeJS. Would it be doable to construct an app with nodeJS and installing it on the client desktop?
• Peter Aron Zentai: Yeah, but if you are new to this technology it might present a new factor for problems... It would create a local webserver on let's say 127.0.0.1:1234 and you still need a WebBrowser control embedded in an exe to communicate with it. So it's doable but not that simple.
• Peter Aron Zentai: Another approach could be a web application that you mark as an "Offline app" with cache manifest. That way after the first use (that must be done from the net, let's say installation) the app can run from the desktop without net using Chrome or Safari browser. You can build your sqLite database with the application (you can not reuse existing ones). Is this a way you can live with?
• Lunatikzx: It answers the question about reusign an existing db ... thanks

Answer 3

You can use PhoneGap with SQLLite at the following URL is a working example.

https://groups.google.com/group/phonegap/browse_thread/thread/07cf9f48e3cd0663?pli=1

regards....