Python的SQL工具包和對象關(guān)系映射器

??? SQLAlchemy的是Python的SQL工具包和對象關(guān)系映射器，讓應(yīng)用程序開發(fā)人員可以使用上SQL的強(qiáng)大功能和靈活性。

??? 它提供了一套完整的企業(yè)級持久化模式，專為高效率和高性能的數(shù)據(jù)庫訪問而設(shè)計(jì)，簡單易用用，專門為Python語言而準(zhǔn)備。

SQLAlchemy的理念

??? SQL數(shù)據(jù)庫與對象集合目標(biāo)不同，它需要關(guān)注更大的數(shù)據(jù)容量與更高的性能;而對象集合則和數(shù)據(jù)表或數(shù)據(jù)行的目標(biāo)不同，它需要更好的數(shù)據(jù)抽象。 SQLAlchemy設(shè)計(jì)的目的，就是適配這兩個(gè)原則。

??? SQLAlchemy把數(shù)據(jù)庫當(dāng)作是一個(gè)關(guān)系型代數(shù)引擎，不只是數(shù)據(jù)表的一個(gè)集合。數(shù)據(jù)行不僅可以從數(shù)據(jù)表中查詢出來，也可以從數(shù)據(jù)表關(guān)聯(lián)后成形成的邏輯數(shù)據(jù)表和其他的查詢語句結(jié)果中進(jìn)行查詢;這些元素可以組合形成更大的數(shù)據(jù)結(jié)構(gòu)。 SQLAlchemy的表達(dá)式語言就是建立在這個(gè)核心概念之上的。

??? SQLAlchemy組件中最有名的是它的對象關(guān)系映射器（ORM），是一個(gè)提供數(shù)據(jù)映射器模式的可選組件，利用這個(gè)組件，類可以以開放式的多種方式映射到數(shù)據(jù)庫上，允許對象模型的設(shè)計(jì)和數(shù)據(jù)庫架構(gòu)的設(shè)計(jì)，一開始就以分離方式進(jìn)行各自的開發(fā)。

??? SQLAlchemy的目標(biāo)，就是改變你對數(shù)據(jù)庫和SQL的觀念！

??? 了解一些SQLAlchemy的 主要特點(diǎn) ，以及人們對 SQLAlchemy的一些探討 。

??? 誰在使用SQLAlchemy？

??? 以下公司正在使用SQLAlchemy：

• Yelp!
• The OpenStack Project
• reddit
• Mozilla
• Survey Monkey
• lolapps
• Freshbooks
• Fedora Project

???? 更多

???? 了解更多內(nèi)容

• 主要功能介紹
• 正在使用SQLAlchemy的公司
• 獲得的榮譽(yù)
• 相關(guān)文檔
• 使用指南

????? 相關(guān)資源

• 相關(guān)下載
• 相關(guān)博客
• 官方支持
• 參與
• 開發(fā)

http://www.uifanr.com/

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:

• Yelp!
• The OpenStack Project
• reddit
• Mozilla
• Survey Monkey
• lolapps
• Freshbooks
• Fedora Project

more...

Learn More

• Overview of Key Features
• Organizations Using SQLAlchemy
• Testimonials
• Documentation
• Recipes

Resources

• Download
• Blog
• Getting Support
• Participate
• Development

1.SQLAlchemy文檔-簡介（中文版）