SQLAlchemy开发学习资源集合：Awesome SQLAlchemy
jopen
10年前
SQLAlchemy 开发学习资源集合。类似的还有 awesome-python。 (其它 awesome lists!)
SQLAlchemy是一个Python的SQL工具包以及数据库对象映射框架。SQLAlchemy在Python Web框架中得到了广泛应用，使用 ORM 等独立SQLAlchemy 的一个优势就是它允许开发人员首先考虑数据模型，并能决定稍后可视化数据的方式（采用命令行工具、Web框架还是GUI框架）。
Table of Contents
Data Structures
- SQLAlchemy-Continuum
-
Versioning and auditing extension for SQLAlchemy.
- Creates versions for inserts, deletes and updates.
- Does not store updates which don't change anything.
- Supports alembic migrations.
- Can revert objects data as well as all object relations at given transaction even if the object was deleted.
- Transactions can be queried afterwards using SQLAlchemy query syntax.
- Query for changed records at given transaction.
- Temporal relationship reflection. Version object's relationship show the parent objects relationships as they where in that point in time.
- Supports native versioning for PostgreSQL database (trigger based versioning).
- sqlalchemy_mptt
- Library for implementing MPTT (modified preorder tree traversal) with SQLAlchemy models and working with trees of model instances, like django-mptt.
- SQLAlchemy-ORM-tree
- An implementation for SQLAlchemy-based applications of the nested-sets/modified-pre-order-tree-traversal technique for storing hierarchical data in a relational database.
- vdm
- Versioned domain model. Python library for revisioning/versioning of databases.
Data Types
- SQLAlchemy-Utils
- Various utility functions, new data types and helpers for SQLAlchemy.
Database Migration Tools
- Alembic
- Alembic is a lightweight database migration tool for usage with the SQLAlchemy Database Toolkit for Python.
- sqlalchemy-migrate
- Inspired by Ruby on Rails' migrations, SQLAlchemy Migrate provides a way to deal with database schema changes in SQLAlchemy projects.
Dialects
http://docs.sqlalchemy.org/en/latest/dialects/
- redshift_sqlalchemy
- Amazon Redshift dialect for SQLAlchemy.
- sphinxalchemy
- SQLAlchemy dialect for iterfacing with Sphinx search engine via SphinxQL.
Documentation
- http://docs.sqlalchemy.org/en/latest/
- http://docs.sqlalchemy.org/en/latest/intro.html
- http://docs.sqlalchemy.org/en/latest/core/tutorial.html
- http://docs.sqlalchemy.org/en/latest/orm/tutorial.html
- http://docs.sqlalchemy.org/en/latest/glossary.html
File and Image Attachments
- SQLAlchemy-ImageAttach
- SQLAlchemy-ImageAttach is a SQLAlchemy extension for attaching images to entity objects.
Forms and Data Validations
- ColanderAlchemy
-
ColanderAlchemy helps you to auto-generate Colander schemas that are based on SQLAlchemy mapped classes.
Such Colander schemas can be used with libraries like Deform and helps remove the need for duplication of schema definitions.
- FormAlchemy
- FormAlchemy eliminates boilerplate by autogenerating HTML input fields from a given model. FormAlchemy will try to figure out what kind of HTML code should be returned by introspecting the model's properties and generate ready-to-use HTML code that will fit the developer's application.
- WTForms-Alchemy
- WTForms-Alchemy is a WTForms extension toolkit for easier creation of model based forms. Strongly influenced by Django ModelForm.
Full-text Searching
- SQLAlchemy-Searchable
- Full-text searchable models for SQLAlchemy. Only supports PostgreSQL.
GIS and Spatial Databases
- GeoAlchemy
-
GeoAlchemy provides extensions to SQLAlchemy to work with spatial databases.
The current supported spatial database systems are PostGIS, Spatialite, MySQL, Oracle, and MS SQL Server 2008.
- GeoAlchemy 2
-
GeoAlchemy 2 provides extensions to SQLAlchemy for working with spatial databases.
GeoAlchemy 2 focuses on PostGIS. PostGIS 1.5 and PostGIS 2 are supported.
GeoAlchemy 2 aims to be simpler than its predecessor, GeoAlchemy. Simpler to use, and simpler to maintain.
Internationalizations
- SQLAlchemy-i18n
-
Internationalization extension for SQLAlchemy models.
- Stores translations in separate tables.
- Reflects translation table structures based on parent model table structure.
- Supports forcing of given locale.
- Good performance (uses proxy dicts and other advanced SQLAlchemy concepts for performance optimization).
Profilers
- flask_debugtoolbar
- Debug toolbar with SQLAlchemy query information for Flask.
- pyramid_debugtoolbar
- Debug toolbar with SQLAlchemy query information for Pyramid.
- SQLTap
-
SQLTap is a library that allows you to profile and introspect the queries that your application makes using SQLAlchemy.
SQLTap helps you understand:
- how many times a sql query is executed
- how much time your sql queries take
- where your application is issuing sql queries from
Recipes
Testing
- factory_boy
- Generate fake data and create random fixtures for testing in SQLAlchemy and many other Python ORM systems.
- mixer
- Generate fake data and create random fixtures for testing in SQLAlchemy and many other Python ORM systems.
Thin Abstractions
- Dataset
- Easy-to-use data handling for SQL data stores in Python with support for implicit table creation, bulk loading, and transaction. Dataset also includes support for freezing data to CSV and JSON flat files.
- rdflib-sqlalchemy
- RDFLib store using SQLAlchemy dbapi as back-end.
- SQLSoup
- SQLSoup provides a convenient way to map Python objects to relational database tables, with no declarative code of any kind. It's built on top of the SQLAlchemy ORM and provides a super-minimalistic interface to an existing database.
Vendor-specific Extensions
PostgreSQL
- sqlalchemy-crosstab-postgresql
- New grammar for SQLAlchemy to make handling the crosstab() tablefunc (i.e. pivot tables) in PostgreSQL easy peasy.
Web
Framework Integrations
- bottle-sqlalchemy
- A Bottle plugin to manage SQLAlchemy session to your application.
- Flask-SQLAlchemy
- Flask-SQLAlchemy is an extension for Flask that adds support for SQLAlchemy to your application.
- Flask-Admin
- The admin interface framework for Flask. With scaffolding for SQLAlchemy, MongoEngine, pymongo and Peewee.
- pyramid_sqlalchemy
- pyramid_sqlalchemy provides everything needed to use SQLAlchemy inPyramid applications.
- pyramid_restler
- pyramid_restler is a somewhat-opinionated toolkit for building RESTful Web services and applications on top of the Pyramid framework (with SQLAlchemy models).
- sacrud
- SACRUD will solve your problem of CRUD interface for SQLAlchemy, by providing extension for Pyramid (yet) or use it in pure form. Unlike classical CRUD interface, pyramid_sacrud allows override and flexibly customize interface (that is closer to django.contrib.admin).
- zope.sqlalchemy
- The aim of this package is to unify the plethora of existing packages integrating SQLAlchemy with Zope's transaction management. As such it seeks only to provide a data manager and makes no attempt to define a zopeish way to configure engines.
Other
- paginate_sqlalchemy
- This module helps dividing large lists of items into pages. The user is shown one page at a time and can navigate to other pages.