Viewing profile — jdreaver

I learned recently that Spain uses the same timezone as Germany (GMT+2 currently, according to Google) despite the GMT line passing through Spain. I've visited Spain and did feel l…

https://en.wikipedia.org/wiki/ReStructuredText This format really took off in the Python community in the 2000's for documentation. The Linux kernel has used it for documentation a…

I recently discovered that `perf` itself can spit out flamegraphs. My workflow has been: $ perf record -g -F 99 ./my-program $ perf script report flamegraph You can also run `perf …

There are plausible scenarios where a region can go down for days or more at a time, like natural disasters. I'm not terribly worried about a region going away _forever_, but durin…

You are correct that storage is cheaper in S3, but S3 charges per request to GET, LIST, POST, COPY, etc objects in your bucket. Block storage can be cheaper when you are frequently…

Huge +1 to this, but I would also add walking _at least_ 8000 steps per day. I still had some minor, nagging pain until I started walking more. Turns out humans are not meant to si…

Most of my company uses VS Code or IntelliJ IDEs, which are officially supported by our developer productivity team, but many of us use Emacs and Vim (I'm an Emacs user). I spend m…

The book is a bit more foundational than that. It teaches you about Bayesian statistics, and discusses (among other things) why the concept of binary yes/no statistical significanc…

The Elements of Computing Systems: Building a Modern Computer from First Principles [0] [1] Easily one of the most interesting and engaging textbooks I've read in my entire life. I…

I agree with basically everything you are saying, except I think a sprinkle of rote memorization can go a long way in some domains. Whenever I read a math book, memorizing definiti…

That's probably so you can rotate your keys without downtime.

I've used Aurora and the IO is much better there than on vanilla RDS. Postgres Aurora is basically a fork of postgres with a totally different storage system. Their are some neat r…

> RDS is slow. I've seen select statements take 20 minutes on RDS which take a few seconds on _much_ cheaper baremetal. I'm sure you observed this, but concluding that RDS is slow …

I've read this book and taken this course twice, and it is easily one of the best learning experiences I've ever had. Statistics is a fascinating subject and Richard helps bring it…

Interesting, I know folks at Stripe that have been remote since around or before 2019, and one of the reasons I joined Stripe was because of the fantastic remote policies (hint: th…

+1 to both of these approaches. Maybe once per year we would have a query plan regress because of out of date column statistics. This happened on some pathological cases like table…

Nope. There is an AWS blog post [0] from September 2021 about setting up pgbouncer in front of Aurora Postgres, and that blog post references the AWS RDS Proxy service [1], but Aur…

> If you see idle is above 20 it's recommended to explore using PgBouncer. Exploring pgbouncer when you have lots of idle connections is a great tip, but 20 idle connections feels …

Making a closure usually requires allocation. For example: package main import "fmt" func main() { closure := make_closure() fmt.Println("closure():", closure()) } func make_closur…

This is solvable with vanilla table design. Add a version column to the discounts table, make your foreign key point to (discount_id, version) instead of just discount_id, keep old…

Ah understood. I thought this comment thread was talking about replacing _production_ AWS use cases with a bare metal system that has a compatible API.

https://docs.aws.amazon.com/amazondynamodb/latest/developerg... > The downloadable version of DynamoDB is intended for development and testing purposes only. By comparison, the Dyn…

> nor morally defensible. I don't think this is accurate. There are plenty of legitimate critiques against intellectual property, for example: https://plato.stanford.edu/entries/in…

I've installed NixOS over wifi a few times, most recently for a desktop that wasn't next to my router and that I didn't feel like relocating to connect via ethernet. The fully feat…

I wonder if that is just limited to IBKR Lite, their commission free platform https://www.interactivebrokers.com/en/index.php?f=45196