graphql-sqlalchemy
flask-sqlalchemy
graphql-sqlalchemy | flask-sqlalchemy | |
---|---|---|
1 | 11 | |
17 | 4,154 | |
- | 0.4% | |
0.0 | 7.9 | |
7 months ago | 6 days ago | |
Python | Python | |
MIT License | BSD 3-clause "New" or "Revised" License |
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.
graphql-sqlalchemy
-
Listen to your to PostgreSQL database in realtime via WebSockets
For Python folks, this library builds a GraphQL schema from your SQLAlchemy models: https://github.com/gzzo/graphql-sqlalchemy
flask-sqlalchemy
-
Voting webapp saves votes locally, but not on server
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.
-
How to build an API using Flask
Flask-SQLAlchemy: An extension that integrates SQLAlchemy with Flask. You can install it using pip install flask-sqlalchemy.
-
How to dynamically generate graphics and PDFs using Python an jinja
flask-sqlalchemy: ORM for database access
-
pagination in flask
I've made several runs at stripping the essential paginating functionality of flask-sqlalchemy for use with things like lists. That's where I'd start.
-
Connect Flask APP to Two Already Existing Tables in two distinct databases
You can either use an ORM, which might be sqlalchemy, possibly wrapped up as a flask plugin https://flask-sqlalchemy.palletsprojects.com/ or more directly: https://www.sqlalchemy.org/
-
Methods for dynamically loading test db data
You can learn more about this approach and see an example is this Flask-SQLAlchemy PR.
-
Usage of Restful API + Database with Flask
Flask SQL Alchemy
-
I built an Image Search Engine using OpenAI CLIP and Images from Wikimedia
I used for this project Flask and OpenAI CLIP. For the vector search I used approximate nearest neighbors provided by spotify/annoy. I used Flask-SQLAlchemy with GeoAlchemy2 to query GPS coordinates. The embedding was done using UMAP using the CLIP image vectors.
-
I uninstalled an reinstalled sqalalchemy to get the latest version. Now my flask app won't work.
This appears to be this: https://github.com/pallets/flask-sqlalchemy/issues/910
-
Problem with circular imports and app context
from sqlalchemy.engine.reflection import Inspector from sqlalchemy.schema import DropConstraint, DropTable, MetaData, Table from extensions import db # from dotmap import DotMap def try_add(object): """ Try to add the column 'object' to its table in the database and return it. """ try: db.session.add(object) db.session.commit() return object except Exception: db.session.rollback() raise def drop_all_cascade(): """(On a live db) drops all foreign key constraints before dropping all tables. Workaround for SQLAlchemy not doing DROP ## CASCADE for drop_all() (https://github.com/pallets/flask-sqlalchemy/issues/722) """ con = db.engine.connect() trans = con.begin() inspector = Inspector.from_engine(db.engine) # We need to re-create a minimal metadata with only the required things to # successfully emit drop constraints and tables commands for postgres # (based on the actual schema of the running instance) meta = MetaData() tables = [] all_fkeys = [] for table_name in inspector.get_table_names(): fkeys = [] for fkey in inspector.get_foreign_keys(table_name): if not fkey["name"]: continue fkeys.append(db.ForeignKeyConstraint((), (), name=fkey["name"])) tables.append(Table(table_name, meta, *fkeys)) all_fkeys.extend(fkeys) for fkey in all_fkeys: con.execute(DropConstraint(fkey)) for table in tables: con.execute(DropTable(table)) trans.commit()
What are some alternatives?
sqlmodel - SQL databases in Python, designed for simplicity, compatibility, and robustness.
flask-sqlacodegen - :sake: Automatic model code generator for SQLAlchemy with Flask support
SQLAlchemy - The Database Toolkit for Python
sqlalchemy-hana - SQLAlchemy Dialect for SAP HANA
realtime - Broadcast, Presence, and Postgres Changes via WebSockets
sqlalchemy-filters-plus - Lightweight library for providing filtering mechanism for your APIs using SQLAlchemy
apollo-server - 🌍 Spec-compliant and production ready JavaScript GraphQL server that lets you develop in a schema-first way. Built for Express, Connect, Hapi, Koa, and more.
geoalchemy2 - Geospatial extension to SQLAlchemy
nhost - The Open Source Firebase Alternative with GraphQL.
flask-file-upload - Easy file uploads for Flask.
safrs - SqlAlchemy Flask-Restful Swagger Json:API OpenAPI
mentorship-backend - Mentorship System is an application that matches women in tech to mentor each other, on career development, through 1:1 relations during a certain period of time. This is the backend of this system.