Facilitating the Spread of Knowledge and Innovation in Professional Software Development

Write for InfoQ


Choose your language

InfoQ Homepage News Chrome 4 Now Supports the HTML 5 Web SQL Database API

Chrome 4 Now Supports the HTML 5 Web SQL Database API

Leia em Português

This item in japanese

Google has announced support for the HTML 5 Web SQL Database API, and others are likely to follow soon or have already started on support for this API. In the meantime, the completion of the specification is blocked because all the implementers involved have chosen to use SQLite as underlying database, and multiple independent implementations are required for standardization.

As part of HTML 5, the W3C organization is working on a draft of the Web SQL Database API, a specification which covers storing and accessing data through SQL. The SQL language dialect which is described in the documentation is that of SQLite 3.6.19. This API allows web pages to contain code that interacts with an embedded client database, which is useful for applications wanting to store data locally or for offline browsing.

Google has announced support for Web SQL Database in the latest production version of their browser, Chrome 4, based on SQLite. This is a move toward standardization considering Google has a Database API, also based on SQLite, in Gears. Through the Gears API, structured data storage was provided for all major browsers, including IE, Firefox, and Safari; however, Google has stopped developing Gears.

Firefox 3 has an embedded SQLite database which is currently used mostly for storing bookmarks and history, but it will probably add support for Web SQL Database API. Work is underway on WebKit, the rendering engine used by Safari, to make the Web Database API available to web workers. Nothing is currently known about Microsoft’s plans for IE and the HTML 5 database API.

While some companies have implemented the Web Database API and others are working on implementing it, the specification has reached a roadblock according to the draft because all interested parties have chosen to use SQLite:

This specification has reached an impasse: all interested implementers have used the same SQL backend (SQLite), but we need multiple independent implementations to proceed along a standardization path. Until another implementer is interested in implementing this spec, the description of the SQL dialect has been left as simply a reference to SQLite, which isn't acceptable for a standard. Should you be an implementer interested in implementing an independent SQL backend, please contact the editor so that he can write a specification for the dialect, thus allowing this specification to move forward.

Given this “impasse”, it remains to see if the standard will drive the implementation or if it will be the other way around. At present, it appears that Google has driven an increase in the pace of browser development, and none of the browser vendors are waiting for the standards to complete before implementing their own Web SQL Database API support.

Rate this Article