skysight-inc/HackerNews huggingface dataset:
Yes, the city I'm living in is planning to do so also, it's one of the biggest french cities.

My biggest issue with it is there is no plan to help poor people who will need to buy a new car or they won't be able to drive anymore in the city. Those policies must happen fast, but we should not sacrifice poor people to do so.
> "We hope to publish guides about more complex use cases (lending, insurance, etc.) in the future."

That would be appreciated. It'd be nice to see the minimal complexity needed for something like a local credit union that managed customer savings and checking accounts, as well as home and car loans.

More ambitious would be a central banking app, in particular how does double-entry accounting work when a central bank (i.e. the Fed) is doing 'quantitative easing' and using their helicopter money to buy up Treasury bonds and mortgage-backed securities in order to keep major banks and government solvent? What's the private bank's balance sheet look like when they use the central bank money for stock buy-backs instead of for increasing commercial lending?

For example, the Fed says it's unloading the mortgage-backed securities it bought up in 2008-2009. That's got to be some convoluted accounting:

https://www.marketplace.org/2022/06/02/why-the-federal-reser...
so you can do this?

WITH t AS (
DELETE FROM foo
)
DELETE FROM bar;

Or can you only use SELECT for WITH queries? Did you not realize that other databases and the SQL standard allow you to do this?

Yes on the final query of the CTE you can do all sorts of things, but that's way less useful if you can't do them in all the component queries.
I legitimately have no idea why there is such antipathy towards nuclear energy lately.

It produces very little waste, it can be stored on site, and has almost no pollution (besides heat waste and the used radioactive materials).
>If the state government was serious about this, they would be installing chargers all over the place.

Just a reminder for everyone, the average car on the road is over a decade old. Since this ban only applies to new cars, electric cars are unlikely to be a majority on the road until the 2040s possibly even the 2050s as maintaining old gasoline cars will become more desirable the harder they are to purchase new. There is plenty of time to build out the charging infrastructure and chargers will naturally be built in larger numbers as demand for them increases.
There's a third option you didn't mention in your comment: instead of signing the block with these banned transactions (option 1), or signing an alternate block with other transactions (option 2), the node could pretend to be offline for that block (option 3). Instead of being slashed, the node would then be subject only to the much smaller inactivity leak for these blocks.

The only question then is how indirect these sanctions can be. The node might not be allowed to validate a block with banned transactions, but what about the next block, which does not include these blocked transactions, only a pointer to a block with these banned transactions? What about the second next block, which has only a pointer to a block with a pointer to a block with these banned transactions? How many blocks until the link is tenuous enough that the validators under USA jurisdiction could validate again without fear?
If you buy something you own it, you don't subscribe for physical things. That's the outrage, double dipping from manufacturers.

If I buy a car with heated seats physically there then i own them.

On that note, if someone just enables them without payment i'm curious of the legality. (or selling devices to enable it)
What about installing fennec from f-droid? Doesn't work?
I think it would be great if they actually policed not just the pawn shops and sketchier bike shops, but also the people randomly selling them on the street and the back-alley bicycle chop shops, which are easily visible. Instead of the theft victims wandering the neighborhood trying to find their bike and get it back, which is what happens a lot here, I would like the police to take a swing at it.

But from the air of the police taking reports, absolutely nothing will happen. One time a cop asked me why I was bothering, did I need it for insurance or something? No, I told him, it was a crime and I figured that being police, they'd want to know. That seemed novel to him.

But I don't just want them to do something for me after my bicycle is stolen. I'd like them to be energetic enough in running down organized bike theft operations that those criminals find some other line of work. And a good way way to do that is taking individual bike thefts seriously.
You don't see that you have a conflict of interest?

It is in those corporations (listed as Sponsors) interest to have access to vast array of Open Source projects to exploit them commercially without committing to any R&D costs and paying the authors.

I would argue that you have hijacked the "open source" term.
Have we used the same PHP? IME it's usually necessary to read the comments on the documentation for important information, which is frequently totally absent in the actual documentation.
I used the same xbox 360 controller for PC gaming until I literally wore the tops of the analog sticks off and it never drifted. My Switch Pro controller started drifting after eight months.
How do you expect `y.b` to behave on EMPTY rows? Should it return EMPTY or NULL?
It's not a "gratis bonus" when I specifically buy a device because I require that feature.

Besides Windows 11 requiring a TPM, which was known to be on the cards for a while now, storing the key on a USB drive is not functionally the same as the TPM. It means either the key material is stored in plaintext on the USB, which is pointless, or I still need to use a PIN. I need my computer to be able to boot without intervention, so that isn't an option.
I'd vote that is a bad way to govern, I am not in Cali so I have no ability to affect this.
Remote start is a basic feature in cold climates like Canada, especially if you have young kids. It's hard enough to wrangle kids into the car, let alone when it's -40°C outside. Remote start allows the interior of the car to warm up beforehand.
Why would anybody use the Outlook app on iOS as opposed to the built-in one?
Just keep the backup diesel generators far, far above the tsunami zone and all will be well. There were repeated recommendations (that were ignored) to move the backup generators at Fukushima Daiichi to a significantly higher elevation but management decided it wasn't a priority based on known threats. After March 2011 I don't think it will take much persuasion to implement such safety recommendations.
This is not a credible line of argument.

Other countries - notably Finland and Austria, among others - have no problem providing reasonable state housing at reasonable cost.

Finland houses its homeless as a matter of course because it turns out to be hugely cheaper than the alternatives, economically and politically.

Some of those countries also score well on affordable private home ownership.

America doesn't - because the idea of a government that buffers its citizens from private sector exploitation is against the guiding creed of economic narcissism.
I imagine they believe there is the potential to lose significant money
Why would this be any more plutocratic than any other capitalist economy? It's a mechanism where you can lock up ETH and get paid a steady return over time (about 3.9% today). Similarly the US dollar has treasury bonds where you can lock up USD and get paid a steady return over time (about 3.4% today).
60m publicly addressable users on Matrix protocol, not even including EU gov, healthcare, military, emergency services.

Nobody is saying email is going anywhere.
Do they have the infrastructure in place to allow this to happen? Charging points, electricity generation capacity? Or is it just an unrealistic aspiration?
Remain confused.
When do most people charge their cars? If it's when they get home from work, they'd be adding to grid load at peak times. Although maybe cars are smart enough to wait until 5am to start charging
I also don't understand what stops ycombinator from supporting IPv6.
It's a pretty simple website, what's the big effort?
Apple saying "looking at web content can lead to arbitrary code execution, this is potentially already used in the wild" wasn't enough?
Also worth noting that Sqlite released a WAL2 journal mode recently that eliminates the "stop of the world" we had with WAL when checkpointing. Basically it maintains two wal files and switched between them when one needs to be checkpointed. It is quite neat!
Perhaps Amazon is FINALLY starting to do something about their rampant book piracy problem?

[0]https://mobile.twitter.com/martinkl/status/15511491594026680...

[1]https://nypost.com/2022/07/31/pirated-books-thrive-on-amazon...
That's a way to classify whether or not the pics are indeed dick pics, but the problem lies in how these recent diffusion models work. Typically you have two encoders, one for the text prompt and one for the image. Then you train a model to optimize where the prompt embeddings match the image embeddings. You've got to actually have some decent descriptions of the dick, like: thin, girthy, 7", 8", 4", micropenis, veiny, limp, hard, huge tip, bifurcated, foreskin, black, white, latino, asian, etc, if you want to generate with any accuracy your desired fake penis.
I beg to pardon.
Also, he's using an AMD graphics card. AMD GPUs are infamous for stuttering issues and framerate problems on Windows.

