sqlalchemy-filters-plus
fastapi-boilerplate
sqlalchemy-filters-plus | fastapi-boilerplate | |
---|---|---|
1 | 1 | |
43 | 890 | |
- | - | |
0.0 | 6.7 | |
over 1 year ago | 20 days ago | |
Python | Python | |
GNU General Public License v3.0 or later | - |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
sqlalchemy-filters-plus
-
New sqlalchemy filtering library - needs your support!
Hence i thought of dedicating some of my spare time to build sqlalchemy-filters-plus, a library that provides elegant way of constructing filters and fields, also giving the possibility to create custom operators either based on sqlalchemy builtin operators and entirely custom ones and more..
fastapi-boilerplate
-
[Python] How to implement a transactional decorator in FastAPI + SQLAlchemy - with reviewing other approaches
from typing import Optional from contextvars import ContextVar from sqlalchemy.ext.asyncio import ( create_async_engine, async_scoped_session, async_sessionmaker, AsyncSession, ) from ..config import config # some hints from: https://github.com/teamhide/fastapi-boilerplate/blob/master/core/db/session.py db_session_context: ContextVar[Optional[int]] = ContextVar( "db_session_context", default=None ) engine = create_async_engine(url=config.DB_URL) def get_db_session_context() -> int: session_id = db_session_context.get() if not session_id: raise ValueError("Currently no session is available") return session_id def set_db_session_context(*, session_id: int) -> None: db_session_context.set(session_id) AsyncScopedSession = async_scoped_session( session_factory=async_sessionmaker(bind=engine, autoflush=False, autocommit=False), scopefunc=get_db_session_context, ) def get_current_session() -> AsyncSession: return AsyncScopedSession()
What are some alternatives?
sqlmodel - SQL databases in Python, designed for simplicity, compatibility, and robustness.
FastAPI-Production-Boilerplate - A scalable and production ready boilerplate for FastAPI
sqlalchemy-filters - Filter, sort and paginate SQLAlchemy query objects. Ideal for exposing these actions over a REST API.
FastAPI-boilerplate - An extendable async API using FastAPI, Pydantic V2, SQLAlchemy 2.0, PostgreSQL and Redis.
flask-sqlalchemy - Adds SQLAlchemy support to Flask
fastapi-template - FastAPI template
shillelagh - Making it easy to query APIs via SQL
warp_fastapi - Create FastAPI app with warp speed.
sandman2 - Automatically generate a RESTful API service for your legacy database. No code required!
FastAPI-template - Feature rich robust FastAPI template.
SQLAlchemy - The Database Toolkit for Python
fastapi-layered-architecture - FastAPI Layered Architecture