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. Learn more β
Top 23 Python Sqlalchemy Projects
-
InfluxDB
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.
-
WorkOS
The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.
-
fastapi-react
π Cookiecutter Template for FastAPI + React Projects. Using PostgreSQL, SQLAlchemy, and Docker
-
indico
Indico - A feature-rich event management system, made @ CERN, the place where the Web was born.
-
mixer
Mixer -- Is a fixtures replacement. Supported Django, Flask, SqlAlchemy and custom python objects. (by klen)
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
OK -
can we start considering binary files committed to a repo, even as data for tests, to be a huge red flag, and that the binary files themselves should instead be generated at testing time by source code that's stated as reviewable cleartext. This would make it much harder (though of course we can never really say "impossible") to embed a substantial payload in this way.
when binary files are part of a test suite, they are typically trying to illustrate some element of the program being tested, in this case a file that was incorrectly xz-encoded. Binary files like these weren't typed by hand, they will always ultimately come from something plaintext source.
Here's an example! My own SQLAlchemy repository has a few binary files in it! https://github.com/sqlalchemy/sqlalchemy/blob/main/test/bina... oh noes. Why are those files there? well in this case I just wanted to test that I can send large binary BLOBs into the database driver and I was lazy. This is actually pretty dumb, the two binary files here add 35K of useless crap to the source, and I could just as easily generate this binary data on the fly using a two liner that spits out random bytes. Anyone could see that two liner and know that it isn't embedding a malicious payload.
If I wanted to generate a poorly formed .xz file, I'd illustrate source code that generates random data, runs it through .xz, then applies "corruption" to it, like zeroing out the high bit of every byte. The process by which this occurs would be all reviewable in source code.
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.
Project mention: Show HN: Hashquery, a Python library for defining reusable analysis | news.ycombinator.com | 2024-04-23I 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/
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.
Project mention: Show HN: Teable β Open-Source No-Code Database Fusion of Postgres and Airtable | news.ycombinator.com | 2024-03-11Congratulations 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.
Project mention: Tool to manage participant invitations at regulars' table | /r/selfhosted | 2023-08-29
Python Sqlalchemy related posts
- Xz/liblzma: Bash-stage Obfuscation Explained
- Alembic with Async SQLAlchemy
- 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
-
A note from our sponsor - InfluxDB
www.influxdata.com | 23 Apr 2024
Index
What are some of the best open-source Sqlalchemy projects in Python? This list will help you:
Project | Stars | |
---|---|---|
1 | sqlmodel | 12,894 |
2 | SQLAlchemy | 8,750 |
3 | flask-sqlalchemy | 4,149 |
4 | ibis | 4,074 |
5 | databases | 3,697 |
6 | factory_boy | 3,402 |
7 | flask-base | 2,978 |
8 | GINO | 2,635 |
9 | alembic | 2,456 |
10 | mathesar | 2,196 |
11 | fastapi-react | 2,062 |
12 | sandman2 | 1,983 |
13 | aiomysql | 1,701 |
14 | PyHive | 1,665 |
15 | indico | 1,649 |
16 | ormar | 1,573 |
17 | sqladmin | 1,564 |
18 | eventsourcing | 1,400 |
19 | aiopg | 1,374 |
20 | eralchemy | 1,075 |
21 | flask-bones | 992 |
22 | graphene-sqlalchemy | 969 |
23 | mixer | 929 |
Sponsored