List of object–relational mapping software: Difference between revisions

Revision as of 22:25, 16 July 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

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

==Node.js==

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

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

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

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

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

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

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

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

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

*[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]]

==PHP==

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

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

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

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

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

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

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

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

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

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

===.NET=Python==

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

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

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

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

*[[SQLObject]], open source

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

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

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

*[[Tryton]], open source

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

*[[web2py]], the facilities of an ORM are handled by the DAL in web2py, open source

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

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

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

*[[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

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

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

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

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

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

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

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

*[[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

*[[Wilson ORMapper for .NET]] [http://www.ormapper.net/], commercial

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

*[[Vanatec OpenAccess]] [http://www.vanatec.com], The O/RM for Microsoft .NET, commercial

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

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

*[[Wilson OR mapper]] [http://www.ormapper.net/], commercial (license includes source code)

*[[BLToolkit]] [http://www.bltoolkit.net], open source

===Perl=Ruby==

* [[iBATIS]] (inactive)

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

* [[ActiveRecord]]

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

* [[DataMapper]]

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

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

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

*[[Alzabo]] [http://www.alzabo.org], open source

===PHP=Rust==

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

*[[Metastorage]] [http://www.meta-language.net/metastorage.html] ORM classes generator tool for PHP 4, PHP 5 or higher, open source

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

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

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

*[[DB_DataObject]] [http://pear.php.net/package/DB_DataObject] PEAR Package, open source

*[[Php Object Generator (POG)]] [http://www.phpobjectgenerator.com/] Open Source online ORM Generator, creates objects for PHP 5, PHP 4

*[[CakePHP]] [http://cakephp.org/] Framework modelled on Rails, that uses common design patterns such as ActiveRecord.

*[[EZPDO]], [http://www.ezpdo.net/], A lightweight and easy-to-use PHP persistence solution. Open source.

*Doctrine, [http://www.phpdoctrine.com], Open source ORM solution for PHP

*[[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.

*[[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].

===Python=Smalltalk==

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

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

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

*[[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=See also==

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

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

* Og [http://www.nitrohq.com/]

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

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

===Smalltalk=References==

<references />

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

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

[[Category:Lists of software]]

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

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