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 is free and open source software.
- Industrial strength ORM, built from the core on the identity map, unit of work, and data mapper patterns. These patterns allow transparent persistence of objects using a declarative configuration system. Domain models can be constructed and manipulated naturally, and changes are synchronized with the current transaction automatically.
- Two distinct components, known as the Core and the ORM. The Core is itself a fully featured SQL abstraction toolkit, providing a smooth layer of abstraction over a wide variety of DBAPI implementations and behaviors, as well as a SQL Expression Language which allows expression of the SQL language via generative Python expressions. A schema representation system that can both emit DDL statements as well as introspect existing schemas, and a type system that allows any mapping of Python types to database types, rounds out the system. The Object Relational Mapper is then an optional package which builds upon the Core.
- Mature, high performing architecture.
- DBA Approved
- The Unit Of Work system, a central part of SQLAlchemy’s Object Relational Mapper (ORM), organizes pending insert/update/delete operations into queues and flushes them all in one batch.
- Function-based query construction allows SQL clauses to be built via Python functions and expressions.
- Modular and extensible.
- Separate mapping and class design.
- Eager-loading and caching of related objects and collections.
- Composite (multiple-column) primary keys.
- Self-referential Object Mappings.
- Inheritance Mapping.
- Raw SQL statement mapping.
- Pre- and post-processing of data.
- Includes dialects for SQLite, Postgresql, MySQL, Oracle, MS-SQL, Firebird, Sybase and others, most of which support multiple DBAPIs.
|The largest compilation of the best free and open source software in the universe. Each article is supplied with a legendary ratings chart helping you to make informed decisions.
|Hundreds of in-depth reviews offering our unbiased and expert opinion on software. We offer helpful and impartial information.
|Replace proprietary software with open source alternatives: Google, Microsoft, Apple, Adobe, IBM, Autodesk, Oracle, Atlassian, Corel, Cisco, Intuit, and SAS.
|Awesome Free Linux Games Tools showcases a series of tools that making gaming on Linux a more pleasurable experience. This is a new series.
|Machine Learning explores practical applications of machine learning and deep learning from a Linux perspective. We've written reviews of more than 40 self-hosted apps. All are free and open source.
|New to Linux? Read our Linux for Starters series. We start right at the basics and teach you everything you need to know to get started with Linux.
|Alternatives to popular CLI tools showcases essential tools that are modern replacements for core Linux utilities.
|Essential Linux system tools focuses on small, indispensable utilities, useful for system administrators as well as regular users.
|Linux utilities to maximise your productivity. Small, indispensable tools, useful for anyone running a Linux machine.
|Surveys popular streaming services from a Linux perspective: Amazon Music Unlimited, Myuzi, Spotify, Deezer, Tidal.
|Saving Money with Linux looks at how you can reduce your energy bills running Linux.
|Home computers became commonplace in the 1980s. Emulate home computers including the Commodore 64, Amiga, Atari ST, ZX81, Amstrad CPC, and ZX Spectrum.
|Now and Then examines how promising open source software fared over the years. It can be a bumpy ride.
|Linux at Home looks at a range of home activities where Linux can play its part, making the most of our time at home, keeping active and engaged.
|Linux Candy reveals the lighter side of Linux. Have some fun and escape from the daily drudgery.
|Getting Started with Docker helps you master Docker, a set of platform as a service products that delivers software in packages called containers.
|Best Free Android Apps. We showcase free Android apps that are definitely worth downloading. There's a strict eligibility criteria for inclusion in this series.
|These best free books accelerate your learning of every programming language. Learn a new language today!
|These free tutorials offer the perfect tonic to our free programming books series.
|Linux Around The World showcases usergroups that are relevant to Linux enthusiasts. Great ways to meet up with fellow enthusiasts.
|Stars and Stripes is an occasional series looking at the impact of Linux in the USA.