SQLAlchemy

  •        643

SQLAlchemy is the Python SQL toolkit and Object Relational Mapper that gives application developers the full power and flexibility of SQL. It provides a full suite of well known enterprise-level persistence patterns, designed for efficient and high-performing database access, adapted into a simple and Pythonic domain language.

http://www.sqlalchemy.org/

Tags
Implementation
License
Platform

   




Related Projects

gino - GINO Is Not ORM - a Python asyncio ORM on SQLAlchemy core.

  •    Python

GINO - GINO Is Not ORM - is a lightweight asynchronous ORM built on top of SQLAlchemy core for Python asyncio. Now (early 2018) GINO supports only one dialect asyncpg. There are a few tasks in GitHub issues marked as help wanted. Please feel free to take any of them and pull requests are greatly welcome.

Xml Data Mapper - a simple xml based ORM, database to object, POCO / DTO mapper

  •    ASPNET

The Cached Xml Data Mapper is a a simple xml based ORM. It converts DataReader, DataTable to custom DTOs / POCOs / objects and vice versa. Unlike ORMs which are difficult to choose from, complex to understand and that leaves a heavy memory footprint, this one is simple and...

rom - Redis object mapper for Python

  •    Python

Released under the LGPL license version 2.1 and version 3 (you can choose which you'd like to be bound under). Rom is a package whose purpose is to offer active-record style data modeling within Redis from Python, similar to the semantics of Django ORM, SQLAlchemy, Google's Appengine datastore, and others.

Typeorm - Amazing ORM for TypeScript and JavaScript (ES7, ES6, ES5)

  •    Typescript

TypeORM is an ORM that can run in NodeJS, Browser, Cordova, PhoneGap and Ionic platforms and can be used with TypeScript and JavaScript (ES5, ES6, ES7). Its goal to always support latest JavaScript features and provide features that help you to develop any kind of applications that use databases - from small applications with a few tables to large scale enterprise applications with multiple databases.

lifter - A generic query engine, inspired by Django ORM

  •    Python

Lifter is a generic query engine, inspired by Django ORM and SQLAlchemy. Its goal is to provide a unique interface to query any type of data, regardless of the underlying query language or data backend (SQL, REST, Python objects...).


her - Her is an ORM (Object Relational Mapper) that maps REST resources to Ruby objects

  •    Ruby

Her is an ORM (Object Relational Mapper) that maps REST resources to Ruby objects. It is designed to build applications that are powered by a RESTful API instead of a database. For a complete reference of all the methods you can use, check out the documentation.

OrmLite - A lightweight ORM for Java

  •    Java

Object Relational Mapping Lite (ORM Lite) provides some simple, lightweight functionality for persisting Java objects to SQL databases while avoiding the complexity and overhead of more standard ORM packages.

Lean Mapper - Tiny ORM based on powerful Dibi database abstraction library for PHP

  •    PHP

Lean Mapper is a tiny ORM based on powerful Dibi database abstraction library for PHP.

Doctrine ORM - Object relational mapper for PHP

  •    PHP

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.

js-data - Give your data the treatment it deserves with a framework-agnostic, datastore-agnostic JavaScript ORM built for ease of use and peace of mind

  •    Javascript

JSData v3 is now stable!. Some adapters still need to be updated to work with v3. Message @jmdobry on the JSData Slack channel if you want to help with tests, documentation, tutorials, adapters, etc.JSData is a framework-agnostic, datastore-agnostic ORM for Node.js and the Browser.

massive-js - A data mapper for Node.js and PostgreSQL.

  •    Javascript

Massive.js is a data mapper for Node.js that goes all in on PostgreSQL and fully embraces the power and flexibility of the SQL language and relational metaphors. Providing minimal abstractions for the interfaces and tools you already use, its goal is to do just enough to make working with your data as easy and intuitive as possible, then get out of your way. Massive is not an object-relational mapper (ORM)! It doesn't use models, it doesn't track state, and it doesn't limit you to a single entity-based metaphor for accessing and persisting data. Massive connects to your database and introspects its schemas to build an API for the data model you already have: your tables, views, functions, and easily-modified SQL scripts.

dORM - Automate SQL. Focus on business logic

  •    PHP

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.

Bookshelf - A simple Node.js ORM for PostgreSQL, MySQL and SQLite3 built on top of Knex.js

  •    Javascript

Bookshelf is a JavaScript ORM for Node.js, built on the Knex SQL query builder. Featuring both promise based and traditional callback interfaces, providing transaction support, eager/nested-eager relation loading, polymorphic associations, and support for one-to-one, one-to-many, and many-to-many relations. It is designed to work well with PostgreSQL, MySQL, and SQLite3.

vuex-orm - The Vuex plugin to enable Object-Relational Mapping access to the Vuex Store.

  •    Javascript

Vuex ORM is a plugin for Vuex to enable Object-Relational Mapping access to the Vuex Store. Vuex ORM lets you create "normalized" data schema within Vuex Store with relationships such as "Has One" and "Belongs To Many" like any other usual ORM library. It also provides fluent API to get, search and update Store state. Vuex ORM is heavily inspired by Redux recipe of "Normalizing State Shape" and "Updating Normalized Data". Learn more about the concept and motivation of Vuex ORM at What Is Vuex ORM?.

nplusone - Auto-detecting the n+1 queries problem in Python

  •    Python

nplusone is a library for detecting the n+1 queries problem in Python ORMs, including SQLAlchemy, Peewee, and the Django ORM. Many object-relational mapping (ORM) libraries default to lazy loading for relationships. This pattern can be efficient when related rows are rarely accessed, but quickly becomes inefficient as relationships are accessed more frequently. In these cases, loading related rows eagerly using a JOIN can be vastly more performant. Unfortunately, understanding when to use lazy versus eager loading can be challenging: you might not notice the problem until your app has slowed to a crawl.

SimpleFlatMapper - Fast and Easy mapping from database and CSV to POJO

  •    Java

Fast and Easy mapping from database and CSV to POJO. It is a java micro ORM, lightweight alternative to iBatis and Hibernate. It supports Fast Csv Parser and Csv Mapper.

awesome-sqlalchemy - A curated list of awesome tools for SQLAlchemy

  •    Python

Licensed under a Creative Commons Attribution-ShareAlike 4.0 International License. Versioning and auditing extension for SQLAlchemy.

Apache Gora - Provides persistence to column stores, key value stores, document stores and RDBMS

  •    Java

The Apache Gora open source framework provides an in-memory data model and persistence for big data. Gora supports persisting to column stores, key value stores, document stores and RDBMSs, and analyzing the data with extensive Apache Hadoop MapReduce support.

QtPersistence

  •    C++

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.

jOOQ - Java Object Oriented Querying

  •    Java

jOOQ stands for Java Object Oriented Querying, it effectively combines complex SQL, typesafety, source code generation, active records, stored procedures, advanced data types, and Java in a fluent, intuitive DSL. It is NOT an OR-mapper, but provides a 1:1 mapping between tables/views and classes. Between columns and members. It supports all standard SQL language features including the more complex UNION's, nested SELECTs, joins, aliasing.