Object relational mapper (ORM) for PHP that sits on top of a powerful database abstraction layer (DBAL). One of its key features is the option to write database queries in a proprietary object oriented SQL dialect called Doctrine Query Language (DQL), inspired by Hibernates HQL. This provides developers with a powerful alternative to SQL that maintains flexibility without requiring unnecessary code duplication. The Doctrine ORM aims to provide transparent object persistence for idiomatic, object-oriented PHP. It is very similar in nature and API to the Java Persistence API with a lot of PHP-specific features aiming at more simplicity and practicability for the PHP environment.

Object relational mapper (ORM) for PHP that sits on top of a powerful database abstraction layer (DBAL). One of its key features is the option to write database queries in a proprietary object oriented SQL dialect called Doctrine Query Language (DQL), inspired by Hibernates HQL. This provides developers with a powerful alternative to SQL that maintains flexibility without requiring unnecessary code duplication.

Doctrine ORM - Object relational mapper for PHP

Propel is an open-source Object-Relational Mapping (ORM) for PHP5. It allows you to access your database using a set of objects, providing a simple API for storing and retrieving data. Propel uses PDO as an abstraction layer, and code generation to remove the burden of runtime introspection. Therefore Propel is fast. Propel implements all the key concepts of mature ORM layers: the ActiveRecord pattern, validators, behaviors, table inheritance, reverse engineering an existing database, nested sets, nested transactions, lazy loading, LOB, etc. Propel supports MySQL, PostgreSQL, SQLite, MSSQL, and Oracle.

Propel is an open-source Object-Relational Mapping (ORM) for PHP5. It allows you to access your database using a set of objects, providing a simple API for storing and retrieving data. Propel uses PDO as an abstraction layer, and code generation to remove the burden of runtime introspection. Therefore Propel is fast.

Propel - smart easy object persistance in PHP

Hibernate facilitated the storage and retrieval of domain objects via Object/Relational Mapping. Today, Hibernate is a collection of related projects enabling developers to utilize POJO-style domain models in their applications in ways extending well beyond Object/Relational Mapping. Hibernate lets you develop persistent classes following natural Object-oriented idioms including inheritance, polymorphism, association, composition. It supports Oracle, DB2, MySQL, PostgreSQL, Sybase, Interbase, Microsoft SQL Server, Progress, SAP DB, and HypersonicSQL. It also provides support to do text search and Shard (horizontal partition) the database.
 <UL>
	<LI>Transparent Persistence</LI>
	<LI>High Performance</LI>
	<LI>Reliability and Scalability</LI>
	<LI>Extensibility: Hibernate is highly customizable and extensible. </LI>
	<LI>Support for Hibernate Query Language (HQL)</LI>
 </UL>

Hibernate facilitated the storage and retrieval of domain objects via Object/Relational Mapping.  Today, Hibernate is a collection of related projects enabling developers to utilize POJO-style domain models in their applications in ways extending well beyond Object/Relational Mapping.

Hibernate - Relational Persistence for Java

NHibernate is a mature, open source object-relational mapper for the .NET framework. NHibernate is a port of Hibernate Core for Java to the .NET Framework. It handles persisting plain .NET objects to and from an underlying relational database. NHibernate supports transparent persistence, your object classes don't have to follow a restrictive programming model. Persistent classes do not need to implement any interface or inherit from a special base class. This makes it possible to design the business logic using plain .NET (CLR) objects and object-oriented idiom. Full Text Search. Cluster-scoped caching with Microsoft Velocity & Memcached. Business validation rules. ReSharper plugin. Castle Active Record. S#arp Architecture. And many more... 
 <UL><li>Natural programming model - NHibernate supports natural OO idiom; inheritance, polymorphism, composition and the .NET collections framework, including generic collections.</li></ul><ul style="text-align: justify;"><li>Native .NET - NHibernate API uses .NET conventions and idioms</li></ul><ul style="text-align: justify;"><li>Support for fine-grained object models - a rich variety of mappings for collections and dependent objects</li></ul><ul style="text-align: justify;"><li>No build-time bytecode enhancement - there's no extra code generation or bytecode processing steps in your build procedure</li></ul><ul style="text-align: justify;"><li>The query options - NHibernate addresses both sides of the problem; not only how to get objects into the database, but also how to get them out again</li></ul><ul style="text-align: justify;"><li>Custom SQL - specify the exact SQL that NHibernate should use to persist your objects. Stored procedures are supported on Microsoft SQL Server.</li></ul><ul style="text-align: justify;"><li>Support for "conversations" - NHibernate supports long-lived persistence contexts, detach/reattach of objects, and takes care of optimistic locking automatically</li></ul><ul style="text-align: justify;"></ul>

