simonw
hacker-news-to-sqlite
simonw | hacker-news-to-sqlite | |
---|---|---|
9 | 4 | |
380 | 43 | |
- | - | |
9.9 | 0.0 | |
8 days ago | about 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.
simonw
-
Ask HN: High quality Python scripts or small libraries to learn from
Everything @simonw has worked on, honestly: https://github.com/simonw
- Datasette is my data hammer
-
How to add coding projects to Github portfolio?
You can create a repo at https://github.com/simonw/simonw (only using your username twice) and the README.md file in there will be used to populate your profile page.
-
Should i keep my forked repos after contribution if i want to use github as resume ?
I'd leave the forked repos there, and then use pinned repositories on your profile to highlight the repositories you are most proud of. You can also use a personal README to customize your profile - I have one here for example: https://github.com/simonw
-
how to run a github action every 6 hours
Here's one of mine that runs three times an hour: https://github.com/simonw/simonw/blob/main/.github/workflows/build.yml
-
How to Build a Dynamic GitHub Profile with GitHub Actions and PHP
As I was browsing examples for some inspiration, I stumbled upon Simon Willison's version, which features some dynamic content like recent work and blog publications. He explained how he used a combination of GitHub Actions and Python to achieve this in a blog post, and I decided to do something similar with PHP.
-
sqlite-utils - my Python library and CLI tool for manipulating SQLite databases
I have GitHub sponsors setup: https://github.com/simonw
-
CALISHOT 2021-08: Find ebooks among 403 Calibre sites
If you really want to please me, consider sponsoring Simon Willinson the author of the framework I'm relying on .
-
Ask HN: What are some tools / libraries you built yourself?
I have 112 mostly-maintained released project listed on https://github.com/simonw/simonw/blob/main/releases.md now - most of which are tools for loading data into SQLite database files (a surprisingly under-served use-case given how ubiquitous SQLite is) and plugins for my https://datasette.io/ project for reading data back out of SQLite again.
I realized a few years ago that SQLite was the perfect tool for doing data analysis at the small-data scale, where small data is less that 10GB which is pretty much everything you might want to analyze - especially for personal projects.
So I've been building tools to fill that niche!
hacker-news-to-sqlite
-
Ask HN: Is there a Hacker News takeout to export my comments / upvotes, etc.?
Partially. https://github.com/dogsheep/hacker-news-to-sqlite
- More people should write (2012)
- “Obtaining My Personal Data from Amazon Was a Nightmare”
-
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?
rupy - HTTP App. Server and JSON DB - Shared Parallel (Atomic) & Distributed
twitter-to-sqlite - Save data from Twitter to a SQLite database
datasette - An open source multi-tool for exploring and publishing data
pocket-to-sqlite - Create a SQLite database containing data from your Pocket account
github-to-sqlite - Save data from GitHub to a SQLite database
ClickHouse - ClickHouse® is a free analytics DBMS for big data
kondo - Cleans dependencies and build artifacts from your projects.
genome-to-sqlite - Import your genome into a SQLite database
google-takeout-to-sqlite - Save data from Google Takeout to a SQLite database
tera - A template engine for Rust based on Jinja2/Django