shillelagh
dj
shillelagh | dj | |
---|---|---|
7 | 1 | |
354 | 27 | |
- | - | |
8.0 | 9.8 | |
6 days ago | 1 day ago | |
Python | Python | |
MIT License | 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.
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!
dj
-
Need inspo
DJ (https://github.com/datajunction/dj) is a metric repository, where metrics are defined in ANSI SQL and can be translated on the fly to different databases. The project is relatively new, but promising.
What are some alternatives?
superset - Apache Superset is a Data Visualization and Data Exploration Platform
PyAthena - PyAthena is a Python DB API 2.0 (PEP 249) client for Amazon Athena.
sqlalchemy-filters-plus - Lightweight library for providing filtering mechanism for your APIs using SQLAlchemy
pyodbc - Python ODBC bridge
fastapi-crudrouter - A dynamic FastAPI router that automatically creates CRUD routes for your models
q - q - Run SQL directly on delimited files and multi-file sqlite databases
PyHive - Python interface to Hive and Presto. 🐝
ExcelStuff - Various Tools in Excel