I tried a RX580 pre-pandemic and it was both a space heater with massive power consumption, framerates were wildly inconsistent in several games, and I had game crashes.

Switched to a GTX1060 and boom, problems gone.
Auto companies are scared of big tech. So stuff like heated seat subscriptions ends up happening due to some cargo cult bureaucracy, where the idea could be good (new innovative feature) but execution is horrible.
The first target seems reasonable, as an extension of the current ZEV percentage trend. Setting targets also helps alleviate market uncertainty around large transitions like this.

The state is taking steps to develop and expand charging infrastructure, both through extensive funding of utility-side upgrades, building standards and codes, as well as grants and tax incentives. <a href="https://afdc.energy.gov/fuels/laws/ELEC?state=CA">Here</a> is an overview if you are interested.
Chromium OS Fast Boot (2009)
In the US there's a derogatory slang for the most obnoxious form of the second category: Freds. Fred is a guy on a $10k bike that treats a pedestrian and commuter heavy bike path like their own personal tour de France.
Phishing attack against PyPI users
Show HN: My first ever web app
The great part of this is that I can guarantee you will modernize your architecture using google cloud.

Once a year has passed, google will sunset the core services you need, forcing you to rearchitect your solution. Guaranteed modernization!

Thanks Google!
JavaScript, embedded, in email is, pejoratively, a bad idea by putting too much power into a transmitted email.

Too many security holes, discovered and undiscovered with JavaScript, not to mention JMTP.

Better yet,

Hashing the local part of the email address and retrofitting mail clients to do the mapping and rejection is the best way to delete unwanted and unsolicited emails.

Couple that with new decentralized lookup of sender’s PKI (as well as DKIM).

That should add years/decades to SMTP viability and usability.
3-Lisp: an infinite tower of meta-circular interpreters
A 3-lisp program is executed by an interpreter written in 3-lisp that is itself executed by an interpreter written in 3-lisp and so on ad infinitum.
Researchers find a better semiconductor but must find a way to mass produce it
Nintendo hasn't committed to using it.

This is just an announcement that the DRM SDK exists for companies to add to their games, not that it would be included in any specific games, Nintendo 1st party or otherwise.
Toyota ! That breaks my heart.
I am not talking about the entrance exam. I am talking about the final exam you need to pass to graduate. It is the same for everyone.

Once again, most of the students who qualify in the entrance exam with a lower score are the middle-high income class, donations and payments based upper caste students.

In all my years in India, not once has anyone complained about the upper caste doctors who have literally purchased a seat in medical school, including yourself. Their only concern is caste. The racism is very loud and very clear.
Vote with your wallet. Do not purchase any car with these "features"
Any validator can run the slasher process.

Docs from one of the validator clients: https://docs.prylabs.network/docs/prysm-usage/slasher
Dbt to the rescue!
Excellent reply!

Many were frustrated for so long with paying for alllll of the cable channels so we could watch < 10. All I ever wanted was to pay a flat fee per month for each channel. Well, now we live in a world where that's possible and it's great!

Being able to subscribe to one service for a month or two, catch up on a favorite program, then cancel paying for it when that's done is an unimaginable convenience. Some make it unnecessarily difficult to do that, but it seems like those are the services with less interesting content anyway.

Anyway, I think where we're at with this is fantastic. Likely we'll see some consolidation in the market where less successful services disappear and other services suck up the shows left behind. If that pendulum swings too far it'd be unfortunate, but where we are right now seems to be a sweet spot.
Stuff like Denuvo was normal back when games where sold on floppies… What is this “normalization” you’re talking about?
Speak the truth at any cost.
but how will they deal with the additional surge on the already stressed grid and no water?

this is national virtue signaling and there's no way that ICE cars are going away. I know several people who sold their electric cars and are back to ICE because these electric cars struggle during cold weather, snow, and uphills. Not everybody lives in a flat terrain

