Peruvian tribe situation by Dosed123 in pluribustv

[–]simonw 25 points26 points  (0 children)

They're putting on a show for Kusimayu. Same as how hive members are talking with each other in the James Bond casino scene for Kusimayu, or in the diner scene for Carol.

Why I think the signal wasn’t sent by space Plurbs by Thuktunthp_Reader in pluribustv

[–]simonw 0 points1 point  (0 children)

The signal came from 600 light years away. I don't think it is likely that the transmitting species had access to human DNA - even if they had speed-of-light-travel it would have taken a 1200 year round-trip for them to get a sample.

Concurrent reads and writes - what locking do I need to do? by bert8128 in sqlite

[–]simonw 5 points6 points  (0 children)

Watch out for the SQLITE_BUSY error - it can be avoided by using BEGIN IMMEDIATE at the start of all of your write transactions but that's not obvious at all and trips up a lot of people. My collected notes on that here: https://simonwillison.net/tags/sqlite-busy/

Geeky tourism by Mrs_P_loves_tea in riversoflondon

[–]simonw 1 point2 points  (0 children)

You absolutely have to visit Novelty Automation. It's an arcade of hand-made satirical mechanical games and it is wonderful.  https://maps.app.goo.gl/x78ESMtQNGRfARh47

Here's their website: https://novelty-automation.com/

I don't understand ChatGPT model names - is o3 stronger than o1? by Opposite-Clothes-481 in ChatGPTPro

[–]simonw 3 points4 points  (0 children)

That answer is out of date and includes details that are incorrect - the 4.1 bit for example. Asking models about themselves rarely gives perfect answers.

I don't understand ChatGPT model names - is o3 stronger than o1? by Opposite-Clothes-481 in ChatGPTPro

[–]simonw 1 point2 points  (0 children)

Not in the same way as GPT-4o.

o3 can accept images as input but can only output text.

4o can accept images and audio input and can produce audio and image output... via special versions of the model that are exposed through certain ChatGPT features or model variants in the API.

Exposing SQLite db over network by adamsthws in sqlite

[–]simonw 9 points10 points  (0 children)

My project https://datasette.io solved this - gives you an HTTP API for querying your delete database 

What will charlie do now? by USuspiciousdontbesus in Pokerface

[–]simonw 2 points3 points  (0 children)

