https://github.com/infraguys/restalchemy/actions/workflows/tests.yml/badge.svg https://img.shields.io/pypi/pyversions/restalchemy https://img.shields.io/pypi/dm/restalchemy

RESTAlchemy

RESTAlchemy is a Python toolkit for building HTTP REST APIs on top of a flexible data model and storage abstraction.

It combines:

  • A Data Model (DM) layer for defining domain models and validation.

  • A Storage layer for persisting models (for example, SQL databases).

  • An API layer for exposing models as RESTful HTTP resources.

  • Optional OpenAPI support for discoverable, documented APIs.

Features

  • Clear separation between domain models, storage implementation details, and HTTP API.

  • Strongly typed, validated data model with reusable properties.

  • Minimal boilerplate to expose models as REST resources.

  • Built-in migration tooling for evolving database schemas.

Performance

On all three request patterns, RESTAlchemy is the fastest framework measured here, and stands nearer to the floor of what such a request can cost at all than to any framework behind it. The benchmark in this repository asks six stacks the same three questions against the same PostgreSQL and the same rows: read a collection of 100, read one resource, create one. The first row of the table is not one of them: it is a hand-written query and orjson.dumps, which is what the database and the JSON cost before any framework has run.

15 rounds × best of 20 calls, 1000 rows in the table, 100 per page, Python 3.12, PostgreSQL 16, one AMD EPYC 7742. The full run, with confidence intervals and the machine it was measured on, is in bench/results/results.md; these are its numbers. In parentheses: the same number as a multiple of RESTAlchemy’s.

Stack

Collection of 100

One resource

POST one

Per row

raw psycopg + orjson †

1272 µs (0.7×)

174 µs (0.5×)

229 µs (0.6×)

11.1 µs (0.8×)

RESTAlchemy

1705 µs

317 µs

397 µs

14.0 µs

Flask + SQLAlchemy

2267 µs (1.3×)

636 µs (2.0×)

606 µs (1.5×)

16.5 µs (1.2×)

FastAPI + SQLAlchemy

2417 µs (1.4×)

894 µs (2.8×)

829 µs (2.1×)

15.4 µs (1.1×)

Litestar + SQLAlchemy

2524 µs (1.5×)

857 µs (2.7×)

811 µs (2.0×)

16.8 µs (1.2×)

Django + DRF

5276 µs (3.1×)

943 µs (3.0×)

895 µs (2.3×)

43.8 µs (3.1×)

† Not a framework, and faster than every framework under it, as it should be: it is the floor the rest are read against, not a stack anyone would build a service on.

RESTAlchemy adds 143 µs to that bare single-row query, 168 µs to the bare insert, and under three microseconds to each row of a collection — a REST service, routed, validated and packed, for a few microseconds over the floor.

Every stack is written the way its own documentation writes it, answers with the same rows — checked field by field before anything is timed — and is called at its own interface, so what is measured is the framework and its database work rather than a web server. The command that runs it, and what the numbers do not say, are in bench/README.md.

Documentation

The rendered documentation is published at https://infraguys.github.io/restalchemy/.

All documentation is available in four languages. The structure of files and sections is identical across languages:

If you are new to RESTAlchemy, start with:

Quick start

Install from PyPI:

pip install restalchemy

Define a simple DM model (simplified from the getting started guide):

from restalchemy.dm import models
from restalchemy.dm import properties
from restalchemy.dm import types


class FooModel(models.ModelWithUUID):
    value = properties.property(types.Integer(), required=True)

For a complete in-memory REST service example, including controllers, routes and a WSGI application, see docs/en/getting-started.md.

Examples

Real code examples live in the examples/ directory:

  • examples/restapi_foo_bar_service.py – a simple REST API service built with in-memory storage.

  • examples/dm_mysql_storage.py – data model with MySQL storage example.

  • examples/openapi_app.py – example API with OpenAPI specification generation.

Migration commands

RESTAlchemy provides command-line tools for managing database migrations.

<migration number>-<message>-<hash>.py
$ ra-rename-migrations -p <path-to-migrations>

Create migrations:

$ ra-new-migration --path examples/migrations/ --message "1st migration"
$ ra-new-migration --path examples/migrations/ --message "2st migration" --depend 1st
$ ra-new-migration --path examples/migrations/ --message "3st migration" --depend 2st
$ ra-new-migration --path examples/migrations/ --message "4st migration"
$ ra-new-migration --path examples/migrations/ --message "5st migration" --depend 3st --depend 4st

Apply migrations:

$ ra-apply-migration --path examples/migrations/ --db-connection mysql://test:test@localhost/test -m 5st
> upgrade 1st
> upgrade 2st
> upgrade 3st
> upgrade 4st
> upgrade 5st

Rolled back migrations:

$ ra-rollback-migration --path examples/migrations/ --db-connection mysql://test:test@localhost/test -m 4st
> downgrade 5st
> downgrade 4st
$ ra-rollback-migration --path examples/migrations/ --db-connection mysql://test:test@localhost/test -m 1st
> downgrade 3st
> downgrade 2st
> downgrade 1st

Tests

Tests are managed via tox. The default environment list includes Python 3.8, 3.10, 3.12 and 3.13.

