Python Sqlalchemy

Open-source Python projects categorized as Sqlalchemy

Top 23 Python Sqlalchemy Projects

  • sqlmodel

    SQL databases in Python, designed for simplicity, compatibility, and robustness.

    Project mention: SQLModel with the same relationship column twice | /r/FastAPI | 2023-02-06

    Seems like this is a known bug in SQLModel:

  • SQLAlchemy

    The Database Toolkit for Python

    Project mention: Imperative vs. Declarative mapping style in Domain Driven Design project | | 2023-10-28
  • InfluxDB

    Collect and Analyze Billions of Data Points in Real Time. Manage all types of time series data in a single, purpose-built database. Run at any scale in any environment in the cloud, on-premises, or at the edge.

  • flask-sqlalchemy

    Adds SQLAlchemy support to Flask

    Project mention: Voting webapp saves votes locally, but not on server | /r/flask | 2023-07-08

    You should probably use a database for this, using something like sqlite a single file "database" is probably the quickest way to get started, I recommend you use it with Flask-SQLAlchemy which makes working with the db easy as pie.

  • databases

    Async database support for Python. 🗄

    Project mention: Whats the standard way for interacting with a DB. | /r/FastAPI | 2023-03-15
  • factory_boy

    A test fixtures replacement for Python

    Project mention: Embracing Modern Python for Web Development | | 2023-12-08

    Factory Boy doesn't currently support asynchronous operations, but there is an async-factory-boy extension with enough async support for most use cases. There is also an open pull request in Factory Boy with recent updates (July 2023) that will hopefully be merged soon.

  • flask-base

    A simple Flask boilerplate app with SQLAlchemy, Redis, User Authentication, and more.

  • GINO

    GINO Is Not ORM - a Python asyncio ORM on SQLAlchemy core.

  • Onboard AI

    Learn any GitHub repo in 59 seconds. Onboard AI learns any GitHub repo in minutes and lets you chat with it to locate functionality, understand different parts, and generate new code. Use it for free at

  • alembic

    A database migrations tool for SQLAlchemy.

  • mathesar

    Web application providing an intuitive user experience to databases.

    Project mention: A modern, open-source spreadsheet that goes beyond the grid | | 2023-10-30

    This is what we're trying to do with [Mathesar]( We probably don't meet your needs yet because we don't support real-time concurrent editing, but we're actively working on the project and it is early days.

  • sandman2

    Automatically generate a RESTful API service for your legacy database. No code required!

  • fastapi-react

    🚀 Cookiecutter Template for FastAPI + React Projects. Using PostgreSQL, SQLAlchemy, and Docker

  • aiomysql

    aiomysql is a library for accessing a MySQL database from the asyncio

    Project mention: Tuesday Daily Thread: Advanced questions | /r/Python | 2023-02-21

    Use asyncio lib for mysql, for example – aiomysql

  • PyHive

    Python interface to Hive and Presto. 🐝

  • indico

    Indico - A feature-rich event management system, made @ CERN, the place where the Web was born.

    Project mention: Tool to manage participant invitations at regulars' table | /r/selfhosted | 2023-08-29
  • ormar

    python async orm with fastapi in mind and pydantic validation

    Project mention: What Python library do you wish existed? | /r/Python | 2023-01-15

    How about ormar?

  • aiopg

    aiopg is a library for accessing a PostgreSQL database from the asyncio

  • eventsourcing

    A library for event sourcing in Python.

    Project mention: walnats: Nats-powered event-driven background jobs and microservices framework for Python. It's like Celey or Dramatiq but for microservices, asyncio-powered, and type-safe. | /r/Python | 2023-02-16

    There is no built-in storage backend but in just a few lines you can make an actor (or use the monitor method to consume everything) that will store everything wherever you want, with eventsourcing or plain events.

  • sqladmin

    SQLAlchemy Admin for FastAPI and Starlette

  • eralchemy

    Entity Relation Diagrams generation tool

  • flask-bones

    An example of a large scale Flask application using blueprints and extensions.

    Project mention: A Python Script to connect to GitHub and Fetches Search Results | | 2023-02-10

    python3 docker-php-extension-installer: codechecker: SingleFileZ: china-dictatorship: vscode-docker: flask-bones: ProjectFib: S3Mock: home: docker-php: dockbix-xxl: wind-layer: powerstrip: selenium-jupiter: gnome-shell-extension-docker: hacktoberfest-2022: azure-docker-extension: pgrocks-fdw: docker-php-yii2: docker-community-extensions: alpine-php-fpm: autoview-tradingview-chrome-docker-bot: .config: docker-phpfpm: coc-docker: china-dictatorhsip-6: testcontainers-spock: Dockery: docker-extension: volumes-backup-extension: ajeetraina@Docker-Ajeet-Singh-Rainas-MacBook-Pro chatgpt % vi ajeetraina@Docker-Ajeet-Singh-Rainas-MacBook-Pro chatgpt % python3 .config: Dockery: docker-extension: ransomware: jfrog-docker-desktop-extension: dd-extension-lgtm: openshift-dd-ext: k9s-dd-extension: pgadmin4-docker-extension: trivy-docker-extension: drone-ci-docker-extension: docker-extension: swagger-editor-docker-extension: wasm-docker-extension: microcks-docker-desktop-extension: docker-extension-golang-playground: diveintoansible-extension: docker-desktop-extension: docker-extension-rabbitmq: docker-storj-extension: github-registry-docker-desktop-extension: docker-desktop-extension-issues: sdw-docker-extension: vcluster-dd-extension: extension-docker-desktop: asyncapi-studio-docker-extension: gefyra-docker-desktop-extension: oraclexe-docker-extension: docker-extensions-101: step-ca-docker-extension:

  • graphene-sqlalchemy

    Graphene SQLAlchemy integration

  • mixer

    Mixer -- Is a fixtures replacement. Supported Django, Flask, SqlAlchemy and custom python objects. (by klen)

  • fastapi-boilerplate

    FastAPI boilerplate for real world production (by teamhide)

    Project mention: [Python] How to implement a transactional decorator in FastAPI + SQLAlchemy - with reviewing other approaches | | 2023-05-29

    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: 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()

  • SaaSHub

    SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

NOTE: The open source projects on this list are ordered by number of github stars. The number of mentions indicates repo mentiontions in the last 12 Months or since we started tracking (Dec 2020). The latest post mention was on 2023-12-08.

Python Sqlalchemy related posts


What are some of the best open-source Sqlalchemy projects in Python? This list will help you:

Project Stars
1 sqlmodel 11,584
2 SQLAlchemy 8,077
3 flask-sqlalchemy 4,100
4 databases 3,603
5 factory_boy 3,247
6 flask-base 2,936
7 GINO 2,612
8 alembic 2,253
9 mathesar 1,971
10 sandman2 1,964
11 fastapi-react 1,911
12 aiomysql 1,663
13 PyHive 1,645
14 indico 1,572
15 ormar 1,486
16 aiopg 1,348
17 eventsourcing 1,338
18 sqladmin 1,326
19 eralchemy 1,056
20 flask-bones 983
21 graphene-sqlalchemy 956
22 mixer 919
23 fastapi-boilerplate 729
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives