sqlalchemy.orgSQLAlchemy · PyPI - The Python Package Index

home features Feature Overview Testimonials blog library Reference Reference Documentation Architecture Citing SQLAlchemy Blog Posts Talks Tutorials Recipes community Get Support Participate Develop Code of Conduct Github download Current Release Series (1.3) Maintenance Release (1.2) Development Access License Version Numbering Release Status Current Releases 1.3.19 - 2020-08-17 - announce changes | migration notes | docs 1.2.19 - 2019-04-15 - announce changes | migration notes | docs 1.4 - next major series What's New in 1.4? | docs Sponsor SQLAlchemy! Donate to SQLAlchemy through PayPal Sponsor SQLAlchemy through the Tidelift Subscription Latest News SQLAlchemy 1.3.19 Released Mon, 17 Aug 2020 SQLAlchemy 1.3.18 Released Thu, 25 Jun 2020 SQLAlchemy 1.3.17 Released Wed, 13 May 2020 SQLAlchemy 1.3.16 Released Wed, 08 Apr 2020 SQLAlchemy 1.3.15 Released Wed, 11 Mar 2020 More news... Follow Tweets by @sqlalchemy The Python SQL Toolkit and Object Relational Mapper 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. SQLALCHEMY'S PHILOSOPHY SQL databases behave less like object collections the more size and performance start to matter; object collections behave less like tables and rows the more abstraction starts to matter. SQLAlchemy aims to accommodate both of these principles. SQLAlchemy considers the database to be a relational algebra engine, not just a collection of tables. Rows can be selected from not only tables but also joins and other select statements; any of these units can be composed into a larger structure. SQLAlchemy's expression language builds on this concept from its core. SQLAlchemy is most famous for its object-relational mapper (ORM), an optional component that provides the data mapper pattern , where classes can be mapped to the database in open ended, multiple ways - allowing the object model and database schema to develop in a cleanly decoupled way from the beginning. SQLAlchemy's overall approach to these problems is entirely different from that of most other SQL / ORM tools, rooted in a so-called complimentarity- oriented approach; instead of hiding away SQL and object relational details behind a wall of automation, all processes are fully exposed within a series of composable, transparent tools. The library takes on the job of automating redundant tasks while the developer remains in control of how the database is organized and how SQL is constructed. The main goal of SQLAlchemy is to change the way you think about databases and SQL! Read some key features of SQLAlchemy, as well as what people are saying about SQLAlchemy. Who Uses SQLAlchemy SQLAlchemy is used by organizations such as: Yelp! reddit DropBox The OpenStack Project Survey Monkey Learn More Library - master index of documentation, videos, talks, and more Overview of Key Features Testimonials Resources Download Blog Getting Support Participate Development SQLAlchemy Sponsors Website content copyright © by SQLAlchemy authors and contributors. SQLAlchemy and its documentation are licensed under the MIT license. SQLAlchemy is a trademark of Michael Bayer. mike(&)zzzcomputing.com All rights reserved. Website generation by zeekofile , with huge thanks to the Blogofile project....