sqlalchemy-filters-plus
shillelagh
| sqlalchemy-filters-plus | shillelagh | |
|---|---|---|
| 1 | 7 | |
| 43 | 351 | |
| - | - | |
| 0.0 | 8.0 | |
| over 1 year ago | 7 days ago | |
| Python | Python | |
| GNU General Public License v3.0 or later | MIT 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.
sqlalchemy-filters-plus
-
New sqlalchemy filtering library - needs your support!
Hence i thought of dedicating some of my spare time to build sqlalchemy-filters-plus, a library that provides elegant way of constructing filters and fields, also giving the possibility to create custom operators either based on sqlalchemy builtin operators and entirely custom ones and more..
shillelagh
-
Apache Superset
It should be possible (have not tried myself):
https://preset.io/blog/accessing-apis-with-superset/
"Shillelagh (ʃɪˈleɪlɪ) is a Python library and CLI that allows you to query many resources (APIs, files, in memory objects) using SQL. It's both user and developer friendly, making it trivial to access resources and easy to add support for new ones"
https://github.com/betodealmeida/shillelagh
- Python: Making it easy to query APIs via SQL (Shillelagh)
-
Need inspo
Shillelagh (https://github.com/betodealmeida/shillelagh) is a wrapper that allows users to query APIs using SQL. You can join weather data with a Google spreadsheet, for example. It always need more help in adding adapters for new data sources.
-
A library for querying APIs and files using SQL
You can read more about it in the architecture document.
-
Easy way of copying web data to excel.
I'm adding this to Apache Superset today!
-
ELIA5: Spark/Hive syntactical SQL
- Shillelagh (https://github.com/betodealmeida/shillelagh): query API's .. using SQL!
What are some alternatives?
sqlmodel - SQL databases in Python, designed for simplicity, compatibility, and robustness.
superset - Apache Superset is a Data Visualization and Data Exploration Platform
sqlalchemy-filters - Filter, sort and paginate SQLAlchemy query objects. Ideal for exposing these actions over a REST API.
PyAthena - PyAthena is a Python DB API 2.0 (PEP 249) client for Amazon Athena.
flask-sqlalchemy - Adds SQLAlchemy support to Flask
pyodbc - Python ODBC bridge
sandman2 - Automatically generate a RESTful API service for your legacy database. No code required!
fastapi-crudrouter - A dynamic FastAPI router that automatically creates CRUD routes for your models
SQLAlchemy - The Database Toolkit for Python
q - q - Run SQL directly on delimited files and multi-file sqlite databases
PyHive - Python interface to Hive and Presto. 🐝
dj - A metrics platform.