ORM (object relational manager) solution with multiple programming language support

views:

605

answers:

+4 Q:

ORM (object relational manager) solution with multiple programming language support

Is there a good ORM (object relational manager) solution that can use the same database from C++, C#, Python?

It could also be multiple solutions, e.g. one per language, as long as they can can access the same database and use the same schema.

Multi platform support is also needed.

Clarification:

The idea is to have one database and access this from software written in several different programming languages. Ideally this would be provided by one ORM having APIs (or bindings) in all of these languages.

One other solution is to have a different ORM in each language, that use compatible schemas. However I believe that schema migration will be very hard in this setting.

+1 A:

With SQLAlchemy, you can use reflection to get the schema, so it should work with any of the supported engines.

I've used this to migrate data from an old SQLite to Postgres.

Matthew Schinckel 2009-01-27 08:37:53

Not really what I was looking for. I don't want to migrate to a different DB, rather I would like to access one schema from several programming languages using ORM(s)

Ber 2009-01-27 09:53:14

@Ber: is this a clarification to your question? Please EDIT your question to add these new facts.

S.Lott 2009-01-27 13:21:12

@Ber: The point was that SQLAlchemy can give you a class and table definition for the existing schema, so you don't have to declare it again in the code (or change it whenever the schema changes). Granted, C# and C++ don't have metaclasses, so for them you'll have to define the schema yourself.

Nikhil Chelliah 2009-01-28 00:00:46

@Ber: ie, SqlAlchemy's just a good suggestion on the Python end of things. If you can interface from Python to the other languages, that would be the best choice.

Nikhil Chelliah 2009-01-28 00:01:51

Thanks Nikhil - the migration was just an example: the point was that it was built on a pre-existing DB, and was just a reflection of the schema.

Matthew Schinckel 2009-01-29 00:58:37

We have an O/RM that has C++ and C# (actually COM) bindings (in FOST.3) and we're putting together the Python bindings which are new in version 4 together with Linux and Mac support.

2009-01-30 16:34:06

+1 A:

I know DataAbstract for Pascal, C# and soon for objective C for Mac and Iphone but no Python support.

Hugues Van Landeghem 2009-04-25 13:35:20

ansaurus

tags:

views:

answers:

ORM (object relational manager) solution with multiple programming language support

Clarification:

related questions