NHibernate is a mature, open source object-relational mapper for the .NET framework. NHibernate is a port of Hibernate Core for Java to the .NET Framework. It handles persisting plain .NET objects to and from an underlying relational database.

NHibernate - object-relational mapper for .NET

The Qcodo Development Framework is an open-source PHP web application framework which builds an Object Relational Model (ORM), CRUD (Create, Retrieve, Update, Delete) UI pages, and AJAX hooks from an existing data model. It additionally includes a tightly-integrated HTML and JavaScript form toolkit which interfaces directly with the generated entities. It is a robust, comprehensive framework which can be utilized by small and large Web applications alike. The framework consists of three main components: the Code Generator, QForms (OOP generated stateful Ajax- or server-processed webform), QQuery (OOP based SQL Query builder) -- all of which can be used independently of each other. The Code Generator parses an existing Relational Database structure, and builds an ORM, as well as several remote interfaces (SOAP, AJAX) to the ORM. The ORM in Qcodo can be extended to provide user-maintained functionality (via object subclassing). QForms is a ASP.NET-inspired templating engine in which each form element is an object exposing its functionality and state via methods and attributes. Delo.si, the official website of <A HREF="http://www.delo.si/" target="_blank">Delo</A>, the major daily newspaper of Slovenia.

The Qcodo Development Framework is an open-source PHP web application framework which builds an Object Relational Model (ORM), CRUD (Create, Retrieve, Update, Delete) UI pages, and AJAX hooks from an existing data model. It additionally includes a tightly-integrated HTML and JavaScript form toolkit which interfaces directly with the generated entities. It is a robust, comprehensive framework which can be utilized by small and large Web applications alike.

Qcodo - Code Less Do More

nHydrate is an object-relational mapping (ORM) solution for the Microsoft .NET platform providing a framework for a relational database to be mapped to .NET objects. It is designed to alleviate the software developers experience writing persistence domains. The model controls database generation, LINQ syntax, API, DAL, etc. The tool is entirely sited within Visual Studio.NET and all model maintenance and generation is handled directly from the environment. There are no XML files or other complex configuration scenarios to navigate like almost all other ORM tools. The VS.NET plugin GUI editor provides an interface to interact with a model and use it. Its features include: 
 <UL>
	<LI>Model Driven Architecture (MDA)</LI>
	<LI>Powerful code generation framework</LI>
	<LI>Visual Studio Integration</LI>
	<LI>Dependency Walking</LI>
	<LI>Persistence of 'dirty' (changed) data only</LI>
	<LI>Server-side paging</LI>
	<LI>In-memory filtering and sorting using LINQ</LI>
	<LI>Auditing Support</LI>
	<LI>Validation support</LI>
	<LI>Callbacks and Notifications</LI>
	<LI>Advanced lazy loading/load on demand</LI>
	<LI>Load objects with LINQ syntax</LI>
	<LI>Support for aggregate functionality</LI>
	<LI>Concurrency Control Mechanism</LI>
	<LI>Dynamic SQL Support</LI>
 </UL>

nHydrate is an object-relational mapping (ORM) solution for the Microsoft .NET platform providing a framework for a relational database to be mapped to .NET objects. It is designed to alleviate the software developers experience writing persistence domains. The model controls database generation, LINQ syntax, API, DAL, etc.

nHydrate - Conceive, Model, Generate

SubSonic is A Super High-fidelity Batman Utility Belt that works up your Data Access (using Linq in 3.0), throws in some much-needed utility functions, and generally speeds along your dev cycle. You can code your objects the way you like (with some minor convention tweaks) and the SimpleRepository will save them for you. It will also create your database on the fly if you want, altering the schema as you change your object. If you like having to do as little as possible with your data access, ActiveRecord makes this very, very simple. You don't need to create a lot of extra objects or know how the guts of anything work. It's as simple as asking for a new object and calling a Save() method.

SubSonic is A Super High-fidelity Batman Utility Belt that works up your Data Access (using Linq in 3.0), throws in some much-needed utility functions, and generally speeds along your dev cycle.

SubSonic - Data access for .NET

