db-to-sqlite
twitter-to-sqlite
db-to-sqlite | twitter-to-sqlite | |
---|---|---|
1 | 2 | |
334 | 395 | |
- | 0.0% | |
0.0 | 0.0 | |
about 1 year ago | over 1 year ago | |
Python | Python | |
Apache License 2.0 | 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.
db-to-sqlite
-
Show HN: I built an open-source data copy tool called ingestr
I was surprised to see SQLite listed as a source but not as a destination. Any big reasons for that or is it just something you haven't got around to implementing yet?
I've been getting a huge amount of useful work done over the past few years sucking data from other systems into SQLite files on my own computer - I even have my own small db-to-sqlite tool for this (built on top of SQLAlchemy) - https://github.com/simonw/db-to-sqlite
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?
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
healthkit-to-sqlite - Convert an Apple Healthkit export zip to a SQLite database
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
ibis-datasette - An ibis backend for querying datasette