SQLAlchemy admin for FastAPI and Starlette
Project description
SQLAlchemy Admin for Starlette/FastAPI
SQLAdmin is a flexible Admin interface for SQLAlchemy models.
Main features include:
- SQLAlchemy sync/async engines
- Starlette integration
- FastAPI integration
- SQLModel support
- Modern UI using Tabler
Documentation: https://aminalaee.dev/sqladmin
Source Code: https://github.com/aminalaee/sqladmin
Online Demo: Demo
Installation
$ pip install sqladmin
Screenshots
Quickstart
Let's define an example SQLAlchemy model:
from sqlalchemy import Column, Integer, String, create_engine
from sqlalchemy.ext.declarative import declarative_base
Base = declarative_base()
engine = create_engine(
"sqlite:///example.db",
connect_args={"check_same_thread": False},
)
class User(Base):
__tablename__ = "users"
id = Column(Integer, primary_key=True)
name = Column(String)
Base.metadata.create_all(engine) # Create tables
If you want to use SQLAdmin
with FastAPI
:
from fastapi import FastAPI
from sqladmin import Admin, ModelView
app = FastAPI()
admin = Admin(app, engine)
class UserAdmin(ModelView, model=User):
column_list = [User.id, User.name]
admin.add_view(UserAdmin)
Or if you want to use SQLAdmin
with Starlette
:
from sqladmin import Admin, ModelView
from starlette.applications import Starlette
app = Starlette()
admin = Admin(app, engine)
class UserAdmin(ModelView, model=User):
column_list = [User.id, User.name]
admin.add_view(UserAdmin)
Now visiting /admin
on your browser you can see the SQLAdmin
interface.
Related projects and inspirations
- Flask-Admin Admin interface for Flask supporting different database backends and ORMs. This project has inspired SQLAdmin extensively and most of the features and configurations are implemented the same.
- FastAPI-Admin Admin interface for FastAPI which works with
TortoiseORM
. - Dashboard Admin interface for ASGI frameworks which works with the
orm
package.
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
sqladmin-0.11.0.tar.gz
(407.7 kB
view hashes)
Built Distribution
sqladmin-0.11.0-py3-none-any.whl
(421.3 kB
view hashes)
Close
Hashes for sqladmin-0.11.0-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 75030554d3218be95b52de3562d9763eef015e046767117782c168bbf8f6efd0 |
|
MD5 | ea9fc379b3947b218f2c1c234a320d3a |
|
BLAKE2b-256 | 2b90e20ec750de72108ddf97d45002e352ef447548c62740508469a7a3990b11 |