|
SELECT * FROM parts WHERE name = 'gearbox' LIMIT 1; -- MySQL or PostgreSQL
</source>
=== ColdFusion ===
[[ColdFusion]] has an open source implementation of the active record pattern.
The [[ColdFusion on Wheels]] framework has an implementation of the active record pattern. It is open source and has the added advantage of requiring no complex configuration.
The [[ColdBox Platform|ColdBox]] [https://coldbox-orm.ortusbooks.com/ cborm] Module has an implementation of the [https://coldbox-orm.ortusbooks.com/active-record/active-entity active record pattern] for [[ColdFusion Markup Language|ColdFusion]] ORM based on [[Hibernate (framework)|Hibernate]].
=== PHP ===
PHP ActiveRecord is one [[open-source]] library designed to fulfill the active record pattern.<ref>{{cite web|title=PHP ActiveRecord|url=http://www.phpactiverecord.org/|access-date=2009-10-23|archive-url=https://web.archive.org/web/20100208131627/http://www.phpactiverecord.org/|archive-date=2010-02-08|dead-url=yes|df=}}</ref>
Several open-source [[PHP]] frameworks also bundle their own [[Object-relational mapping|ORM]] implementing the active record pattern. Most implementations support relationships, behaviors, [[input validation|validation]], [[serialization]] and support for multiple data sources.
=== Ruby ===
The [[Ruby (programming language)|Ruby]] library ActiveRecord implements ORM. It creates a [[Persistence (computer science)|persistable]] ___domain model from business objects and database tables, where logic and data are presented as a unified package. It largely simplifies object-record mapping by assuming homogeneous identification method (i.e. [[Surrogate key]]) by virtue of [[convention over configuration]]. ActiveRecord adds [[Inheritance (computer science)|inheritance]] and [[Association (object-oriented programming)|associations]] to the pattern above, solving two substantial limitations of that pattern. A set of macros acts as a ___domain language for the latter, and the [[Single Table Inheritance]] pattern is integrated for the former; thus, ActiveRecord increases the functionality of the active record pattern approach to database interaction. ActiveRecord is the default ‘model’ component of the [[model-view-controller]] web-application framework [[Ruby on Rails]], and is also a stand-alone ORM package for other Ruby applications. In both forms, it was conceived of by [[David Heinemeier Hansson]], and has been improved upon by a number of contributors.<ref>{{cite web|url=https://github.com/rails/rails/tree/master/activerecord|title=Ruby Active Record|accessdate=2013-04-12}}</ref>
Other ORMs have been released since ActiveRecord first appeared. For example, [[DataMapper (Ruby)|DataMapper]] and [[Sequel (Ruby)|Sequel]]. These ORMs include improvements over the original ActiveRecord framework.{{POV statement|date=May 2012}} As a response to their release and adoption by the Rails community, Ruby on Rails v3.0 became independent of an ORM system, so that Rails users can instead use DataMapper or Sequel as their ORM.
=== Python ===
[[Django_(web_framework)|Django]], one of [[Python_(programming_language)|Python]]'s many web frameworks, uses the Active Record pattern for its ORM.<ref>{{cite web|url=https://docs.djangoproject.com/en/1.11/misc/design-philosophies/#models|accessdate=2017-06-28}}</ref>
=== Java ===
The [[Java (programming language)|Java language]] implements the Active Record pattern via the [[ActiveJDBC]] library. ActiveJDBC is an implementation of Active Record design pattern inspired by [[Ruby on Rails]] ActiveRecord. ActiveJDBC is lightweight, fast, small and does not require any configuration.
[[ActiveJPA]] and [[Java Object Oriented Querying|jOOQ (for Java Object Oriented Querying)]] implements the Active record pattern, combining active records with [[Automatic programming|source code generation]] and a querying DSL similar to [[SQL]] allowing for retrieving active records using complex SQL statements.
The [[Play framework]] is a Java web framework which implements the Active Record pattern, using ideas from [[Ruby on Rails]].
=== Other languages ===
There are several open-source implementations of the Active Record pattern in other languages, including [[JavaScript]] (e.g., [[ActiveJS]]'s Active Record<ref name="ActiveJS">{{cite web|url=http://www.activejs.org/activerecord/ActiveRecord/index.html|title=ActiveJS Active Record|accessdate=2011-07-28|archive-url=https://web.archive.org/web/20110930024525/http://activejs.org/activerecord/ActiveRecord/index.html|archive-date=2011-09-30|dead-url=yes|df=}}</ref>), [[Perl]] ([[DBIx::Class]]), [[ActionScript]], [[Haxe]] (SPOD<ref name="HaxeSPOD">{{cite web|url=http://haxe.org/manual/spod|title=SPOD Macros|accessdate=2013-01-09|archive-url=https://web.archive.org/web/20121130055044/http://haxe.org/manual/spod|archive-date=2012-11-30|dead-url=yes|df=}}</ref>), [[C Sharp (programming language)|C#]],<ref name="CastleActiveRecord">{{cite web|title=Castle ActiveRecord|url=http://www.castleproject.org/projects/activerecord/|accessdate=14 January 2014}}</ref> [[Objective-C]]<ref>{{cite web|title=Objective Record|url=https://github.com/mneorr/Objective-Record|accessdate=14 January 2013}}</ref> and [[Scala (programming language)|Scala]].<ref>{{cite web|title=Scala Active Record|url=https://github.com/aselab/scala-activerecord|accessdate=4 December 2013}}</ref>
== Criticism ==
| 