Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
lrem
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
60 ms
·
721.
▲
by
lrem
6y ago
TBF: you don't. The moment you care about any shortcoming of SQLite, move away. One of the cool things about it, is that SQLite is very lax about what it accepts (mostly in the datatype area). You can write your SQL statements targetin
722.
▲
by
lrem
6y ago
I've recently had my Python script generate about 100GB of data and inserting them into SQLite was _far_ from being the bottleneck.
723.
▲
by
lrem
6y ago
Well, one reason that S.V. companies can pay more is that they earn more thanks to being in S.V. Once I've been visiting the mothership and took a bike to drive up/down the road. There have been offices of all kinds of companies I
724.
▲
by
lrem
6y ago
Oh, I read more into the "on purpose" than probably meant. Yes, a lab accident looks like a completely reasonable hypothesis to me. What I meant is that it's implausible that this has been released on purpose.
725.
▲
by
lrem
6y ago
To anyone, like me, who has observed this from a safe distance : DFV is a widely-reported username. Like, you'd read it in a short news piece about the whole debacle. This post is the first time I see "Roaring Kitty".
726.
▲
by
lrem
6y ago
The "on purpose" bit seems highly implausible. AFAIU the ones with the means would have been the Chinese national labs and maybe their US collaborators. But releasing this right in their backyard would be an implausibly idiotic mo
727.
▲
by
lrem
6y ago
Hasn't the largest brokerage also restricted? Edit: OK, I think the list I looked at is wrong. I meant Charles Schwab, but I don't know which one is _actually_ the largest.
728.
▲
by
lrem
6y ago
Doesn't China need relatively the least recovery from this?
729.
▲
by
lrem
6y ago
Now, how would you tell if overall productivity went down? The problem at hand is that we measure "overall productivity" via the proxy of "the number of articles a panel of other scientists considered interesting enough"
730.
▲
by
lrem
6y ago
How rare is this kind of an accident?
731.
▲
by
lrem
6y ago
Why do you link now an article that mentions the possibility of Trump starting a war with Iran in last days in office?
732.
▲
by
lrem
6y ago
So, you're saying that the URLs visited are not the important bit, just that "someone under this IP is browsing internet" is the most marketable bit?
733.
▲
by
lrem
6y ago
What makes this pair special?
734.
▲
by
lrem
6y ago
My Vim is indeed magic. I start typing in a name and it autocompletes, then adds includes for whatever the package the thing I just used is in. I also can't imagine going back to not having code search, with its turning every identifie
735.
▲
by
lrem
6y ago
I've ordered non-prime items on the local Amazon, where I'd first receive a "sorry, this is taking longer than expected, please hang with us" and then the package would come _way_ later straight from China.
736.
▲
by
lrem
6y ago
And this is a passed down requirement, coming from the major advertisers. Google is simply enacting their will to never advertise on anything remotely related to a laundry list of taboos. I have a vague memory of something about this being
737.
▲
by
lrem
6y ago
Google did exit the Chinese market though and its stock price has since under-performed the competitors that did not.
738.
▲
by
lrem
6y ago
Funding for the project/department as well as personal career prospects of everyone involved are tied to the publications. Various approaches to analysing those produce importance numbers. (Note: Pagerank was an attempt of doing same t
739.
▲
by
lrem
6y ago
Oh, this is not a China thing. I've had a paper have a bunch of reviewers suggest a bunch of references each. Every bunch had every paper share at least one author. Every bunch was pairwise disjoint in the author sets. Draw your own co
740.
▲
by
lrem
6y ago
For personal projects, I start with SQLite by default. Never came close to its scalability limit too ;)
741.
▲
by
lrem
6y ago
From tesla.com description of Model Y: > Recharge 162 miles in 15 minutes at Supercharger locations Meaning you add a grand total of one hour charge time. With each charge being about long enough to do a bio break and a short stretch. As
742.
▲
by
lrem
6y ago
That only shifts the bandwidth cost between the original server and the user, Google's resources are unaffected. And it's not what GP claimed. I just checked the nginx access logs - both the 32MB and the 8MB zip files have been ac
743.
▲
by
lrem
6y ago
https://developers.virustotal.com/v3.0/reference#files-scan Seems I might have just hit the limit? ... Nope, 8.1MB zip file also wasn't sent anywhere.
744.
▲
by
lrem
6y ago
Isn't this way to get hurt by a Google's bot a brand new discovery as of 2008 or so? And the bottom line of "letting users upload things is dangerous" is no newer?
745.
▲
by
lrem
6y ago
Sounds rather too resource-intensive? I've just tried with current Chrome on Windows and a 32MB zip on my personal domain, Wireshark says the file has not been sent anywhere.
746.
▲
by
lrem
6y ago
Meh? A couple years back, I bought myself a box set of a season of Doctor Who. A taxpayer-funded series. It refused to play on any of my devices, because they were not to the DRM's liking. Torrenting took a fraction of the time I spent
747.
▲
by
lrem
6y ago
I'm not a musician, but got recently a pair of Presonus Eris 3.5 monitors as my desk speakers. I find that more pleasant to use than headphones I have (AT BPHS1 and Bose QC35).
748.
▲
by
lrem
6y ago
It isn't a matter of server-side vs client-side (I have no clue what Discord does, but it does eat quite a bit of compute client-side), but of what we get out of the box.
749.
▲
by
lrem
6y ago
> Teamspeak never stopped working Ah, so your circle of friends does not include people with messed up audio. Teamspeak happily passes on whatever it got as input. Discord does quite a bit of filtering, able to salvage legibility of some
750.
▲
by
lrem
6y ago
I'm using Element very sparsely, but keep getting annoyed by it. I did not care to touch any settings. I have a persistent tab in my browser and it keeps having the notification dot for silly reasons: - My connection flaked out (duh, I
More ›