RedBeanPHP is an open source ORM (object relational mapping) tool for PHP. It focuses on simplicity and ease of use. What makes RedBean unique is that it creates your database schema on-the-fly. It scans your data and adjusts the column types to fit your object properties. If your models are stabilized you can freeze the database. This way RedBean is easy to develop with but is also extremely fast on production servers. RedBean requires zero configuration. No INI, YAML, XML or other config files. Just include the file in your code and you are done. RedBean works with beans. Beans are simple objects that only have public properties. The idea behind RedBean is simple, you fill the bean with the properties you need and then you give it to RedBean and it will be stored in the database. No matter what. RedBean creates tables, columns and column types on the fly. No need to switch back-and-forth to phpmyadmin anymore! Just write your code and RedBean takes care of the database. RedBeanPHP is compatible with the best open source databases around; MySQL, SQLite and PostgreSQL.

RedBeanPHP is an open source ORM (object relational mapping) tool for PHP. It focuses on simplicity and ease of use. What makes RedBean unique is that it creates your database schema on-the-fly. It scans your data and adjusts the column types to fit your object properties. If your models are stabilized you can freeze the database. This way RedBean is easy to develop with but is also extremely fast on production servers.

RedBeanPHP - Easiest ORM layer for php

Outlet differs from other orm solutions for php in that it provides transparent, unobtrusive persistence. It does not require your entity objects to implement any interfaces or extend some sort of base class. It is also very lightweight, only a handful of classes and tools. It uses an approach similar to hibernate in java, using proxy objects that save the data behind the scenes. This library is not about database abstraction (although it does provide some abstraction). It is about using objects to model domain concepts.

Outlet differs from other orm solutions for php in that it provides transparent, unobtrusive persistence. It does not require your entity objects to implement any interfaces or extend some sort of base class. It is also very lightweight, only a handful of classes and tools.

Outlet - object-to-relational mapping for PHP

Fluent, XML-less, compile safe, automated, convention-based mappings for NHibernate. Fluent NHibernate offers an alternative to NHibernate's standard XML mapping files. Rather than writing XML documents, you write mappings in strongly typed C# code. This allows for easy refactoring, improved readability and more concise code. Why replace HBM.XML? While the separation of code and XML is nice, it can lead to several undesirable situations.<ul><li> Due to XML not being evaluated by the compiler, you can rename properties in your classes that aren't updated in your mappings; in this situation, you wouldn't find out about the breakage until the mappings are parsed at runtime.
</li><li> XML is verbose; NHibernate has gradually reduced the mandatory XML elements, but you still can't escape the verbosity of XML.
</li><li> Repetitive mappings - NHibernate HBM mappings can become quite verbose if you find yourself specifying the same rules over again. For example if you need to ensure all <code>string</code> properties mustn't be nullable and should have a length of 1000, and all <code>int</code>s must have a default value of -1.
</li></ul>
How does Fluent NHibernate counter these issues? It does so by moving your mappings into actual code, so they're compiled along with the rest of your application; rename refactorings will alter your mappings just like they should, and the compiler will fail on any typos. As for the repetition, Fluent NHibernate has a conventional configuration system, where you can specify patterns for overriding naming conventions and many other things; you set how things should be named once, then Fluent NHibernate does the rest.
 Its feature includes:

 <ul>
	 <li> Auto mappings - where mappings are inferred from the design of your entities</li>
	 <li> Persistence specification testing - round-trip testing for your entities, without ever having to write a line of CRUD</li>
	 <li> Full application configuration with our Fluent configuration API</li>
	 <li> Database configuration - fluently configure your database in code</li>
 </ul>

Fluent, XML-less, compile safe, automated, convention-based mappings for NHibernate. Fluent NHibernate offers an alternative to NHibernate's standard XML mapping files. Rather than writing XML documents, you write mappings in strongly typed C# code. This allows for easy refactoring, improved readability and more concise code. 

Fluent NHibernate - Fluent mapping for model

Business Logic Toolkit is a set of components to simplify .NET application development. BLToolkit is provided as source code that you can use "as is" or customize for your applications. It is written in C# and compatible with .NET Framework 3.5 and 4.0. Source code location: <A HREF="http://code.google.com/p/bl-toolkit/" target="_blank">http://code.google.com/p/bl-toolkit/</A>

Business Logic Toolkit is a set of components to simplify .NET application development. BLToolkit is provided as source code that you can use "as is" or customize for your applications. It is written in C# and compatible with .NET Framework 3.5 and 4.0.

BL-Toolkit - Business Logic Toolkit for .NET

