ActiveRecord with **some** columns mapped to database?

Hi There. I'm involved in creating a bridge between ROR and an open-source database (OpenAccess, or OA for short) used for EDA (Electronic Design Automation).

OA is a great database for capturing properties of hardware designs (such as pins, ports, constraints on signals etc.), since it provides very compact storage for designs which contain millions of objects,but is not a relational database. There is a preliminary OA<->Ruby bridge done in SWIG, so that we can create OA objects through Ruby, store them in OA etc.

I would like to combine the two - i.e. have n "activerecord"-like object, where some columns are stored directly in an *SQL table, but other columns are mapped to OA objects. That way I can use the Rails framework while utilizing the compact OA database.

Is that doable? Any pointers or advice would be most welcome

Kretch

Hi There. I'm involved in creating a bridge between ROR and an open-source database (OpenAccess, or OA for short) used for EDA (Electronic Design Automation).

OA is a great database for capturing properties of hardware designs (such as pins, ports, constraints on signals etc.), since it provides very compact storage for designs which contain millions of objects,but is not a relational database. There is a preliminary OA<->Ruby bridge done in SWIG, so that we can create OA objects through Ruby, store them in OA etc.

I would like to combine the two - i.e. have n "activerecord"-like object, where some columns are stored directly in an *SQL table, but other columns are mapped to OA objects. That way I can use the Rails framework while utilizing the compact OA database.

store the OA data as a blob column on the corresponding activerecord or store as a text column whatever info you need to get the info out of OA ?

Fred

Frederick Cheung wrote: