CODEWITHSUNDEEP
javascripthtmlsqlitejaydata
Lunatikzx
Lunatikzx

Reputation: 264

SQLite and JayData

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/

Upvotes: 3

Views: 1593

Answers (3)

Claudio Cárcamo Correa
Claudio Cárcamo Correa

Reputation: 11

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....

Upvotes: 1

Peter Aron Zentai
Peter Aron Zentai

Reputation: 11740

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.

Upvotes: 1

Quentin
Quentin

Reputation: 943635

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).

Upvotes: 2

Related Questions