skysight-inc/HackerNews huggingface dataset:
That's what I had always assumed - i.e. if the first keyword is SELECT it can't possibly modify the data, which does match the OP's claim that SQL separates queries from data manipulation commands.
Twitter, challenging block orders, sues India’s government
Thanks for the correction. So MS could have decided to leave EU if they did not want to accept interoperability. So the Apple fans have a study case here where a giant was forced to open up and nothing bad happened to the users, even good stuff like I can tell people that some project of mine can import from Word if they use the docx format.
Trial as a personalized airport flight information display: https://qz.com/2183996/delta-is-trying-personalized-flight-i...
So that's why you make sure your assumptions and claims match what happened.

For instance, anyone who claims that the economic impact was solely the result of government action, and that no private individuals or organizations changed their behavior independently, is ignoring the timeline of events.

Anyone who claims that the vaccines didn't change things so that post-vaccine policies could have been equally successful pre-vaccines, is ignoring the stats.

All this stuff is pretty easily googleable in the current and past-two-years news records, and yet you still get lots of people here making arguments based on completely different claimed facts.
Or just use Newpipe/Piped :).
Then you are arguing that these surveys would abridge free speech?
After my data was leaked, now scammers periodically call my phone to let me know that "I'm from bank security and someone's recently tried to change phone number for your bank account" or "I'm from police and we're opening a criminal case against you". It was fun first few times, but now I'm considering changing my phone number because I could miss an actual bank security call.

And I'm sure that plenty of gullible people were scammed and lost their money because of those leaks. When someone calls you, knows your full name and talks with enough confidence, it causes some trust.
I think essentially yes, they can't bundle all their apps and services; you have to be able to install their apps and services separately in the unprotected mode. Not very sure though.
I am happy with the supercharger network and software. My car didn't fall apart at 8,000 miles and the build quality is good. I did have one minor issue with a window that stopped going up and down smoothly and a Tesla tech came to my house and fixed it with an easy to book appointment. I didn't buy FSD, but I would be unhappy if I did because I don't understand the appeal of pre-paying for something that isn't here yet.
> 3080 is supposed to be only say $700, which changes the equation in favor of gpu.

Yes, more than an order of magnitude cheaper, and also 2x higher peak teraflops. This makes a 20x-30x difference in your dollars per request calculation. So it’s somewhat confusing why at the end you ignore this and conclude GPUs aren’t worth it. V100 is a couple generations old, and comes in a half price model too, plus there are some other server grade options. The reasons to use the most expensive V100 are the mem capacity, or double precision, or to argue that it’s too expensive… ;)
I’m definitely at the tired, unmotivated, and imprecise stage after one 5% beer.
https://reason.com/2017/07/12/cory-doctorows-fully-automated...
to go where? Mars isn't ready yet
It's not an unreasonable scenario. But yes, some 50/50 coin flip assumptions have been made.
Maybe one of the goals is to make driving so tedious that people happily adopt autonomous features.

If someone puts up a fake speed limit sign and tricks your self-driving car to travel 30 mph under the actual limit, then you might not care, if you're having a snooze on a nice reclining seat.

Still, I think it's not too early for governments to pass harsh laws against interfering with or obscuring road signs. With some clever networking and an open dataset, it might be possible for cars to detect such missing or altered signs within minutes of the crime being committed.
Deno showed there is space for not-Node, and that developers would be receptive to this.

And yes, Deno is just one player in edge, but you can agree there is much more money involved with all those other players you listed.

It’s going to be a battle of eyeballs from those edge providers then wouldn’t it? Whether that’s consulting or licensing fees, or just an acquisition / acquihire player.

Maybe you’re suggesting these players would build a runtime themselves. From my experience, only a fraction of companies, rarely, tackle ambitious projects like this. It’d be hard to justify to management who need quarterly results. Instead, they’ll fork an existing technology and make it better, because you can show incremental progress but keep your baseline. For example, Facebook didn’t rewrite their PHP code right away. They wrote a faster interpreter.
I have.

A couple years ago, I had a phone interview with one of the big tech companies. The interviewer almost immediately started asking a series of pretty basic questions - something a new grad should be able to answer, where if you can answer one, you can answer them all. I don't have an issue with couple of questions like that to verify the info on my resume is accurate, but he was going on and on with them.

I told him I had a question for him and gave him the question. He giggled and said, "That's an interesting question", then started to ask me another question. I stopped him and asked him to answer my question. He said something along the lines of "this isn't for me to answer your questions".

I ended the interview. I don't think I would have liked working there.
He just told you though. Speeding happens, and there are many scenarios in which it is OK. Hearing the beeping might actually induce road rage... or not... I wonder though.
It's very trivial to bypass those: just delete the packages off your system. Of course this means your system now won't boot, and you must expend effort to deploy a replacement. That's the actual non-trivial part. There's nothing the systemd developers can do to make that any easier for you, unless you expect them to suddenly start developing two or more init systems for some rather unclear reasons.

