Open Source Linux Object-Relational Mapping (ORM) Software

Hibernate is an Object/Relational Mapper tool. It's very popular among Java applications and implements the Java Persistence API. Hibernate ORM enables developers to more easily write applications whose data outlives the application process. As an Object/Relational Mapping (ORM) framework, Hibernate is concerned with data persistence as it applies to relational databases (via JDBC).

Prisma helps app developers build faster and make fewer errors with an open source ORM for PostgreSQL, MySQL and SQLite. Central to Prisma is the schema, a declarative way to define your app's data models and their relations that's human-readable. And you don't have to painstakingly create it from scratch if you already have a database - prisma introspect takes care of that. Prisma Client is a query builder that composes the way you think and gets auto-generated from the Prisma schema with types tailored to your app. We designed the API to be intuitive for both SQL veterans and people brand new to databases. Auto-completion, linting, formatting and more help Prisma developers in VSCode stay confident without distractions. Prisma Client puts extra emphasis on extensive type safety for more productive development in TypeScript. Prisma is a server-side library that helps your app read and write data to the database in an intuitive and safe way.

The CAM editor is the leading open source XML Editor/Validation/Schema toolset for rapidly building / deploying XML /JSON /Hibernate /SQL data /Forms applications. Visual WYSIWYG data design, rule entry wizards + drag & drop dictionary components. Will import, analyze / refactor from XML Schema / JSON. Oracle is a proud enterprise sponsor; with NIEM.gov support. Do SQL data import/map+ Open Data API delivery+ Hibernate JPA + UI Forms/Pencil Makes XSD schema (default, flatten, NIEM, & OASIS modes) + JAXB bindings; Mindmap FreeMind or UML models(XMI); XML unit test & live SQL data; HTML docs + spreadsheets (NIEM IEPDs). Canonical component dictionaries from schema sets, SQL, JSON, ERwin XSD, or spreadsheets. The XML CAM templates (OASIS standard) store the exchange structure, content model, code lists, DBMappings, SQL lookups+business rules (XPath). Java CAMV XML/JSON validation engine is a complete exchange test framework [XMLUnit, TEAM(Schematron)]. Java/Eclipse +Saxon/XSL

Hibernate ORM is a library providing Object/Relational Mapping (ORM) support to applications, libraries, and frameworks. It also provides an implementation of the JPA specification, which is the standard Java specification for ORM. The build requires a Java 8 JDK as JAVA_HOME. You will need Git to obtain the source. Hibernate makes use of Jenkins for its CI needs. The project is built continuous on each push to the upstream repository. The Hibernate build defines several database testing "profiles" in databases.gradle. These profiles can be activated by name using the db build property which can be passed either as a JVM system prop (-D) or as a Gradle project property (-P). You don't have to install all databases locally to be able to test against them in case you have docker available. The script docker_db.sh allows you to start a pre-configured database which can be used for testing.

Basic types, integers, floats, string, bool, time.Time, net.IP, net.IPNet. All struct fields are nullable by default and zero values (empty string, 0, zero time, empty map or slice, nil ptr) are marshalled as SQL NULL. pg:",notnull" is used to add SQL NOT NULL constraint and pg:",use_zero" to allow Go zero values. sql.NullBool, sql.NullString, sql.NullInt64, sql.NullFloat64 and pg.NullTime. Structs, maps and arrays are marshalled as JSON by default. PostgreSQL multidimensional Arrays using array tag and Array wrapper. Hstore using hstore tag and Hstore wrapper. go-pg supports 2 last Go versions and requires support for Go modules. So make sure to initialize a Go module. ORM supports has one, belongs to, has many, and many to many with composite/multi-column primary keys. ForEach that calls a function for each row returned by the query without loading all rows into the memory.

Sequelize is a promise-based Node.js ORM for Postgres, MySQL, MariaDB, SQLite and Microsoft SQL Server. It features solid transaction support, relations, eager and lazy loading, read replication and more. Sequelize follows SEMVER. Supports Node v6 and above to use ES6 features. Sequelize v5 was released on March 13, 2019. Official TypeScript typings are now included. Sequelize can be used since the beginning in order to automate the creation of every table in your database. Models are the essence of Sequelize. A model is an abstraction that represents a table in your database. In Sequelize, it is a class that extends Model. The model tells Sequelize several things about the entity it represents, such as the name of the table in the database and which columns it has (and their data types).

Realm is a fast, scalable alternative to SQLite with mobile to cloud data sync that makes building real-time, reactive mobile apps easy. Build data-rich apps without draining device resources with Realm's lazy loading and zero-copy architecture. The object-oriented data model lets developers work directly with native objects – no ORMs or DAOs are needed. Real-time mobile to cloud data sync makes it easy to build interactive features that keep data up-to-date across multiple devices, users, and the backend. Accelerate time-to-market with easy to learn, language-native APIs that simplify data access. Device Sync, backed by MongoDB Atlas, handles the most complex part of connecting your client to the backend with ease – guaranteeing an app that works as expected and syncs data reliably, every time. Build full mobile apps with ease.

DataNucleus provides Java data persistence to a range of datastores using JDO/JPA/REST APIs. *** Note that code development is no longer on SourceForge (code on SourceForge is for versions up to 3.3.5 only) ***

