7 ms·
Author of the article here. I am surprised to see the post was submitted and made it to the front page! Happy to answer any questions
by letFunny 3mo ago
Author of the article here. I am surprised to see the post was submitted and made it to the front page! Happy to answer any questions
- stevekemp 3mo ago"to prevent multiple from" seems to be missing a word.
- buggymcbugfix 3mo agoThanks for the nice article. The SQLite docs that explain this bug are emphatic about how utterly rare, even irreproducible it is. How, then, was it found, one wonders?
- letFunny 3mo agoMy guess is that they noticed something was not quite right when inspecting the code and then tested their hypothesis manually to see if it was actually a real bug. Something similar happened to me when I was working on some code that should clear the state and, by inspection, I noticed some field was not properly cleared under specific circumstances. Then I tested the hypothesis and indeed found a bug. Sometimes intuition and guessing is what it takes.
- bradfitz 3mo agoWe found it at Tailscale and bought an enterprise support contract from SQLite to debug it for us. Worth every penny. We should probably blog about it.
- doctorpangloss 3mo agoWhat mission critical purpose does sqlite provide at Tailscale exactly? Why use it at all?
- akoboldfrying 3mo agoIt's in Chrome, Firefox, Safari, Windows 10, macOS because it efficiently solves a huge number of use cases while giving plenty of headroom for flexible querying. If you have data more complicated than a single CSV or tab-separated text file that you will only ever process in sequential order, and you don't need inter-process interaction, you should be asking why not use SQLite.
- inigyou 3mo agosqlite is useful everywhere CSV files are useful but you'd like them to have more data integrity and faster updates. sqlite can replace some uses of MySQL, but more commonly it replaces fopen. https://sqlite.org/whentouse.html https://sqlite.org/whentouse.html
- jen20 3mo agoQuite a bit, it seems: https://tailscale.com/blog/database-for-2022 https://tailscale.com/blog/database-for-2022
- sennalen 3mo agoYou’re in a desert walking along in the sand when all of the sudden you look down, and you see a tortoise, it’s crawling toward you. You reach down, you flip the tortoise over on its back. The tortoise lays on its back, its belly baking in the hot sun, beating its legs trying to turn itself over, but it can’t, not without your help. But you’re not helping. Why is that?
- Groxx 3mo agoBecause that would reverse flipping it over the first time, and our universe's physics are not reversible. Thermodynamics demands the turtle stay flipped.
- _doctor_love 3mo agoWhat’s a tortoise?
- wowczarek 3mo agoYou know what a turtle is? Same thing, Leon.
- globnomulous 2mo agoMy mother?
- erikerikson 3mo agoA turtle-like animal that only lives on land.
- CoastalCoder 3mo agoI feel like I'm ignorant of some classical fable here. Is this an allusion?
- calcifer 3mo agoIt's a Blade Runner reference [1]. [1] https://bladerunner.fandom.com/wiki/Voight-Kampff_test https://bladerunner.fandom.com/wiki/Voight-Kampff_test
- deleted 3mo ago[deleted]
- keynha 3mo ago[dead]