ICE cars are not going away unless they are able to suddenly produce EV in such massive numbers that it will become cheaper than ICE AND handle the load on the grid.

EVs struggle in mountainous and cold weather regions which Japan and South Korea regularly go through. On top of that there is a growing water shortage which means the nuclear power plants being built will be capped.

All of this weird wokeness and virtue signaling is only making the world a worse place. The bulk of the co2 production comes from countries that make cheap goods for Californians and in wealthy nations. But you won't give up your goods now for a better world right? It has to be the talking points by ESG lobbyist and corporate interest.

What a sad pathetic world. At this rate MIT is dead on money about society collapsing.
When I dropped it my basic cable TV was more than $100/month. Now I pay something under $50 (depending on how you count Prime and my Apple One bundle) for what's probably frankly more streaming options than I need. I don't have any live TV though I could always add a service if I wanted to and I still wouldn't be more than my cable bundle was.
> bikes are not saving anyone

They are actually, biking improves health a lot more than any negative aspect. It's a ridiculously good way to save lives.
Even the very smallest Tesla Solar (21 KW/day) setup can generate x3 times more electricity than needed by a moderate commute. Most EVs use roughly 3 miles per KW. So, 7 KW would allow you to travel 20 miles per day 7 days a week or about 45 miles per day 3 days a week.

there's more than enough electricity to go around.
Look at the Sponsors list - it proves my point. That term has been hijacked by big corporations to ensure they have free access to projects created by community without remunerating the authors.
The other odd thing is that the journal_mode is only persistent for WAL, I believe. The DELETE, TRUNCATE, & PERSIST modes are per-connection. It makes sense though since those 3 modes deal with the rollback journal and are compatible with each other while the WAL is totally separate. https://www.sqlite.org/pragma.html#pragma_journal_mode
What exactly do you think Valve did wrong that they should be sued for? Should Quaker Oats Company have gotten sued over the Cap'n Crunch whistles that became popular for hacking phone systems?
That's between Nintendo's ego and people who own the steam deck, not valve.
We don't live in a technocratic dictatorship. The fact that a technology exists does not give government the right to shove it down everyone's throats.

This is going to result in a voter backlash if they really try to force it through. And that backlash could very easily result in a backlash against climate policy in general, especially if the left follows their normal habit of responding with even more strident moralizing rather than compromising with a more incremental approach.
This is only true if ETH remains a niche security and not a widespread currency. A large population won't drop a commonly used currency because of ideological concerns like miner collusion. Indeed, they'll have massive incentive to keep using it since their saving may be denominated in it.
I don't know about France but the plan in California is to end sales of new ICE cars. If you have an existing car you can keep using it.
Maybe Tesla shouldn't be claiming it was solved in 2016, if it wasn't an easy problem.

The deadline for "Coast to Coast Full Self Driving" is over 5 years old now. https://techcrunch.com/2016/10/19/musk-targeting-coast-to-co...
I don't see them making progress. They have gone backwards. A few years back, when they still used radar, they had a ho-hum suite of driver assistance features. Now they have nothing I would trust.
I think you're confusing "unpopular" with "technically impossible".
A lot of people buy these three ton machines to feel "safe". In turn they don't feel the need to protect others from that machine. In my LA neighborhood I saw a lot of moms barreling through the neighborhood in their big SUVs with their kids while talking on the phone or texting. I have had several occasions where I had to jump out of the way to not getting run over. I don't think the drivers even noticed me.

when I had my motorcycle most near misses were also with SUV drivers not paying attention when changing lanes. The more expensive the SUV the more dangerous.
I look forward to the "pollution", personally

This is not in denigration of human artists, photographers, etc

I think it'll drive artists to make better/different work (just like the advent/adoption of the vanishing point changed art ~500-1000y ago)
TigerBeetle is an open source ledger database you might be interested in.

Not sure about payments integration though.