Ebean provides multiple levels of query abstraction ORM Queries, mixed with SQL, DTO Queries, SqlQuery and JDBC. Work at the highest level of abstraction and drop down levels as needed. Built in DB migration generation and running. Support for "rebase" migrations as well as repeatable, init and 'normal' migrations. Ebean produces SQL that you would hand craft yourself. Use great SQL, never generate SQL cartesian product, always honor relational limit/offset. For ORM queries Ebean can profile the object graph being used and either automatically tune the query. Docker test containers for all the supported databases. Get 100% test coverage on all the features of the database we use. We can build queries using type safe query beans. IDE auto-complete when writing queries, compile time checking and it's FUN. Optimize queries to only fetch what we need (partial objects). Automatically avoid N+1 via a smart load context.

It provides a uniform API for accessing stuff from different kinds of databases, protocols, and 3rd party APIs. That means you write the same code to get and store things like users, whether they live in Redis, mySQL, LDAP, MongoDB, or Postgres. Waterline strives to inherit the best parts of ORMs like ActiveRecord, Hibernate, and Mongoose, but with a fresh perspective and emphasis on modularity, testability, and consistency across adapters. Sails comes installed with a powerful ORM/ODM called Waterline, a datastore-agnostic tool that dramatically simplifies interaction with one or more databases. It provides an abstraction layer on top of the underlying database, allowing you to easily query and manipulate your data without writing vendor-specific integration code. Waterline query syntax floats above all that, focusing on business logic like creating new records, fetching/searching existing records, updating records, or destroying records.

LiteSQL is a codegenerator and C++ library that integrates C++ objects tightly to relational database and thus provides an object persistence layer. LiteSQL supports SQLite3, PostgreSQL, MySQL and oracle as backends.

Database mapping layer for MongoDB on Python. Includes schema enforcement and some facilities for schema migration.

SQLObject is an object-relational mapper for Python. It supports MySQL, PostgreSQL, SQLite, Firebird, MaxDB/SapDB, MS SQL and Sybase. It supports Python versions back to 2.7.

POJava is a simple, light-weight Java-based API for data processing and development. It includes an immutable DateTime object capable of parsing free-form dates in multiple languages and formats, and a variety of utilities for data transformation.

QsT SQL Tools - ORM system based on Qt 4.6.0 (and higher) to improve programming databases with Qt. QST has a little functionality to make simple SELECT, INSERT, UPDATE, DELETE and EXEC queries. It uses PostgreSQL but can be ported for other language

Criteria2JPQL API is an adaptation of the powerful Hibernate Criteria API to standard JPA API enabling the compatibility with any orm tool. Against the native SQL queries created by Hibernate Criteria, Criteria2JPQL outputs standard JPQL queries.

A lightweight framework to create and process metadata based, type-safe, debugable, readable, and maintainable queries for JPA 2.0. Example: CriteriaComposer(Student.class).select(AggregateFunction.SUM, Student_.unit).groupBy(Student_.name);

A library providing object-relational mapping services for programs written in C++. IOPC2 can be used in one of the following stand-alone configurations: An ORM library, a database access library and a library providing reflection capabilities.

QtPersistence is a project to create an ORM library for Qt Users. It’s loosely based on ideas from both the Active Record and Data Mapper Ruby ORM projects.

A simple base DAO framework for JPA, Hibernate, iBatis, etc. and testing helpers. Note: Releases are in Maven Central and Snapshots are in Sonatype OSS hosting, not in SourceForge files. Refer to: https://sourceforge.net/p/sidaof/news/2011/01/new-download-location/

This tool converts Common Infomation Model (CIM) into an ontological representation in OWL language.

Analogue is a flexible, easy-to-use ORM for PHP. It is a transposition of the Eloquent ORM that ships with Laravel framework using a Data Mapper pattern instead of the original Active Record approach. it overcomes some of Eloquent's architectural limitations by using a strict separation of concerns; for example, you can use Value Objects or Single-table-inheritance, which are hard/impossible to implement correctly using the native ORM. As a Laravel package, it integrates flawlessly inside the framework, and provides a more powerfull peristance layer, allowing to build enterprise-grade applications while retaining a simple and enjoyable development experience.

Self-validating, secure and smart models for Laravel's Eloquent ORM. Based on the Aware bundle for Laravel 3 by Colby Rabideau. Add laravelbook/ardent as a requirement to composer.json. You can also add the package using composer require laravelbook/ardent and later specifying the version you want (for now, dev-master is your best bet). The magic-dust-powered, wrist-friendly, one-stop solution to all your dreary input sanitization boilerplates! Puns aside, input validation functionality can quickly become tedious to write and maintain. Ardent deals away with these complexities by providing helpers for automating many repetitive tasks. Ardent is not just great for input validation, though, it will help you significantly reduce your Eloquent data model code. Ardent is particularly useful if you find yourself wearily writing very similar code time and again in multiple individual applications.

Using the new CQL3 driver by Datastax Artemis provides extremely easy to use "ORM" like functionality for Cassandra. It also contains hooks for integration into Jersey2 to enable rapid development of RESTful services, or even websites, if you enable JSP functionality for Jersey. If there is a demand, I could add a plugin to render views using things like Velocity, etc. See https://sourceforge.net/p/wicca/wiki/Home/ for more documentation