Simon WillisonVerifizierter Account

@simonw

Creator of , co-creator Django. Fellow 2020. Collector of . Usually hanging out with and . He/Him

San Francisco, CA
Beigetreten November 2006

Tweets

Du hast @simonw blockiert

Bist du sicher, dass du diese Tweets sehen willst? Das Ansehen von Tweets wird @simonw nicht entblocken.

  1. Angehefteter Tweet
    7. Feb.

    Here's an annotated version of that video with extra links, notes and code samples: I think this is now the best answer I have to the question "what is Datasette?"

    Diesen Thread anzeigen
    Rückgängig machen
  2. vor 10 Stunden

    OK on further thought I don't think my original tweet here was justified - the wider context of that thread is reasonable, I was picking up on specific wording in a single tweet that I took offense so - so my apologies to both and the Chromium team, I over-reacted

    Diesen Thread anzeigen
    Rückgängig machen
  3. vor 11 Stunden

    In this thread: turns out pretty much everyone had a role in Miami Vice early on in their careers

    Rückgängig machen
  4. vor 11 Stunden

    It's likely I'm over-reacting to some clumsy wording in the tweet I originally tweeted here - it hit a bit of a nerve for me!

    Diesen Thread anzeigen
    Rückgängig machen
  5. vor 11 Stunden

    The document linked to in this tweet is absolutely worth reading, it provides a much more detailed and nuanced description of the Chromium team's attitude to breaking changes

    Diesen Thread anzeigen
    Rückgängig machen
  6. vor 11 Stunden

    But it's not OK to imply that breaking changes on the web should be common and expected - they need to stay as rare as possible and have extremely strong, universally discussed justification

    Diesen Thread anzeigen
    Rückgängig machen
  7. vor 11 Stunden

    The rationale for this particular breaking change makes OK sense to me - if something causes major trust/safety issues (see SameSite cookies - ) I think breakage can be justified

    Diesen Thread anzeigen
    Rückgängig machen
  8. vor 12 Stunden

    Aaron is more eloquent than I, and has experience developing web browsers

    Diesen Thread anzeigen
    Rückgängig machen
  9. vor 12 Stunden

    No, no, no, no! One of the best things about developing for the web is that, as a rule, browsers don't break old code. Expecting every website and application to have an active team of developers maintaining it at all times is not how the web should work!

    Diesen Thread anzeigen
    Rückgängig machen
  10. vor 17 Stunden

    by is crammed with useful tips like this one

    Diesen Thread anzeigen
    Rückgängig machen
  11. vor 18 Stunden

    Looks like PostgreSQL supports that too, and there are ways of achieving the same thing with a CASE statement in other databases:

    Diesen Thread anzeigen
    Rückgängig machen
  12. vor 18 Stunden

    Just found out SQLite supports filter clauses on aggregates! select year, sum(revenue) filter (where month = 1) as jan_revenue, sum(revenue) filter (where month = 2) as feb_revenue from invoices group by year

    Screenshot of the linked article, showing how to use sqlite-utils to insert CSV example data and then run the SQL query against it
    Diesen Thread anzeigen
    Rückgängig machen
  13. vor 18 Stunden

    Started putting together an interactive Jupyter+Binder tutorial for my sqlite-utils Python library - still very much in progress but you can try out the first version of it on Binder here:

    Rückgängig machen
  14. vor 20 Stunden

    SmartThings uses the meaningless "Lifestyle" subheading too

    Diesen Thread anzeigen
    Rückgängig machen
  15. vor 20 Stunden

    The word "Roomba" does not appear anywhere in the iRobot Home listing. Good thing I happen to know which company manufactures the Roomba! This is the same issue that lead me to get scammed by the "Smart Things" (as opposed to SmartThings) app a while ago

    Diesen Thread anzeigen
    Rückgängig machen
  16. vor 20 Stunden

    Got a new Roomba. Searched "roomba" on the App Store to install the remote control app for it. First result (sponsored) is an in-app purchase scam app called "Vacuum Robot Control App" The official app I was looking for comes next: "iRobot Home", subtitle "Lifestyle"

    Screenshot of the search results as described in my tweet
    Diesen Thread anzeigen
    Rückgängig machen
  17. vor 22 Stunden

    Urgh, smart light switches. If we're going to get some are there any good guides to which ones are the easiest to write custom code against?

    Rückgängig machen
  18. 4. Aug.

    I learn so much about film making from Todd's conversations like this one

    Rückgängig machen
  19. 4. Aug.

    This list of things that have changed with Delta is sobering

    Rückgängig machen
  20. 3. Aug.

    Anyone seen a good analysis of exactly why Fleets didn't work on Twitter? It intuitively didn't feel like a good fit for the platform to me, but I'd love to see something backed up by actual surveys and research as opposed to random opinions

    Rückgängig machen
  21. hat retweetet
    3. Aug.

    We're building better voting tech for American elections. Simple, affordable, transparent. And we just opened two spots for engineers. Work anywhere in the US. Help make democracy better. Downside: I do dad jokes. Upside: you may snort or roll your eyes, all feedback welcome.

    Rückgängig machen

Das Laden scheint etwas zu dauern.

Twitter ist möglicherweise überlastet oder hat einen vorübergehenden Schluckauf. Probiere es erneut oder besuche Twitter Status für weitere Informationen.

    Vielleicht gefällt dir auch

    ·