crate-python
shillelagh
Our great sponsors
| crate-python | shillelagh | |
|---|---|---|
| 1 | 7 | |
| 78 | 351 | |
| - | - | |
| 8.1 | 8.0 | |
| 6 days ago | 4 days ago | |
| Python | Python | |
| Apache License 2.0 | 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.
crate-python
-
From data storage to data analysis: Tutorial on CrateDB and pandas 2
Python 3.x with the pandas 2 and crate 0.31 packages installed.
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?
chdb-server-bak - API Server for chDB, an in-process SQL OLAP Engine powered by ClickHouse
superset - Apache Superset is a Data Visualization and Data Exploration Platform
SQLAlchemy - The Database Toolkit for Python
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. 🐝
dj - A metrics platform.
ExcelStuff - Various Tools in Excel