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. Learn more →
Top 23 Python Sqlalchemy Projects
-
Seems like this is a known bug in SQLModel: https://github.com/tiangolo/sqlmodel/issues/10
-
Project mention: Imperative vs. Declarative mapping style in Domain Driven Design project | news.ycombinator.com | 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.
-
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.
-
-
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.
-
-
-
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 www.getonboard.dev.
-
-
Project mention: A modern, open-source spreadsheet that goes beyond the grid | news.ycombinator.com | 2023-10-30
This is what we're trying to do with [Mathesar](https://github.com/centerofci/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.
-
-
fastapi-react
🚀 Cookiecutter Template for FastAPI + React Projects. Using PostgreSQL, SQLAlchemy, and Docker
-
Use asyncio lib for mysql, for example – aiomysql
-
-
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 -
How about ormar?
-
-
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.
-
-
-
Project mention: A Python Script to connect to GitHub and Fetches Search Results | dev.to | 2023-02-10
python3 new.py docker-php-extension-installer: https://github.com/mlocati/docker-php-extension-installer codechecker: https://github.com/Ericsson/codechecker SingleFileZ: https://github.com/gildas-lormeau/SingleFileZ china-dictatorship: https://github.com/cirosantilli/china-dictatorship vscode-docker: https://github.com/microsoft/vscode-docker flask-bones: https://github.com/cburmeister/flask-bones ProjectFib: https://github.com/anantdgoel/ProjectFib S3Mock: https://github.com/adobe/S3Mock home: https://github.com/gege-circle/home docker-php: https://github.com/chialab/docker-php dockbix-xxl: https://github.com/monitoringartist/dockbix-xxl wind-layer: https://github.com/sakitam-fdd/wind-layer powerstrip: https://github.com/ClusterHQ/powerstrip selenium-jupiter: https://github.com/bonigarcia/selenium-jupiter gnome-shell-extension-docker: https://github.com/gpouilloux/gnome-shell-extension-docker hacktoberfest-2022: https://github.com/docker/hacktoberfest-2022 azure-docker-extension: https://github.com/Azure/azure-docker-extension pgrocks-fdw: https://github.com/vidardb/pgrocks-fdw docker-php-yii2: https://github.com/dmstr/docker-php-yii2 docker-community-extensions: https://github.com/collabnix/docker-community-extensions alpine-php-fpm: https://github.com/joseluisq/alpine-php-fpm autoview-tradingview-chrome-docker-bot: https://github.com/IAMtheIAM/autoview-tradingview-chrome-docker-bot .config: https://github.com/zszszszsz/.config docker-phpfpm: https://github.com/adhocore/docker-phpfpm coc-docker: https://github.com/josa42/coc-docker china-dictatorhsip-6: https://github.com/cirosantilli/china-dictatorhsip-6 testcontainers-spock: https://github.com/testcontainers/testcontainers-spock Dockery: https://github.com/oslabs-beta/Dockery docker-extension: https://github.com/tailscale/docker-extension volumes-backup-extension: https://github.com/docker/volumes-backup-extension ajeetraina@Docker-Ajeet-Singh-Rainas-MacBook-Pro chatgpt % vi new.py ajeetraina@Docker-Ajeet-Singh-Rainas-MacBook-Pro chatgpt % python3 new.py .config: https://github.com/zszszszsz/.config Dockery: https://github.com/oslabs-beta/Dockery docker-extension: https://github.com/tailscale/docker-extension ransomware: https://github.com/abhir98/ransomware jfrog-docker-desktop-extension: https://github.com/jfrog/jfrog-docker-desktop-extension dd-extension-lgtm: https://github.com/cedricziel/dd-extension-lgtm openshift-dd-ext: https://github.com/redhat-developer/openshift-dd-ext k9s-dd-extension: https://github.com/spurin/k9s-dd-extension pgadmin4-docker-extension: https://github.com/marcelo-ochoa/pgadmin4-docker-extension trivy-docker-extension: https://github.com/aquasecurity/trivy-docker-extension drone-ci-docker-extension: https://github.com/harness/drone-ci-docker-extension docker-extension: https://github.com/loopDelicious/docker-extension swagger-editor-docker-extension: https://github.com/n-murphy/swagger-editor-docker-extension wasm-docker-extension: https://github.com/cmrigney/wasm-docker-extension microcks-docker-desktop-extension: https://github.com/microcks/microcks-docker-desktop-extension docker-extension-golang-playground: https://github.com/rumpl/docker-extension-golang-playground diveintoansible-extension: https://github.com/spurin/diveintoansible-extension docker-desktop-extension: https://github.com/okteto/docker-desktop-extension docker-extension-rabbitmq: https://github.com/Yogendra0Sharma/docker-extension-rabbitmq docker-storj-extension: https://github.com/elek/docker-storj-extension github-registry-docker-desktop-extension: https://github.com/peacecwz/github-registry-docker-desktop-extension docker-desktop-extension-issues: https://github.com/mutagen-io/docker-desktop-extension-issues sdw-docker-extension: https://github.com/marcelo-ochoa/sdw-docker-extension vcluster-dd-extension: https://github.com/loft-sh/vcluster-dd-extension extension-docker-desktop: https://github.com/epinio/extension-docker-desktop asyncapi-studio-docker-extension: https://github.com/thiyagu06/asyncapi-studio-docker-extension gefyra-docker-desktop-extension: https://github.com/gefyrahq/gefyra-docker-desktop-extension oraclexe-docker-extension: https://github.com/marcelo-ochoa/oraclexe-docker-extension docker-extensions-101: https://github.com/collabnix/docker-extensions-101 step-ca-docker-extension: https://github.com/hslatman/step-ca-docker-extension
-
-
mixer
Mixer -- Is a fixtures replacement. Supported Django, Flask, SqlAlchemy and custom python objects. (by klen)
-
Project mention: [Python] How to implement a transactional decorator in FastAPI + SQLAlchemy - with reviewing other approaches | dev.to | 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: 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()
-
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
- Imperative vs. Declarative mapping style in Domain Driven Design project
- Show HN: Visual DB – Airtable alternative for your own database
- Voting webapp saves votes locally, but not on server
- I'm So Frustrated Finding a NocoDB Alternative (Need a Postgres / SQL-Based Spreadsheet)
- SQLAlchemy “SQL Man-in-the-middle” for soft-deleted entities
- How useful is Python in accounting and auditing?
- MS Access alternative?
-
A note from our sponsor - InfluxDB
www.influxdata.com | 10 Dec 2023
Index
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
www.saashub.com