SQLAlchemy

Inspired by .

!

SQLAlchemy type to store standard `enum.Enum` values.

SQLAlchemy type to store aware `datetime.datetime` values.

Various utility functions, new data types and helpers for SQLAlchemy

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)

Alembic is a lightweight database migration tool for usage with the SQLAlchemy Database Toolkit for Python.

Inspired by Ruby on Rails' migrations, SQLAlchemy Migrate provides a way to deal with database schema changes in SQLAlchemy projects.

Alembic is a lightweight database migration tool for usage with the SQLAlchemy Database Toolkit for Python.

Amazon Redshift_ dialect for SQLAlchemy.

SQLAlchemy dialect for interfacing with Sphinx_ (search engine) via SphinxQL.

An asynchronous PostgreSQL dialect for asyncpg_, providing SQLAlchemy core support and its own asynchronous ORM interface.

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.

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.

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.

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.

Data validator for Flask and SQL-Alchemy, working at Model component with events, preventing invalid data in the columns.

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.

Full-text searchable models for SQLAlchemy.

Fulltext search support with MySQL & SQLAlchemy.

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.

GeoAlchemy 2 provides extensions to SQLAlchemy for working with spatial databases.

Internationalization extension for SQLAlchemy models.

Debug toolbar with SQLAlchemy query information for Flask.

Debug toolbar with SQLAlchemy query information for Pyramid.

SQLTap is a library that allows you to profile and introspect the queries that your application makes using SQLAlchemy.

Auto-detect the n+1 queries problem in SQLAlchemy (and other Python ORMs)

This library implements keyset-based paging for SQLAlchemy (both ORM and core).

SQLAlchemy integration with the marshmallow_ (de)serialization library.

Data parsing and validation using Python type hints

SQLAlchemy extension for interacting models with python dictionary.

Fixtures management for SQLAlchemy and other systems.

Generate fake data and create random fixtures for testing in SQLAlchemy and many other Python ORM systems.

Generate fake data and create random fixtures for testing in SQLAlchemy and many other Python ORM systems.

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_ store using SQLAlchemy dbapi as back-end.

Loading and execution of parameterized queries stored in 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.

Loading and execution of parameterized queries stored in files.

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.

Easy-to-use data handling for SQL data stores in Python with support for implicit table creation, bulk loading, and transaction.

Flask extension that uses SQLAlchemy and psycopg2-pgevents <https://github.com/shawalli/psycopg2-pgevents>_ to enable event listeners tied into database-layer triggers.

New grammar for SQLAlchemy to make handling the `crosstab()` tablefunc (i.e. pivot tables) in PostgreSQL easy peasy.

Wrapper for using PostgreSQL COPY with SQLAlchemy for efficient bulk data imports and exports.

Simple package for describing SQLAlchemy schema and display raw database tables by reflecting feature.

This module generates images from SQLAlchemy models.

ERAlchemy generates Entity Relation (ER) diagram from databases or from SQLAlchemy models.

CLI and Library that generates Mermaid and DOT Diagrams from SQLAlchemy models and injects them into documentation.

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.

The admin interface framework for Flask_.

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.

pyramidsqlalchemy 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.

This module helps dividing large lists of items into pages.

Generate a curl-able REST HTTP API with searching and filtering for all tables in a database and an admin UI with Flask-SQLAlchemy and HTTP Basic Authentication.

A set of well-tested mixins that brings Active Record, Django-like queries, nested eager load and beauty repr to your SQLAlchemy.

like

Versioned domain model. Python library for revisioning/versioning of databases.

Versioning and auditing extension for SQLAlchemy.

Library for implementing MPTT (modified preorder tree traversal) with SQLAlchemy models and working with trees of model instances, like django-mptt_.

An implementation for SQLAlchemy-based applications of the nested-sets/modified-pre-order-tree-traversal technique for storing hierarchical data in a relational database.