Run the full test suite:

tox

Run tests for a specific Python version (for example, Python 3.10):

tox -e py310

Run functional tests (require access to a MySQL database):

export DATABASE_URI="mysql://root:@localhost:3306/radatabase"
tox -e py310-functional

Run functional tests with PostgreSQL:

export DATABASE_URI="postgresql://postgres:password@localhost:5432/radatabase"
tox -e py310-functional

License

RESTAlchemy is licensed under the Apache License, Version 2.0.

Copyright (c) Genesis Corporation, 2025.

See the LICENSE file in this repository or https://www.apache.org/licenses/LICENSE-2.0 for the full license text.

Project links

Data verified by PyPI on Aug 31, 2026
Data provided by the project maintainers, verified at the time the release was uploaded to PyPI.

Key dates

PyPI data
Data sourced directly from PyPI's database.
  • Released:
Newer release available (16.0.4)

Owner

PyPI data
Data sourced directly from PyPI's database.

Credits

Author: Genesis Corporation

GitHub Statistics

Data verified by PyPI on Aug 31, 2026
The GitHub source repository was provided by the project maintainers and verified by PyPI at the time of upload. Stars, forks, and open issues/PRs are derived from that repository and have not been independently verified.

License

Apache Software License (Apache-2.0)

Requires

Python >=3.8

Provides Extra

dev test mypy ruff shellcheck testenv docs

Classifiers

Report project as malware

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

restalchemy-16.0.1.tar.gz (632.7 kB view details)

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

restalchemy-16.0.1-py3-none-any.whl (673.4 kB view details)

Uploaded Python 3

File details

Details for the file restalchemy-16.0.1.tar.gz.

File metadata

  • Download URL: restalchemy-16.0.1.tar.gz
  • Upload date:
  • Size: 632.7 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? Yes
  • Uploaded via: twine/7.0.0 CPython/3.13.14

File hashes

Hashes for restalchemy-16.0.1.tar.gz
Algorithm Hash digest
SHA256 678b38270e304e0dea684b3dbde39e27a21962d262601bf549b7e4a89dfaa0ee
MD5 c23e7b8f5d710f491fad6994df34f950
BLAKE2b-256 3f992791638cc4e58c5ab52abb5c1f46be83fe716a5dc77b5de1b0dbc7899d26

See more details on using hashes here.

Provenance

The following attestation bundles were made for restalchemy-16.0.1.tar.gz:

Publisher: publish-to-pypi.yml on infraguys/restalchemy

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

File details

Details for the file restalchemy-16.0.1-py3-none-any.whl.

File metadata

  • Download URL: restalchemy-16.0.1-py3-none-any.whl
  • Upload date:
  • Size: 673.4 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? Yes
  • Uploaded via: twine/7.0.0 CPython/3.13.14

File hashes

Hashes for restalchemy-16.0.1-py3-none-any.whl
Algorithm Hash digest
SHA256 ad5ea37d419aecf5e3f7603801f263258d37011c9217eda5039a18d9b87c37ac
MD5 fd5b40f9adbbe6f6725621d3cbb9ca9e
BLAKE2b-256 7cccfd343eba99524a89f9475b42b0dd9112dd1f77533cc0f28cdb9b8d9a8ff0

See more details on using hashes here.

Provenance

The following attestation bundles were made for restalchemy-16.0.1-py3-none-any.whl:

Publisher: publish-to-pypi.yml on infraguys/restalchemy

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

Release history Release notifications | RSS feed

16.0.4

2 files

16.0.3

2 files

16.0.2

2 files

This release

16.0.1 This release

2 files

16.0.0

2 files

15.3.0

2 files

15.2.8

2 files

15.2.7

2 files

15.2.6

2 files

15.2.5

2 files

15.2.4

2 files

15.2.3

2 files

15.2.2

2 files

15.2.1

2 files

15.2.0

2 files

15.1.2

2 files

15.1.1

2 files

15.1.0

2 files

15.0.12

2 files

15.0.11

2 files

15.0.10

2 files

15.0.9

2 files

15.0.8

2 files

15.0.7

2 files

15.0.6

2 files

15.0.5

2 files

15.0.4

2 files

15.0.3

2 files

15.0.2

2 files

15.0.1

2 files

15.0.0

2 files

14.7.0

2 files

14.6.0

2 files

14.5.0

2 files

14.4.1

2 files

14.4.0

2 files

14.3.0

2 files

14.2.0

2 files

14.1.6

2 files

Yanked

14.1.5

2 files

Yanked reason: Wrong content, same as 14.1.4

14.1.4

2 files

14.1.3

2 files

14.1.2

2 files

14.1.1

2 files

14.1.0

2 files

14.0.0

2 files

13.0.1

2 files

13.0.0

2 files

12.10.1

2 files

12.9.0

2 files

12.8.0

2 files

12.7.0

2 files

12.6.0

2 files

12.5.1

2 files

12.5.0

2 files

12.4.0

2 files

12.3.1

2 files

12.3.0

2 files

12.2.0

2 files

12.1.0

2 files

12.0.0

2 files

11.0.1

2 files

11.0.0

2 files

1.2.1

2 files

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page