The Castle ActiveRecord project is an implementation of the ActiveRecord pattern for .NET. The ActiveRecord pattern consists on instance properties representing a record in the database, instance methods acting on that specific record and static methods acting on all records. Castle ActiveRecord is built on top of NHibernate, but its attribute-based mapping free the developer of writing XML for database-to-object mapping, which is needed when using NHibernate directly. With Castle ActiveRecord you won't have to learn NHibernate mapping schema to have a working data access layer in minutes. For most cases you won't need to deal with ISession and ISessionFactory. Castle ActiveRecord was built on top of NHibernate. It offers: 
 <UL>
	<LI>Fast development (it handles the mapping and infers as much as it can so you don't have to dig into documentation or deal with tons of xml files every time something changes on your schema)</LI>
	<LI>Predefined common methods like Create, Update, Save, Delete</LI>
	<LI>Easy to implement method like Find, FindAll, FindByName. (Predefined if you use ActiveRecordBase)</LI>
	<LI>Session and transaction scopes that abstracts the ISession offering a more natural idiom</LI>
 </UL>

The Castle ActiveRecord project is an implementation of the ActiveRecord pattern for .NET. The ActiveRecord pattern consists on instance properties representing a record in the database, instance methods acting on that specific record and static methods acting on all records. Castle ActiveRecord is built on top of NHibernate, but its attribute-based mapping free the developer of writing XML for database-to-object mapping, which is needed when using NHibernate directly.

ActiveRecord - ActiveRecord pattern for .NET

Norm is a simple way to access a JDBC database, usually in one line of code. It purges your code of the complex mess that is Hibernate, JPA, and ORM. It is an extremely lightweight layer over JDBC. It gets rid of large amounts of boilerplate JDBC code. 

norm - Not Object-Relational Mapping

dORM is a PHP 5 ORM (object relational mapper) library that seamlessly loads, saves and deletes PHP objects from and to a relational database. dORM requires a small XML file that maps classes to their respective database tables. currently, only MySQL was tested. Its feature include

 <ul>
 <li>Simple of use</li>
 <li>Supports multiple data types</li>
 <li>Supports multiple relationships</li>
 <li>No code generation</li>
 <li>No class extending</li>
 <li>No naming convention</li>
 <li>No directory structure</li>
 <li>No modification of your classes</li>
 <li>No modification of your database</li>
</ul>

dORM is a PHP 5 ORM (object relational mapper) library that seamlessly loads, saves and deletes PHP objects from and to a relational database. dORM requires a small XML file that maps classes to their respective database tables. currently, only MySQL was tested.

dORM - Automate SQL. Focus on business logic

The main strength of Vici CoolStorage is the ease of use. Most ORM tools still require a lot of unneeded code to accomplish basic data persistence tasks, but Vici CoolStorage is designed to relieve the programmer from these tedious and error-prone tasks, making it very intuitive to use.
<ul>
	<li>Supports SQL Server 2000/2005, MySQL, SQLite, MS Access and VistaDB. Other custom providers can be added.</li>
	<li>Full support for MonoTouch (using SQLite)</li>
	<li>Session-less and context-free database access</li>
	<li>Any existing relational data model can be mapped to CoolStorage objects with minimal effort</li>
	<li>No code generator required. Mapping is done by creating simple classes.</li>
	<li>All relation types are supported: One-To-Many, Many-To-One and Many-To-Many</li>
	<li>Completely typed object model (no type casts required)</li>
	<li>Dirty tracking on the column level. Only changed fields are persisted to the database</li>
	<li>Full support for transactions, including ##TransactionScope##</li>
	<li>Nullable columns can be mapped to nullable fields or to a default value</li>
	<li>Delayed (lazy) loading of data to minimize database access. Configurable per field.</li>
	<li>Selective or automatic prefetching of all relation types for improved query performance</li>
	<li>Powerful and intuitive database-independent object query language</li>
	<li>Flexible event mechanism to intercept any event</li>
	<li>Identity (auto-increment) keys or sequences are supported for all database types</li>
	<li>Support for server and client generated Guid keys</li>
	<li>Objects can be mapped to different databases, even across object relations</li>
	<li>Paging of object collections (at server level)</li>
	<li>Extensive support for retrieving aggregate values on collections (count, sum, average, ...)</li>
	<li>Collections implement IBindingList so they can be used by controls (grids) as a data source</li>
	<li>Underlying database engine uses optimized and parameterized SQL queries. SQL injection is impossible</li>
	<li>Built specifically for .NET 2.0 and up, taking full advantage of generics and nullable types</li>
	<li>Raw SQL and/or stored procedures can be called on the underlying database without the need for a separate database connection</li>
	<li>Small footprint (less than 250 KB, including Vici Core)</li>
</ul>

The main strength of Vici CoolStorage is the ease of use. Most ORM tools still require a lot of unneeded code to accomplish basic data persistence tasks, but Vici CoolStorage is designed to relieve the programmer from these tedious and error-prone tasks, making it very intuitive to use.

Coolstorage - ORM library for .NET

Discover open source projects across all platforms

Projects