On Mon, Mar 9, 2015 at 3:25 PM, Simon Slavin <slavins at bigfraud.org> wrote: > > On 9 Mar 2015, at 9:38pm, Scott Robison <scott at casaderobison.com> wrote: > >> A co-worker who is working on a project is interested in finding out if >> there is an effective ORM for C++ / SQLite. I've not used one so I'm >> turning to the list to see if anyone has a recommendation. > > For those playing along at home, ORM == Object Relational Mapping. In other > words you do Object-oriented programming in C++ and the objects are stored in > a SQLite database. > > I'm not aware that this problem has been solved well in any language or with > any database engine. It might seem like a terrific oppotunity to write a > demonstration library, but differences in how languages do OO and how > databases store data seem to make this a difficult problem to crack. I'd be > interested in any solutions that use SQLite with any popular OO language.
You did qualify it with "solved well", so I can only comment that depending on your requirements various ORMs may work well enough for the job. I've done projects in Python with Django's ORM (MVC web apps), SQLAlchemy, and am finding peewee [1] to work well for a small project I'm working on right now. Most OO language ORMs work about like this: Model Definition: Model classes, fields and model instances all map to database concepts: Thing :: Corresponds to... Model class :: Database table Field instance :: Column on a table Model instance :: Row in a database table All that said, I'm not familiar with C++ options myself. [1] http://peewee.readthedocs.org/en/latest/index.html -- Darren Spruell phatbuckett at gmail.com
