lua-users home
lua-l archive

[Date Prev][Date Next][Thread Prev][Thread Next] [Date Index] [Thread Index]


Hello,

I'm wondering if anyone is working on some sort of object-relational mapping tool for LuaSQL?

Perhaps something along the lines of NeXT's Enterprise Object's EOAccess framework:

http://en.wikipedia.org/wiki/Enterprise_Objects_Framework
http://developer.apple.com/documentation/WebObjects/Reference/API/com/ webobjects/eoaccess/package-summary.html

Or Rails's ActiveRecord:

http://ar.rubyonrails.org/

SQL92 INFORMATION_SCHEMA provides all the necessary information to build a full fledge ORM library without too much fuss. Most relational databases do support this SQL92 standard one way or another*:

http://dev.mysql.com/doc/mysql/en/information-schema-tables.html
http://www.postgresql.org/docs/current/static/information-schema.html
http://www.sqlite.org/cvstrac/wiki?p=InformationSchema
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ tsqlref/ts_ia-iz_4pbn.asp

Thoughts?

Cheers

--
PA, Onnay Equitursay
http://alt.textdrive.com/

* Oracle is in a world by itself... but it would be straightforward enough to provide a set of INFORMATION_SCHEMA compatible views derived from Oracle's own data dictionary and/or DBMS_METADATA.

http://www.oreillynet.com/pub/a/network/2002/10/28/data_dictionary.html