efxhoy

19 ms·

181.
by efxhoy 5y ago
Speaker components, tools and plywood. I've just finished building my first speaker and it sounds FANTASTIC and I designed and built it myself. It's been extremely rewarding and I highly recommend everyone to make something physic
182.
by efxhoy 5y ago
I agree that a materialized view is a lot more ergonomic and probably the correct choice in most cases. Refreshing a materialized view blocks selects from it though, rendering it inaccessible while the refresh is taking place. There is the
183.
by efxhoy 5y ago
Dr. Martin Loetzsch did a great video, ETL Patterns with Postgres. He covers some really good topics: - Instead of updating tables build their replacements under a different name then rename them. This makes updating heavy-to-compute table
184.
by efxhoy 5y ago
We had a fun bug in production with our timezones going haywire due to a similar issue: https://stackoverflow.com/questions/64581249/rails-activesup... No broken builds but all times displayed from our alpine base
185.
by efxhoy 5y ago
I'm in the same boat. As soon as I find time I'm nuking my pfsense router and installing OpenBSD. I just need it to do NAT, DHCP and always work. I don't need a fancy web-ui, traffic graphs or anything like that, I thought I
186.
by efxhoy 5y ago
I recently spent a week doodling around with postgraphile and postgrest. I really liked both, writing everything in SQL is super great. It does feel a bit weird at first but the amount of boilerplate it removes is fantastic and it really fo
187.
by efxhoy 5y ago
I have 128GB in my desktop, which is the same amount of ram that our cluster compute nodes have. I use it for Python/pandas forecasting work. The extra ram in my machine means I can work on the same datasets we use in prod locally, whi
188.
by efxhoy 6y ago
That was a nice read! Good to read about something simple after a day working with AWS and their managed magic. Scrolling through the cert pages 2015 seems to be in the future though? > We personally toured every single major datacenter
189.
by efxhoy 6y ago
Here's a good summary with some performance charts: https://github.com/openzfs/zfs/pull/10278
190.
by efxhoy 6y ago
It's `pandas.read_<format> -> DataFrame` and `DataFrame.to_<format>`. So pandas reads a data format and gives you a dataframe. The `to_<format>` are instane methods of the DataFrame where you write a dataframe to a
191.
by efxhoy 6y ago
The biggest feature for me was zstd compression
192.
by efxhoy 6y ago
The underlining of "beautiful" bugged me. It intersects with the text and it extends further to the left of the first b than to the right of the last l. If I was paying money for a beautiful UI component I'd expect the create
193.
by efxhoy 6y ago
I don’t know genetics but this smells like weak instrument to me? The genetic risk score instruments explained only 2% of variation in vitamin D deficiency. Relevance in the first stage of an instrumental variables analysis is crucial to ge
194.
by efxhoy 6y ago
I have used three USB-C displays extensively: a Dell U3219Q, an LG 27ud88 and an LG 32ud89. The 32" Dell and 27" LG work flawlessly: usb ethernet dongle, usb ssd drives, USB audio interface, mouse and keyboard work great. They don
195.
by efxhoy 6y ago
Yes, exactly right and well put. It's always difficult to jump into online discussions about economics because you need to give the entire econ 101 micro course in single comment just to make sure everyone is talking about the same thi
196.
by efxhoy 6y ago
>> Textbooks state that, in the absence of a minimum wage, a worker is paid his “marginal product of labour”, which means the value of what he produces. > This sentence is just wrong. First of all a rational actor will not intentio
197.
by efxhoy 6y ago
Another thing that Mac does well is the Swedish layout. ~ [] | \ {} are IMO much better placed on the Swedish Mac layout than in Linux or Windows. In some games in windows I can't even bring up the terminal with ~ as it requires a spac
198.
by efxhoy 6y ago
Nice post! I have written several versions of a scientific simulation program in python, first using MPI (single machine) and then native multiprocessing. Using numpy and Pandas for all the heavy data operations. I really valued the ergonom
199.
by efxhoy 6y ago
What kind of networking equipment? I'm thinking of ditching pfsense and going bare freebsd or pfsense for my home router box and a few more anecdotes of similar projects would be nice to hear.
200.
by efxhoy 6y ago
They scrapped that idea last year afaik and are now focusing all efforts on starship which will be fully reusable.
201.
by efxhoy 6y ago
They said in the press conference after launch that docking will be automatic. The purpose of this mission is to demo dragon and testing automatic docking is part of that.
202.
by efxhoy 6y ago
I've written python for a living everyday for a few years now. No means an expert but IMO there are two core skills: Cleanliness and design. Learning and using language features that make code easier to build on, test, and deduce about
203.
by efxhoy 7y ago
> It often feels like newcomers and zealots preaching the unsafe issue, too. A little knowledge is a dangerous thing. This is true for so many topics.
204.
by efxhoy 7y ago
My rewrites always end up much smaller than my original rushed implementations. I think it comes down to a few reasons * I get better at writing code. * Better understanding of the problem, the feedback from the first iteration usually tell