If the problem is that your employer has required you to only use packages supported by some vendor, that's a different problem and it extends to a lot of other things besides systemd. For some perspective you might want to go talk to some people who still have to use COBOL at work...
Hopefully they moderate. But freedom of the press is the keystone that holds a free society together. Once that is chipped away at by the government, it’s difficult to hold back the deluge
So many people in this thread seem to be arguing I should not be allowed to choose Apple’s model as it is today, “for my own good”. The article is about explicitly outlawing parts of their model.

How’s that for personal agency and not infantilising me?
A technical person with good people skills is the solution. The combi is not rare. It is not payed properly, but defineyely not rare.

I had many non technical managers stuck in their ideas from '70s or from condoms production lines. Non technical managers should either adapt to the industry's dynamics or go elsewhere. They burn a lot of time of the team.

But an unexperienced team does require a manager, of any kind.
It's a counter-productive rhetoric that I've long decried and sadly started from environmentally conscious folks. It's hard to understand how "It's too late to do anything" is going to push people in the right direction, if anything it achieves the opposite effect.
That’s helpful but the token prefixes are also helpful. You might be interested in GitHub’s reasoning at https://github.blog/2021-04-05-behind-githubs-new-authentica...
> ... one of the reasons iOS is profitable for developers.

Is it profitable for many developers?

Was under the impression that making decent money was possible years ago, but in recent years it's not real profitable for the vast majority of devs.
I like your approach. So far I used profiles extensively. AWS_PROFILE is your friend. No idea why AWS doesn't heavily promote this everywhere they can.
Good for you. Have you considered that you live in a bubble? People buy iPhones because they work better, and end-to-end control of the experience is how Apple does that. If you don’t want a curated experience, there is Android.

