ComputerGuru

6 ms·

61.
by ComputerGuru 2mo ago
> I pay about $0.075 USD per kWh Around here electricity companies quote prices like yours but that is supply only while transmission, taxes, and fees are again as much on top. Is that really all inclusive?
62.
by ComputerGuru 2mo ago
It’s not hard to use libavcodec to transcode, though.
63.
by ComputerGuru 2mo ago
Bandwidth is almost never a concern for databases. The right number to worry about instead is latency.
64.
by ComputerGuru 2mo ago
Very good point, but also unfortunately requires getting into the internals. If you can tolerate it just use fastupdate off.
65.
by ComputerGuru 2mo ago
In practice you’ll never notice the difference between joining on a bigint vs uuid for most OLTP purposes and you’ll be able to generate the uuids in your backend instead of in the db which a) can be very helpful if you’re pre-generating li
66.
by ComputerGuru 2mo ago
The seqscan option being a binary on/off is a bit of a misnomer; what it actually does is set the cost associated with a seqscan to be astronomically high so that other options will be preferred over it. An index on age when you'r
67.
by ComputerGuru 2mo ago
Some comments and corrections: * Use uuidv7 not uuid in general (typically v4) * in addition to minimizing locked records, make sure your locks are ordered deterministically across all queries (eg by id asc, always) or you’ll deadlock (but
68.
by ComputerGuru 2mo ago
There’s no need to get all complicated and fancy or introduce more dependencies. For most people, a cron job calling pg_dump_all piped to zstd and copying the output to s3/ftp/whatever is plenty good enough. Obviously past a certa
69.
by ComputerGuru 2mo ago
It runs easily on a vps at your scale, even the same vps serving your app. That used to mean having a modicum of sysadmin knowhow but it’s straightforward these days, especially if you just use a premade docker file.
70.
by ComputerGuru 2mo ago
So 3.6 Flash is a somewhat of an admission that Google miscalculated by charging 3-5x for 3.5 Flash what it did for 3.0 Flash (3x input and output costs plus large token inefficiency changes) despite only modest improvements? 3.5 Flash Lite
71.
by ComputerGuru 2mo ago
If you mean the new windows 11 emoji, they are some of the ugliest design with I’ve ever seen, and I say this as someone that appreciated the previous windows 10 style despite the hate it got.
72.
by ComputerGuru 2mo ago
It’s insane because it literally breaks everything published with the old emoji to date.
73.
by ComputerGuru 2mo ago
Why did the cat get an evil smirk? It seems like adding rain to the umbrella potentially breaks the existing meaning? What’s the emoji that went from three colored circles on a stick to three completely ambiguous widgets?
74.
by ComputerGuru 2mo ago
> Emoji with the darkest skin tones can be difficult to see in dark mode — a problem for anyone who sends or receives them. That’s why we built an AI-powered contrast tool that analyzes each emoji at the pixel level, flags when the contr
75.
by ComputerGuru 2mo ago
> Apple can make them smaller and put them on the device Someone can, but Apple has essentially admitted defeat and handed the reigns over to Google.
76.
by ComputerGuru 2mo ago
Author also discussing it on their Twitter [0]. I’m reserving judgement for now, but this has lots of potential usecases even apart from replacing postgres. [0]: https://x.com/glcst/status/2077759127682486561?s=46
77.
by ComputerGuru 2mo ago
> This is great Absolutely spectacular, indeed… > and long overdue for outdated devices! I would pause here and reflect. There is zero chance this performs better (speed, latency, memory, battery life, etc) than Safari on iPhones sinc
78.
by ComputerGuru 2mo ago
Why do I have a sneaky feeling Safari for iOS isn’t fully written in a fully memory safe language?
79.
by ComputerGuru 2mo ago
Lol, this post is number one on the leaderboard on the “filtered” list list. Trusting ai slop to filter out ai is as ironic as it gets.
80.
by ComputerGuru 2mo ago
Note that this breaks a lot of core functionality unless you CAST(s as TEXT) before you use it, eg iirc LIKE won’t work. Then you’re back to the same problem.
81.
by ComputerGuru 2mo ago
Whisper v3 is still the best (by far) when it comes to poor quality input (say background audio from a security camera), though remains more susceptible to hallucination so it's a bit of a tradeoff.
82.
by ComputerGuru 2mo ago
If op is here: you can dramatically improve the robustness and soundness of your benchmark with one simple trick: you can run old versions of ASP.NET (Core) frameworks on newer .NET runtimes with no other changes; i.e. instead of benchmarki
83.
by ComputerGuru 2mo ago
Seems the entire repo and documentation is all ai-generated?
84.
by ComputerGuru 2mo ago
> wildly excessive amounts of prose Not just prose. I think this is part of the reason why you see ridiculous code with insane error handling and type checking even for impossible cases.
85.
by ComputerGuru 2mo ago
This announcement is very much a nothing burger; it’s already been more or less decided that adding leap seconds just isn’t going to be a thing anymore (in our lifetime). Here’s on article from 2022: https://www.timeanddate.com&#
86.
by ComputerGuru 2mo ago
Bing is the easiest to buy programmatic access to. But I think they don’t tell you because they sometimes use residential proxies to scrape search results the same way they used residential proxies to scrape the web.
87.
by ComputerGuru 2mo ago
I am very much in camp “minimize your dependencies and take the utmost advantage of what you already have” but I also am in camp “your database is the most important bottleneck component.” This has two implications: 1) make sure if you use
88.
by ComputerGuru 2mo ago
Already reported (not as thoroughly but still quite detailed) two weeks ago and silently “closed as not planned” (keep in mind that the specific reason might be an artifact of GitHub workflow/UX and not actually the intended reason) wi
89.
by ComputerGuru 3mo ago
Am I the only one that feels three/four years is a mighty ambitious timeline for the upgrade? It seems to be a very significant undertaking…
90.
by ComputerGuru 3mo ago
Yup. This works until it doesn’t (fairly soon thereafter), both from experimentation and understanding of theory. Here’s an illustrative example: https://old.reddit.com/r/Bard/comments/1l1qxk9/why_does_ge

More ›