marzell · HackerTrans

Also there are other variants and tricks around this for other colors as well https://en.wikipedia.org/wiki/Impossible_color

marzell

6 ay öncediscuss

"correting" lol

marzell

7 ay öncediscuss

There's good arguments for the case that gatherer communities actually had generally better health and far more free time than farmers and agrarian society.

Farming provided the calories necessary for a population that hunting and gathering could not support (so no going back) but required basically working all day to make it work and survive less than ideal conditions. But prior to farming people often had significant more free time.

marzell

9 ay öncediscuss

Yeah at that point I think we'd be better off if everything was just UTC and dealt with locally

marzell

11 ay öncediscuss

You absolutely can in many engines, for instance in Snowflake... with the small exception that in all supporting engines you actually need to use HAVING instead of WHERE in your second example (because it compares an aggregation, otherwise WHERE is fine).

You can also use "correlated column aliases" (I can't recall the proper name) i.e.

    SELECT
        id AS foo,
        foo || '_1' as foo_n,
        right(foo_n, 1) as foo_ordinal
    FROM MyTable
    WHERE foo = 1;

Again, if this isn't all part of SQL standards, the reality is that a lot of engines have semi-standard (sometimes very proprietary too) ways of handling these now common patterns. For real-world use cases, the standards are unfortunately becoming increasingly irrelevant. I think it would be better in the long term to use standards, but if they can't keep up with actual usage then they will just get ignored.

marzell

11 ay öncediscuss

> Per the SQL standard, you can't use column aliases in WHERE clauses, because the selection (again, relational algebra) occurs before the projection.

Except this works in most major vendor SQL implementations. And they all support relation aliases in SELECT... Seems the standards have long fell behind actual implementations.

marzell

geçen yıldiscuss

Some factors I think are involved, but I don't see mentioned - EVs produce more readily available torque in general, and also tire choice heavily factors in EV range (low rolling resistance), which has a negative impact on tread life

marzell

geçen yıldiscuss

We make corn that isn't even considered a food, legally. We subsidize that using a lot of tax dollars, to the absurd point that we pay farmers to NOT grow corn and leave fields empty. Everyone is paying for way more corn than is needed through taxes, while people claim this keeps costs low (it's more, you are just paying it in taxes). And then we come up with excuses to use more of it, like corn syrup and ethanol. This is absolutely absurd.

marzell

2 yıl öncediscuss

Long before the richest man on earth bought Twitter to be his personal megaphone to help him prepare to become president in order to boost all his personal endeavors, the letter X has been used as a sort of contraction to replace common morphemes like "cross", "trans" etc, in places where the physical representation "x" likens to a cross or crossing of some sort, or in reference to the Greek letter Chi. Must we change our use of language to support this guy, too?

Xtian Xmas xfer tx/rx xor...

marzell

2 yıl öncediscuss

I believe the "thinking out loud" is fundamentally part of the process of "text completion" which is what it is doing. Certainly we can (and do) break things apart and add layers that could be used to effectively do this by adding more steps and processing time. But ultimately in a single turn, the entire conversation up to that point (including instructions you may have added telling it to not think out loud) is the input, and the output will reflect that.

marzell

2 yıl öncediscuss

I'm not arguing your point, but this is the general state of gaming today. A significant portion of "single player only" games require you to be online, contain "online" content, and access to the game can/will be effectively removed when servers/services go offline.

marzell

3 yıl öncediscuss

The second point, yeah that's relevant.

On the first point, just give each person n-1 shards, each missing a different one. Then any 2 can decrypt. Or configure it for however many participants there are and they minimum number needed to encrypt.

marzell

3 yıl öncediscuss

What's the practical benefit over just sharding a decryption key and handing out multiple shards to each person?

marzell

3 yıl öncediscuss

for something a bit more robust, check out DuckDB. It's a library you can embed, use it to run SQL on local files as well as connect to databases, do joins, analytics, etc.

marzell

3 yıl öncediscuss

If we aren't already living in a simulation, then we've begun a feedback loop so that in the near future, we very well may be.

marzell

7 yıl öncediscuss

I wonder if this if at all related to the news about Sackler transferring funds to offshore accounts

https://edition-m.cnn.com/2019/09/13/us/sackler-family-purdu...

marzell

7 yıl öncediscuss

I think it's a great opportunity for exposure for these new meat alternatives, and also a potentially great income boost that will help them expand operations and secure their future business.

marzell

7 yıl öncediscuss

My impression of Impossible Burger v1.0 was that the pinkish/uncharred bits had an odd sweetness and moisture/texture that made it most distinguishable from a beef burger. With 2.0, the texture is a bit more firm and beef-like, and it seems they've put less emphasis on the 'bleeding' which I think has reduced the sweetness as well.

I had a notion that I intended to test with v1.0 that it would be more convincing if you charred the hell out of it and made it more like an overcooked burger, however I never did test it, and I also read that it didn't perform well (fell apart, etc) if too overcooked. However, I did really like the flavor and texture of the most charred bits of the burgers I did have.

marzell

7 yıl öncediscuss

Another aspect of this is that processed foods require less calories for your body to metabolize, since they are already partly broken down. While that doesn't specifically increase the rate of exposure to pathogens/toxicity, it does increase the net calories consumed in an already high-calorie category, and contributes to obesity.

marzell

7 yıl öncediscuss

I have found the 2.0 versions of both Impossible Burger and Beyond Meat burgers to be a decent improvement over their original versions.

comments