3931. Analyzing iMessage with SQL (arctype.com)
142 points | 2022 | author dliff showed up | their comment | thread
“I have sent/received 643,576 messages since 2009 which totaled 590MB. To my knowledge media is never stored in the SQL database (for iMessage).”
3932. What would open sourcing the Twitter algorithm actually look like? (transitivebullsh.it)
142 points | 2022 | author transitivebs showed up (and submitted it) | their comment | thread
“I needed to split this up into multiple posts because it required a lot deeper dive than I had originally expected. What I'm really interested in, however, is help with…”
3933. Cameras and Open Source Smartphones: It’s Complicated (puri.sm)
142 points | 2022 | author dcz_self showed up | their comment | thread
“While the essay comes from the side of smartphones, it's not really limited to them. As I mention, even some laptops use setups that require complex infrastructure to…”
3934. Map Data: False Assumptions (solutionspace.blog)
142 points | 2022 | author dme1 showed up | their comment | thread
“Thanks for reading my stuff! :-) I did not go into details of geopolitical issues because I covered that in an earlier article:”
3935. Smolnes: A NES emulator in less than 5000 significant bytes of C++ (github.com)
142 points | 2022 | author binji showed up | their comment | thread
“Happy to answer any questions y'all have”
3936. Decentralized Syndication – The Missing Internet Protocol (tautvilas.lt)
142 points | 2025 | author brisky showed up (and submitted it) | their comment | thread
“Regarding backdating it is a valid concern. I did not mention in the article, but in my proposed architecture users could post links of others (consider that a retweet).…”
3937. Geocoding APIs compared: Pricing, free tiers and terms of use (bitoff.org)
142 points | 2025 | author janv showed up | their comment | thread
“First of all: I didn't submit it to HN. As few people pointed out, this article was written in 2023 and it's intentionally focused just on pricing – I planned a follow…”
3938. Land of Lisp: Learn to Program in Lisp, One Game at a Time (oreilly.com)
141 points | 2010 | author drcode showed up | their comment | thread
“I'm the author- The book is printing as we speak and should be hitting the stores late Oct/early Nov. Around that time a lot more info on the book will also be available…”
3939. Nothing is certain, except death and taxes .. and chargebacks (blog.balancedpayments.com)
141 points | 2013 | author npcomplete showed up | their comment (+1 more) | thread
“Thanks! There are certain aspects of fraud which can be open and will definitely help the community of anti-fraudsters. This was our way of contributing something back.”
3940. Don't write code first (blog.reemer.com)
141 points | 2013 | author kareemm showed up | their comment | thread
“This is demonstrably not true.”
3941. Can Namecoin obsolete ICANN (and more)? (theumlaut.com)
141 points | 2014 | author elidourado showed up | their comment | thread
“Just wanted to add that if any of you work for companies that send engineers to the IETF, there is an Internet-Draft RFC that would normalize the use of several P2P…”
3942. How I learned to stop worrying and love React (firstdoit.com)
141 points | 2015 | author gadr90 showed up | their comment | thread
“Woke up to a lot of unexpected traffic on the blog. I hope you like this article. I took a long time to understand React and, now I do, I hope other people don't take as…”
3943. Academics, we need to talk (matt-welsh.blogspot.com)
141 points | 2016 | author mdwelsh showed up | their comment | thread
“Ad hominem attacks aside, I do think it's a big deal if a bunch of academics are spending time working on the wrong things, if for no better reason than maximizing…”
3944. Show HN: Procedural Voxel Rendering in WebGL (guillaumechereau.github.io)
141 points | 2016 | author guillaumec showed up (and submitted it) | their comment | thread
“this is simply using a bump texture.”
3945. Copy and paste-friendly Go crypto (github.com)
141 points | 2016 | author gtank showed up | their comment | thread
“glad you enjoyed the talk! Looking into it more I noticed that there's a Go implementation[1] that is noted to be constant-time with a !amd64 build tag. So it isn't just…”
3946. Zero-knowledge proofs, Zcash, and Ethereum (medium.com)
141 points | 2017 | author mhluongo showed up (and submitted it) | their comment | thread
“Sorry it didn't gel with you, but I'm happy to defend this example. A zero-knowledge proof is about a prover convincing a verifier they have some knowledge, without…”
3947. Fun with compute shaders and fluid dynamics (blog.kummerlaender.eu)
141 points | 2019 | author akr showed up | their comment | thread
“Thanks for the interesting links! I agree that there is much that could be optimized. The choice to use vertex buffers was driven by the overarching goal of implementing…”
3948. V100 Server On-Prem vs. AWS P3 Instance Cost Comparison (lambdalabs.com)
141 points | 2019 | author sabalaba showed up | their comment | thread
“I agree with a lot of your points, especially the fact that TCO is practically impossible to calculate, is highly subjective, and should ideally include opportunity…”
3949. Speculating on the Animal Crossing Turnip Market (insignificantbits.com)
141 points | 2020 | author scast showed up | their comment (+1 more) | thread
“For sure, I hinted at this on the last paragraph of the post. The interesting bit is that if you do that you will build a more diversified portfolio (as the turnip price…”
3950. Covid-19: The T Cell Story (berthub.eu)
141 points | 2020 | author ahubert showed up | their comment | thread
“the article has been read and retweeted by actual world class experts. Given that the article is now nearly two weeks old, I would have heard about any gross…”
3951. Engineering Dropbox Transfer: Making simple even simpler (dropbox.tech)
141 points | 2020 | author nicksundin showed up (and submitted it) | their comment | thread
“Happy to answer questions!”
3952. Show HN: Lunatic – Actor System for Rust/WebAssembly (github.com)
141 points | 2020 | author bkolobara showed up (and submitted it) | their comment | thread
“Hi! Author here. I wrote more about the motivation behind Lunatic if you are interested, check it out:”
3953. Write an SQL query builder in 150 lines of Python (death.andgravity.com)
141 points | 2021 | author genericlemon24 showed up (and submitted it) | their comment | thread
“Yup, good thing to note, thank you! I've kinda assumed everyone knows about the named parameters some bindings offer, but that's probably not true. Will add a…”
3954. RETRO is fast (mitchgordon.me)
141 points | 2022 | author bitforger showed up | their comment | thread
“Hey! Author here. I've noticed on certain mobile devices the contrast can be weird, not sure why. I updated the default theme's text color to be 10% darker, lmk if that…”
3955. Password protect a static HTML page, decrypted in-browser in JavaScript (github.com)
141 points | 2024 | author yoble showed up | their comment (+1 more) | thread
“I was wondering why I was seeing plenty of people from github on my meditation website so I checked HN, hi! Happy to answer any question you might have, and feel free to…”
3956. Inside a Ferroelectric RAM Chip (righto.com)
141 points | 2024 | author kens showed up | their comment | thread
“Author here if anyone has questions about ferroelectric RAM...”
3957. Requiem for a Solar Plant (7goldfish.com)
141 points | 2025 | author giblfiz showed up | their comment (+1 more) | thread
“If you look a little more carefully the thing that killed us was an actual physical infrastructure problem. Mineral rights were a nightmare, but we were humping our way…”
3958. Packing the world for longest lines of sight (tombh.co.uk)
141 points | 2025 | author tombh showed up (and submitted it) | their comment (+1 more) | thread
“Well there's actually a term in the kernel to normalise the surface area of each visible point by a factor of tan(1 radian): I don't know if that's related to what…”
3959. The stack circuitry of the Intel 8087 floating point chip, reverse-engineered (righto.com)
141 points | 2025 | author kens showed up | their comment | thread
“Author here for your 8087 questions...”
3960. “You should never build a CMS” (sanity.io)
141 points | 2025 | author kmelve showed up | their comment (+2 more) | thread
“Of course, I'm biased! But in that bias is a ton of experience in the CMS field and a lot of observation of actual teams trying to solve for content operations…”