#sqlite
5 posts tagged “sqlite”.
- admin
- backups
- deployment
- design
- docker
- listens
- media
- meta
- newtab
- notes
- projects
- simkl
- spotify
- sqlite
- svelte
- sveltekit
- tailwind
- ui
- unsplash
- watchlist
Jul 21, 2026 · 5 min read
Building /notes as a force-directed graph, then rebuilding it for mobile
A canvas full of notes connected by springs is a fine idea for a mouse and a keyboard. It has nothing to say to a phone — so the mobile version isn't a responsive tweak, it's a second app sharing one state tree.
- notes
- sqlite
- svelte
- ui
Jul 20, 2026 · 3 min read
A media library, an admin area that feels like one, and backups that diff
Three admin-area gaps that all trace back to the same root cause — nothing here persisted or gave feedback the way it should — and the git-based backup job that ties them together.
- admin
- sqlite
- backups
- media
Jul 20, 2026 · 2 min read
A weekly heatmap, a project lightbox, and swapping a callout for a sparkline
Three small, unrelated features shipped together, tied by the same idea — once data already lives in SQLite, another way to look at it is just another query.
- listens
- spotify
- sqlite
- ui
Jul 20, 2026 · 4 min read
Turning /newtab into an actual dashboard
A browser new-tab page needs to survive being reopened fifty times a day — that constraint shaped everything from the background photo cache to the layout system more than any feature idea did.
- newtab
- sqlite
- unsplash
Jul 18, 2026 · 3 min read
Building /listens from a Spotify data export instead of an API
Spotify's API only gives you the last ~50 plays. Getting real history — and years of stats out of it — meant starting from my own data export instead.
- spotify
- listens
- sqlite