Hello HN, just read about Pocket shutting down. I migrated away from it 2 years ago and built a small migration tool to transfer the data to Safari‘s reading list. Might be useful for other Safari users :)

Author here. Thank you (and others) for mentioning SELECT FOR UPDATE. Definitely missing at least a footnote in the article.

Note that "one step" updates (e.g., SET followers_count = followers_count + 1) are still not in place. They are regular transactional updates that rewrite the entire row. Still, they can achieve higher throughput because there is no application/database roundtrip between locking and committing.

If it's not an indexed column (and your page isn't too full), it can do a HOT update, which is effectively the same as an in-place write if you're flushing to disk at page granularity anyway unless you have really wide rows.

Those two problems sound like they could differ substantially in perceived business value. Maybe it’s not how hard management think it is, but how valuable?

If management thinks it’s easy and it has big business value - they’re going to understaff it and expect it done tomorrow. Which is gonna hurt someone, and it usually isn’t the execs.

Hi everyone! For anyone who is not familiar with the concept of Jodel: It's an anonymous social networking app. A post is only visible within a distance of 10 kilometers. This is where Jodel Stats jumps in: it lets you see the most popular posts from anywhere in the world. Built using Rails, Bootstrap and Google Maps API :)

For anyone who is not familiar with the concept of Jodel: It's an anonymous social networking app. A post is only visible within a distance of 10 kilometers. This is where Jodel Stats jumps in: it lets you see the most popular posts from anywhere in the world. Built using Rails, Bootstrap and Google Maps API :)