ODBC Bridge for HTML5 - Safari Extension


What is this?

An extension that provides HTML5 Web SQL Database API binding to ODBC.

Why is it important?

Rather than being confined to SQLite for Web Database access, users and developers can now use the HTML5 Web SQL Database API against any ODBC-accessible RDBMS engine, including Oracle, Microsoft SQL Server, IBM DB2, IBM Informix, Sybase, Ingres, Progress, MySQL, PostgreSQL, Firebird, etc.

When using OpenLink Virtuoso as their Web Database, users and developers enjoy the following additional benefits:

  • Virtual/Federated RDBMS access — A single ODBC connection to Virtuoso enables access to, and distributed joins across, all ODBC- or JDBC-accessible data sources.
  • RDF and Graph Database access — A single ODBC connection to Virtuoso enables SPARQL access to local and/or remote RDF-based Linked Data via SPASQL (SQL and SPARQL query language hybrid).
  • Extra security — Client-side X.509 certificates leverage SSL and RDF-based Linked Data (aka, FOAF+SSL) for fine-grained security and data-access policies which can be scoped to Virtuoso User Accounts.

How do I install the HTML5 Extension for Safari ?

Install this ODBC HTML5 Bridge extension for Safari. Once installed depending on the operating system (Mac OS X or Windows) in use a separate OS specific installer needs to be run to install the OS specific ODBC modules not allowed in Safari extensions.

On Mac OS X:

  • Download the OpenLink iODBC internet plugin.zip file.
  • Unzip "OpenLink iODBC internet plugin.zip" and run the extracted "OpenLink iODBC internet plugin.mpkg" file to install the iODBC internet plugin components

On Windows:

How do I use it?

Simply install an ODBC Driver for your desired target RDBMS. Then start using the new Web Database APIs for data access from your HTML5 application as detailed at this URL: http://dev.w3.org/html5/webdatabase/

Simple Test HTML5 document that uses this API for SQL based RDBMS data access is available at this URL: http://html5-webdb.s3.amazonaws.com/webdb-api/ODBCsample1.html.

How do I obtain ODBC Drivers?

Related Links: