bhaak

16 ms·

181.
by bhaak 3y ago
I’m missing the execution plans of these DELETE statements. Without them it‘s not clear what‘s the problem. But in any case sacrificing referential integrity for speed is a bad idea. You could go NoSQL in that case anyway.
182.
by bhaak 3y ago
This argument is the Neo/Morpheus matrix meme. It's a powerful image but it doesn't change the properties of Bitcoin. You are actually holding digital gold, not digital money which also needs constant maintenance to keep func
183.
by bhaak 3y ago
People think of it as money but mostly as unusable money. Even Bitcoin proponents now longer propose "using Bitcoin" but "holding Bitcoin" and cashing out to fiat if they have to use money.
184.
by bhaak 3y ago
> If you've ended up here, chances are you're looking to subscribe to our blog in your RSS feed. > Unfortunately, we don't have official RSS feed support for now, but we're actively working on a solution. Well, tha
185.
by bhaak 3y ago
An obvious area for improvement would be semantic version control. If the VCS would have an understanding of not only what has changed but also how this affects the code, it could deduce a lot if interesting facts about commit blocks. Like
186.
by bhaak 3y ago
Oh, look at that. Nice. Still losing the coloring but you can't have everything.
187.
by bhaak 3y ago
git status --untracked-files=all sn is 'git status --untracked-files=no'.
188.
by bhaak 3y ago
As I have overloaded my rg with a customized rg alias, I can't pipe multiple rg calls. Otherwise it would look like this: # rg nokogiri | rg linux <stdin>:11:Gemfile.lock:647: nokogiri (1.15.5-x86_64-linux) But
189.
by bhaak 3y ago
Even faster, I have an alias 'ss' (mnemonic for 'super search') for rg. Fitts' Law to the max!
190.
by bhaak 3y ago
We already pretty good images of some landing sites. https://en.wikipedia.org/wiki/Third-party_evidence_for_Apoll...
191.
by bhaak 3y ago
Everything will have problems if you start from scratch and have to import millions of items. But of course there's a standard for paging: https://www.rfc-editor.org/rfc/rfc5005#section-3 Then both ATOM and RSS ca
192.
by bhaak 3y ago
Everything is a website these days. Even code commits. https://github.com/torvalds/linux/commits.atom
193.
by bhaak 3y ago
Anything that has updates and doesn't need to be an instant notification. It's rather the other way around. Nowadays everything is a website. News is a website. GitHub commits, pull requests, issues, etc. are websites, too. Social
194.
by bhaak 3y ago
Interesting info. Thanks. In my particular case it doesn't help that I only have limited control over the query and the query designer has a bias towards large, complicated db functions.
195.
by bhaak 3y ago
Interesting. I've never seen this though. I guess that only happens for simple cases?
196.
by bhaak 3y ago
Functions are hard barriers for optimization and I don't see that changing any time soon. Which goes even so far that EXPLAIN doesn't work on them and you just get a black box of "Function call to ..." in the execution p
197.
by bhaak 3y ago
> Improve database schemas, e.g., through normalization, to promote efficient filtering. Cries in ActiveRecord type columns. In less sad news, I recently learned that Postgres can have serious problems with joining a lot of tables. I loo
198.
by bhaak 3y ago
Why is that newsworthy?
199.
by bhaak 3y ago
Is there any Paradox game that doesn’t have lots of obvious bugs and terrible UI at release? And only the former gets somewhat addressed over time. I really wonder how they develop at that place. And what kind of QS they have.I think even a
200.
by bhaak 3y ago
It took 18 hours to transfer the data to the probe. According to the article the update hasn't been activated yet but they are still checking if everything is okay. > NASA scientists are carrying out a readout of the AACS memory to
201.
by bhaak 3y ago
I doubt that giraffes are metric. But maybe they are some obscure SI unit? Fun fact. 1 billion km is almost 1.1 light hours. 1 billion miles is almost 1.5 light hours with less error margin. So you can easily calculate that Voyager 2 is abo
202.
by bhaak 3y ago
How much is that in metric units?
203.
by bhaak 3y ago
What's your opinion on one line method definitions (edit: just learned that those are called endless methods) and numbered block parameters?
204.
by bhaak 3y ago
I couldn't imagine that he's trying to kill Twitter even faster than he already was killing it. I've seen so many bots with blue checkmarks that $1 per year doesn't seem to be that much of a deterrence for the more sophi
205.
by bhaak 3y ago
You said people do what Vitalik says. Ethereum Classic is the prime counter argument that this is not true. It almost flipped Ethereum, split the community, and completely wreaked the price. That's not supposed to happen if everybody f
206.
by bhaak 3y ago
So you don't believe in the existence of Ethereum Classic?
207.
by bhaak 3y ago
The settlement times of the Dollar is instant if cash is used. Credit cards are fast, too. Even bank transactions are usually faster than 3 days. How do you arrive at „3 days at best“? LN transactions are usually not settled within minutes
208.
by bhaak 3y ago
In what way is Ethereum centrally controlled that Bitcoin isn‘t?
209.
by bhaak 3y ago
No that’s not a modern convention. You could argue that any higher order bit beyond the 7th bit is undefined by the specification but the order if the bits is clearly defined. Anything with a defined 8th bit would be an extension of ASCII.
210.
by bhaak 3y ago
> "If you know what UTF-8 is (and you should) every ASCII file is correct UTF-8 as well." > > I mean kind of? ASCII is a character set, it doesn't define the on-disk representation. Excuse me for being pedantic as we

More ›