Re: Regarding: Making the W3C Web SQL Database Specification Active
On Wed, 01 Jan 2014 23:00:21 +0100, Marcos Caceres wrote: On Tuesday, December 31, 2013 at 3:29 AM, Shane Harrelson wrote: Not to beat a dead horse, but would https://code.google.com/p/csharp-sqlite/ count as an independent implementation of the SQLite SQL syntax? So no, it would not count (not unless we want to really dilute how a specification becomes a W3C standard). To prove that it is possible to independently implement the specification and get something interoperable, it would in principle be fine. But that is only one part of the requirements for a standard... Using an unmaintained project as a ways of advancing as specification would kinda defeat the point of standardization of browser technology. In that it fails to change the perception that there is not real interest in making the particular spec into a standard. To benefit the web, the only independent implementations that would actually matter would need to be browser-based. That's not really true. It is important to get implementations in browsers, and the fact that currently a number of major browsers have stated that they are not interested in implementing (or in some cases in maintaining impementations of) Web SQL is one reason it is not considered worth further work at this time. If there were compelling* services based on WebSQL, the question might be re-examined. The inability to meet a particular bureaucratic interpretation of "independently implemented interoperable uses" isn't the reason why work has stopped. It happened because there was no apparent likelihood of WebSQL becoming a standard that was generally implemented, and there was an alternative that appeared to have a much higher probability of being worth working on. Of course, all these judgements are just that. History has proven them wrong in the past, and that will continue to happen. cheers Chaals *I mean something that has 10% penetration, or 25% penetration in a few key markets, not just "a few hundred people agree this is really fantastic" - although if those people happen to be browser engineers or standards wonks the reality is that you have a better chance of getting a real standard to occur) -- Charles McCathie Nevile - Consultant (web standards) CTO Office, Yandex cha...@yandex-team.ru Find more at http://yandex.com
Re: Regarding: Making the W3C Web SQL Database Specification Active
On Tuesday, December 31, 2013 at 3:29 AM, Shane Harrelson wrote: > Not to beat a dead horse, but would https://code.google.com/p/csharp-sqlite/ > count as an independent implementation of the SQLite SQL syntax? > Using an unmaintained project as a ways of advancing as specification would kinda defeat the point of standardization of browser technology. To benefit the web, the only independent implementations that would actually matter would need to be browser-based. So no, it would not count (not unless we want to really dilute how a specification becomes a W3C standard). -- Marcos Caceres
Re: Regarding: Making the W3C Web SQL Database Specification Active
> Not to beat a dead horse, but would https://code.google.com/p/csharp-sqlite/ > count as an independent implementation of the SQLite SQL syntax? > I don't understand: is it a port of SQLite to managed code, or is it a reimplementation from scratch? -- "Si quieres viajar alrededor del mundo y ser invitado a hablar en un monton de sitios diferentes, simplemente escribe un sistema operativo Unix." – Linus Tordvals, creador del sistema operativo Linux
Re: Regarding: Making the W3C Web SQL Database Specification Active
Not to beat a dead horse, but would https://code.google.com/p/csharp-sqlite/ count as an independent implementation of the SQLite SQL syntax? Regards- Shane Harrelson On Tue, Oct 1, 2013 at 8:53 AM, Arthur Barstow wrote: > On 10/1/13 8:46 AM, ext David Bruant wrote: > >> Le 27/09/2013 23:23, Jonas Sicking a écrit : >> >>> On Wed, Sep 25, 2013 at 3:39 PM, Michael Fitchett >>> wrote: >>> >>>> Dear Members of the W3C Consortium:: >>>> >>>> Regarding: Making the W3C Web SQL Database Specification Active >>>> >>>> I would like to request that you make the W3C Web SQL Database >>>> specification active again. The Web SQL Database Specification enables >>>> developers to build web-based applications that can store, retrieve, >>>> manipulate and query against data on the client machine. This >>>> technology is >>>> similar to SQLite, Microsoft SQL Server, MySQL, etc. Web SQL combined >>>> with >>>> Manifest enable developers to build web-based applications that work >>>> while >>>> offline. >>>> >>>> The Web SQL Database specification was on the W3C Recommendation track, >>>> but >>>> the specification was stopped because Mozilla and Microsoft did not >>>> want to >>>> implement a specification that lacked proper SQL definition. I know >>>> there is >>>> a need for both a NoSQL and SQL solution. The two specifications (Web >>>> SQL >>>> Database and Indexed Database API) that exist to date are acceptable.. >>>> However, as stated above, the problem is the lack of definition for SQL. >>>> Since lack of definition is the issue, I would like to recommend a >>>> remedy. >>>> I know SQL experts and great documentation writers who I would gladly >>>> hire >>>> to further define the Web SQL Database specification and fill in the >>>> missing >>>> SQL definition. Is this something that would be possible to help revive >>>> the >>>> specification and get the remaining vendors on board? >>>> >>> The minimum requirements for bringing back WebSQL, or any other >>> SQL-based web spec is IMHO: >>> >>> 1. A specification for the SQL dialect being proposed. >>> 2. *Two* independent, production quality, database implementations >>> being willing to implement exactly that SQL dialect. Not a subset of >>> it, and not a superset of it. >>> 3. The two independent implementations need to have roughly the same >>> performance characteristics. I.e. it's not ok for an implementation to >>> generate correct results, but do it so slowly that it's in practice >>> unusable. >>> >> I'd like to add another requirement which is having a significant >> advantage over IndexedDB. If web devs want SQL, they can have it on top of >> IndexedDB in the form of an open source library (I'm willing to be it >> already exists). They don't need to wait for a standard to emerge, nor for >> browsers to consistently implement it. >> >> If they really want a spec, they can create a W3C community group (or a >> Github repo). We don't need browsers to do all the work for us! >> > > > Michael - I don't see consensus to re-visit WebApps' decision to stop > working on Web SQL Database. > > Like David, I also was thinking that a W3C Community Group could be a way > for you to do related work. > > -Regards, AB > > > >
Re: Regarding: Making the W3C Web SQL Database Specification Active
On 10/1/13 8:46 AM, ext David Bruant wrote: Le 27/09/2013 23:23, Jonas Sicking a écrit : On Wed, Sep 25, 2013 at 3:39 PM, Michael Fitchett wrote: Dear Members of the W3C Consortium:: Regarding: Making the W3C Web SQL Database Specification Active I would like to request that you make the W3C Web SQL Database specification active again. The Web SQL Database Specification enables developers to build web-based applications that can store, retrieve, manipulate and query against data on the client machine. This technology is similar to SQLite, Microsoft SQL Server, MySQL, etc. Web SQL combined with Manifest enable developers to build web-based applications that work while offline. The Web SQL Database specification was on the W3C Recommendation track, but the specification was stopped because Mozilla and Microsoft did not want to implement a specification that lacked proper SQL definition. I know there is a need for both a NoSQL and SQL solution. The two specifications (Web SQL Database and Indexed Database API) that exist to date are acceptable.. However, as stated above, the problem is the lack of definition for SQL. Since lack of definition is the issue, I would like to recommend a remedy. I know SQL experts and great documentation writers who I would gladly hire to further define the Web SQL Database specification and fill in the missing SQL definition. Is this something that would be possible to help revive the specification and get the remaining vendors on board? The minimum requirements for bringing back WebSQL, or any other SQL-based web spec is IMHO: 1. A specification for the SQL dialect being proposed. 2. *Two* independent, production quality, database implementations being willing to implement exactly that SQL dialect. Not a subset of it, and not a superset of it. 3. The two independent implementations need to have roughly the same performance characteristics. I.e. it's not ok for an implementation to generate correct results, but do it so slowly that it's in practice unusable. I'd like to add another requirement which is having a significant advantage over IndexedDB. If web devs want SQL, they can have it on top of IndexedDB in the form of an open source library (I'm willing to be it already exists). They don't need to wait for a standard to emerge, nor for browsers to consistently implement it. If they really want a spec, they can create a W3C community group (or a Github repo). We don't need browsers to do all the work for us! Michael - I don't see consensus to re-visit WebApps' decision to stop working on Web SQL Database. Like David, I also was thinking that a W3C Community Group could be a way for you to do related work. -Regards, AB
Re: Regarding: Making the W3C Web SQL Database Specification Active
Le 27/09/2013 23:23, Jonas Sicking a écrit : On Wed, Sep 25, 2013 at 3:39 PM, Michael Fitchett wrote: Dear Members of the W3C Consortium:: Regarding: Making the W3C Web SQL Database Specification Active I would like to request that you make the W3C Web SQL Database specification active again. The Web SQL Database Specification enables developers to build web-based applications that can store, retrieve, manipulate and query against data on the client machine. This technology is similar to SQLite, Microsoft SQL Server, MySQL, etc. Web SQL combined with Manifest enable developers to build web-based applications that work while offline. The Web SQL Database specification was on the W3C Recommendation track, but the specification was stopped because Mozilla and Microsoft did not want to implement a specification that lacked proper SQL definition. I know there is a need for both a NoSQL and SQL solution. The two specifications (Web SQL Database and Indexed Database API) that exist to date are acceptable.. However, as stated above, the problem is the lack of definition for SQL. Since lack of definition is the issue, I would like to recommend a remedy. I know SQL experts and great documentation writers who I would gladly hire to further define the Web SQL Database specification and fill in the missing SQL definition. Is this something that would be possible to help revive the specification and get the remaining vendors on board? The minimum requirements for bringing back WebSQL, or any other SQL-based web spec is IMHO: 1. A specification for the SQL dialect being proposed. 2. *Two* independent, production quality, database implementations being willing to implement exactly that SQL dialect. Not a subset of it, and not a superset of it. 3. The two independent implementations need to have roughly the same performance characteristics. I.e. it's not ok for an implementation to generate correct results, but do it so slowly that it's in practice unusable. I'd like to add another requirement which is having a significant advantage over IndexedDB. If web devs want SQL, they can have it on top of IndexedDB in the form of an open source library (I'm willing to be it already exists). They don't need to wait for a standard to emerge, nor for browsers to consistently implement it. If they really want a spec, they can create a W3C community group (or a Github repo). We don't need browsers to do all the work for us! David
Re: Regarding: Making the W3C Web SQL Database Specification Active
On Fri, Sep 27, 2013 at 8:05 PM, Glenn Maynard wrote: > On Fri, Sep 27, 2013 at 4:23 PM, Jonas Sicking wrote: >> >> 2. *Two* independent, production quality, database implementations >> being willing to implement exactly that SQL dialect. Not a subset of >> it, and not a superset of it. > > This is an overstatement. It's not required that there be two > implementations of something that are exactly the same, match the spec > exactly, with no experimental features, no unimplemented features and no > known bugs. That's not how development of features on the Web works. I didn't say "no bugs", I said "not a subset". But yes, additional features could definitely be exist within reason. Though the intent should be that those features are going to be added to the standard. And it needs to be clear that those features are extensions, for example through the use of prefixes or by only enabling them when opted into by the user. I think there is reason to be extra conservative about allowing deviations from the standard here. SQL has a horrible record of interoperability. So someone needs to show that interoperability can actually be accomplished. / Jonas
Re: Regarding: Making the W3C Web SQL Database Specification Active
On Fri, Sep 27, 2013 at 4:23 PM, Jonas Sicking wrote: > 2. *Two* independent, production quality, database implementations > being willing to implement exactly that SQL dialect. Not a subset of > it, and not a superset of it. > This is an overstatement. It's not required that there be two implementations of something that are exactly the same, match the spec exactly, with no experimental features, no unimplemented features and no known bugs. That's not how development of features on the Web works. -- Glenn Maynard
Re: Regarding: Making the W3C Web SQL Database Specification Active
On Wed, Sep 25, 2013 at 3:39 PM, Michael Fitchett wrote: > Dear Members of the W3C Consortium:: > > Regarding: Making the W3C Web SQL Database Specification Active > > I would like to request that you make the W3C Web SQL Database > specification active again. The Web SQL Database Specification enables > developers to build web-based applications that can store, retrieve, > manipulate and query against data on the client machine. This technology is > similar to SQLite, Microsoft SQL Server, MySQL, etc. Web SQL combined with > Manifest enable developers to build web-based applications that work while > offline. > > The Web SQL Database specification was on the W3C Recommendation track, but > the specification was stopped because Mozilla and Microsoft did not want to > implement a specification that lacked proper SQL definition. I know there is > a need for both a NoSQL and SQL solution. The two specifications (Web SQL > Database and Indexed Database API) that exist to date are acceptable.. > However, as stated above, the problem is the lack of definition for SQL. > Since lack of definition is the issue, I would like to recommend a remedy. > I know SQL experts and great documentation writers who I would gladly hire > to further define the Web SQL Database specification and fill in the missing > SQL definition. Is this something that would be possible to help revive the > specification and get the remaining vendors on board? The minimum requirements for bringing back WebSQL, or any other SQL-based web spec is IMHO: 1. A specification for the SQL dialect being proposed. 2. *Two* independent, production quality, database implementations being willing to implement exactly that SQL dialect. Not a subset of it, and not a superset of it. 3. The two independent implementations need to have roughly the same performance characteristics. I.e. it's not ok for an implementation to generate correct results, but do it so slowly that it's in practice unusable. Unfortunately these are minimum requirements. I couldn't promise that even if we had that that WebSQL would get revived. So that means that we're at a bit of a catch-22. Even investigating if the above is feasible would be a lot of work, so it's unclear if anyone is willing to do that work when there is guaranteed reward. / Jonas
Re: Regarding: Making the W3C Web SQL Database Specification Active
On Friday, September 27, 2013 at 3:07 PM, pira...@gmail.com wrote: > I agree with Marcos. Also, I thinks IndexedDB fits better as a > Javascript database working in a pure object oriented way. I don't > think WebSQL it's absolutely bad, relational databases usually are > easier to work with, but a NoSQL one can be more efficient. I would go > for improve IndexedDB and if so, develop a SQL database on top of it > (it would only need just the SQL parser) as a javascript library, so > you could get the best of both worlds and also merge queries and > results in both ways (SQL and NoSQL) over the same database and data. > yeah, that would be nice. Given how low level IDB is, I'd be surprised if someone hadn't already tried to do this. -- Marcos Caceres
Re: Regarding: Making the W3C Web SQL Database Specification Active
I agree with Marcos. Also, I thinks IndexedDB fits better as a Javascript database working in a pure object oriented way. I don't think WebSQL it's absolutely bad, relational databases usually are easier to work with, but a NoSQL one can be more efficient. I would go for improve IndexedDB and if so, develop a SQL database on top of it (it would only need just the SQL parser) as a javascript library, so you could get the best of both worlds and also merge queries and results in both ways (SQL and NoSQL) over the same database and data. 2013/9/27 Marcos Caceres : > > > > On Wednesday, September 25, 2013 at 11:39 PM, Michael Fitchett wrote: > >> Dear Members of the W3C Consortium:: >> >> Regarding: Making the W3C Web SQL Database Specification Active >> >> I would like to request that you make the W3C Web SQL Database specification >> active again. The Web SQL Database Specification enables developers to build >> web-based applications that can store, retrieve, manipulate and query >> against data on the client machine. This technology is similar to SQLite, >> Microsoft SQL Server, MySQL, etc. Web SQL combined with Manifest enable >> developers to build web-based applications that work while offline. >> >> The Web SQL Database specification was on the W3C Recommendation track, but >> the specification was stopped because Mozilla and Microsoft did not want to >> implement a specification that lacked proper SQL definition. I know there is >> a need for both a NoSQL and SQL solution. The two specifications (Web SQL >> Database and Indexed Database API) that exist to date are acceptable.. >> However, as stated above, the problem is the lack of definition for SQL. >> Since lack of definition is the issue, I would like to recommend a remedy. I >> know SQL experts and great documentation writers who I would gladly hire to >> further define the Web SQL Database specification and fill in the missing >> SQL definition. Is this something that would be possible to help revive the >> specification and get the remaining vendors on board? > > I think this ship has sailed, for better or for worst. We have IndexedDB as > the database solution for the platform. It would be great to get help making > IndexedDB more usable instead of working on Web SQL. > > Kind regards, > Marcos > > -- > Marcos Caceres > > > > -- "Si quieres viajar alrededor del mundo y ser invitado a hablar en un monton de sitios diferentes, simplemente escribe un sistema operativo Unix." – Linus Tordvals, creador del sistema operativo Linux
Re: Regarding: Making the W3C Web SQL Database Specification Active
* Michael Fitchett wrote: >Since lack of definition is the issue, I would like to recommend a remedy. >I know SQL experts and great documentation writers who I would gladly hire >to further define the Web SQL Database specification and fill in the >missing SQL definition. Is this something that would be possible to help >revive the specification and get the remaining vendors on board? (Having a good specification of the SQL syntax and semantics supported by current versions of SQLite 3.x that can easily be forked, including for the purposes of "WebSQL", would be nice to have regardless of whether that makes any web browser vendor want to implement "WebSQL", especially if it can be done in cooperation with the SQLite developers.) -- Björn Höhrmann · mailto:bjo...@hoehrmann.de · http://bjoern.hoehrmann.de Am Badedeich 7 · Telefon: +49(0)160/4415681 · http://www.bjoernsworld.de 25899 Dagebüll · PGP Pub. KeyID: 0xA4357E78 · http://www.websitedev.de/
Re: Regarding: Making the W3C Web SQL Database Specification Active
On Wednesday, September 25, 2013 at 11:39 PM, Michael Fitchett wrote: > Dear Members of the W3C Consortium:: > > Regarding: Making the W3C Web SQL Database Specification Active > > I would like to request that you make the W3C Web SQL Database specification > active again. The Web SQL Database Specification enables developers to build > web-based applications that can store, retrieve, manipulate and query against > data on the client machine. This technology is similar to SQLite, Microsoft > SQL Server, MySQL, etc. Web SQL combined with Manifest enable developers to > build web-based applications that work while offline. > > The Web SQL Database specification was on the W3C Recommendation track, but > the specification was stopped because Mozilla and Microsoft did not want to > implement a specification that lacked proper SQL definition. I know there is > a need for both a NoSQL and SQL solution. The two specifications (Web SQL > Database and Indexed Database API) that exist to date are acceptable.. > However, as stated above, the problem is the lack of definition for SQL. > Since lack of definition is the issue, I would like to recommend a remedy. I > know SQL experts and great documentation writers who I would gladly hire to > further define the Web SQL Database specification and fill in the missing SQL > definition. Is this something that would be possible to help revive the > specification and get the remaining vendors on board? I think this ship has sailed, for better or for worst. We have IndexedDB as the database solution for the platform. It would be great to get help making IndexedDB more usable instead of working on Web SQL. Kind regards, Marcos -- Marcos Caceres
Regarding: Making the W3C Web SQL Database Specification Active
Dear Members of the W3C Consortium:: *Regarding: Making the W3C Web SQL Database Specification Active* I would like to request that you make the W3C Web SQL Database specification active again. The Web SQL Database Specification enables developers to build web-based applications that can store, retrieve, manipulate and query against data on the client machine. This technology is similar to SQLite, Microsoft SQL Server, MySQL, etc. Web SQL combined with Manifest enable developers to build web-based applications that work while offline. The Web SQL Database specification was on the W3C Recommendation track, but the specification was stopped because Mozilla and Microsoft did not want to implement a specification that lacked proper SQL definition. I know there is a need for both a NoSQL and SQL solution. The two specifications (Web SQL Database and Indexed Database API) that exist to date are acceptable. However, as stated above, the problem is the lack of definition for SQL. Since lack of definition is the issue, I would like to recommend a remedy. I know SQL experts and great documentation writers who I would gladly hire to further define the Web SQL Database specification and fill in the missing SQL definition. Is this something that would be possible to help revive the specification and get the remaining vendors on board? -- Michael Fitchett, Chief Executive Officer www.spotsync.com | michael.fitch...@spotsync.com 23121 Verdugo Dr, Suite 203 Laguna Hills, CA 92653 (949) 793-7371