Given the browser choice utopia that is Android, it is hard to believe iPhone does any business at all, if hacker news comments are to be taken seriously.
Bringing up pg here seems to me a red herring. The point is that you've been posting unsubstantive and flamebait comments, and we need you to follow the site guidelines.
The (already-dead, so I can't reply directly to it) response from 'prometheus76 is telling here, so I think it's worth preserving to expose the fakeness of this whole "what if the costs are higher than the benefits" posturing:

"But I thought humans were not adaptable to climate change? Isn't that the panic?"

After all that hand-wringing about "destroying the world economy" you'd think that "adapting to climate change" would not be the bar for them. "Adapting without economic harm" would be. Even if you frame it purely economically and don't care about lives lost, the economic cost of things like rising temperatures and sea levels is easily calculable as being enormous. That precious petro-heavy global economy depends massively on infrastructure on today's coast, for starters.

This is just "I disagree with making any efforts entirely but I've given up on being able to convince people that the efforts aren't needed, so I'll just try to claim they're too expensive instead by arguing against a worst-faith interpretation of what we could possibly try to do."
> I dont think anyone disagrees with speed limits

Hello there, I disagree with speed limits on any highway, as well as most well built roads that don't have pedestrians adjacent. I'm not a civil engineer or traffic researcher, but I do disagree with them. Having ridden on the autobahn I also didn't feel less safe there.
You imagine poor people in position to make choices that affect their future. But it is the billionaires who make those choices and impose them.
> The only way I could see a speed limiter like this would work is if there were a central control system with local knowledge of the road and those on the road, similar to how a subway control, airport control or rail way control works.

Now you're getting, it's all about the control. Once they've got the device in what's to stop the government from saying your car can go 0 miles an hour if they decide it is necessary? It's all about control my friend, all about control.
I had exactly this kind of problems on an Audi I was renting in Switzerland where the car started suddenly braking while going 110 on a motorway. Freaked the shit out of me and the cars behind me as well. Wtf
And there is also the true story when "someone" forgot to fill the tank after 5 years of regular monthly tests, then the real thing happened.

> had an electric start wired to the mains supply.

But that's a good one, humans being humans...but it worked every time before today ;))
...and people think roads are perfect, too. That is a huge mistake. Try smaller cities in Eastern Europe. There is no way such a car could help you much there. When it comes to self-driving cars, yeah... no. It is really risky.
> SQL prohibits that, separating queries and data manipulation statements.

With the exception of the case where the set of rows you want to return (a projection of) are exactly the same ones being modified.

IIRC, you can hack around this about with JOIN in the FROM clause of the main statement even if it is only of substantive use in the RETURNING clause, to get what amounts to arbitrary data modifying queries.
> And even if you're a die hard fan of closed computing, nothing bad will happen. You'll simply pick Safari, never sideload an app, and pay with Apple Pay. We can coexist.

This is the important point. Just like with decentralized VS centralized debate, starting out with one of them, decides if you can even have the other one.

If you have a decentralized foundation (like HTTP), you can always add centralized entities on top, if that's favorable (like Twitter). But the other way is not true, you can't build decentralized things on a centralized foundation.

If you have open computing on mobile devices, you can always opt-in to just stay within one ecosystem without being hurt by the openness. But the other way around is not true.
'Tron' Changed Cinema
*SPOILERS*

Very funny minigame! Given the responses here, it would be nice to have a "browse as anonymous" button with another ending. Or perhaps an intro screen before the account creation to frame the account creation as part of the game.

But abcabc666 is a badnamer and his advice should likely be ignored.
The irony is that this is exactly the problem of current social media. Everyone can comment on everything in any way they like and there is no way to validate their affiliations, intentions, or sponsorships on scale.
Yes, they have simulators that bolt on : https://www.intuitive.com/en-us/products-and-services/da-vin...

Other manufacturers also have them
Crypto’s last man standing
> If it sucks, that means chances are there will be a very long dry spell before investors decide to try another Tolkein work.

After seeing the fruits of the investors being involved I think I'm ok with that.
> I'm sure the YT PMs have proof that this improves engagement.

I sometimes wonder if the opposite is true - that the PMs can convince the upper managment that users are staying on the website longer with all those stupid as fuck shit changes, but in reality they are there longer because it's increasingly more difficult to find anything you are looking for

Sort of 'When a measure becomes a target, it ceases to be a good measure'
The article is vague about the identities of the elements. They tend to occur together, but some are way more valuable than others. Cerium, for example, is considered a "rare earth" but is not that rare at all:

> Cerium is the most abundant of all the lanthanides, making up 66 ppm of the Earth's crust; this value is just behind that of copper (68 ppm), and cerium is even more abundant than common metals such as lead (13 ppm) and tin (2.1 ppm). Thus, despite its position as one of the so-called rare-earth metals, cerium is actually not rare at all. ...

https://en.wikipedia.org/wiki/Cerium
3 REMOTE openings for Python/Django/Vue.js/JavaScript Software Engineers

Student Loan Repayment, Matching retirement benefits, choose your own tools, regular training and conferences, tons of encouragement to try new things.

This is professional and technical programming work analyzing, designing, developing, implementing, and maintaining applications supporting the Senate. Work includes system analysis and design, programming, and conducting program and system testing. The incumbent must determine the tools and methods in planning, designing and modeling the applications. Instructions received can include general and specific procedures and methods used to complete assigned tasks as well as time frames for completing assigned tasks. The incumbent must have experience with Python programming language and web frameworks as well as JavaScript and JavaScript Frameworks.

Ability to obtain and maintain a security clearance.

$85,980 - $128,964

All applicants must use the link below and follow instructions. https://sen.gov/0Z3J

Tuesday, July 05, 2022 to Tuesday, July 19, 2022

https://s3.amazonaws.com/atds-jobs-production/positions/soft...

https://sen.gov/0Z3J
Yep. I think that certain kinds of code enforcement should be null for people who prove they have been violating it for some number of years. This isn't violent, it isn't environmentally unsavory, it isn't inconvenient. It is merely "nuisance".

Damned neighbor.
Archived : https://archive.ph/Q3S7D
yes! https://arxiv.org/abs/2002.07798
Excellent read. This is why I’m here. Thanks!
I think the title is a bit misleading.

The mandate is for intelligent speed assistance. I own a car with such a feature and I think it's already pretty common in higher-end vehicles even without the mandate.

The form it takes in my car is that there's a little symbol with the current speed limit displayed on the HUD. The speed limit is sourced from road signs or the car's navigation data. When you exceed the speed limit, the symbol turns red. Unless you engage "cruise control", that's it.

If you do engage "cruise control", a few things happen. First, when the speed limit changes, the targeted cruise control speed will change and the car will either gently accelerate or gently decelerate (think 1kph of change in speed every second or so). You can always choose to override this by using the pedals, changing the set speed manually or turning it off.

Another thing the car will do is use radar to maintain distance between you and the car in front of you (the distance is somewhat configurable), which will also mean maintaining speed and coming to a stop if the car in front of you does.

However if you never turn on "cruise control", the feature is nothing but an easy to ignore red symbol on your HUD.

I really like the feature. Combined with other features like lane keeping assist, it makes driving on the motorway quite relaxing (though you still need to pay attention, this isn't meant to allow you to fall asleep at the wheel or anything).
Does this work on Mac M1? I tried a couple of days ago and IIRC it segfaulted.
You answered your own question. Quest 2 is the best thing Meta could produce so far and Cambria is still not on the market. Apple is known for extra polished experience of its first iteration of any product category. That may mean it will provide much broader uses than game-oriented Quest (and work-oriented Cambria). Fitness and entertainment are two categories where Apple have long time bets, while they make great strides in non-casual gaming. Since there isn’t the one killer AR/VR app for everybody, the device plus OS combo has to provide great experiences in all mentioned categories - gaming, entertainment, productivity & fitness. If they can pull it off, they will definitely put Meta in an uncomfortable spot from where they can compete only in terms of price and not the quality of experience.

Anyway, I am really looking forward to the next chapter of the Mac.
unfortunately it still seems to be impossible to buy a steam deck at a normal price, they're on ebay from scalpers... I've no idea what the real world waiting list time is right now.
That looks like a bug, if you really have a need to do that you should report it.
The ability to scale up experiments is really nice in cloud. In my experience you need to be quite large before you’re using your own GPUs at a utilization percentage that saves money while still having capacity for large one off experiments.
Really? Security cameras are illegal in france?
Freedom of speech also covers compelled speech so I would think this would violate that.
Rich Ruddie Favorite Quote on Reality
Living life in one reality while others think it's impossible is the way that great founders and entrepreneurs like "Rich Ruddie" think. Do the impossible and do things that others think are out of this world and you will find yourself on the right side of success in the business/tech world.
The modern world wants you to be spontaneously correct. To answer quickly and confidently. To be thoughtful without thinking about it.
What do you think the ratio of developers to users is?

Coexisting with closed computing is buying an Android, not forcing open the gates with a battering ram.

It’s incredibly naive to think opening the ecosystem won’t lead to abuse and a worse experience for everyone that doesn’t have a niche appreciation for browser engines.
i heard everyone is calling it AVXECUTIONER

> Note that on a vulnerable machine, proper testing of OpenSSL would fail and
should be noticed before deployment.

so is 'proper testing' included in the default build script or..?
I don't think we're going to reach and real agreements here, a lot of these things are going to be subjective. I think there's a certain amount of "if everyone around you is an asshole maybe you're actually an asshole" but I doubt I'm going to be changing anyone's minds today.

That being said there is a bit of hard data, this post nicely shows gnome contributions over time, as less and less non-redhat developer contribute.

https://hpjansson.org/blag/2020/12/16/on-the-graying-of-gnom...

Now I'm sure you have a dozen explanations lined up for why that might be the case, most of them involving how good redhat is and how they're a bastion of light all that, which sure I have no way to definitively prove that there's any malfeasance going on.

Still, I think it's clear that at the very least gnome has a bit of an image problem going on. Where we're not debating any kind of concrete facts as just shouting our subjective opinions of who's the asshole at each other, well I don't expect us to come to any sort of an understanding.
I'd need to see the data on that EV comparison. And earth-to-earth carbon emissions of wind turbines are very unlikely to be higher than coal or nuclear.

Regardless, people aren't buying small cars with efficient gas engines. They're buying trucks and SUVs they don't need. Which will likely continue until it's clear gasoline isn't going to get financially cheaper.
Serious scientists are not allowed to predict it. But it is certainly among the end states. Even likely ones.
> It seems like the main thing that bun does to stay ahead is cache the manifest responses. PNPM, for example, resolves all package versions when installing (without a lockfile), which is slower.

This isn't the main optimization. The main optimization is the system calls used to copy/link files. To see the difference, compare `bun install --backend=copyfile` with `bun install --backend=hardlink` (hardlink should be the default). The other big optimization is the binary formats for both the lockfile and the manifest. npm clients waste a lot of time parsing JSON.

The more minor optimizations have to do with reducing memory usage. The binary lockfile format interns the strings (very repetitive strings). However, many of these strings are tiny, so it's actually more expensive to store a hash and a length separately from the string itself. Instead, Bun stores the string as 8 bytes and one bit bit says whether the entire string is contained inside those 8 bytes or if it's a memory offset into the lockfile's string buffer (since 64-bit pointers can't use the full memory address and bun currently only targets 64-bit CPUs, this works)

yarn also caches the manifest responses.

> If I install a simple nextjs app, then remove node_modules, the lockfile, and the ~/.bun/install/cache/.npm files (i.e. keep the contents, remove the manifests) and then install, bun takes around ~3-4s. PNPM is consistently faster for me at around ~2-3s.

This sounds like a concurrency bug with scheduling tasks from the main thread to the HTTP thread. I would love someone to help review the code for the thread pool & async io.

> One piece of feedback, having the lockfile be binary is a HUGE turn off for me. Impossible to diff. Is there another format?

If you do `bun install -y`, it will output as a yarn v1 lockfile.

If you add this to your .gitattributes:

*.lockb binary diff=lockb

It will print the diff as a yarn lockfile.