glogla

> Is being against child sexual abuse really an unusual opinion in the tech industry?

Nobody said that. You are being manipulative an trying to make it look that people who disagree with you are somehow pro-child abuse.

In saying "Does the tech industry have any alternate solutions that could functionally mitigate this abuse?" you are trying to pain a picture in which child abuse is somehow "tech industry" fault.

You are also trying to paint a complete Panopticon in which every interpersonal communication is subjected to surveillance by the state as somehow the default, that end to end encrypted electronic communication is changing - while the truth is that personal communication was private for hundreds of years, because it was impossible for the state to listen in on everything.

MB is not just a knowledgeable about typography and fonts, he also published his online book using his own software he built in Racket. Definitely a true hacker!

Brandenburg airport, I think we might watch the same podcast (with slides).

Which I am sure will be used as a proof that infrastructure investment into anything else but cars is a bad idea, in due time.

Yes, I am looking forward to seeing this on some engineering disaster channel in few years.

SMS is the only second factor that works for people without smartphones. Having a smartphone means signing your life (your location 24/7, your messages, your contacts, your everything) over to either Google or Apple.

I understand the security aspect and realistically most people will have smartphones anyway, but forcing everyone into this surveillance duopoly, especially as Apple is overpriced and Google is ad company with stated mission of removing privacy, makes me pretty salty.

There should be a better way.

See this https://shops.audi.com/en_GB/web/zubehoer/p/retrofit-solutio... for example. I can only assume it's resistive, since it doesn't start the engine - but it might be a system for running the AC heatpump without engine, maybe. Also now that I think of it, window defrost is resistive.

I would guess system like this would be rare in US, because you are allowed to have remote start on your cars.

edit: never mind, it burns fuel https://www.auditech.org/acont-1427.html

The engine by itself produces a lot of waste heat. But modern engines are more efficient and take a while to warm up (especially diesels, but small turbos like Honda 1.5 too) so cars sometimes implement resistive heating to heat the cabin quicker.

Also some cars have independent heating that can be used to heat up the car up without running an engine. Not sure how exactly it works but I think it uses special battery.

AC compressor of course takes a lot of power.

> I usually assume drugs or suicide.

And sometimes it's hard to discern one from the other.

It is not broken. They are punishing you for not wanting to be tracked, profiled and manipulated.

They also do bunch of stuff that ClickHouse can't do, like correlated subqueries [1] or recursive CTEs.

I kinda wish for a database with ClickHouse storage and DuckDB optimizer. At least my experience with ClickHouse is that MergeTree is incredibly good at what it does, but the optimizer hurts.

[1]: https://duckdb.org/2023/05/26/correlated-subqueries-in-sql.h...

Last time this showed up on HN, I complained about it not having CASE WHEN equivalent, which I've seen heavily used in ETL usecases. Now I see they added it!

Pretty cool and responsive. I'll go take it up for a spin.

What can I say.

It seems that if there aren't thousands of chargers in Stockholm as of today, then it is horribly terribly inconvenient to use EV. And since it will never get better, I guess we just have no choice than to keep burning oil and destroying the planet.

Ah, you're calling that suburban. Ok, then it kind of makes sense. When I hear apartment, I imagine place like this: https://goo.gl/maps/hArPffCzEF8GZfHh6

In your case, we're not talking about some kind of physical or technological limitation but about politics - it would be very easy to add chargers to the parking lots, and it would be easy to have better public transport. It is not an EV problem, but municipal elections problem.

The film is a satire of fascists propaganda, and as good satire often it, it is also an good example of fascist propaganda, just like Snow Crash is satire of Cyberpunk while being a good Cyberpunk.

The book isn't exactly fascist though. Verhoeven said he didn't read the book and does not plan to, so he is satirising somewhat superficially.

Heinlein did explore a lot of various political systems in his books, and I think Starship Troopers is focusing most on voter engagement - how people who vote should know something about what they vote on, and that is why only those who served (which includes military but also other "national service" like being a worker colonising planets or postman or whatever) get vote.

Is that fascist? I don't think so. Is it a good political system? I don't think so either but it is a good enough idea for a book.

I'll admit I'm a bit surprised by "apartment in suburbia". Of US I have only seen few places. I thought most people either live in a house in the endless featureless landscape of suburban New Jersey or in Brooklyn apartment or whatever - and the former can charge in their driveway and the latter can just mostly use the subway and citibike.

