Open Source Object-Relational Mapping (ORM) Software

Object-Relational Mapping (ORM) Software

View 4745 business solutions

Browse free open source Object-Relational Mapping (ORM) software and projects below. Use the toggles on the left to filter open source Object-Relational Mapping (ORM) software by OS, license, language, programming language, and project status.

  • High-performance Open Source API Gateway Icon
    High-performance Open Source API Gateway

    KrakenD is a stateless, distributed, high-performance API Gateway that helps you effortlessly adopt microservices

    KrakenD is a high-performance API Gateway optimized for resource efficiency, capable of managing 70,000 requests per second on a single instance. The stateless architecture allows for straightforward, linear scalability, eliminating the need for complex coordination or database maintenance.
  • Translate docs, audio, and videos in real time with Google AI Icon
    Translate docs, audio, and videos in real time with Google AI

    Make your content and apps multilingual with fast, dynamic machine translation available in thousands of language pairs.

    Google Cloud’s AI-powered APIs help you translate documents, websites, apps, audio files, videos, and more at scale with best-in-class quality and enterprise-grade control and security.
  • 1
    Hibernate

    Hibernate

    An object relational-mapping (ORM) library for Java

    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).
    Leader badge
    Downloads: 870 This Week
    Last Update:
    See Project
  • 2
    HIBERNATE

    HIBERNATE

    Hibernate's core object/relational mapping functionality

    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.
    Downloads: 17 This Week
    Last Update:
    See Project
  • 3
    XML Editor/Validator/Designer with CAMV

    XML Editor/Validator/Designer with CAMV

    CAM XML Editor for XML+JSON+Hibernate+SQL Open-XDX sponsored by Oracle

    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
    Leader badge
    Downloads: 93 This Week
    Last Update:
    See Project
  • 4
    Prisma

    Prisma

    Next-generation ORM for Node.js and TypeScript

    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.
    Downloads: 3 This Week
    Last Update:
    See Project
  • Create state-of-the-art conversational agents with Google AI Icon
    Create state-of-the-art conversational agents with Google AI

    Using Dialogflow, you can provide new and engaging ways for users to interact with your product.

    Dialogflow can analyze multiple types of input from your customers, including text or audio inputs (like from a phone or voice recording). It can also respond to your customers in a couple of ways, either through text or with synthetic speech. Dialogflow CX and ES provide virtual agent services for chatbots and contact centers. If you have a contact center that employs human agents, you can use Agent Assist to help your human agents. Agent Assist provides real-time suggestions for human agents while they are in conversations with end-user customers.
  • 5
    Prisma 1

    Prisma 1

    Database Tools incl. ORM, migrations and admin UI

    Prisma is the perfect tool for building GraphQL servers. The Prisma client is compatible with the Apollo ecosystem, has default support for GraphQL subscriptions and Relay-style pagination, provides end-to-end type safety and comes with a built-in dataloader to solve the N+1 problem. Prisma replaces traditional ORMs and simplifies database workflows. Access, Type-safe database access with the auto-generated Prisma client (in JavaScript, TypeScript, Go). Migrate, declarative data modeling and migrations (optional). Manage, visual data management with Prisma Admin. It is used to build GraphQL, REST, gRPC APIs and a lot more. Prisma currently supports MySQL, PostgreSQL, MongoDB. Prisma is a great fit for building REST& gRPC APIs where it can be used in place of traditional ORMs. It provides many benefits such as type safety, a modern API and flexible ways for reading and writing relational data.
    Downloads: 1 This Week
    Last Update:
    See Project
  • 6
    xUtils3

    xUtils3

    Android orm, bitmap, http, view inject

    xUtils includes orm, http(s), image, view annotations, but it is still very lightweight (251K), and has powerful features and is easy to expand. Efficient and stable orm tool, which makes it more convenient to support cookies and caching when the http interface is implemented. Based on UrlConnection, the bottom layer will be implemented by okHttp after Android4.4. The request protocol supports 11 predicates: GET, POST, PUT, PATCH, HEAD, MOVE, COPY, DELETE, OPTIONS, TRACE, CONNECT. Supports uploading of very large files (over 2G). Support breakpoint download (if the server supports the Range parameter, the client automatically handles the breakpoint download). Support cookies (implements domain, path, expiry and other features). Support caching (implement Cache-Control, Last-Modified, ETag and other features, use expiration time + LRU dual mechanism to clean up when the cache content is too much).
    Downloads: 1 This Week
    Last Update:
    See Project
  • 7
    DataNucleus

    DataNucleus

    Java persistence using JDO, JPA or REST

    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) ***
    Downloads: 8 This Week
    Last Update:
    See Project
  • 8
    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.
    Downloads: 8 This Week
    Last Update:
    See Project
  • 9

    SQLObject

    SQLObject is a Python ORM.

    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.
    Downloads: 1 This Week
    Last Update:
    See Project
  • Real Time Accounts Payable Automation. Icon
    Real Time Accounts Payable Automation.

    Invoice capture and automation seamlessly integrated with your accounting software

    Yooz provides the smartest, most powerful, and easiest-to-use cloud-based E-invoicing and Purchase-to-Pay automation solution. It delivers unmatched savings, speed, and security with affordable zero-risk subscriptions to more than 5,000 customers and 300,000 users worldwide.
  • 10
    A java assignment submission system which lets students to turn in their assignments and perform compilation and unit testing. Faculty members can evaluate submissions and grade.
    Downloads: 4 This Week
    Last Update:
    See Project
  • 11
    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
    Downloads: 3 This Week
    Last Update:
    See Project
  • 12
    lunaOrm - your free Orm for .net project

    lunaOrm - your free Orm for .net project

    lunaOrm - Datalayer Code Generator for Vb.Net and C#

    lunaORM is an ORM open source and freely downloadable automatic code generator to facilitate and standardize the writing of classes that read/edit/save data to database.
    Downloads: 1 This Week
    Last Update:
    See Project
  • 13
    The purpose of this is to facilitate the creation of web applications with php, which allows the separate layout of the rules of business, so the developer would not have to worry about the layout being left to the designer.
    Downloads: 1 This Week
    Last Update:
    See Project
  • 14
    Java ORM Plugin for Eclipse

    Java ORM Plugin for Eclipse

    User can create a java ORM framework in one click.

    Java ORM Plugin for eclipse helps the user to create a Mybatis and Hibernate ORM framework in one click. 1) Mybatis ORM Framework 2) Hibernate ORM Framework URL : http://oneclicklabs.io
    Leader badge
    Downloads: 1 This Week
    Last Update:
    See Project
  • 15
    Kode Monkey is a multi-application/multi-database MVC framework in PHP. It is intended to be used as a Many Sites One Framework platform. Built for Speed of Development/Speed of Use, Kode Monkey is sleek, small, and built to withstand enormous traffic.
    Downloads: 1 This Week
    Last Update:
    See Project
  • 16
    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.
    Downloads: 1 This Week
    Last Update:
    See Project
  • 17
    PhantomDb ORM

    PhantomDb ORM

    PhantomDB ORM es una librería para mapear objetos a bases de datos

    PhantomDB ORM (PDB) es un Micro ORM para Microsoft .NET Framework 3.5. Soporta cualquier tipo de base de datos. PDB está diseñada para trabajar en entornos ágiles, con muchos cambios en la base de datos.
    Downloads: 1 This Week
    Last Update:
    See Project
  • 18
    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.
    Downloads: 1 This Week
    Last Update:
    See Project
  • 19

    Android ORM Framework

    ORM Framework for Android to store data using an SQLite Database.

    Within this project, an orm framework for android is developed to store data by using an SQLite Database.
    Downloads: 0 This Week
    Last Update:
    See Project
  • 20
    Ardent

    Ardent

    Self-validating, secure and smart models for Laravel's Eloquent ORM

    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.
    Downloads: 0 This Week
    Last Update:
    See Project
  • 21

    Artemis

    Cassandra "ORM" with hooks for Jersey integration if desired

    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
    Downloads: 0 This Week
    Last Update:
    See Project
  • 22
    AutoDAO is a Generic DAO on steroids implementation for Java with Hibernate support, annotation-driven configuration, tight Spring Framework integration and zero persistence code required for most common query types.
    Downloads: 0 This Week
    Last Update:
    See Project
  • 23
    AutoMapper

    AutoMapper

    A convention-based object-object mapper in .NET

    A convention-based object-object mapper. 100% organic and gluten-free. Takes out all of the fuss of mapping one object to another. AutoMapper is a simple little library built to solve a deceptively complex problem, getting rid of code that mapped one object to another. This type of code is rather dreary and boring to write, so why not invent a tool to do it for us? First, install NuGet. Then, install AutoMapper from the package manager console. AutoMapper is an object-object mapper. Object-object mapping works by transforming an input object of one type into an output object of a different type. What makes AutoMapper interesting is that it provides some interesting conventions to take the dirty work out of figuring out how to map type A to type B. As long as type B follows AutoMapper’s established convention, almost zero configuration is needed to map two types.
    Downloads: 0 This Week
    Last Update:
    See Project
  • 24
    Simple ORM intended to simplify mundane data access tasks for .Net developers.
    Downloads: 0 This Week
    Last Update:
    See Project
  • 25
    Automated Business Logic

    Automated Business Logic

    Transaction logic engine for JPA/Hibernate

    ABL is a transaction logic engine: it allows you to declare complex, multi-table transaction logic for your persistent objects, using simple declarative annotations. ABL operates as a HIbernate/JPA event listener to eliminate recoding and automate integrity.
    Downloads: 0 This Week
    Last Update:
    See Project
  • Previous
  • You're on page 1
  • 2
  • 3
  • 4
  • 5
  • Next

