1.SQLAlchemy文档-简介(中文版)
Python的SQL工具包和对象关系映射器
SQLAlchemy的是Python的SQL工具包和对象关系映射器,让应用程序开发人员可以使用上SQL的强大功能和灵活性。
它提供了一套完整的企业级持久化模式,专为高效率和高性能的数据库访问而设计,简单易用用,专门为Python语言而准备。
SQLAlchemy的理念
SQL数据库与对象集合目标不同,它需要关注更大的数据容量与更高的性能;而对象集合则和数据表或数据行的目标不同,它需要更好的数据抽象。 SQLAlchemy设计的目的,就是适配这两个原则。
SQLAlchemy把数据库当作是一个关系型代数引擎,不只是数据表的一个集合。数据行不仅可以从数据表中查询出来,也可以从数据表关联后成形成的逻辑数据表和其他的查询语句结果中进行查询;这些元素可以组合形成更大的数据结构。 SQLAlchemy的表达式语言就是建立在这个核心概念之上的。
SQLAlchemy组件中最有名的是它的对象关系映射器(ORM),是一个提供数据映射器模式的可选组件,利用这个组件,类可以以开放式的多种方式映射到数据库上,允许对象模型的设计和数据库架构的设计,一开始就以分离方式进行各自的开发。
SQLAlchemy的目标,就是改变你对数据库和SQL的观念!
了解一些SQLAlchemy的主要特点,以及人们对SQLAlchemy的一些探讨。
谁在使用SQLAlchemy?
以下公司正在使用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.
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:
more... - Learn More
- Resources