ibis-datasette
twitter-to-sqlite
ibis-datasette | twitter-to-sqlite | |
---|---|---|
1 | 2 | |
11 | 395 | |
- | 0.0% | |
0.0 | 0.0 | |
over 1 year ago | over 1 year ago | |
Python | Python | |
BSD 3-clause "New" or "Revised" License | Apache License 2.0 |
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.
ibis-datasette
-
ibis-datasette: Query datasette servers without writing a line of SQL
To help acquaint myself with more of the internals, I hacked up a new backend for querying [datasette](datasette.io/) servers. Datasette is a multi-tool for publishing and exploring SQLite databases. It's an excellent tool, I cannot recommend it enough.
twitter-to-sqlite
-
Using Datasette for an ELT Personal Twitter Data Warehouse
Keep in mind that all of this is automatically generated from a sqlite table (which itself was automatically generated by running twitter-to-sqlite), greatly reducing the bar for GUI-based, SQL-based EDA.
-
sqlite-utils - my Python library and CLI tool for manipulating SQLite databases
I've been using the sqlite_utils Python library to build a whole suite of tools for importing data from various different sources into SQLite, including healthkit-to-sqlite, swarm-to-sqlite, twitter-to-sqlite, inaturalist-to-sqlite, google-takeout-to-sqlite, github-to-sqlite, genome-to-sqlite, pocket-to-sqlite, hacker-news-to-sqlite, evernote-to-sqlite.
What are some alternatives?
healthkit-to-sqlite - Convert an Apple Healthkit export zip to a SQLite database
hacker-news-to-sqlite - Create a SQLite database containing data pulled from Hacker News
github-to-sqlite - Save data from GitHub to a SQLite database
datasette - An open source multi-tool for exploring and publishing data
google-takeout-to-sqlite - Save data from Google Takeout to a SQLite database
inaturalist-to-sqlite - Create a SQLite database containing your observation history from iNaturalist
evernote-to-sqlite - Tools for converting Evernote content to SQLite
pocket-to-sqlite - Create a SQLite database containing data from your Pocket account
simonw - https://simonwillison.net/2020/Jul/10/self-updating-profile-readme/
swarm-to-sqlite - Create a SQLite database containing your checkin history from Foursquare Swarm
genome-to-sqlite - Import your genome into a SQLite database