evanelias

5 ms·

1.
by evanelias 7d ago
In this specific case (Tailwind Labs) I don't understand this sentiment at all . It was a completely bootstrapped company! Its entire existence is due to the many years of difficult work by its founders. What exact outcome would corre
2.
by evanelias 17d ago
Interesting, I wouldn't have expected that auto_increment replication problem to occur for InnoDB tables that have a clustered index key (the old PK converted to UNIQUE), that is indeed surprising. Maybe the SQL layer does something du
3.
by evanelias 17d ago
Huh, if the table effectively already had a clustered index key (from the old PK) then I'm surprised that the auto_inc values would be assigned non-deterministically. I would have naively assumed that the values would be assigned in cl
4.
by evanelias 18d ago
No, the binlog format is actually irrelevant here; the post author was just incorrect about that part. ALTER TABLE always gets replicated as a statement, regardless of the binlog format. Auto_increment only has broken replication semantics
5.
by evanelias 18d ago
I agree the root cause here is the lack of a primary key to begin with. But as far as I know, DDL is always replicated as just a statement, regardless of session binlog_format. So I believe the only real fix here is the general approach sug
6.
by evanelias 26d ago
That's largely a fantasy in the NYC metro area as well. Unless you're talking about a tiny condo, and/or your office is extremely close to a major transit hub.
7.
by evanelias 26d ago
NATURAL JOIN is actually in the SQL standard; it's not specific to MySQL. I'm not aware of any databases that allow UNION to take table names directly, although in many cases you can use the TABLE keyword as a shortcut for "S
8.
by evanelias 1mo ago
My sense is that a lot of this activity isn't even legitimate use. As one example: my company has a GitHub app, and last night some bot added my app to 1700 repos. Then the bot immediately started rapid-firing commits which each affect
9.
by evanelias 1mo ago
Unless I'm missing something, your linked comments seem to be responding only to the title of the article, without addressing any of the actual points being made in the body of the article?
10.
by evanelias 1mo ago
> Mass layoffs are going on for a couple years. I couldn't figure out why it is only making noise now? This specific infamous mass-layoff-via-Zoom happened back in December 2021, and a lot of noise was made about it at the time. F
11.
by evanelias 1mo ago
Actually, Zuckerberg's Facemash site was online for less than 3 days. It's worth mentioning that the events depicted in The Social Network regarding Facemash's traffic level supposedly crashing the Harvard FAS network were
12.
by evanelias 1mo ago
I was about to post the same; they adopted the pass/fail first semester policy in 1971. But then I was just horrified to read apparently they got rid of that system in 2017 [1], and now it's a normal letter grade?! Assuming that H
13.
by evanelias 1mo ago
> The barber example is not theft. You cannot steal a haircut. You may be harming the barber, but it's not theft. [...] Words matter! Then why is it legally considered "theft of services", which is a crime that directly in
14.
by evanelias 1mo ago
In theory you can do filesystem-copy-speed population of large seed data using InnoDB's transportable tablespaces feature. For the test db use-case specifically though, unfortunately it's far less ergonomic than Postgres template
15.
by evanelias 1mo ago
Case sensitivity/insensitivity is a property of the collation, which is configurable on a per-column basis. In Postgres the default collation is case-sensitive, and in MySQL the default collation is case-insensitive, but this does not
16.
by evanelias 2mo ago
Regardless of whether they are "truly" stateless, if they have no identity documentation -- which your AI answer repeatedly indicates is a situation applying to a larger number of Roma -- and they refuse to say where they're
17.
by evanelias 2mo ago
The articles I read yesterday indicated that it would be quite difficult to determine country of origin in many cases, due to complete lack of official identity documentation. The article I previously mentioned by name literally describes s
18.
by evanelias 2mo ago
Pardon my skepticism, but cursory web searching and LLM prompting is giving me responses like "a significant portion of the European Roma population faces high rates of statelessness or lacks basic civil documents", while citing r
19.
by evanelias 2mo ago
Which is where, exactly, for the people in question? i.e. what is the legal home country for most Roma in Denmark? Given folks like DHH have such strong opinions about this, I would expect they should be able to detail the specifics of the
20.
by evanelias 2mo ago
I meant in the sense that Roma are an ethnicity lacking their own sovereign state, "stateless" as in https://en.wikipedia.org/wiki/Stateless_nation
21.
by evanelias 2mo ago
> But that's hard to square with the fact that 7 years since IPO the share price is up 75% Uber has severely underperformed the market. Passive S&P500 index funds had a total return of more than double that in the same time pe
22.
by evanelias 2mo ago
Dupe of https://news.ycombinator.com/item?id=49078196 which was posted a couple days ago, and then seemingly revived in second chance pool before getting flagged for obvious slop-tone.
23.
by evanelias 2mo ago
Interesting theory, but fwiw synths were quite popular among the Baltimore music scene throughout the 00s. Besides Beach House, there was Dan Deacon, Future Islands, Celebration, among others. Lake Trout was another example, although a few
24.
by evanelias 2mo ago
If some individuals are committing crimes, why isn't the normal criminal justice system the answer, instead of deportation? And deport them to where exactly, and on what justification? They've been in Europe for a thousand years a
25.
by evanelias 2mo ago
> the PostgreSQL MVCC approach is well worth never seeing ORA-01555 like error message. But that's a false comparison; it's not a binary decision. As InnoDB demonstrates, you can take the undo log approach without having ORA-01
26.
by evanelias 2mo ago
If you steal an unpopular product from a store, the damage is also only to "potential profits", so how does that differ? It's entirely possible no one would have purchased the product and it would have eventually been discard
27.
by evanelias 2mo ago
My point is that the number will entirely vary for each user, depending on how many poor DB-related infra decisions they've made. Some users may save 99%, others may save almost nothing, right? So why say 40% here? Where did this numbe
28.
by evanelias 2mo ago
> cut database costs by 40% Where does this number come from? It feels completely arbitrary.
29.
by evanelias 2mo ago
> MySQL You still haven't indicated what version. For example there's a substantial join planner improvement in the latest LTS (MySQL 9.7). And in any case the original thread was about MariaDB, not MySQL. > I disagree OK, b
30.
by evanelias 2mo ago
"Mid thirties" is absolutely not a common definition of mid life. For reference, Wikipedia defines "middle age" as being the age range from 40 to 64, based on citing nine different sources: https://en.wikipedi

More ›