branko_d

29 ms·

301.
by branko_d 5y ago
It's exactly like building a bridge... if nobody never built a bridge before. The only reason you can design a bridge beforehand is because (millions?) bridges have been built before so you can apply the lessons learned. Even if your b
302.
by branko_d 5y ago
> there's one table with the columns "rowid, columnname, value" Yeah, that's known as "entity-attribute-value model" (or just "EAV") and is considered an anti-pattern unless you actually need the f
303.
by branko_d 5y ago
How is that? Are you talking about word wrapping? Also, what's the alternative here? Sure, I could indent everything and make it much more vertical, but that would make things even less readable.
304.
by branko_d 5y ago
SELECT CAST(CASE WHEN DENY_ADMIN_FILTERS > 0 THEN 0 WHEN ALLOW_ADMIN_FILTERS > 0 THEN 1 END AS bit) CAN_ADMIN_FILTERS, CAST(CASE WHEN DENY_ADMIN_ACL > 0 THEN 0 WHEN ALLOW_ADMIN_ACL &gt
305.
by branko_d 5y ago
Few more advantages: - Round-trips avoided. - Security. - Data integrity. The last two points rely on building a public API out of stored procedures / functions / views and disallowing direct access to base tables. That
306.
Death on the Roads(extranet.who.int)
1 points by branko_d 5y ago|0 comments
307.
by branko_d 5y ago
"Fast Processing and Querying of 170TB of Genomics Data via a Repeated And Merged BloOm Filter (RAMBO)" https://dl.acm.org/doi/abs/10.1145/3448016.3457333
308.
DNA databases: New method cuts indexing from weeks to hours, searches to minutes(techxplore.com)
27 points by branko_d 5y ago|1 comments
309.
by branko_d 5y ago
It's better to use a native date/time with a CHECK that ensures that the time portion is 0. You'll have to do a CHECK on the YYYY-MM-DD string anyway to protect your database from bad data, so why not just do it on the native
310.
System failure: Inside Maine’s $35M human resources software meltdown(pressherald.com)
22 points by branko_d 5y ago|0 comments
311.
by branko_d 5y ago
But you can make it burn! https://madison.com/wsj/huge-grease-fire-was-a-hot-mess/arti... > With so much oil-rich food on hand, including lard, cheese and more than 10 million pounds of surplus butter stored by
312.
The Economic Value of Rapid Response Time (1982)(jlelliotton.blogspot.com)
2 points by branko_d 5y ago|0 comments
313.
by branko_d 5y ago
Sorry, I disagree. Serial reading is exactly what you want to do on an HDD, assuming big enough files which are not too fragmented. The name of the game is minimizing the head movements. Try the following experiment: find a couple of multi-
314.
by branko_d 5y ago
> Yeah, there's absolutely no reason game loading should be serial. It's straightforward for a game to figure out everything it needs and grab dozens in parallel. And that would likely tank the performance if the game is runnin
315.
by branko_d 5y ago
Similar effect existed for the HDDs of old. As the platter density increased, the head could glide over more data at the same spindle speed and you would get increasingly higher sequential speed. But you would not get much better latency
316.
by branko_d 5y ago
Oracle has had flashback queries for a long time. Though this does not do what immudb claims: > immudb is the first database to provide tamper-evident data management, immutable history and client-cryptographic proof. And: > Client
317.
Bell's Theorem Refuted(sciencex.com)
3 points by branko_d 5y ago|0 comments
318.
by branko_d 5y ago
And if the cardinality of a is low, it can even be an index for b! This is called “skip scan”. Oracle has supported this for a long time, and apparently newer versions of MySQL as well.
319.
by branko_d 5y ago
It's a balance between the (evolutionary) advantage for of the group vs the advantage for the individual. Some lying may be beneficial for the individual as long as it doesn't harm the group too much. Lie too much though, and the
320.
by branko_d 5y ago
There are great benefits for the society, and dare I say species. Conscience, after all, is not an accident. Its a product of our evolution. We lived in small groups for most of our existence, and the very survival of the group was tied pre
321.
Tesla Autopilot director contradicts Musk’s self-driving timeline(arstechnica.com)
33 points by branko_d 5y ago|19 comments
322.
Reasons the Peloton Tread+ Is Not Safe for Kids, Small Pets(youtube.com)
1 points by branko_d 5y ago|0 comments
323.
Towards complete and error-free genome assemblies of all vertebrate species(nature.com)
1 points by branko_d 5y ago|0 comments
324.
by branko_d 5y ago
We make tests robust in the face of existing data. For example, each name is "GUID-ified", we only compare specific subsets of rows that we know will be isolated from the rest etc... We still use transaction rollback for most of o
325.
by branko_d 6y ago
Looks like they are emulating generics (what would be accomplished with templates in C++).
326.
by branko_d 6y ago
From the OP: > I’m a fan of the Pareto principle: 80% of consequences come from 20% of the causes. This reminds me of the claim that most users only use 20% of the features of a given application. What is often forgotten though, is that
327.
by branko_d 6y ago
Locks and transactions are intertwined. Write locks are typically released only when the transaction ends, and read locks too at some transaction isolation levels.
328.
by branko_d 6y ago
I think this quote from Alan Kay is rather illuminating: "The key in making great and growable systems is much more to design how its modules communicate rather than what their internal properties and behaviors should be." http
329.
by branko_d 6y ago
> stack and heap as with C# structs and classes Nitpick: C# struct can be on the heap (when it's "boxed"). The fundamental difference between C# class and struct is how they treat assignment operation. The class has "
330.
by branko_d 6y ago
> lead-acid's very low risk of fire Isn't lead-acid prone to releasing hydrogen gas? When jump-starting a car, it is commonly recommended to connect the ground (black) cable to the chassis, not to the battery's black ter

More ›