us-counties-datasette
twitter-to-sqlite
| us-counties-datasette | twitter-to-sqlite | |
|---|---|---|
| 1 | 2 | |
| 9 | 399 | |
| - | 0.0% | |
| 0.0 | 0.0 | |
| over 1 year ago | over 1 year ago | |
| Shell | Python | |
| - | 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.
us-counties-datasette
-
SpatiaLite: A Spatial Extension to SQLite
It had been quite a while since a major release, but then SpatiaLite 5.0 came out a couple of months ago with some very significant new features - the K-Nearest-Neighbor stuff is particularly interesting. https://www.gaia-gis.it/fossil/libspatialite/wiki?name=5.0.0...
I've built a few fun demos using SpatiaLite and Datasette. Here's an API that tells you the timezone for a latitude longitude point:
https://timezones-api.datasette.io/timezones/by_point?longit... - implementation here: https://github.com/simonw/timezones-api
And here's the same thing for which US county a point is within: https://us-counties.datasette.io/counties/county_for_latitud... - implementation here: https://github.com/simonw/us-counties-datasette
I've also built an experimental Datasette plugin that lets you draw a shape on a Leaflet map to generate a GeoJSON polygon, then uses SpatiaLite to show you geometries that are contained by that drawn polygon. I wrote about that here: https://simonwillison.net/2021/Jan/24/drawing-shapes-spatial...
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?
timezones-api - A Datasette-powered API for finding the time zone for a latitude/longitude point
healthkit-to-sqlite - Convert an Apple Healthkit export zip to a SQLite database
laion-aesthetic-datasette - Use Datasette to explore LAION improved_aesthetics_6plus training data used by Stable DIffusion
github-to-sqlite - Save data from GitHub to a SQLite database
til - Today I Learned
hacker-news-to-sqlite - Create a SQLite database containing data pulled from Hacker News
sqlite-utils - Python CLI utility and library for manipulating SQLite databases
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
datasette - An open source multi-tool for exploring and publishing data
evernote-to-sqlite - Tools for converting Evernote content to SQLite
swarm-to-sqlite - Create a SQLite database containing your checkin history from Foursquare Swarm