ComputerGuru

5 ms·

181.
by ComputerGuru 7mo ago
No one thinks only corporations have to sacrifice; they do think that it's folly to ask individual members of society, who on average contribute the smallest overall proportion to global warming, to sacrifice while corporations continu
182.
by ComputerGuru 7mo ago
A supporting point and a counterpoint: * Good database drivers will let you pipeline multiple queries concurrently (esp. in languages with async support), effectively eliminating the _N_x roundtrip cost (you can even execute them in paralle
183.
by ComputerGuru 7mo ago
Wow, the in-browser preview is excellent . I first assumed it was just a demonstration and appreciated it very much, but then I realized it was live-editable and was blown away.
184.
by ComputerGuru 7mo ago
I haven’t been able to swipe-type “you” (on qwerty us) for two+ years now – it autocorrects to “your” every single time.
185.
by ComputerGuru 7mo ago
This isn't planned to be exclusively on-device. Siri isn't exclusively on-device now, to begin with.
186.
by ComputerGuru 7mo ago
The counterpoint to that is you aren't trusting any random wifi signal strong enough to reach your device to be telling the truth about the time!
187.
by ComputerGuru 7mo ago
That was my first FRAM experience, too. Good chip, good times. Insanely low power draw!
188.
by ComputerGuru 7mo ago
This is more resourceful than what I once did, which was set up an atomic clock "repeater" to get analog atomic clocks (one in each room) in a site to actually receive the signal in a 1930s structure made of solid brick and concre
189.
Recreating Epstein PDFs from raw encoded attachments(neosmart.net)
544 points by ComputerGuru 8mo ago|201 comments
190.
by ComputerGuru 8mo ago
Email from Epstein to Epstein, with some details that stretch the imagination.
191.
by ComputerGuru 8mo ago
It’s also not four weeks, they’ve been deprecated api models for some time now.
192.
by ComputerGuru 8mo ago
Everyone keeps saying that but I’ve found it to be incredibly weak in the real world every single time I’ve reached for it. I think it’s benchmaxxed to an extent.
193.
by ComputerGuru 8mo ago
I remembered it being higher, but you are correct. All “technical help” (coding + data analysis + math) is 7.5%, with coding only being 4.2% as of June 2025 [0]. Note that there is a separate (sub)category of seeking information -> speci
194.
by ComputerGuru 8mo ago
Not that I’m aware. Models can be fairly seamlessly switched even mid-conversation, so this is unlikely to affect history.
195.
by ComputerGuru 8mo ago
You can’t ask GPT to assess the situation. That’s not the kind of question you can count on a an LLM to accurately answer. Playing with the system prompts, temperature, and max token output dials absolutely lets you make enough headway (wit
196.
by ComputerGuru 8mo ago
Not true. People can rationally know what they want but still be tempted by the poorer alternative. If you ask me if I want to eat healthy and clean and I respond on the affirmative, it’s not a “gotcha” if you bait me with a greasy cheesebu
197.
by ComputerGuru 8mo ago
Being only slightly more performant than an interpreted GC-only language is hard to believe (even though typescript is just a spec and you probably meant slightly more performant than v8).
198.
by ComputerGuru 8mo ago
BSG had notably muted sounds from interstellar explosions.
199.
by ComputerGuru 8mo ago
Yes, as in there’s no reason Linux can’t clean up its game the same way.
200.
by ComputerGuru 8mo ago
On Windows this was always easier because, for some reason, most everyone respected %appdata% compared to XDG_CONFIG_HOME, but also because hidden files wasn’t just a naming convention but an actual separate metadata flag.
201.
Portable Cartesian brace expansion in your shell(neosmart.net)
1 points by ComputerGuru 8mo ago|0 comments
202.
by ComputerGuru 8mo ago
> even though most people would agree that I'm not killing immorally. They’d only agree in the abstract. As soon as you name the oppressive regime you’re fighting against, suddenly a huge chunk of those people will come up with reas
203.
by ComputerGuru 8mo ago
I guess that depends on the definition of corrupted. It just describes what to do when the WAL is corrupt, but doesn’t say what conditions are considered corrupt. (We use ZFS so I haven’t run into torn writes.)
204.
by ComputerGuru 8mo ago
If you lose the WAL you lose the data since the last merge but there’s no risk of corruption. The WAL handles missed syncs fine, too, missing losing just that window of data. I don’t know if or how Postgres records the transaction number in
205.
by ComputerGuru 8mo ago
Minor correction: you don’t even have to guarantee the data is monotonic, it just performs best when it mostly is (good example is when handling incoming timestamps data on the server so messages/rexords are only generally monotonic bu
206.
by ComputerGuru 8mo ago
Virtual columns are basically one or two minor patches from being fully done. Pg18 brought us most of the way there. Hash indices have long been crippled; they shipped almost unusable but every few years get a good QoL update. I think autom
207.
by ComputerGuru 8mo ago
Sibling comment mentions less space but also your alternative doesn’t (naively) handle supporting values that differ but hash to the same value. Of course the hash index also outperforms a unique (btree) index on top of separately calculati
208.
by ComputerGuru 8mo ago
Maybe? I wasn’t under the impression these could be reliably lost or out of sync without risking data loss?
209.
by ComputerGuru 8mo ago
The no unique constraint using hash index thing is something I always run into. Am I missing something or is it just glue code missing to translate that syntax to a exclusion constraint with a hash index, allowing foreign keys to reference
210.
by ComputerGuru 8mo ago
Another option would be a good way of placing indexes on a different physical disk. You could use fast, ephemeral storage like you can for a WAL without amplifying the writes to the same device that is your expensive bottleneck. You could r

More ›