List of object–relational mapping software: Difference between revisions

Revision as of 10:09, 27 December 2006

Latest revision as of 18:22, 11 May 2025

Line 1:

{{Short description|none}}

This is a list of well-known [[object-relational mapping]] software. This list is neither up-to-date nor all-inclusive.

This is a list of well-known [[object–relational mapping]] software.

<!-- IF YOU DON'T PAY ATTENTION TO THIS MESSAGE, YOUR EDIT WILL BE ROLLED BACK WITHOUT WARNING.

Only place entries here that are links to actual Wikipedia articles about notable object–relational mapping software. External links, redlinks, non-notable sites will be removed. If you have questions, use the talk page. Please try to keep entries in alphabetical order. Adding unnecessary links or text to any other section (such as the "References" section) will also be removed. Thanks.

===ColdFusion===

* [[Arf]] [http://www.clearsoftware.net/index.cfm?mode=cat&catid=4BF355FB-E081-2BAC-691AF2BBF35F5E7C] ARF - Active Record Factory

* [[CFCPowerTools]] [http://cfcpowertools.com/] Batch generation of your data layer objects in minutes.

* [[Reactor]] [http://www.doughughes.net/index.cfm?filter=category&categoryId=30] Reactor is a very simple API for ColdFusion which generates and instantiates database abstraction CFCs on the fly as needed.

* [[objectBreeze]] [http://www.nictunney.com/objectBreeze.cfm] objectBreeze creates objects directly from your data persistence layer.

* [[Transfer]] [http://www.compoundtheory.com/transfer/] Transfer is a library for generating Business Objects on the fly and abstracting database transactions through them.

-->

===Common Lisp===

==Java==

* [[CLSQL]] [http://clsql.b9.com] CLSQL is a Database interface Library for Common Lisp that can access a number of different SQL database engines.

*[[Apache Cayenne]], open-source for Java

*[[Apache OpenJPA]], open-source for Java

===Java===

*[[DataNucleus]], open-source JDO and JPA implementation (formerly known as JPOX)

*Castor [http://www.castor.org/license.html], open source, object/XML/relational mapping tool

*[[Cayenne (Java)|CayenneEbean]] [http://objectstyle.org/cayenne], open -source forORM javaframework

*[[EclipseLink]], Eclipse persistence platform

*[[CrossDB]] [http://crossdb.com/], open source

*[[Enterprise JavaBeans]] (EJB)

*[[Enterprise Objects Framework]], Mac OS X/Java, part of Apple [[WebObjects]]

*[[Hibernate (framework)|Hibernate]], open-source ORM framework, widely used

* FireStorm/DAO [http://www.codefutures.com/hibernate/], generates ORM code from relational schema

*[[Hibernate (Java)|Hibernate]], [http://www.hibernate.org/], open source ORM Framework, widely used

*Hydrate [http://hydrate.sourceforge.net/], open source, relational/object/XML mapping tool

*[[iBATIS]] [http://ibatis.apache.org/], maintained by [[Apache Software Foundation | ASF]], and with .NET port.

*[[intelliBO]] by Signsoft [http://www.intellibo.com/], implementation of JDO

*[[Java Data Objects]] (JDO)

*[[JOOQ Object Oriented Querying]] (jOOQ)

* JDX [http://www.softwaretree.com], commercial

*[[Apache OpenJPA|Kodo]], commercial implementation of both [[Java Data Objects]] and [[Java Persistence API]]

*[[JPOX]] [http://www.jpox.org/], open source JDO 2 reference implementation

*[[TopLink]] by Oracle

*Lychee [http://www.lycheemapper.org/], SQL-centric O/R mapper, open source

*OpenAccess [http://www.vanatec.com/en/java], commercial JDO implementation, also available on .NET.

==Node.js==

*[[OJB]], [http://db.apache.org/ojb],apache, open source, supports OJB, JDO and ODMG API.

*[https://npm-compare.com/bookshelf Bookshelf], lightweight ORM tool for PostgreSQL, MySQL, and SQLite3

*SimpleORM [http://www.simpleorm.org/], open source ORM Framework (lightweight)

*[https://orange-orm.io/ Orange ORM] Typescript/Javascript ORM for PostgreSQL, MySQL, SQL Server, SQLite, Oracle, SAP ASE and Cloudflare D1

*Speedo [http://speedo.objectweb.org/], open source implementation of JDO

*[https://www.prisma.io/ Prisma ORM] Typescript/Javascript ORM for PostgreSQL, MySQL, SQL Server, SQLite, MongoDB, CockroachDB, Planetscale, MariaDB

*[[TopLink]] by Oracle [http://www.oracle.com/technology/products/ias/toplink/index.html]

*[https://npm-compare.com/sequelize Sequelize], Node.js ORM tool for Postgres, MySQL, MariaDB, SQLite, DB2, Microsoft SQL Server, and Snowflake

*[[JDBCPersistence]][http://www.jdbcpersistence.org] Fast ORM for Java

*[https://npm-compare.com/typeorm Typeorm], Typescript/Javascript scalable ORM tool

*[[WebObjects]][http://www.apple.com/webobjects/] commercial from Apple, includes EOF as the object-relational mapping layer

*[https://npm-compare.com/@mikro-orm/core MikroORM], TypeScript ORM based on Data Mapper, Unit of Work and Identity Map patterns. Supports PostgreSQL, MySQL, SQLite (including libSQL), MongoDB, and MariaDB

==iOS==

*[[Core Data]] by [[Apple Inc|Apple]] for [[Mac OS X]] and [[iOS]]

==.NET==

*[[Base One Foundation Component Library]], free or commercial

*[[Dapper ORM|Dapper]], open source

*[[Entity Framework]], included in .NET Framework 3.5 SP1 and above

*[[iBATIS]], free open source, maintained by [[Apache Software Foundation|ASF]] but now inactive.

*[[Language Integrated Query#LINQ to SQL|LINQ to SQL]], included in .NET Framework 3.5

*[[NHibernate]], open source

*nHydrate, open source

*Quick Objects, free or commercial

==Objective-C, Cocoa==

* [[Enterprise Objects Framework|Enterprise Objects]], one of the first commercial OR mappers, available as part of [[WebObjects]]

* [[Core Data]], object graph management framework with several persistent stores, ships with Mac OS X and iOS

==Perl==

*[[DBIx::Class]]

===.NET=PHP==

*[[Laravel]], framework that contains an ORM called "Eloquent" an ActiveRecord implementation.

*[[Briyante Integration Environment]] [http://www.visiphor.com/], commercial

*[[Doctrine (PHP)|Doctrine]], open source ORM for PHP, Free software (MIT)

*[[Business Logic Toolkit for .NET]] [http://www.bltoolkit.net], open source

*[[CakePHP]], ORM and framework, open source (scalars, arrays, objects); based on database introspection, no class extending

*[[Castle ActiveRecord]] [http://www.castleproject.org/activerecord/index.html], ActiveRecord for .NET, open source

*[[CodeIgniter]], framework that includes an ActiveRecord implementation

*[[Data Tier Modeler]] [http://www.evaluant.com], commercial

*[[Yii]], ORM and framework, released under the BSD license. Based on the ActiveRecord pattern

*[[DataBlock]] [http://www.voidsoft.ro/], commercial

*[[FuelPHP]], ORM and framework for PHP, released under the MIT license. Based on the ActiveRecord pattern.

*[[DataObjects.NET]] [http://www.x-tensive.com/], commercial

*[[Laminas]], framework that includes a table data gateway and row data gateway implementations

*[[dOOdads]] [http://www.mygenerationsoftware.com/portal/dOOdads/Overview/tabid/63/Default.aspx], freeware

*[[Qcodo]], ORM and framework, open source

*[[EasyObjects.NET]] [http://www.easyobjects.net], The O/RM for the Microsoft Enterprise Library, open source

*[[Redbean (software)|Redbean]], ORM layer for PHP, for creating and maintaining tables on the fly, open source, BSD

*[[EUSS]] [http://www.evaluant.com], open source

*[[Skipper (computer software)|Skipper]], visualization tool and a [[Automatic programming|code/schema generator]] for PHP [[O/R mapper|ORM frameworks]], commercial

*[[eXpress Persistent Objects for .NET]] [http://www.devexpress.com/Products/NET/XPO], commercial

*[[Genom-e]] [http://www.genom-e.com/], commercial

*[[Gentle.NET]] [http://www.mertner.com/confluence/display/Gentle/Home], open source

*[[NHibernate]] [http://www.nhibernate.org/], open source

*[[iBATIS.NET]] [http://ibatisnet.apache.org/], open source

*[[IdeaBlade_DevForce]] [http://www.ideablade.com], Free or commercial

*[[Lattice.DataMapper]] [http://www.latticesoft.com/], free or commercial

*[[LLBLGen Pro]] [http://www.llblgen.com/], commercial

*[[LLBLGen]] [http://www.sd.nl/software/], open source

*[[Neo (object-relational toolset)|Neo]] [http://neo.codehaus.org/], open source

* NJDX [http://www.softwaretree.com/], commercial

* Nolics[http://www.Nolics.com/], commercial, auto-update database structure

*[[ObjectMagix]] [http://www.objectmagix.com/], O/R mapper for .NET 2.0, commercial with free demo

*[[ObjectMapper .NET]] [http://www.objectmapper.net], GPL and commercial license

* OpenAccess [http://www.vanatec.com], commercial, free express version [http://www.vanatec.com/express], source code available (also available on Java)

*[[Opf3]] [http://www.opf3.com/], commercial

*[[ORM.NET]] [http://www.olero.com/], open source; GNU license

*[[Persistor.NET]] [http://www.persistor.net], free or commercial

*[[Puzzle.NPersist]] [http://www.puzzleframework.com/forum/forum.aspx?Forum=23], open source

*[[Sooda]] [http://www.sooda.org/], open source; BSD license

*[[TierDeveloper]] [http://www.alachisoft.com/], commercial

*[[Wilson ORMapper for .NET]] [http://www.ormapper.net/], commercial (license includes source code)

===Perl=Python==

*[[Django (web framework)|Django]], ActiveRecord ORM included in Django framework, open source

*[[Class::DBI]] [http://search.cpan.org/~tmtm/Class-DBI-0.96/lib/Class/DBI.pm], open source

*[[SQLAlchemy]], open source, a Data Mapper ORM

*[[Rose::DB::Object]] [http://search.cpan.org/dist/Rose-DB-Object/lib/Rose/DB/Object.pm], open source

*[[Perl OOPS|OOPSSQLObject]] [http://search.cpan.org/~muir/OOPS/lib/OOPS.pod], open source

*[[Storm (software)|Storm]], open source (LGPL 2.1) developed at [[Canonical Ltd.]]

*[[PerlORM|ORM]] [http://perlorm.sourceforge.net/], open source

*[[DBIx::ClassTryton]] [http://dbix-class.shadowcatsystems.co.uk/], open source

*[[Alzaboweb2py]], [http://www.alzabo.org]the facilities of an ORM are handled by the DAL in web2py, open source

*[[Odoo]] – Formerly known as OpenERP, It is an Open Source ERP in which ORM is included.

*[[Tangram (Perl]] [http://search.cpan.org/dist/Tangram/], open source

===PHP=Ruby==

* [[iBATIS]] (inactive)

*[[Metastorage]] [http://www.meta-language.net/metastorage.html] ORM classes generator tool for PHP 4, PHP 5 or higher, free software (modified BSD license)

* [[ActiveRecord]]

*[[Propel (PHP ORM toolkit)]] [http://propel.phpdb.org/] ORM and Query-Toolkit for PHP5, inspired from Apache Torque, free software (GNU LGPL)

* [[DataMapper]]

*[[DB_DataObject]] [http://pear.php.net/package/DB_DataObject] PEAR Package, free software (PHP License)

*[[Doctrine]] [http://www.phpdoctrine.org] Open Source ORM for PHP 5.1, free software (GNU LGPL)

*[[CakePHP]] [http://cakephp.org/] Framework modelled on Rails, that uses common design patterns such as ActiveRecord. free software (MIT/Expat license)

*[[EZPDO]], [http://www.ezpdo.net/], A lightweight and easy-to-use PHP persistence solution. free software (modified BSD license)

*[[ADOdb Active Record]], [http://phplens.com/lens/adodb/docs-active-record.htm], Recently, ADOdb, a well-known PHP database abstraction layer, has included an implementation of ActiveRecord as well. free software (dual licensed, modified BSD license + GNU LGPL)

*[[Solar PHP]], [http://solarphp.com], PHP5 Framework which provides a lighweight implementation of the TableModule pattern, [http://solarphp.com/index.php/docs/read/Solar_Sql_Table/ Solar_Sql_Table], based on [http://solarphp.com/index.php/docs/read/Solar_Sql/HomePage Solar_Sql]. free software (modified BSD license)

===Python=Rust==

* [http://diesel.rs/ Diesel]

Lists of ORM tools for [[Python (programming language)|Python]]: [http://www.thinkware.se/cgi-bin/thinki.cgi/ObjectRelationalMappersForPython] [http://wiki.python.org/moin/HigherLevelDatabaseProgramming]

* [https://www.sea-ql.org/SeaORM/ SeaORM]

*Ape [http://hathawaymix.org/Software/Ape], an ORM layer on top of the [[Zope]] Object Database ([[ZODB]])

* [https://github.com/weldsorm/welds/ Welds]

*[[SQLAlchemy]] [http://sqlalchemy.org/], open source

*[[SQLObject]] [http://sqlobject.org/], open source

*[[PyDO]] [http://skunkweb.sourceforge.net/pydo.html], part of [[SkunkWeb]] (open source)

*[[PyDO2]] [http://skunkweb.sourceforge.net/pydo2.html], an implementation of [[PyDO]] with no dependencies on [[SkunkWeb]], with [http://skunkweb.sourceforge.net/PyDO2/manual.html#differences-from-pydo-1 many other improvements over PyDO], in particular a more elegant declarative syntax. PyDO2 requires [[Python (programming language)|Python]] 2.4.

*[[MiddleKit]], part of [[Webware]] [http://www.webwareforpython.org/] (open source)

*[[ForgetSQL]] [http://soiland.no/software/forgetsql], open source

*[[QLime]] [http://www.qlime.org/], open source

* The open source [[Django web framework]] includes an object-relational mapper.

*Dejavu [http://projects.amor.org/dejavu/], a public ___domain Data Mapper featuring mixable stores and pure-Python queries.

*[[Twisted Asynchronous Database Api]] [http://www.darkarts.co.za/projects/tada], open source, twisted matrix

===Ruby=Smalltalk==

* [[TopLink|TOPLink/Smalltalk]], by Oracle, the Smalltalk predecessor of the Java version of TOPLink

*[[Active Record]] [http://ar.rubyonrails.com], part of [[Ruby on Rails]] [http://www.rubyonrails.com] (open source)

* Og [http://www.nitroproject.org/wiki/pages/Programming+Og/Documentation] part of [[Nitro]] [http://www.nitroproject.org/] (open source)

* Rubernate [http://rubernate.rubyforge.org]

* Lafcadio [http://lafcadio.rubyforge.org/]

===Smalltalk=See also==

* [[Comparison of object–relational mapping software]]

*[[GLORP]] [http://www.glorp.org/], open source

===C++=References==

<references />

*DTL [http://dtemplatelib.sourceforge.net/], Database Template Library

{{DEFAULTSORT:List Of Object-Relational Mapping Software}}

[[Category:Lists of software|Object-relational mapping software]]

[[Category:Object–relational mapping|*]]

[[Category:Database management systems|Object-relational mapping software]]