azurelake

9 ms·

31.
by azurelake 3y ago
MySQL has DDL replication.
32.
by azurelake 4y ago
> Like most things, it's more complex than that, Sure, no doubt. My point wasn't really about the particularities. It was around the mistaken idea that I see sometimes where people believe that TrueTime allows for synchronized
33.
by azurelake 4y ago
> who doesn't want instantaneous global writes I want to gently note since I see a lot of misunderstanding around Spanner and global writes: Global writes need at least one round trip to each data center, and so they're still s
34.
by azurelake 4y ago
I mean, he definitely knew about the concept of edit distance: https://en.wikipedia.org/wiki/Edit_distance before writing this code, which is the most difficult part. Here's a practice problem: https://
35.
by azurelake 4y ago
Cool, thanks for the clarification!
36.
by azurelake 4y ago
When you say per user, you mean per user of your app?
37.
by azurelake 4y ago
Let's say the price was 12. If this idea is compelling enough for you at that price point to venmo me an advance for your first month, I have some ideas to explore that could actually make this viable. FWIW, I've worked profession
38.
by azurelake 4y ago
Let's say the following product existed: 1. You can only run one instance of your app. 2. There is a small window of downtime each deploy. 3. Your app has access to 10 GB of storage. The storage is persisted across deploys and can be u
39.
by azurelake 4y ago
If you want to read about an option that doesn't suffer from fragmentation (no pedantic replies please), check out LSM Trees which are what RocksDB uses. Designing Data-Intensive Applications has a VERY clear and understandable chapter
40.
by azurelake 4y ago
You can use `>>>` from `Control.Arrow` to switch the order if you don't mind make your code more esoteric.
41.
by azurelake 4y ago
Interesting, I’ll have to dig more into this. Thanks for the super detailed response!
42.
by azurelake 4y ago
I don't think what you're saying is correct, especially your last sentence (it definitely DOES work at least in terms of not being a table scan). Here's a stackoverflow answer that agrees with me and 8n4vidtmkvmk: https:&#x2
43.
by azurelake 4y ago
The concept you're looking for is linearizability. Basically, it's the idea of being able to pretend that your distributed system is a single node with a single source of truth. An example system that has this property is etcd: h
44.
by azurelake 4y ago
You can already do this with MySQL/Postgres/etc., and there's no special magic in any of these newer tools that allow you to avoid the speed of light. The reason people don't typically run WAN synchronous setups is exact
45.
by azurelake 4y ago
You’re living in the past my friend! https://old.reddit.com/r/unclebens/comments/el1d8q/part_2_in...
46.
by azurelake 5y ago
Laziness by default makes it extremely hard to reason about performance, at least for me. So Rust is actually far closer to C/C++ than Haskell lite in terms of being able to think about how the code you write maps to the physical machi
47.
by azurelake 5y ago
The parent comment said "C lineage", not C.
48.
by azurelake 5y ago
Yeah, and a real problem is how they "poison" the ecosystem. If the community was one that strongly encouraged libraries and frameworks to stick to Haskell2010, I might still consider using it.
49.
by azurelake 5y ago
I have a similar experience and I agree. I think there is a solid, relatively practical language hiding under all the language extensions, but the never ending desire of the community to solve problems of abstraction vs. real user problems
50.
by azurelake 5y ago
It's just a fancy way of saying you can use generics for the "outer" type of a container. e.g. List<T> vs. U<T>. That's literally all there is to it.
51.
by azurelake 5y ago
MySQL has query hints: https://mariadb.com/kb/en/index-hints-how-to-force-query-pla...
52.
by azurelake 5y ago
It's not. For the niche it has found success in (infra type backend stuff), it's by far the best option available. `if err != nil` is a godsend in that world.
53.
by azurelake 5y ago
You can make the type itself public without making the fields public. This means someone could hypothetically create one of your structs without using the "New" function you provide, but it's not an issue in practice. And if
54.
by azurelake 5y ago
The effort to use something like SQS is almost nothing.
55.
by azurelake 5y ago
There's a pretty big spread between google-scale and needing to use a "real" queue instead of a RDBMS though. I honestly think you're better off using something like SQS to start with and taking the very minimal ops burd
56.
by azurelake 5y ago
https://news.ycombinator.com/item?id=30274912
57.
by azurelake 5y ago
Sure, but this post is specifically about a tool that relates to that weak story. In the context of the use cases PgCat is trying to address, Postgres is most definitely not "the greatest". Apparently, that's a controversial
58.
by azurelake 5y ago
Not only is not the greatest, it's literally the worst database technology that's in use for the things PgCat is trying to solve. And that's not a knock on PgCat all (or on Postgres!), it's a knock on the "golden ha
59.
by azurelake 5y ago
I see, guess I'm wrong then! What's the disadvantage of Paxos Commit vs 2PC? Presumably there's a reason that the Spanner team didn't use it for distributed transactions. edit: Looking at the paper, it looks like the tra
60.
by azurelake 5y ago
Yes, see https://en.wikipedia.org/wiki/X/Open_XA That being said, I don't think it's a good idea for reasons similar to this: https://wiki.c2.com/?DistributedTransactionsAreEvil vs. usin

More ›