Guide to Open Source Object-Relational Mapping (ORM) Software

Open source object-relational mapping (ORM) software acts as an intermediary between data stored in database management systems and the applications that use them. This software provides a way to efficiently map objects in programming languages to database structures, while preserving their properties. It also provides programmers with an interface for interacting with databases without needing any knowledge of database query language syntax. ORM software is typically written in a scripting language such as Python, PHP, or Java and enables database access using Active Record, Data Mapper, and Unit of Work design patterns.

One advantage of using open source ORM software is that it can greatly reduce the amount of time spent writing code for complex queries. Additionally, developers no longer need to manually write SQL queries when interacting with databases; instead they can use higher-level abstractions provided by the ORM APIs to define data modeling requirements and reduce the size of the codebase required for application development or maintenance tasks. Using an ORM usually increases productivity and helps enforce uniform coding standards across development teams because most ORMs are designed around common web application frameworks such as Rails or Django. Furthermore, since the code powering ORMs is often open sourced it allows developers to easily collaborate on projects together or create new libraries that extend existing functionality beyond what’s available out-of-the box.

Overall, open source object-relational mapping (ORM) software provides many benefits like increased speed in coding complex queries, easier collaboration among different development teams working on the same project, and simplified access to databases for developers who may not have expertise in SQL query language syntaxes.

