cakoose

13 ms·

61.
by cakoose 5y ago
Even with an index, counting the number of rows is an O(N) operation in most DBs. Why? 1. DBs typically store data in some flavor of b-tree. Determining the number of elements in a sub-range of a b-tree (or any "standard" search t
62.
by cakoose 5y ago
City buses seem like a great use case for battery swapping! Depends a lot on the exact bus system, but thinking loosely about San Francisco: maybe retrofitting ~10 terminals with swap+recharge capabilities means most routes only need 1-2 ho
63.
by cakoose 5y ago
These charts should have the y-axis start at zero. As they are now, I have to convert the bars into numbers, then mentally compare the numbers, which defeats the point of charting them graphically. Though I guess I can compare the confidenc
64.
by cakoose 5y ago
"Some opinionated thoughts on SQL databases" (2021): https://blog.nelhage.com/post/some-opinionated-sql-takes/ There are many factors to take into account, but this article focuses on the "operating
65.
by cakoose 5y ago
Not always at the cost of the users? If dceddia is able to add features and fixes more quickly, that's good for users too. And if Svelte on the desktop becomes popular, people will likely come up with more efficient options. For examp
66.
by cakoose 5y ago
The first idea -- generating the reverse delta while applying the forward delta -- seem obvious. The second idea is clever, but Chrome did it in 2011: https://news.ycombinator.com/item?id=2576878 Even if the ideas aren&#x2
67.
by cakoose 5y ago
Maybe it's because they know some sites will use the title as-is?
68.
by cakoose 5y ago
KeyDB is a multithreaded fork of Redis. According to their benchmarks, the performance difference is large: https://docs.keydb.dev/blog/2020/09/29/blog-post/
69.
by cakoose 5y ago
The beginning of article acknowledges that Redis can do a bunch more things and explicitly scopes things down to caching use case: > None of the the above are going to be covered in any detail. If you do need any of the above functionali
70.
by cakoose 5y ago
Does anybody here understand the argument they're making? The language is vague and most examples seem to apply to un-nested transactions as well. > Additionally, nested transactions can amplify performance anomalies... This is a fu
71.
by cakoose 5y ago
The original was Dijkstra's "Go To Statement Considered Harmful". Many considered that title unnecessarily provocative, but it ended up creating a new CS/programming meme. Now, I see "Considered Harmful" as jus
72.
by cakoose 5y ago
Yup, ignoring the costs of memory/storage access (cache, main memory, disk) can hurt an algorithm's real-world performance. Laying your data out in chunks that match the memory/storage blocks sizes (cache line size, disk blo
73.
by cakoose 5y ago
Whether P = NP is a long-standing problem. Like many long-standing problems, it's deceptively difficult, which results in many people incorrectly claiming they have solved it: https://www.scottaaronson.com/blog/?p
74.
by cakoose 5y ago
I think the difference is the all-or-nothing mentality. Nothing is 100% trustworthy. Even if you write "unsafe"-free Rust that only relies on the Rust standard library, you need to trust: - The Rust compiler and everything it use
75.
by cakoose 5y ago
This article convinced me to go managed for Postgres: https://rbranson.medium.com/10-things-i-hate-about-postgresq... (2020) > The good news is that the pain caused by many of the issues brought up in this post can be re
76.
by cakoose 5y ago
Tink seems similar to Plaid, except focused on Europe? The US DoJ got in the way of Visa's attempted acquisition of Plaid last year. https://sifted.eu/articles/plaid-visa-tink-europe/
77.
by cakoose 5y ago
Adding to the confusion is this often-cited article: https://medium.com/@Rich_Harris/tree-shaking-versus-dead-cod... That article claims that "tree shaking" is different because: > Rather than excluding de
78.
by cakoose 5y ago
This was great! Reminds me a lot of this classic CS paper: Improving IPC by Kernel Design, by Jochen Liedke (1993) https://www.cse.unsw.edu.au/~cs9242/19/papers/Liedtke_93.pdf
79.
by cakoose 5y ago
This looks like an SSH client feature that is invisible to the server. Does the server operator (GitHub) even have to do anything?
80.
by cakoose 5y ago
As others have said, changing the Bitcoin protocol can be tricky. Another issue with replacing Ed25519: the best "post-quantum" asymmetric crypto we have so far is a lot less efficient and compact: https://en.wikipedia.
81.
by cakoose 5y ago
I actually started with Ava for a new project because it did a few things better than Jest. But ended up switching away because of this issue: https://github.com/avajs/ava/issues/2385 Basically, if an assert
82.
by cakoose 5y ago
I was surprised that every Jest+TypeScript guide says to use ts-jest. I already have my IDE, the TypeScript watcher, and ESLint parsing/compiling all the code! I don't want to add fourth one :-P I ended up just pointing Jest at
83.
by cakoose 6y ago
Yes, Rust checks a lot of things at compile time, but not all. For example, dynamic bounds checks (indexing into a Vec or slice).
84.
by cakoose 6y ago
I need to run Postgres in production soon and have been trying to decide between AWS RDS multi-AZ (non-Aurora) and Google Cloud SQL HA. I have some experience with RDS, and from the documentation, Cloud SQL seems very similar. What's
85.
by cakoose 6y ago
I need to run Postgres in production soon. I've used AWS RDS (MySQL) in the past, but am also considering Google Cloud SQL. Things that seem similar in AWS: - For major version upgrades, you need to bring up a new instance from a snap
86.
by cakoose 6y ago
I use 1Password (and the browser extension) for all my passwords, but I still choose "Sign-in with Google" when that's an option. The "Sign-in with Google" button is makes it much quicker to create an account and sl
87.
by cakoose 6y ago
The neat thing about Swift's ABI compatibility is that it's almost as flexible as its API compatibility, e.g. - A library can add new fields to a struct. - A library's parameterized types can be instantiated with new argument
88.
by cakoose 6y ago
Some similar work: The GCC compiler for Java (GCJ) started out doing whole-program compilation, but that couldn't handle Java's flexible ABI and dynamic loading. In 2004 they introduced a compilation mode with an additional layer
89.
by cakoose 6y ago
That's the part they sold in the title, but there's a bunch of other useful stuff for someone operating Postgres in production, something I'll need to do in a few months.
90.
by cakoose 6y ago
This one seems pretty thorough: https://upcommons.upc.edu/bitstream/handle/2117/169283/TJM1d... (Chapter 5). There's also a bunch from Google at various stages of QUIC development.

More ›