SQLAlchemy-Mimer Documentation

SQLAlchemy-Mimer provides a fully featured SQLAlchemy dialect for Mimer SQL, enabling seamless integration between the Mimer database and Python applications using SQLAlchemy’s ORM or Core APIs.

It offers full support for:

• Schema reflection (tables, views, constraints, domains, indexes)
• ORM integration and identity management
• Sequence-based autoincrement (with zero roundtrips)
• Native Mimer SQL syntax and type names
• Safe, idempotent DDL generation

---

📚 Table of contents

• Installation
• User Guide
• Autoincrement & Sequence Handling
• Changelog

---

🔍 Quick start

python -m pip install sqlalchemy-mimer

Then connect to Mimer SQL:

from sqlalchemy import create_engine, MetaData, Table, Column, Integer, String

engine = create_engine("mimer://user:password@hostname:port/dbname")
metadata = MetaData()

users = Table(
    "users",
    metadata,
    Column("id", Integer, primary_key=True, autoincrement=True),
    Column("name", String(50))
)

metadata.create_all(engine)