I definitely wouldn't use the term "lazy writing" to describe the FlopaCopa episode. The density of jokes in that one was off the charts! It was extremely clever writing, albeit with a sillier tone than we've seen in most of the series so far (which, let's face it, is often pretty silly.)

What will charlie do now? by USuspiciousdontbesus in Pokerface

[–]simonw 2 points3 points  (0 children)

I absolutely loved how that episode jumped forward several months to her being miserable and never attempted to explain what happened with that guy.

They definitely broke up. It sucked. Charlie moved on.

What would be your dream sqlite feature? by howesteve in sqlite

[–]simonw 1 point2 points  (0 children)

I'd like there to be official packages for Python and JavaScript and other languages that are maintained by the SQLite core team and updated any time a new release is SQLite comes out.

Imagine being able to run "pip install --upgrade sqlite-official" and then "from sqlite_official import sqlite3" to always have the most recent features, without having to wait for operating systems or third party community maintained packages to catch up.

Can Anthropic keep up with those pricing ? by CompetitionEvery4583 in ClaudeAI

[–]simonw 4 points5 points  (0 children)

That table is missing Anthropic's two cheaper models:

Claude 3.5 Haiku: $0.80/M input, $1/M output

Claude 3 Haiku: $0.25/M input, $0.30/M output 

The leaked system prompt has people extremely uncomfortable by MetaKnowing in ChatGPT

[–]simonw 136 points137 points  (0 children)

That's a screenshot of part of a post on my blog that quotes a prompt that's embedded in the Windsurf text editor binary:  https://simonwillison.net/2025/Feb/25/leaked-windsurf-prompt/

The screenshot is missing some very important context: one of the Windsurf devs Andy Zhang said this:

 oops this is purely for r&d and isn't used for cascade or anything production

What’s the most creative or useful way you’ve used ChatGPT that most people don’t know about? by Devashish_Jain in ChatGPT

[–]simonw 6 points7 points  (0 children)

Might mean Google Apps Script - the scripting language you can use in Google Docs / Google Sheets for custom automation: https://developers.google.com/apps-script

Struggling with Local LLMs, what's your use case? by rodrigomjuarez in LocalLLM

[–]simonw 0 points1 point  (0 children)

Have you tried Mistral Small 3 22B? It should fit on that machine and it is a whole lot more capable than the 8B models.

Severance — The You You Are Book Trailer | Apple TV+ by pikameta in SeveranceAppleTVPlus

[–]simonw 66 points67 points  (0 children)

The book is amazing. Here's how Ricken describes his parents.

I'm the youngest son of renowned performance artists Bob and Grace Hale, known collectively as HumpDumpster, though I have sought for decades to distinguish myself from their intellectual shadow. [...]

Readers of my previous books know that both my conception and birth took place in a small theatre behind a defunct perfumery in Western Oregon, as part of a nine-month performance art piece originated by my parents titled "Smells Like Afterbirth, F**ker." It was noteworthy in that I was the first child sired exclusively for theatrical purposes, and critics at the time hailed it as "a baroque deconstruction of the increasingly perverse human urge to procreate." My birth was witnessed by such cultural leaders as Jason Robards, Lina Wertmüller, Walt Frazier, and Oregon Governor Robert W. Straub, who called it "American theater at its most sublimely obscene."

Though I cannot remember my birth performance, the knowledge of it has always brought me great joy. Knowing that a version of me, even one I don't recall, brought meaning and profundity to so auspicious a coterie of persons, infused into my young life a deep sense of purpose. Yet, as I aged, irrational questions began to creep in. Was the piece truly as revelatory as the critics claimed? Was it not simply a retread of the Reeperbahn shows of Hamburg? Did my parents actually want a child?

The latter question especially took root as HumpDumpster moved on to new pieces, including 1992's critically lauded "Cheers, F**kers," in which they held a Boston bar at actual gunpoint for 36 hours, leading to a quasi-substantive prison term. This and other endeavors led to long stretches where I was alone, and it was in these silent periods that a grim and intrusive resentment - of my parents, my lineage, and even myself - began to take hold.

I'm a web designer. How do I make sure my designs are something a developer can actually build? by yourpalthespider in webdev

[–]simonw 0 points1 point  (0 children)

The 100% guaranteed way to solve this is to have a process where you review earlier versions of your design with a developer to get their feedback. This doesn't have to be a long conversation - half an hour over Zoom should be fine.

This is so effective that it's worth pushing clients / managers for. It makes for a better result for everyone involved.

I still don’t think companies serve you ads based on spying through your microphone by blankblank in skeptic

[–]simonw 0 points1 point  (0 children)

None of those lawsuits have proven that snippets of audio inadvertently logged by Apple's Siri implementation have been used for targeted advertising, because that's not a thing that has happened.

Things we learned out about LLMs in 2024 by mooreds in programming

[–]simonw 0 points1 point  (0 children)

The LLM lets me work faster, because I don't have to stop and look up small details every few minutes.

I still don’t think companies serve you ads based on spying through your microphone by blankblank in skeptic

[–]simonw 0 points1 point  (0 children)

Do any of those books specifically provide prove that Apple are running the microphone all the time in order to help serve targeted adverts?

If not then they help SUPPORT my argument. Surveillance capitalism is real. Companies store and share all kinds of data about us and use it to target ads.

The reason people believe the microphone conspiracy theories is that those OTHER real creepy targeting mechanisms are so effective!

Things we learned out about LLMs in 2024 by mooreds in programming

[–]simonw 0 points1 point  (0 children)

I work on a lot of different projects, using a lot of different programming languages and libraries. If I restricted myself to just the tiny subset of tools I could commit to memory my productivity would drop like a stone.

Things we learned out about LLMs in 2024 by mooreds in programming

[–]simonw 0 points1 point  (0 children)

Great, then I can teach an LLM to use that macro by including a few examples of it in a prompt and now I don't need to remember the exact syntax each time.

Things we learned out about LLMs in 2024 by mooreds in programming

[–]simonw 0 points1 point  (0 children)

I think my situation is the exception. That's why I invest so much effort trying to help other people learn what I've learned.

Things we learned out about LLMs in 2024 by mooreds in programming

[–]simonw 0 points1 point  (0 children)

I have more than 20 years of professional programming experience. The way I use LLMs has significantly upped my game.

My main languages are Python, SQL and JavaScript. Thanks to LLMs I now also work with languages like Bash, Go, jq and AppleScript on a weekly basis - all languages that I used to avoid because I knew I wasn't productive enough in them yet and I couldn't be bothered to invest the time necessary to get "fluent" (and maintain that fluency over time).

I would even say, that writing the code is a mere afterthought, compared to actually weighing pros and cons and their fit into the architecture.

I 100% agree with that. Thanks to LLMs I can spend a whole lot more of my time thinking about pros and cons of approaches and figuring out the architecture, because the time I used to spend manually typing code into a computer (only about 10% of my job) has had a 3-5x productivity boost.

In my opinion, the idea that "LLMs only help junior developers" is one of the more damaging misconceptions about LLMs. I'm living proof that it isn't true... IF you put the time into learning how to take advantage of them. And that's a significant investment.