Anyway my assumption was that someone would likely either have a driveway or a public transport. But I'm sure there are places that have neither - I'm just not sure how common that is.

> Why adopt a solution that is worse than the status quo?

Depends. If you believe climate change is a hoax pushed by evil liberals or whatever, the status quo is fine.

If you understand that it is real, then you know that keeping the status quo of burning oil means working towards destroying human civilization. Then it's easy to decide that mild inconvenience of charging an EV is worth keeping humanity around.

I had waiter in Italy tell me "select zero on the card terminal, that goes to my boss, not me, if you want to tip leave some cash".

But yes, the craziness is coming here too. I have not seen it myself, but my friend complained about grocery store self-checkout asking for tip. Touchscreen order terminals in fast food takeout places also ask for tip, of course.

So we're talking about people who live in an apartment, yet far from work or in place with bad public transport so they need a long drive to work? I'm not going to claim people like that don't exist, but is it a common use case?

For me, I have paid charging station right in front of my building, because the electric company recently added charging to all local substations. But for myself I would probably charge the car at free charging places in one of the nearby grocery stores, I usually stop there like once a week anyway. We're also trying to get our employer to enable charging in the office garage, but it's dragging a bit. The larger shopping mall I visit with friends for cinema also has free charging for customers.

It's not that many places, and people in countryside or suburbia who can charge EVs with free electricity from solar panels have it easier, but since people in who live apartments are probably covered by public transport or can bike or whatever, and as such don't really need to drive ever day, I'm not convinced charging EVs is not solved problem right now. We'll see how it scales up.

Your comment can be interpreted two ways.

If you're asking "where do we get the power plants", that is a valid concern, especially as we want to get rid of coal power plants at the same time.

But ultimately it is not that much power - I did a back of the envelope calculation for my country and converting annual vehicle-miles driven into kWh with average EV efficiency ended up adding 11 % increase in electricity consumption.

Not sure how it stacks up with other countries, and yes, we need more and cleaner power, but 11 % increase is not insurmountable problem.

If you're asking "how does that much power gets places", electric trains routinely run as much power. My city runs hundreds of trams that take over 700 kW each, and full power electric locomotive usually takes about 5 MW. The grid already knows how to handle it.

If you live in an apartment and often work from home, you probably don't drive hundred miles every day, and as such don't need to charge the car very often.

I did the math for myself, and with how far and how often I go places, I would need to charge a 400 km range Hyundai Kona about once every two to three weeks.

I do have pretty favorable conditions, though (and mostly continue to use the bus).

In EV space, they're not even that. They have no competitive offerings and they wasted a lot of time going after hydrogen, which was shown to be not feasible like a decade ago.

Their current hybrids are nice, though.

Lately I'm more and more convinced that the challenge is not doing a thing, the challenge is scaling it up. Doing a thing is a necessity for moving forward, but scaling it up is how you change the world.

On one hand, Toyota is pretty good at scaling things up. On the other hand, they have not shown scaling it up, they have shown doing a thing.

We'll have to see. The time is running out.

What kind of person do you have to be, to think "I stand with Ukraine" message is "worst human behavior"?

Yup. Just like in America, construction needs those huge pickups, while around here everyone just uses a van.

That sounds like really smart design that does off with most of the cons of this. Good work!

I'm pretty sure SQL Server and MySQL use locking instead of MultiVersion Concurrency Control so they don't keep more copies of data around. No vacuum needed but there's a possibility of things blocking.

But I might be out of date.

I with people would stop with the "Uber migrated from Postgres to MySQL" thing. Uber migrated from Postgres used as relational database to something that is basically their own non-relational database using MySQL as distributed key-value store. It is not really situation applicable to most users of Postgres.

Anyway, this design of MVCC which moves older data into undo logs / segments is used by Oracle DB, so it definitely works. The common challenge with it is that reading older versions of data is slower, because you have to look it up in a log, and sometimes the data is removed from the log before your transactions finishes, getting the dreaded "Snapshot Too Old" error.

E: I don't see in the article when rows get evicted from the undo logs. If when they are no longer needed, I'm not sure where the improvement comes from because it should be similar amount of bookkeeping? If it's a circular buffer that can ran out of space like Oracle does it that would mean under high write load long-running transactions starts to fail which is pretty unpleasant.

It is an Elden Ring (video game) reference. https://knowyourmeme.com/memes/no-maidens-maidenless

Wow, that website loads so fast.