zeroimpl
zeroimpl on Hacker News
Compared to the mass enslavement of Africans and genocide of indigenous people in the west, this sounds pretty tame. Modern Tibet is certainly flourishing.
Perhaps the people who fled were the ones guilty of crimes mentioned in the article?
Thanks, I got the part about the spec being ambiguous, am more interested in the "why" aspect, since the current behaviour seems intuitive to the name "repeatable read". But on closer inspection, I see PostgreSQL's repeatable read blocks phantom reads even though the ANSI spec permits that! I don't get why phantom reads would be acceptable under "repeatable read"... I probably should give those papers a read some time. But in the meantime, given the choice of phantom reads or G2-item, I think I'd pick blocking phantom reads. (It might be nice to have the option to choose though!)
In PostgreSQL's case, if they somehow made repeatable read to prevent G2-item without sacrificing the phantom reads, would that mean repeatable read is then "serializable" according to the ANSI definition?
For the repeatable read issue, I don't intuitively understand why the violation mentioned would be a problem. In particular, even though the transaction sequence listed wouldn't make sense for a serializable level, it seems consistent with what I'd expect from repeatable read (though I have not read the ANSI SQL standard's definition of repeatable read).
Any insights into why we should want repeatable read to block that? It feels like blocking that is specifically the purpose of serializable isolation.
I don’t mean like shared hosting servers in the cloud. I mean application servers, build servers, and databases, hosted in-house. You don’t always want to give the junior dev root access.
It seems to me that if they had used those replacements names in the first place, nobody would have ever submitted a PR to change them to master/slave or blacklist/whitelist. Thus most people complaining are just making a fuss over nothing.
The stack exchange post is asking specifically for Desktop users.
But for shared linux servers, sudo is very useful. It allows controlling which users are allowed to administer the system. (Generally, people who aren't sudoers can only view log files or do other readonly things). It's much better than letting people login as root directly since it keeps an audit trail of who is actually administering the device (they will show up using the `users` command, for example).
I rarely use sudo to do any fine-grained access control - it's almost always an all-or-nothing configuration - specific users are granted full access (with passwords), and everybody else gets none. I suppose this means that I use only 5% of it's functionality, but this 5% is quite useful.
It also turns out “arg” is a macro which calls scanf. Would be better if they described it more realistically.
FWIW, if I wrote this patch and worked at AWS, I might not want to go to work the next day.
While it’s not as bad as other criticisms, there is still plenty of room for improvement to establish a more professional work environment.
Out of curiosity, why do you assume they are innocent? Do Canadians abroad never commit crimes?
I’ve seen character offsets for JavaScript (which requires it due to minimization), but never Java. I’m pretty sure that data is not available in Java bytecode, nor most compiled languages.
Wouldn’t that make the code less readable?
I think the point is that if 98% of your code fit under 110 chars when you weren’t using a linter, then maybe you don’t need a linter checking line length.
This would make debugging hard, as debuggers are very much line number based. Step commands move one line at a time, breakpoints are for specific lines, and stack traces from exceptions include line numbers but not character offsets.
That’s why for function calls passing multiple arguments where each argument may be non trivial, it’s a good idea to put each argument on its own line.
Why is it “iif” instead of “if”? I don’t recall “if” being a keyword in SQL
I recall windows 95/98 being pretty slow to boot. I also recall being warned by teachers not to move the mouse while things were booting as that would allegedly slow things down further.
These days the only real time I wonder "wtf is this thing doing" is when I'm waiting about 5-10 seconds for my mac to wake up from sleep.
I’ve had issues pasting phone numbers into text fields, where the last digits get cut off because the form doesn’t want hyphens. I’d rather it paste in the full thing and then let me manually remove the hyphens/spaces.
Let’s make phase 1 be the unification of American and British spelling. That should be easy enough right?
It also prevents the dictionary lookup gesture of macOS from working in Firefox, since it selects the whole sentence and looks that up (which fails).
Apologizing and feeling sorry are two different things.
If you say sorry for every bug, the word will lose meaning.
I wouldn’t refer to the first stage as an apology, it is simply an acknowledgement.
I very rarely apologize for a bug at work. I don’t expect others to apologize to me either. Apologies should be reserved for personal/relationship things, like forgetting to invite somebody to a meeting.
It would only serve as defense if governments used zoom. Aren’t most banning it?
The flaw here is the assumption that colors have a single, well-defined name.
If you specify both a width and height, it's not going to be very responsive.
Yeah, they need to make it possible for users to clean up/label things after the fact (including changing things posted by others - like stack overflow’s edits), and perhaps they can have some AI reminders to encourage this behavior (“hey, looks like this conversation is over, would you like to summarize and archive it?”)
Recently, in the middle of an important team discussion where we had a brief lull waiting for senior people to respond, one coworker decided to ask me some off-topic questions. It would have made 10x more sense to send them as DM, or at least start a single thread. But converting messages to a thread or moving to another channel is hard so there was nothing I could do (aside from asking them to delete all the messages)
Tip: run your own mail server and configure it to hide your source IP
Eventually acceleration would go to 0, but it needs to go negative first. Right now acceleration is positive and velocity is positive, hopefully soon acceleration will become negative, then eventually velocity will approach 0 from above and acceleration will approach 0 from below.
A constant 2nd-derivative means quadratic growth, not exponential.
I'm bit confused by the graphs, because they show the 2nd-derivative going to 0. But to stop this thing, we actually need to decelerate, eg going negative on the 2nd-derivative.
kinda. You can use aggregates as window functions, but cannot use window functions as aggregates.
So it would be:
select a, last_value(b) over(partition by a), last_value(c) over(partition by a) from table
Note the lack of a "GROUP BY" so this will result in duplicates unless you add a DISTINCT.
In general if you query a table twice, the query planner will visit that table twice. So DISTINCT ON is almost always more efficient.
The main exception I’ve seen is when using it in a view, if you try to filter the results of the view, it usually can’t optimize a DISTINCT ON, but sometimes can for GROUP BY (though that might have improved on newer versions)
I’ve created a custom aggregate in Postgres that lets you essentially get the same result as what MySQL does:
select a, last(b), last(c) from table group by a
As it’s name implies, returns the last value that the aggregate encountered for the group. You can add an “order by” within the parenthesis to make it deterministic.
It can represent less than 0.1% of all 64-bit ints. That doesn’t seem like most to me.