em500

70 ms·

811.
by em500 5y ago
I'm surprised that sqlite is singled out for this, AFAIK this is standard RDBMS behavior. Your example gives exactly the same results in mysql.
812.
by em500 5y ago
> That said, I am one of those people who would prefer more rigid typing. I'm cautious about using SQLite at work specifically because I've been burned by that first example it gives. I had a situation where a client needed to
813.
by em500 5y ago
Think of SQLite not as a replacement for Oracle but as a replacement for fopen().
814.
by em500 5y ago
Is there a direct link to the bill? The posted link just gives me a WaPo paywall.
815.
by em500 5y ago
I don't disagree with you, but but at the same time I think that if the editor used "Anthropogenic forcing and response yield observed positive trend in Earth’s energy imbalance" as the headline, probably nobody would have c
816.
by em500 5y ago
> Unlike the vast majority of other human endeavors, land actually is a zero sum game, at least until we are a space-faring species. Around 17% of the Netherlands is reclaimed from the sea or lakes. The largest project (the Flevopolder [
817.
by em500 5y ago
Sure, for any individual the risk of the AZ side effect (thrombosis+thrombocytopenia) is low (3 per 100,000 for the <50 age group [1]). But in Australia, the risk of catching COVID and dying is/was even lower, especially for the &lt
818.
by em500 5y ago
> I agree with the premise - SQL gets it right, but perhaps only in PostgreSQL? I don't agree with the premise. Both MySQL[1] and MS SQL Server [2] do an implicit cast and then compare them as numbers. I don't know whether this
819.
by em500 5y ago
> This is so short-sighted and ignorant, it's hard to even read about. Brazilians should cherish their rainforest, legacy of millions of years of evolution, with wondrous biodiversity and an amazing carbon sink the planet desperatel
820.
by em500 5y ago
> Though implicit in that fantasy is that, without democracy, the blue-state liberal gets to impose his will on the Trumpers. Something that can keep someone like that committed to democracy is (for instance) the thought that the alterna
821.
by em500 5y ago
Yup. People who get their news mostly from Western media might believe Chinese live in a repressive Orwellian hellscape, and conclude that if there is not widespread resentment against the CCP it must be because it's all suppressed. Th
822.
by em500 5y ago
Assume for the moment that you're American, liberal, white collar and live in one of the more affluent blue coastal states. Now imagine that 75% of your countrymen are rabbid red state Trump supporters, of low education, get most of th
823.
by em500 5y ago
The article does note that "(Folks who have studied calculus may actually remember some of this from when they were learning about integrals and integral approximations!)"
824.
by em500 5y ago
I saw a telling cartoon in an Asian magazine a few years ago, that basically looked like this: Poor Rich 1960 bike car 2010 car bike
825.
by em500 5y ago
It would be the same issue for whatever supercomputer code you want to run. If you don't specifically target for the Cell SPEs, you're left with a single PPE that could barely keep up with the Pentium 4s and Athlon64s at the time.
826.
by em500 5y ago
We only did a few internal NN and LSTM implementations in the past, we should probably evaluate the new pytorch stuff soon. But as you can imagine a lot of our time was consumed by modelling pandemic-induced dynamics (which is especially at
827.
by em500 5y ago
Time series are numbers measured or aggregated at some consecutive times or days. It's a data type with a specific structure, like a set, a vector or a matrix: what's inside varies a lot and depends on the specific application (e.
828.
by em500 5y ago
No, you have to handcraft all (transformations) of exogenous features. But since it's really all linear regression, that's usually reasonably straightforward.
829.
by em500 5y ago
I'm a professional forecaster (i.e. getting paid for it) at a large e-commerce company. We have extensive experience with Prophet and a host of other approaches (all the traditional models in Hyndman's book/R package, some sc
830.
by em500 5y ago
"Relatable" in the sense that you can imagine that if you grew up in Canada or the USA one or two generations ago, you could easily have been supportive such policies yourself in your own country.
831.
by em500 5y ago
Yes. It's easy to paint the current Chinese policies as barbaric, but such was the official policy in democratic Canada (and the US, which had similar policies) barely a generation ago. It does not justify current Chinese minority po
832.
by em500 5y ago
Compared to ARM, Intel has the additional problem that their Atom descendant little cores don't implement the full instruction/feature set of the big cores. That could be because the full set is (power/die-size wise) expensiv
833.
by em500 5y ago
> It’s bloat directly impacts the speed of the operating system. Do you have any evidence of this? I remember in the XP days the German c't computer magazine tested populating the registry with hundreds MBs of garbage and found no
834.
by em500 5y ago
> Ownership is overrated. I'm largely with you on this, philosophically, rationally, economically. But we're probably a tiny majority, most people seem to react on emotion on this. Amateur psychology time: I think a large compo
835.
What I Witnessed in 1989 in Beijing(chinamatters.blogspot.com)
13 points by em500 5y ago|0 comments
836.
by em500 5y ago
> If Huawei is copying they will always lag behind. I think the cause-effect here is reversed. They are copying because they're behind, in this particular area. No doubt they're vigorously defending their own IP in 5G. Compan
837.
by em500 5y ago
I think practically speaking such concerns are way overblown. There are tons of megacorps with lots of very ethically questionable practices (not just tech wrt privacy issues, think about money laundering banks, food and energy companies c
838.
by em500 5y ago
Some people simply don't get much value or enjoyment from a good meal at all, in that case it's probably too hard to make them understand. But assuming that you do enjoy dining at a good restaurant once in a while, can you imagine
839.
by em500 5y ago
That's the original German version of the article which was translated in my hydrogenaudio link.
840.
by em500 5y ago
> I keep my music library in FLAC, both because I know it's CD quality and because it's an archive. I want to be able to convert the tracks to any new codec that may come along, if I need to. I understand the sentiment. But the

More ›