https://github.com/coilhq/tigerbeetle
I agree that the client's performance is important. I'm hoping to avoid frameworks so that any issues will be as clear as possible, but maintenance will tell if that's a good decision.
A nullable column can always be extracted to a separate table with a non-nullable column and a foreign key. If you left-join this back with the base table, you will get the nulls again for the missing values. So to me it seem nicely symmetrical to use the same kind of NULL value.
Very nice!

Does this tool have a state model that you can check the application state against? In other words, does it have property-based testing? Here[1] is a demo of what that looks like.

I

[1] https://medium.com/criteo-engineering/detecting-the-unexpect...
Not just that, trivial bugs aren't getting fixed. The charts showing response times, for instance, sometimes go crazy when you change the settings for time window or interval.
Love the idea!
Seems like it might save me quite a lot of time and money starting new rust projects - especially to avoid the pains of AWS.

Tho makes me wonder, can the provisioned infra be accessed somehow?
i.e. when provisioning a Postgre DB, is it possible to get the access data so it is accessible via other tools and backends?
> It's the best part for execs who think piracy cuts into legitimate game sales (it doesn't).

I’ve bought games because there were no cracks available, I don’t think I’ve ever bought a game after pirating it.

There’s no way I’m alone in this.
Even if that's true, it's just tracking EV availability. At some point if EV availability can't keep up, what happens?
Many of those complaints seem theoretical. I like to focus on practical concerns. The biggest problem I see is that the SQL language has grown too complex. It's related to the "Lack of Orthogonality" problem mentioned in the article, but I see different solutions. SQL is not based on combinations of simpler concepts, but hard-coded keywords. But how to orthogonize (factor) it gets into philosophical differences. My favorite alternative is an experimental language called SMEQL (Structured Meta-Enabled Query Language):

https://wiki.c2.com/?TqlRoadmap

It's more API-like to reduce the need for specialized keywords. And you can "calculate" column lists via queries instead of have to list columns. For example, if a table has 60 columns and you want to SELECT all 60 minus two columns, you can't without listing all 58. With SMEQL you can use a query to return a list (table) of those 58 and feed it to the equivalent of a SELECT clause.

Things like CREATE TABLE are fed a table if you desire so you can "compute" your schema. You can generate entire schemas from data dictionaries. Anything that can be done with a table is. You can create in-line (virtual) tables if you want it command-driven, but it's still "using tables to do everything". You can use textual code to create such virtual tables or a table editor as it fits the situation. SMEQL is as close to "everything is a table" as I've seen. Even your FROM list can be table-ized. I used to do similar with dBASE/xBASE, and it was really nice, especially for ad-hoc work such as one-off research requests.

And as somebody mentioned here, null handling needs a serious revisit in SQL. I could rant all day about SQL null handling, especially for strings.
Not yet. Feel like I should, but the pain isn't quite enough yet to make me do it. I like heroku a lot when it's working, nothing else I've compared has the DX features I want (although render is getting close. I wish it had better command line tooling, and ability to run tasks on one-off 'run' machines).

(I develop a pretty small-scale app for a non-profit)

So, no, not yet. But I am worried I may regret it.
thehustle went from putting together decent articles to absolute garbage like this low effort graphic. Sure if you purchase all the popular streaming services it will be more expensive than cable. But like cable you will be paying for a lot of content you dont actually watch. That content will be on demand but that doesnt mean you will ever actually watch it.
In case anyone thinks NY Times opinion of anything tech related is worth a damn these days, de-paywalled link: https://archive.ph/zzhKb
Personally I think they don't think about this. They want to feel safe and that's where the thinking ends.
If your goal is to minimize lines of code, sure, Python takes the cake here.

But here's a different way of looking at it: using only Python example, can you identify every way that launching that container might fail?

Now do the same with the Go example. See the difference? Folks who value looking at a piece of code and knowing what might happen - not just in the happy path but also in the error path - I think will likely appreciate the Go sample.