pjscott

40 ms·

421.
by pjscott 6y ago
It's also super common on MacOS. According to lsof(1), my laptop has 95 sqlite .db files currently open; deduping by path shows 56 unique database files open at the moment.
422.
by pjscott 6y ago
You can print the version with this magical incantation: $ python -c 'import sys, struct; print(struct.unpack(">I", open(sys.argv[1], "rb").read()[96:100])[0])' foo.db
423.
by pjscott 6y ago
Make sure to also copy locked.db-wal if it's present. (Is there a better way to do all this? I feel like there really ought to be a better way.)
424.
by pjscott 6y ago
If it becomes hard to find AA batteries, you should just be able to hook up an equivalent voltage supply.
425.
by pjscott 6y ago
A lot of things are background tasks until suddenly, without warning, the user ends up waiting for them to happen. Take your example of handling network connections, for example: this can definitely be a background thing! Your computer migh
426.
by pjscott 6y ago
At the current level of spam link posting, sure. But if getting spam links into Wikipedia were more valuable -- say, if they stopped using rel=nofollow -- I wonder how much the amount of incoming spam would increase.
427.
by pjscott 6y ago
That sounds tedious. You should at least be able to skip that last step with one of the various browser extensions to redirect to old.reddit.com automatically, e.g. this thing for Chrome: https://chrome.google.com/webstore&#
428.
by pjscott 6y ago
There's not that much overlap between the sets of people who'd be able to work on those two things.
429.
by pjscott 6y ago
There used to be a hack where you could write your own UUID-to-dSYM script, name it "dsymForUUID", and then lldb would assume it was Apple's internal magic thing and use it. Fortunately lldb seems to have improved since those
430.
by pjscott 6y ago
To expand on your edit: 1. This comment thread shows comments in random order, so you're not seeing the more upvoted questions bubble to the top the way they usually would, which prevents winner-takes-all feedback loops in the voting.
431.
by pjscott 6y ago
Obviously the argument in that paper applies to humans as a special case, but the whole point of it is that it also applies to a much more general set of possible minds, even ones extremely different from our own.
432.
by pjscott 6y ago
Sure, and if we're very lucky it'll eventually go quadratic as our species expands out into the universe in an ever-widening sphere. :-) Few things can grow exponentially forever, but a lot of things can grow exponentially for lon
433.
by pjscott 6y ago
For tiny arrays, Timsort uses insertion sort.
434.
by pjscott 6y ago
For anybody looking to skip ahead to the real start of the video, where Scott Havens appears: he comes on at about the 7 minute mark.
435.
by pjscott 6y ago
That would break rendering on a bunch of blogs because of mixed content problems: https://support.google.com/blogger/answer/6286127
436.
by pjscott 6y ago
When you click on a link to the news.ycombinator.com domain, what should happen if you prefer dark mode? And vice versa? In comparison, the pure-CSS ideas that some people are posting would work automatically if your browser supports dark m
437.
by pjscott 6y ago
I love it when a business makes the world better and turns a profit. They can use those profits to keep making the world better, instead of (for example) running out of money and shutting down. Or, to make it more concrete: I got some rea
438.
by pjscott 6y ago
That definition sounds fairly non-standard. https://en.wikipedia.org/wiki/Weight#Definitions
439.
by pjscott 6y ago
Weight doesn't vary like that. What varies based on angle are the counterbalancing forces applied by your various body parts to keep it in place. That's vaguely similar to what the article said, so they may be basing this on an
440.
by pjscott 6y ago
You can do all the visual things mentioned in this article and still very easily end up with a lousy landing page. Your goal is to convince people to become your customers, and the visual design is there to play a supporting role. At the
441.
by pjscott 6y ago
The Stack Overflow database may be freely available, but the Stack Overflow user-base will probably keep on going to Stack Overflow because that's where the rest of the Stack Overflow user-base goes. Network effects are tough somet
442.
by pjscott 6y ago
I'm not sure it's even possible for a nicotine company to stay successful for very long without a big lobbying effort. As soon as they're a big enough brand, they become a juicy target for political interference from the us
443.
by pjscott 6y ago
That's officially part of the plan, because otherwise it would be politically impossible -- but if those things get delayed, which seems likely, NASA could "temporarily" use some other, saner way of getting astronauts to lu
444.
by pjscott 6y ago
Here's an article from NASA with more description of what they're building: https://www.nasa.gov/feature/nasa-selects-blue-origin-dyneti...
445.
by pjscott 6y ago
> No exponential increase in tonnage over Apollo, but an exponential increase in costs and private access. When you say "exponential" here, are you using it as a confusing synonym for "really big"? Or is there somethi
446.
by pjscott 6y ago
I keep hearing this, but governments in extremely Democrat-dominated areas don't seem less dysfunctional. I live in San Francisco, for example: Republicans have approximately zero power here, the government is too big to drown in the B
447.
by pjscott 6y ago
Apple's recent 64-bit ARM processors now support unaligned memory access, so there's one porting problem out of the way: https://developer.arm.com/docs/den0024/latest/an-introductio...
448.
by pjscott 7y ago
The thing that really worries me when I'm writing SQL is the possibility that the query planner will get frisky and choose some disastrously slow join order, but only once in a while. I've run into way too many hard-to-reproduce
449.
by pjscott 7y ago
Nice! This is clearly written, and exactly what I was looking for.
450.
by pjscott 7y ago
This is equity financing, not debt. There's no tab to pick up.

More ›