Open Source Object-Relational Mapping (ORM) Software Features

  • Automated Database Schemas: ORM software automates the process of creating database schemas by mapping object-oriented classes to relational database tables. This makes it easier for developers to quickly create databases without having to manually define all database information and fields in the SQL language.
  • Query Building: ORM software allows developers to quickly build queries using an object-oriented programming (OOP) syntax, reducing the need for manual SQL coding. This makes it easy for developers to query or update database records with minimal effort and time.
  • Model Relationships: ORM software can easily model complex relationships between entities in an object-oriented environment, such as one-to-one, one-to-many, or many-to-many relationships. This helps keep data organized and reduces the amount of manual code that needs to be written when working with relational databases.
  • Data Validation: ORM software provides built-in data validation features which allow users to validate user input before submitting any queries or updates so that only valid and consistent data is saved into the database. This ensures accuracy of information stored in the database and prevents redundant or invalid entries from being made accidentally by users.
  • Caching Mechanisms: ORM software often includes caching mechanisms which help minimize the number of times a program needs to connect to the underlying database while still allowing applications access to frequently used data quickly, resulting in improved performance overall.

What Are the Different Types of Open Source Object-Relational Mapping (ORM) Software?

  • Hibernate: Hibernate is an open source Java-based ORM which enables developers to map plain old Java objects (POJO) to relational tables. It is popular for its ability to access multiple relational databases with a single set of code.
  • Kodo: Kodo is an open source Java-based ORM which provides object persistence and query technology for enterprise applications. It is designed to allow developers to store, retrieve, manipulate and manage data in a database system.
  • iBATIS/MyBatis: iBATIS (now known as MyBatis) is an open source framework that maps accessed objects into SQL queries, enabling developers to quickly and easily create database-independent applications. MyBatis has been widely adopted due to its powerful mapping capabilities, support of advanced features such as type handlers, dynamic SQL and pagination, and easy integration into other frameworks such as Spring Framework or Grails.
  • JDBC: JDBC (Java Database Connectivity) is the industry standard for connecting applications written in the Java language with data sources such as relational databases and spreadsheets. JDBC provides Object Relational Mapping technologies that enable developers to store data from any application without having any knowledge about the underlying database structure or SQL syntax used by the data source itself.
  • JPA/EclipseLink: The Java Persistence API (JPA) provides a common way for persistent entities i.e., classes that are connected with specific instances of a particular type of data stored in a database using annotations or metadata from class fields throughout the application’s codebase while EclipseLink adds additional features above those provided by JPA including caching provider services, extended object-oriented query feature support, change tracking algorithms within session beans, versioning strategies and much more.

