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

Re: Web Storage & SQL

From: Ivan Enderlin @ Hoa <@>
Date: Fri, 10 Apr 2009 14:30:36 +0200
Message-ID: <49DF3BEC.3050807@hoa-project.net>
CC: public-webapps@w3c.org
Hi :-),

My opinion about the web storage & SQL is splitted in two parts.

On the one hand, making a subset of SQL instructions is very difficult. 
Each of us knows that and no-one would say the contrary.
On the other hand, I have made an ORM in the past, build on two layers. 
The first one is a database abstract layer (DAL) that enables user to 
choose the RDBMS which he would like to use (what the /type/ argument of 
the openDatabase() function expects). The second one is an 
object-relational mapping layer (ORM) that builds SQL query through an 
object interface. The SQL instructions builder is delagated in many 
classes (with encapsulation): one class per supported database 
(typically, one class per RDBMS).

A relevant and obvious compromise would be to make an ORM, with an API 
interface as jLinq proposes. It abstracts the database, proposes a 
standard API, enables multiple RDBMS in use etc.
Thoughts ?

Best regards.

Ivan Enderlin
Developper of Hoa Framework
Received on Friday, 10 April 2009 12:31:20 UTC

This archive was generated by hypermail 2.4.0 : Friday, 17 January 2020 18:12:53 UTC