I have just returned from my RAD Studio XE3 World Tour stops in Europe. It was great to see so many young and old developers in London, Amsterdam, Warsaw and Heidelberg. In two cities I was asked whether there were any Object Relational Mapping solutions for Delphi. There are two Delphi ORM(s) that I know about:
- TMS Software’s TMS Aurelius - commercial ORM. White paper can be found at http://www.tmssoftware.com/site/manuals/Object-Relational%20Mapping%20with%20TMS%20Aurelius.pdf
- Delphi ORM - open source ORM on Google Code. Introduction to DORM can be found at http://delphi-orm.googlecode.com/files/dorm_introduction.pdf
I have not tried either one of them yet but i hope to take a look when I get off the road. Check them out!
{ 18 } Comments
There used to be Bold…
Mormot from Synapse?
How about ECO?
Yes, http://mormot.net is an Open Source ORM for Delphi 6 and up. It works as local ORM or as a Client-Server ORM (unique feature among other Delphi ORMs), using REST/JSON. It has its own very optimized data access layers (including in-memory tables, Oracle, OleDB, ODBC, SQLite3), and is able to join several databases as one using SQLite3 virtual tables.
It is also an interface-based service oriented framework, with integrated security, UI generation and reporting.
About pure local ORM, you have several other projects than quoted - see http://stackoverflow.com/questions/422426/orm-for-delphi-win32
- InstantObjects
- tiOPF
- DObject
- GFramework
What happened ECO !!
Regards,
FK
Aurelius looks good. I’ll have a look at Delphi ORM next.
Thx.
I believe Aurelius and DORM are the ones which use latest Delphi technologies (new RTTI, generics, operator overloading, etc). While the others might work in older versions of Delphi (which is good in some situations), they are stuck with old ways of doing things and most of them don’t feel "modern" (generics comes to mind, for users of the framework).
There is also hcOPF http://www.tpersistent.com/?p=108 which is hosted on sourceforge at http://sourceforge.net/projects/larryhengensopf/
Thank you for your mention David.
ORMs are really needed in the Delphi eco-system and people are asking for this. Very Good. Now with Livebindings is really easy implmements completely OO solutions using Delphi+ORM+LiveBinding in a really fast way. This is what I’ve been waiting for ages.
And this is the main reason because I’ve started DORM.
I’m the main developer of DORM. DORM is completely Open Source but My company also offers, training, consultancy e specific development request. Just to be clear.
Thanks for mention ORM David. But you are an old timer Delphi guy and you miss to mention Bold for Delphi!
I think it is remarkable. Back in the days when Delphi 7 Architect was released Bold was included.
In my point of view Bold is the most mature ORM framework for Delphi.
I and all in my team is still using Bold in a big system for transport logistics with Delphi 2007.
As we have full source we have modified and optimized it.
It is possible for us to move forward to newer Delphi release by making it Unicode compatible.
But our time is limited and this is a big project.
I hope Embarcadero can release the source for Bold in some way as Bold in current condition has no value for Embarcadero.
The worst is that those developers without full source that invested time and money in developing Bold applications are locked in old Delphi release.
It must be in Embarcaderos interests that developers are using the latest Delphi, right ?
Also look at petition about the issue: http://www.change.org/petitions/embarcadero-technologies-release-the-intellectual-property-of-bold-for-delphi
With the new RTTI is much easy make ORM Frameworks, Aurelius is a good one, but dont work with Datasnap, i made my own in less than 1 month.
Microsoft has had much success in open sourcing some of their key frameworks. Maybe Embarcadero could start with Bold.
First of all, Hi all!
To Daniel: Could share some further info about your own ORM Framework and how you used the new RTTI to build it?
Thanx a lot in advance.
TMS Aurelius will support DataSnap in its next version with a proper Json serializer.
I’m also writing my own ORM framework. Currently it is located in my private repository but you can read some information from it’s wiki: https://bitbucket.org/soundvibe/orm/wiki/Home.
Here’s an post from 2008 with quite a few listed:
http://tdelphihobbyist.blogspot.com/2008/01/win32-object-persistence-frameworks.html
When a complete list is together — it would be a great benefit to us developers if Emb. put together a comparison chart on the docwiki highlighting features (n-tier, Delphi Versions supported, Date of Last Version, Active Y/N, Price/Open Source …)
Also, it would be smart to update the wikipedia page that refers to ORM software: http://en.wikipedia.org/wiki/List_of_object-relational_mapping_software
Revive Bold for Delphi !
I Signed the petition of Bold and I hope that every Delphi Programmer must do.
Please embarcadero enhance it or Free it.
Post a Comment