Top 23 Sqlalchemy Open-Source Projects

• sqlmodel

  23 13,030 8.5 Python

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

• SQLAlchemy

  124 8,807 9.7 Python

  The Database Toolkit for Python

  

Project mention: Python: A SQLAlchemy Wrapper Component That Works With Both Flask and FastAPI Frameworks | dev.to | 2024-05-03

In SQLAlchemy, models representing database tables typically subclass sqlalchemy.orm.DeclarativeBase (this class supersedes the sqlalchemy.orm.declarative_base function). Accordingly, the abstract base class in this database wrapper component is a sqlalchemy.orm.DeclarativeBase subclass, accompanied by another custom base class providing additional dunder methods.

• InfluxDB

  www.influxdata.com featured

  Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  

• ibis

  23 4,241 10.0 Python

  the portable Python dataframe library

  

Project mention: Show HN: Hashquery, a Python library for defining reusable analysis | news.ycombinator.com | 2024-04-23

I really don't understand the appeal of dbt vs a proper programming language. The templating approach leads to massive spaghetti. I look forward to trying out something like Ibis [0]

0: https://ibis-project.org/

• flask-sqlalchemy

  11 4,152 7.9 Python

  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

  15 3,703 5.8 Python

  Async database support for Python. 🗄

  

• factory_boy

  3 3,408 6.9 Python

  A test fixtures replacement for Python

  

Project mention: Embracing Modern Python for Web Development | dev.to | 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

  2 2,989 0.0 Python

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

  

• SaaSHub

  www.saashub.com featured

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

  

• GINO

  0 2,635 0.0 Python

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

  

• alembic

  4 2,467 8.4 Python

  A database migrations tool for SQLAlchemy.

  

• mathesar

  53 2,217 9.9 Python

  Web application providing an intuitive user experience to databases.

  

Project mention: Show HN: Teable – Open-Source No-Code Database Fusion of Postgres and Airtable | news.ycombinator.com | 2024-03-11

Congratulations on launching, it's nice to see more open source products in this area (I work on https://mathesar.org/). Feel free to reach out if you'd like to talk and compare notes.

• fastapi-react

  1 2,074 0.0 Python

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

• sandman2

  3 1,982 0.0 Python

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

• aiomysql

  5 1,703 4.0 Python

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

  

• PyHive

  1 1,665 3.5 Python

  Python interface to Hive and Presto. 🐝

  

• indico

  6 1,654 9.7 Python

  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

• sqladmin

  5 1,587 8.2 Python

  SQLAlchemy Admin for FastAPI and Starlette

• ormar

  3 1,583 8.5 Python

  python async orm with fastapi in mind and pydantic validation

• eventsourcing

  2 1,403 9.1 Python

  A library for event sourcing in Python.

  

• aiopg

  1 1,376 4.2 Python

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

  

• eralchemy

  1 1,077 0.0 Python

  Entity Relation Diagrams generation tool

• flask-bones

  2 992 0.0 Python

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

• graphene-sqlalchemy

  2 971 5.1 Python

  Graphene SQLAlchemy integration

  

• mixer

  1 928 0.0 Python

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

• SaaSHub

  www.saashub.com featured

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

  

Sqlalchemy related posts

• Xz/liblzma: Bash-stage Obfuscation Explained

  1 project | news.ycombinator.com | 31 Mar 2024

• Alembic with Async SQLAlchemy

  1 project | dev.to | 12 Dec 2023

• Imperative vs. Declarative mapping style in Domain Driven Design project

  1 project | news.ycombinator.com | 28 Oct 2023

• Show HN: Visual DB – Airtable alternative for your own database

  1 project | news.ycombinator.com | 23 Aug 2023

• A steering council note about making the global

  3 projects | news.ycombinator.com | 29 Jul 2023

• Voting webapp saves votes locally, but not on server

  2 projects | /r/flask | 8 Jul 2023

• I'm So Frustrated Finding a NocoDB Alternative (Need a Postgres / SQL-Based Spreadsheet)

  1 project | /r/selfhosted | 4 Jul 2023
• A note from our sponsor - SaaSHub
  www.saashub.com | 5 May 2024

  SaaSHub helps you find the best software and product alternatives Learn more →

Index

Sponsored

SaaSHub - Software Alternatives and Reviews

SaaSHub helps you find the best software and product alternatives

www.saashub.com