[Bioc-devel] SQLite databases

[Sean Davis]

Mark W Kimpel wrote:
> I just caught the last two messages on this list regarding making sqlite 
> dbs more accessible from R. Just last week I read a review of 
> SQLAlchemy, http://www.sqlalchemy.org/, a Python derived open-source 
> "object relational mapper" to dbs. Would this be of any help or at least 
> provide some direction in which to go?

I think the general term is Object-Relational Mapping (ORM).  In perl,
there are a number of them including Rose::DB::Object, Class::DBI,
DBIx::Class (and many others).  Python has several, also, including the
above-mentioned sqlalchemy, SqlObject, DejaVu, and a few others.  Ruby
has ActiveRecord.  Java has several, some of them multitiered.  See here
for more information:

http://en.wikipedia.org/wiki/Object-relational_mapping

Sean