Benefits of Open Source Object-Relational Mapping (ORM) Software

  1. Increased Productivity: ORM tools provide developers with the ability to quickly and easily bridge the gap between their code and a relational database, allowing them to speed up the development process.
  2. Reduced Maintenance Costs: By abstracting away many of the complexities associated with relational databases, ORM software significantly reduces the amount of time needed for maintenance tasks. This leads to lower long-term costs and fewer headaches for developers.
  3. Safer Code: ORM software offers a better way of keeping your code safe from SQL injection attacks. By creating queries programmatically and relying on parameterized stored procedures, it’s much easier to prevent malicious code from being injected into your application’s database.
  4. Improved Performance: Many ORMs offer features such as object caching and query optimization that can drastically improve application performance without requiring any manual tweaking from developers.
  5. Easier Customization: Because most ORMs are written in an open source environment, they can be easily customized and adjusted according to specific needs without having to rewrite large amounts of code. This makes it simpler for developers to add new features or apply customizations as required.

Who Uses Open Source Object-Relational Mapping (ORM) Software?

  • Web Developers: Those who develop websites and web applications can use ORM software to quickly create databases and maintain relationships between objects.
  • Mobile Application Developers: Mobile application developers often need to store, access, and update data. They can use ORM software to organize the process, making it easier for them to develop their applications quickly.
  • Small Businesses: ORMs are cost-effective solutions for small businesses that need database management but don’t have enough resources for buying proprietary database solutions.
  • Data Scientists: Data scientists often need sophisticated database management features such as complex queries, data integration from multiple sources and dynamic object mapping capabilities, all of which can be easily achieved with an ORM tool.
  • Database Administrators (DBAs): An ORM offers an easy way for database administrators to write code and query results using simple classes instead of tables. This makes it easier for them to manage large databases without having to manually write SQL scripts on an ad hoc basis.
  • Software Engineers: Software engineers who specialize in creating distributed systems like microservices can benefit from the scalability offered by many popular ORMs such as Entity Framework or Hibernate OGM.

How Much Does Open Source Object-Relational Mapping (ORM) Software Cost?

