simonw

48 ms·

901.
DOOMQL – what if SQLite were the game engine?(github.com)
2 points by simonw 4mo ago|2 comments
902.
by simonw 4mo ago
Is this really an expensive problem to solve? Give Google a continuous feed of the weather data which they cache locally. I can't imagine that being a particularly expensive thing to operate - no need to reply to an API call from Googl
903.
by simonw 4mo ago
Their donors. In the USA members of congress spend an embarrassingly large amount of their time on the phone to their donors ensuring they are happy enough to fund their next run. January 2013: https://www.huffpost.com/entry
904.
by simonw 4mo ago
What's not accurate?
905.
by simonw 4mo ago
What bad things to you anticipate Anthropic doing with your secrets, env vars, and certificates?
906.
by simonw 4mo ago
For a macOS app you don't need a simulator. For an iPhone app I've seen Claude Code launch the simulator without me needing to open Xcode.
907.
by simonw 4mo ago
Which OpenAI model/API do you mean?
908.
by simonw 4mo ago
I also got a hint from this that he worries the community would reject features in Redis (and Redis itself) if they expected that the code has not been human-reviewed. I'm facing this with some of my own open source projects: I feel a
909.
by simonw 4mo ago
I think "skill issue" is often deployed (including here) as a shortcut for what you said - "the only thing stopping them is that no one has helped them understand". (I try not to say "skill issue" myself becaus
910.
by simonw 4mo ago
Important to clarify that this was not the Grok agent deciding to read the files. I don't think the LLM had anything to do with this decision at all. It looks like the Grok tool starts a session by deterministically kicking off a ful
911.
by simonw 4mo ago
The Sam Vimes theory of socioeconomic unfairness: https://en.wikipedia.org/wiki/Boots_theory
912.
by simonw 4mo ago
Right, the transcript is linked from the issue: https://github.com/simonw/sqlite-utils/issues/787#issuecomme... As far as I can tell I've shared more prompt transcripts than anyone else . Happy to be pr
913.
by simonw 4mo ago
A lot of mathematicians are worried: https://arstechnica.com/tech-policy/2026/06/mathematicians-w...
914.
by simonw 4mo ago
Thanks for the nudge, I just added a new test explicitly covering this: https://github.com/simonw/sqlite-utils/commit/d71420065903ff...
915.
by simonw 4mo ago
The person making the tweaks to the harness is the one taking accountability for fixing those mistakes - they're the DRI in this scenario.
916.
by simonw 4mo ago
It uses "PRAGMA foreign_keys=0" and "PRAGMA defer_foreign_keys= ON" before running the transformation, then resets those settings afterwards: https://github.com/simonw/sqlite-utils/blob/3f0
917.
by simonw 4mo ago
> Unfortunately, I don’t think there’s a way to ALTER a table to make it strict. I think you have to copy the data out of the non-strict table into the strict one. This inspired me to add a feature to my sqlite-utils Python library and C
918.
by simonw 4mo ago
Yes, this. For a slightly less dramatic version - you can fire a human if they consistently do the wrong thing despite being told how to do it better. Putting a big ball of matrix arithmetic on a Performance Improvement Plan makes no sense.
919.
by simonw 4mo ago
SQLite very rarely changes defaults because of their commitment to backwards compatibility. They don't want software written against SQLite 3.53 to start throwing errors when upgraded to 3.54 because suddenly `CREATE TABLE` is creating
920.
by simonw 4mo ago
Maybe a useful concept to adopt here is the DRI - Directly Responsible Individual, which is apparently a term first used by Apple. The GitLab Handbook has a good definition: https://handbook.gitlab.com/handbook/people-g
921.
by simonw 4mo ago
It might be worth recreating the git history from scratch in a way that excludes the markdown files - I've used Claude Code and OpenAI Codex to do that in the past with git-filter-branch. Lets you preserve the important history but cle
922.
by simonw 4mo ago
This is an intimidating amount of code! 12,303 lines of C and 244,740 lines of Python, which looks to be a ton of monkeypatching plus huge amounts of test code. Only one commit added all of that, just two hours ago. The published numbers ar
923.
by simonw 4mo ago
The WebAssembly demo that runs in your browser is a really neat touch: https://pgrust.com
924.
by simonw 4mo ago
The test coverage of sqlite-utils is solid - pytest-cov reports 95% total. The project has 9,973 lines of implementation code and 14,860 of test code. Here's the delete_where() test: https://github.com/simonw/sqlit
925.
by simonw 4mo ago
Honestly that's the main value I get from it myself - making a pelican means I have to figure out API keys and how to talk to the provider, or how to run it locally for the local models.
926.
by simonw 4mo ago
A previous employer hit the problem where there were a ton of legacy features that didn't have clear owners and so it wasn't clear where to route bug reports. Their solution was to build a catalog of every feature and then assign
927.
by simonw 4mo ago
It does feel like a chore in weeks like this one where there are new models landing every day. I'm also increasingly worried that I'm not providing enough value in my model reviews. It's really hard to get a useful and credib
928.
by simonw 4mo ago
My blog genuinely is a day job now, I make enough from the (unobtrusive, cookie-free) sponsorship banner that I no longer regret not having a proper software engineering job.
929.
by simonw 4mo ago
The first time I did this was actually less than two years ago - in October 2024 - and it's fun seeing how much better they've got since then: https://simonwillison.net/2024/Oct/25/pelicans-on-a-bicy
930.
by simonw 4mo ago
Someone told me that a model said "oh, the classic" when they asked for this recently. I think that was Opus 4.8.

More ›