datasette
simonw
Our great sponsors
datasette | simonw | |
---|---|---|
187 | 9 | |
8,881 | 380 | |
- | - | |
9.2 | 9.9 | |
6 days ago | 2 days 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.
datasette
-
Ask HN: High quality Python scripts or small libraries to learn from
Simon Willison's github would be a great place to get started imo -
https://github.com/simonw/datasette
- Show HN: TextQuery – Query and Visualize Your CSV Data in Minutes
-
Little Data: How do we query personal data? (2013)
I'm a fan on simonw's datasette/dogsheep ecosystem https://datasette.io/
-
LaTeX and Neovim for technical note-taking
I use Anki the exact same way. After a lifetime of learning I have accepted that I will never read over anything I write for myself voluntarily - so my two options are:
1. Write an article so good I can publish it and look it over myself later on. I did this last year with https://andrew-quinn.me/fzf/, for example.
2. Create Anki cards out of the material. Use the builtin Card Browser or even https://datasette.io/ on the underlying SQLite database in a pinch to search for my notes any time I have to.
-
Daily Price Tracking for Trader Joes
Were you aware of, or tempted by https://datasette.io/ for creating your solution?
- SQLite-Web: Web-based SQLite database browser written in Python
-
Ask HN: What two software products should have a kid?
Browsing HN, GitHub and the like we get to see a huge variety of software products and code bases.
I often see products and think - if this product X, got together with Y, it would be pretty cool - kind of like if they had a kid together.
Not too literally, but more on the conceptual level - my level of programming is low.
E.g. Just some....
- pocketable.io & datasette (+with some more charting) [https://pocketbase.io, https://datasette.io]
-
Ask HN: Looking for a project to volunteer on? (February 2024)
You might like the Datasette project: https://datasette.io/
I don't think they are desperate for contributions but it's a welcoming environment and a fun project to hack on. You'll learn a lot just from reading the source and the incredibly informative PRs. The creator is a really talented developer with a great blog which shows up on the HN front page often.
-
Stuff I Learned during Hanukkah of Data 2023
Last year I worked through the challenges using VisiData, Datasette, and Pandas. I walked through my thought process and solutions in a series of posts.
-
What We Watched: A Netflix Engagement Report – About Netflix
> uploads of boring raw excel data and receive a nice UI
https://datasette.io/
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!
What are some alternatives?
nocodb - 🔥 🔥 🔥 Open Source Airtable Alternative
rupy - HTTP App. Server and JSON DB - Shared Parallel (Atomic) & Distributed
duckdb - DuckDB is an in-process SQL OLAP Database Management System
github-to-sqlite - Save data from GitHub to a SQLite database
sql.js-httpvfs - Hosting read-only SQLite databases on static file hosters like Github Pages
kondo - Cleans dependencies and build artifacts from your projects.
litestream - Streaming replication for SQLite.
google-takeout-to-sqlite - Save data from Google Takeout to a SQLite database
Sequel-Ace - MySQL/MariaDB database management for macOS
hacker-news-to-sqlite - Create a SQLite database containing data pulled from Hacker News
beekeeper-studio - Modern and easy to use SQL client for MySQL, Postgres, SQLite, SQL Server, and more. Linux, MacOS, and Windows.
tera - A template engine for Rust based on Jinja2/Django