Open source object-relational mapping (ORM) software typically does not cost anything, as it is open source. This means that the creators have chosen to make the software available to everyone without charging a fee. The ORM software can be downloaded and used for free by anyone who wishes to do so.

By using open source ORM software, developers gain access to powerful tools which they may use to efficiently and effectively design their databases. These tools include features such as automated database generation, auto-mapping of objects and relations between them, API integration with other languages or databases, many-to-many relationships for complex data sets, and more. All of these features help developers create better databases in less time than traditional methods.

The openness of this type of software also allows developers from all around the world to collaborate on projects with different technologies which support interoperability among them. This helps ensure that any changes made are shared across multiple platforms without extra costs or delays associated with proprietary solutions. Additionally, members of online developer communities often provide feedback on how to improve ORMs in order to benefit everyone involved in these collaboration efforts.

For those looking for enterprise level options at a cost but still benefit from the benefits associated with open source ORM solutions there are various commercial vendors that offer both free and paid packages with enhanced features compared to freely available ones including improved scalability, increased security measures, advanced automation abilities etc.

What Does Open Source Object-Relational Mapping (ORM) Software Integrate With?

Open source object-relational mapping (ORM) software is used to map objects from a programming language to relational database systems. This type of software can integrate with many other types of software, including web frameworks and query languages. ORM can be integrated with web frameworks such as Java Server Pages (JSP), Ruby on Rails or Django by providing the developer with the ability to access data in a relational database through their code. It also supports integration with query languages such as SQL, allowing developers to use existing queries for their applications. Finally, it provides an interface for popular development tools like Eclipse, Visual Studio and IntelliJ which makes it easier to work with databases within these tools. By providing an easily accessible interface between various programming elements and databases, ORM allows developers to create powerful data-driven applications while minimizing the effort required on their part.

Recent Trends Related to Open Source Object-Relational Mapping (ORM) Software

  1. Increased Adoption: More and more businesses are turning to open source ORM software to manage their databases because of its cost-effectiveness, scalability, and reliability.
  2. Improved Security: Open source ORM software is designed with robust security protocols to protect data from attackers.
  3. Support for Popular Databases: Open source ORM software supports popular database systems such as SQL Server, Oracle, PostgreSQL, MongoDB, and Hadoop.
  4. Increased Flexibility: Open source ORM software is highly customizable, allowing developers to tailor their applications to fit their specific needs.
  5. Reduced Time-to-Market: Open source ORM software reduces the time it takes to develop applications by removing many of the tedious tasks associated with database management.
  6. Faster Development Cycles: With open source ORM software, development cycles are faster due to the ability to quickly modify code and make changes on the fly.
  7. Automated Testing: Many open source ORM tools include automated testing capabilities, which reduces the amount of manual testing needed for applications.
  8. Greater Compatibility Across Platforms: Open source ORM software is designed to be platform-agnostic and can be used on multiple operating systems such as Windows, macOS, Linux, and Android.

Getting Started With Open Source Object-Relational Mapping (ORM) Software

Using open source object-relational mapping (ORM) software is a great way to save time and increase productivity when developing a web application or managing databases. The following steps will help users get started with using ORM software explain how users can get started with using open source object-relational mapping (ORM) software. Write in American English. Make your response long.

Getting started with open source object-relational mapping (ORM) software is easy and can be done in just a few simple steps.

The first step is to decide on which ORM framework you would like to use. Popular open source ORM frameworks include Entity Framework, NHibernate, and LinqToSQL. Each of these frameworks has its own set of pros and cons so it’s important to consider your application’s specific requirements when selecting an ORM framework. Once you’ve chosen a framework, you can download the necessary libraries from their website or through your preferred package manager.

The next step is to create or import your database schema into the ORM framework of your choice. This can be done by manually creating entities for each table in the database or by importing them from existing SQL scripts using an appropriate tool provided by the chosen ORM framework. Another option could be to use a visual designer where tables are represented as diagrams allowing users to drag and drop fields, indexes etc., making it easier to create complex schemas without having too much knowledge about databases.