Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
winrid
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
25 ms
·
631.
▲
by
winrid
2y ago
They only auction servers in one region
632.
▲
by
winrid
2y ago
I know you say chrome is fine but curious what CPU you have?
633.
▲
by
winrid
2y ago
oh yeah, that's also a good idea! If they're using the software I sell to organizers it supports regular old computer display out, too, so you could just replace the display board and use HDMI directly these days.
634.
▲
by
winrid
2y ago
Yeah you could do it. I'm sure I will at some point be replacing the guts in some devices with STM32s or RP2040 as you said. Or beef it up with ESP32 :) but if the display itself is damaged, that's tough, pretty much just reuse th
635.
▲
by
winrid
2y ago
Unfortunately some motorsport event organizers barely break even, especially post-covid in CA, although it is picking up slightly this year. It is hard for them to justify $2-4k for a new display or timing system, whereas it's a few ho
636.
▲
by
winrid
2y ago
I repair old timing equipment (think Race America, JACircuits, etc) as a side hobby, and a lot of it is large 7 segment displays with individual LEDs in series for each segment. I am so glad people didn't try using an LCD display or si
637.
▲
by
winrid
2y ago
DuckDB is indeed great for one off stuff. But calling 30s high performance for quantifying 60k unique values like in this case is misleading at best. I try not to mislead people. :)
638.
▲
by
winrid
2y ago
In my case the users were just really happy we solved the problem, I don't think they would care if it ran on minecraft redstone.
639.
▲
by
winrid
2y ago
yeah, but it's not high performance, which was my original point. I spend a lot of time optimizing stuff developers thought was "high performance" and they're scanning a 100gb+ dataset on every page load.
640.
▲
by
winrid
2y ago
Depends on the machine :) hours maybe?
641.
▲
by
winrid
2y ago
You wouldn't need hundreds of gigs of ram to answer this query in 5ms. You'd need a few mb or so to answer this query, after initial indexing is done of course.
642.
▲
by
winrid
2y ago
FWIW JavaFX is still great too BTW. I have a decent sized app that'll run fine with a 50mb heap, and you get native OS installers too. No web support though.
643.
▲
by
winrid
2y ago
That's cool, but not what I would call high performance. If you do these often you would want an index, and should only take single digit ms.
644.
▲
by
winrid
2y ago
That's illegal how? If the US Government, for example, has subsidies for chip production that makes exporting silicon cheaper is that illegal too?
645.
▲
by
winrid
2y ago
I used to rent a space in my landlord's backyard. My arc welder would always make his radio turn to static :D I had a lot of fun putting bigger motors on motorcycles with it, though.
646.
▲
by
winrid
2y ago
The more you know, thanks!
647.
▲
by
winrid
2y ago
COSMIC is the new rust-based DE that's still in alpha right? I wasn't using that. I'm pretty sure it's a window manager issue. gksudo (?) requests focus, and then while you're typing something happens and your keybo
648.
▲
by
winrid
2y ago
I wouldn't say it was a failure. They had a good run in a very quickly evolving time. That they got a slice of business for years during that period isn't bad!
649.
▲
by
winrid
2y ago
The password prompt when you try to do an admin action via the UI, and it happened at like once a week on PopOS before I switched to xfce.
650.
▲
by
winrid
2y ago
does "getting stuff done" include having the Gnome password prompt consistently lose focus and send your password into background applications because it does that a lot
651.
▲
by
winrid
2y ago
saves a couple bytes if you're not using a modern build system :)
652.
▲
by
winrid
2y ago
Well I don't even get a chance to run the script.
653.
▲
by
winrid
2y ago
Neither the URL in the gist or this one load for me. The one in the gist seems to freeze at trying to load some modal, on fully updated Chrome.
654.
▲
by
winrid
2y ago
still is! just make sure you play ETLegacy as it's a more maintained client.
655.
▲
by
winrid
2y ago
ah I forgot grandparent comment said trillion. yeah that's an order of magnitude I would distribute across a cluster if we were in active development and indexes were changing etc. if you're storing that much data you should be ab
656.
▲
by
winrid
2y ago
There's usually a full server or two. ETLegacy has plenty of players for me. but yeah, the communication style is fun. and if you join a server on axis you'll usually get spammed with "Hallo! Hallo! Hallo!" :)
657.
▲
by
winrid
2y ago
> this can mean building some untrivial infra As someone that does it all the time on 10b+ record tables, not really? if you don't have extra resources to build the occasional index your DB is under-provisioned and you're close
658.
▲
by
winrid
2y ago
Reminds me of fixing an ~11yr old bug in Enemy Territory. I had to spend a night debugging the C code only to realize the issue was in the UI config: https://github.com/etlegacy/etlegacy-deprecated/pull/100&#x
659.
▲
by
winrid
2y ago
That's only if you read everything, and if none is in ram. With a columnar DB you can just scan the values of the column you need.
660.
▲
by
winrid
2y ago
You just have to plan and do it in the background at those data sizes.
More ›