Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
efxhoy
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
18 ms
·
151.
▲
by
efxhoy
4y ago
I've seen a lot of results dated 2001-01-31 that were not published then. I'm guessing it's a default somewhere that gets incorrectly picked up.
152.
▲
by
efxhoy
5y ago
We run tests on the master branch before we deploy. If tests fail there we find the offending PR and revert it.
153.
▲
by
efxhoy
5y ago
I just found the Min browser, if you’re on Mac it has great UI for staying focused. Not showing frequently visited sites when I open a new tab helps a lot. Less clutter in general also helps. The same is true for my physical space, for me a
154.
▲
by
efxhoy
5y ago
Rail travel here in Sweden is unfortunately not reliable at all. In february only 75% of long distance and 90% of short distance trips were on time. Many departures were canceled due to a myriad of problems ranging from technical issues wit
155.
▲
by
efxhoy
5y ago
I wrote scientific python for several years at a university research project, coming from a statistics background. I wrote a forecasting tool and related plotting, simulation, ML, evaluation etc tools. The reasons for python’s success are o
156.
▲
by
efxhoy
5y ago
Really nice post! A possible addition could be showing the diff as its own field. This seems like a sane approach: https://stackoverflow.com/a/36043269 But how could you go about not storing the diff but still being ab
157.
▲
by
efxhoy
5y ago
This SO answer has a good jsonb diff function: https://stackoverflow.com/a/36043269
158.
▲
by
efxhoy
5y ago
If you care about errors you can use function wait_all { for job in $(jobs -p); do wait "${job}"; done } A lone wait wont tell you if any of the jobs fail.
159.
▲
by
efxhoy
5y ago
I found a bug once in one of our geospatial pipelines. We were removing all points with invalid coordinates, i.e those with abs(longitude)>90 and abs(latitude)>180. Problem is, it's longitude that goes from -180 to 180 and latit
160.
▲
by
efxhoy
5y ago
Nice project! For the counting of views being limited to a few days you could run a daily job to compute the running total of previous days and compute the total today as that historical sum plus todays sum. Just a thought.
161.
▲
by
efxhoy
5y ago
Well done black team! For me it is a fantastic tool which saves some brain clock cycles when applied, both when reading and writing, which is valuable to me. Thank you.
162.
▲
by
efxhoy
5y ago
- Cat-5 in my apartment wall from my ISP. - ISP provided router that splits out IPTV into my TV box and has one port as passthrough to my pfsense box. It should be possible to do this splitting in pfsense but I never managed. - The pfsense
163.
▲
by
efxhoy
5y ago
An important distinction between specific tolls per road and a general gas tax is that a gas tax funds all roads, not the specific one you're driving on. A toll on a particular road is an informative signal to the market of which par
164.
▲
by
efxhoy
5y ago
There is obviously a tradeoff here with the optimal amount of code review that varies with impact and difficulty. Dogmatically doing and waiting for an in depth review on a tiny and likely insignificant change is silly. Blindly pushing big
165.
▲
by
efxhoy
5y ago
The canonical economist solution to this is to introduce road tolls. Make drivers pay at point of use to fund the road.
166.
▲
by
efxhoy
5y ago
Making physical things really helped me. I started building speaker cabinets. It’s been an incredible source of joy. Making something in the physical world really is a great way to feel good, especially when most of your work is making thin
167.
▲
by
efxhoy
5y ago
Cool that they switched to `doas` from `sudo`. Another great OpenBSD tool gaining more adoption.
168.
▲
by
efxhoy
5y ago
> I can see a name and match that to an import and match that to a package. I miss this so much. I'm a python dev now working on a big Rails monolith. Where does all this stuff come from?
169.
▲
by
efxhoy
5y ago
We use 1password at work. It's fantastic, never had issues. The GUI is really nice (on MacOS where I use it at least). The CLI is also nice for pushing secrets into scripts.
170.
▲
by
efxhoy
5y ago
Really sad to see Steve go. That book is half the reason I'm excited about Rust. As the first thing I stumbled on when approaching the language it gave off such a strong vibe of wanting to help developers instead of trying to make them
171.
▲
by
efxhoy
5y ago
Cool, we have a similar setup with dedicated databases for logically separated parts of the app. I work at an online classifieds platform built on rails. For example we have a listing-events database that acts as an event log for our listin
172.
▲
by
efxhoy
5y ago
wind pushes vehicle. wheels spin. wheels drive propeller (via gears). propeller pushes vehicle. I first assumed it was the other way around with wind->propeller->wheels, which it is not.
173.
▲
by
efxhoy
5y ago
If you use serial integer ids and accidentally join on the wrong tables/columns you will get rows back even if the join doesn't make sense, because all serian integer ids have values in common. If you're using UUIDs you will
174.
▲
by
efxhoy
5y ago
Why is that? Is the ISS in such a low orbit that any junk in the same orbit will slow down from the drag and de-orbit itself?
175.
▲
by
efxhoy
5y ago
> Security and reliability are more likely to go wrong in the seams between components. That means literal integrations, but it also means organization seams. Elon said the best part is no part. Parts between systems, interfaces/val
176.
▲
by
efxhoy
5y ago
One thing I learned about EXPLAIN this week is that it doesn't show constraint checks. I was trying to delete about 40k rows from a table and it was taking hours and I couldn't figure out why. ANALYZE EXPLAIN showed nothing indica
177.
▲
by
efxhoy
5y ago
Change in quality adjusted life years, or variants thereof, are one standard for health-economic evaluation but are obviously very hard to get quality data on. That would capture not only years of life lost but also the quality of those yea
178.
▲
by
efxhoy
5y ago
It's psql through an ssh-tunnel to RDS on AWS, postgres 10.6 usually. But I've had the same experience on other versions and locally too. The problem usually isn't that it doesn't work ever, just that it can take a very
179.
▲
by
efxhoy
5y ago
> Automatic cancellation of long-running queries if the client disconnects Sweet! I often screw up a query and need to cancel it with pg_cancel_backend(pid) because Ctrl-C rarely works. With this I can just ragequit and reconnect.
180.
▲
by
efxhoy
5y ago
Absolutely. Complexity in our own system pretty much exploded when we wanted to serve stats at near "real-time" (a couple of seconds delay). If business could just chill out and wait until next day, or even like an hour, we coul
More ›