zeroimpl

7 ms·

331.
by zeroimpl 6y ago
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
332.
by zeroimpl 6y ago
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 consis
333.
by zeroimpl 6y ago
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.
334.
by zeroimpl 6y ago
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 ove
335.
by zeroimpl 6y ago
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
336.
by zeroimpl 6y ago
It also turns out “arg” is a macro which calls scanf. Would be better if they described it more realistically.
337.
by zeroimpl 6y ago
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.
338.
by zeroimpl 6y ago
Out of curiosity, why do you assume they are innocent? Do Canadians abroad never commit crimes?
339.
by zeroimpl 6y ago
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.
340.
by zeroimpl 6y ago
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.
341.
by zeroimpl 6y ago
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
342.
by zeroimpl 6y ago
Why is it “iif” instead of “if”? I don’t recall “if” being a keyword in SQL
343.
by zeroimpl 6y ago
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
344.
by zeroimpl 6y ago
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.
345.
by zeroimpl 6y ago
Let’s make phase 1 be the unification of American and British spelling. That should be easy enough right?
346.
by zeroimpl 6y ago
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).
347.
by zeroimpl 6y ago
Apologizing and feeling sorry are two different things. If you say sorry for every bug, the word will lose meaning.
348.
by zeroimpl 6y ago
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 thin
349.
by zeroimpl 6y ago
It would only serve as defense if governments used zoom. Aren’t most banning it?
350.
by zeroimpl 6y ago
The flaw here is the assumption that colors have a single, well-defined name.
351.
by zeroimpl 6y ago
If you specify both a width and height, it's not going to be very responsive.
352.
by zeroimpl 6y ago
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 (“
353.
by zeroimpl 6y ago
Tip: run your own mail server and configure it to hide your source IP
354.
by zeroimpl 6y ago
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
355.
by zeroimpl 6y ago
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-de
356.
by zeroimpl 6y ago
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 "
357.
by zeroimpl 7y ago
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
358.
by zeroimpl 7y ago
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 encounte
359.
by zeroimpl 7y ago
It can represent less than 0.1% of all 64-bit ints. That doesn’t seem like most to me.
360.
by zeroimpl 7y ago
Sounds interesting, but the website has very little details on it so I can't really evaluate how well it would work for me.

More ›