JavaScriptSQL (JSSQL)

Related Links

In this section we want to mention some open source projects like JavaScriptSQL . All of them make, at their own way, a approach to the use of SQL statements from JavaScript.


SQL.js: http://syntensity.com/static/sql.html

Using the Emscripten compilator, SQL.js s a compilation of SQLite to JavaScript .
Advantages: It has all or nearly all the functionality of SQLite.
Disadvantages:It not defines the persistence of the data, is up to the developer to do it. The library is quite heavy (1 MB or so).
REALLY AMAZING
created by Alon Zakai.

PublicSQL: www.en.publicsql.org

Allows you to use SQL to access tables in the PTF type (Portable Table Format) directly from JavaScript. PTF is a type of text file similar to the CSV. Under Licence
MIT, created by Jörg Siebrands.

TrimQuery: code.google.com/p/trimpath/wiki/TrimQuery

TrimQuery es parte de la librería TrimPath, permite realizar un filtrado de objetos JSON (que represnetan tablas de una base de datos) mediante consultas SQL.
Para ver mejor el funcionamiento es preferible empezar viendo la demo: TrimQuery Demo
Bajo licencia GNU versión 2 y ALV versión 2

Web SQL Database: dev.w3.org/html5/webdatabase/

This is the proposal to implement a database engine like SQLLite as a standard for HTML 5. Unfortunately did not prosper. Firefox apparently decided not to adopt this proposal considering it 'problematic'. A few browsers have a standard approach to this.
Some interesting examples: html5demos



.. Well, this has nothing to do with anything but I always wanted to publish it: The Magic Cube (Rubick)



If you know any open source project like JavaScriptSQL and want to share it contact me at joaquin.becerra@gmail.com