Dear 43 Things Users,

10 years after introducing 43 Things to the world, we have decided we have met our last goal: completing the incredible experience that has been 43 Things. Please join us in giving one last cheer to all the folks who have shared their goals with the world, as well as all the people who have worked at The Robot Co-op to build this incredible website. We won a Webby Award, published a book, and brought happiness to a lot of people.

Starting today, 43 Things users can export their goals and entries from the site. Starting August 15, we will make the site “read only”. 43 Things users will still be able to view the site and export their content, but we won’t be taking any new content from users. We hope to leave the site up for folks to see and download their content until the end of the year. Ending on New Year’s Eve takes us full circle.

It has been a long ride (one of our original goals was to "build a company that lasts at least 2 years” - we beat that one!) While we wish the site could live on, it has suffered from a number of challenges - changes in how people use the site, the advertising industry, and how search engines view the site. We wish the outcome was different – but we’ve always been realistic about when our goals are met and when they aren't.

As of today, you will be able to download your goals and entries. See more about that on the FAQ page. Thanks for 10 great years of goal-setting and achieving.

- The Robots.

Export My Content

Eric Hodel in Seattle is doing 34 things including…

witness the destruction of mysql

5 cheers


Eric Hodel has written 3 entries about this goal


I’ve now got a tool (almost complete) that slurps in a MySQL DB definition and spits out one for Postgres. I will post a link to it when I get creation of the enum tables working. (Instead of enums, Postgres uses constraints and extra tables.)

I forgot to mention...

I had a few problems moving to FreeBSD 5 with MySQL, which ultimately caused by was shoddy code in InnoDB.


I just rewrote all our in-code SQL queries to be easily recognizable. They now all live in

FOO = <<-SQL
FROM there
WHERE x = 1

This will help us with moving away from MySQL.

Bob has also been exploring Postgres performance, but his results are preliminary

Eric Hodel has gotten 5 cheers on this goal.

  • Josh cheered this 5 years ago
  • Chuq cheered this 8 years ago
  • Random Geek cheered this 9 years ago
  • batkins cheered this 9 years ago
  • dagvl cheered this 9 years ago


I want to:
43 Things Login