SQLAlchemy
Contents
Awesome SQLAlchemy
Data Types
Various utility functions, new data types and helpers for SQLAlchemy - Listeners - Data types: {..., ChoiceType, CountryType, JSONType, URLType, UUIDType, ...} - Range data types - Aggregated attributes - Generates decorator - Generic relationships - Database helpers: createdatabase, dropdatabase - Foreign key helpers - ORM helpers - Utility classes - Model mixins: Timestamp (created, updated times)
Database Migration Tools
Dialects
File and Image Attachments
DEPOT is a framework for easily storing and serving files in web applications. Depot features simple integration with SQLAlchemy by providing customized model field types for storing files attached to your ORM document.
SQLAlchemy-ImageAttach is a SQLAlchemy extension for attaching images to entity objects.
Based on SQLAlchemy-ImageAttach but using JSON type instead of relation, and SqlAlchemy's mutable facility, Also supports multiple stores per context.
Forms and Data Validations
ColanderAlchemy helps you to auto-generate Colander_ schemas that are based on SQLAlchemy mapped classes.
Data validator for Flask and SQL-Alchemy, working at Model component with events, preventing invalid data in the columns. The extension works with event listeners from SQLAlchemy.
FormAlchemy eliminates boilerplate by autogenerating HTML input fields from a given model.
WTForms-Alchemy is a WTForms_ extension toolkit for easier creation of model based forms.
Sprox provides an easy way to create forms for web content which are: automatically generated, easy to customize, and validated.
Full-text Searching
GIS and Spatial Databases
GeoAlchemy provides extensions to SQLAlchemy to work with spatial databases.
GeoAlchemy 2 provides extensions to SQLAlchemy for working with spatial databases. GeoAlchemy 2 focuses on PostGIS_. PostGIS 1.5 and PostGIS 2 are supported. Spatialite_ is also supported, but using GeoAlchemy 2 with Spatialite requires some specific configuration on the application side. GeoAlchemy 2 aims to be simpler than its predecessor, GeoAlchemy_. Simpler to use, and simpler to maintain.
Internationalizations
Profilers
Query helpers
Serialization and deserialization
Testing
Thin Abstractions
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.
SQLSoup provides a convenient way to map Python objects to relational database tables, with no declarative code of any kind.
SQLModel is a library for interacting with SQL databases from Python code, with Python objects.
Zillion is a free, open data warehousing and dimensional modeling tool that allows combining and analyzing data from multiple datasources through a simple API.
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.
Vendor-specific Extensions
Flask extension that uses SQLAlchemy and psycopg2-pgevents <https://github.com/shawalli/psycopg2-pgevents>_ to enable event listeners tied into database-layer triggers.
Visualizations
Web
A Bottle_ plugin to manage SQLAlchemy session to your application.
Declarative query builder that auto-generates filter parameters from models and parses request parameters using marshmallow-sqlalchemy and webargs.
Flask-SQLAlchemy is an extension for Flask_ that adds support for SQLAlchemy to your application.
pyramid_sqlalchemy provides everything needed to use SQLAlchemy in Pyramid_ applications.
pyramid_restler is a somewhat-opinionated toolkit for building RESTful Web services and applications on top of the Pyramid framework (with SQLAlchemy models).
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, pyramidsacrud allows override and flexibly customize interface (that is closer to `django.contrib.admin`).
A light and framework-independent wrapper for SQLAlchemy that makes it really easy to setup and use.
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.
Provides a convenient way to work with sessions in asynchronous applications using context.
Flask-SQLAlchemy is an extension for Flask_ that adds support for SQLAlchemy to your application.
SACRUD will solve your problem of CRUD interface for SQLAlchemy, by providing extension for Pyramid_ (yet) or use it in pure form.
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.
pyramid_sqlalchemy provides everything needed to use SQLAlchemy in Pyramid_ applications.
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.
pyramid_sqlalchemy provides everything needed to use SQLAlchemy in Pyramid_ applications.