simonw VS datasette

Everything @simonw has worked on, honestly: https://github.com/simonw

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.

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

Here's one of mine that runs three times an hour: https://github.com/simonw/simonw/blob/main/.github/workflows/build.yml

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.

I have GitHub sponsors setup: https://github.com/simonw

If you really want to please me, consider sponsoring Simon Willinson the author of the framework I'm relying on .

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!

Simon Willison's github would be a great place to get started imo -

https://github.com/simonw/datasette

I'm a fan on simonw's datasette/dogsheep ecosystem https://datasette.io/

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.

Were you aware of, or tempted by https://datasette.io/ for creating your solution?

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]

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.

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.

> uploads of boring raw excel data and receive a nice UI

https://datasette.io/