HNHacker News
TopNewBestAskShowJobs

ppati000

89 karma · joined July 18, 2015

senior software engineer github/x.com: ppati000
submissionscomments
ppati000··on Pickpocket imports Pocket links to Safari reading list
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 :)
ppati000··on PostgreSQL internals: Things to know about update statements
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.

ppati000··on Evil programmer's tip: avoid “easy” things (2016)
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?
ppati000··on Show HN: Jodel Stats – Best posts from all over the world on (YikYak like) Jodel
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 :)
ppati000··on Show HN: Jodel Stats – View posts from all over the world on (YikYak like) Jodel
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 :)