PyAthena
flask-sqlalchemy
Our great sponsors
PyAthena | flask-sqlalchemy | |
---|---|---|
1 | 11 | |
447 | 4,149 | |
- | 0.4% | |
9.1 | 8.1 | |
17 days ago | 17 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.
PyAthena
-
Best Practices for AWS Athena Queries
For python there is PyAthena which is a nice little wrapper around boto3 that tries to adhere to the python DB API.
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?
AWS Data Wrangler - pandas on AWS - Easy integration with Athena, Glue, Redshift, Timestream, Neptune, OpenSearch, QuickSight, Chime, CloudWatchLogs, DynamoDB, EMR, SecretManager, PostgreSQL, MySQL, SQLServer and S3 (Parquet, CSV, JSON and EXCEL).
flask-sqlacodegen - :sake: Automatic model code generator for SQLAlchemy with Flask support
pyodbc - Python ODBC bridge
sqlalchemy-hana - SQLAlchemy Dialect for SAP HANA
PyHive - Python interface to Hive and Presto. 🐝
sqlalchemy-filters-plus - Lightweight library for providing filtering mechanism for your APIs using SQLAlchemy
shillelagh - Making it easy to query APIs via SQL
geoalchemy2 - Geospatial extension to SQLAlchemy
athena-glue-service-logs - Glue scripts for converting AWS Service Logs for use in Athena
flask-file-upload - Easy file uploads for Flask.
Redash - Make Your Company Data Driven. Connect to any data source, easily visualize, dashboard and share your data.
graphql-sqlalchemy - Generate GraphQL Schemas from your SQLAlchemy models