W3C home > Mailing lists > Public > public-webapps@w3.org > April to June 2009

Re: Web Storage & SQL

From: Kris Zyp <kris@sitepen.com>
Date: Thu, 09 Apr 2009 07:03:19 -0600
Message-ID: <49DDF217.8050505@sitepen.com>
To: Giovanni Campagna <scampa.giovanni@gmail.com>
CC: Vladimir Vukicevic <vladimir@mozilla.com>, public-webapps@w3c.org
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
 


Giovanni Campagna wrote:
> As far as I understand from this discussion and from the linked posts,
> there are currently three database types and their respective query
> languages:
>
> - relational databases and SQL
> - Ecmascript objects and JSONQuery
> - XML databases and XQuery
>
> Each one has its own merits: for example XML allows to use XML
> serialization and DOM, relational databases allow great masses of data
> with fast indexing, ES object allow for both typed and untyped
> (object) data. In addition, each one has its own community of
> followers.
> So why not adding a parameter on openDatabase() to specify what kind
> of database we want (and what kind of query language we will use)?
> I mean something like
> openDatabase(name, version, type, displayName, estimatedSize)
> where type can be any string
> so, for example, type = "sql" uses the standard SQL, type="sqlite"
> uses SQLite extensions, type="-vendor-xyz" is a vendor specific
> extension, etc.
I think you would have to take the "lite" out the db name ;). I would
think supporting three completely different data paradigms and three
different query languages would be a large system.

Also, just a clarification, our JSON/JS-oriented object style storage
system in Persevere that uses JSONQuery has fully indexed tables, so
it achieves the some level of scalability for querying massive tables
(using JSONQuery) as its relational counterparts (that use SQL). I
don't know of any scalability advantage to SQL. The same may be true
of XQuery, I haven't dealt with XML dbs.

- --
Kris Zyp
SitePen
(503) 806-1841
http://sitepen.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
 
iEYEARECAAYFAknd8hcACgkQ9VpNnHc4zAy3owCdEpThZk9wpKBZZSJIlEtWg6T8
8owAn3s1dLUOHX+AHF3OqpIp3vZ9lCMm
=BlmS
-----END PGP SIGNATURE-----
Received on Thursday, 9 April 2009 13:07:05 GMT

This archive was generated by hypermail 2.3.1 : Tuesday, 26 March 2013 18:49:31 GMT