skysight-inc/HackerNews huggingface dataset:
I wish there were SQL "primitives" functions instead of the SQL language.

For example if I want to pick a single row by id, with SQL I must send a query string, which results in parsing, which means lower latency.

If I want to randomly select 100k rows among a database of 1 million entries, I need to build 10k query strings (I think?), which won't be fast to parse. I don't think this happens when using C pointers in C, C++ or arrays in other languages.
I believe there were more than that one. From what I've read some time ago, to prevent the Ethereum 1 (proof-of-work) chain from continuing to exist after the migration to the Ethereum 2 (proof-of-stake) chain, the Ethereum 1 protocol has a built-in "difficulty bomb" which dramatically increases the proof-of-work difficulty after some time. But since the migration to Ethereum 2 has been delayed for so long, they've had to reset that "difficulty bomb" more than once (making it trigger later), which AFAIK requires a hard fork (and updating all nodes with the new rules).
> I worked with a Microservices Architect (and developer) once, and when I asked how he intended for failures to cascade properly between services; how he would maintain cohesive state, especially if things went wrong; and how he would diagnose problems between them, he confidently told me: "That is for devops to work out."

JFC, that's an incompetent.

I know a lot of people will consider that too strongly said, but I don't think so. Any jackass can succcessfully build for the happy path, it's precisely where the happy path isn't that real skill comes into play.
5 hours of grid-scale storage seems like a lot.
I limit myself to 3 streaming services, when I get bored with the content in one, I cancel it and switch to another.

It's still annoying that content is spread over so many streaming services, but I'm never going back to cable.
>Humans can delay gratification for larger payouts later on, which if we could not consciously do then I personally would probably do nothing with my life besides the basic biologic urges and whatever gives me the strongest immediate dopamine hit.

That's basically living with ADHD - so about 2% to 7% of all people have a lot less free will than the rest.
“Making money” is not a workable definition. What if my product is free but my company makes money off support? What if it’s freemium but I have not added a paid tier yet? What if my product looses money? What if my software is free but I use it to promote my personal brand and pick up consulting work?

I’d say that all of those scenarios are commercial.
I don't feel spied on, I and everyone else is being spied on.

Its a fact, not a feeling, proven by Snowden who sacrificed his life so the people can now about what really is going on.
This very much varies by location in the US. In the central areas of most major metros your bike WILL be stripped if locked up on the street and not attended/guarded. I live in one of the most bike friendly cities in the US, and I can't even lock up my bike outside of a bar/restaurant downtown without having to chase off aggro dudes trying to strip parts off it in the broad daylight. And I'm talking a dirt cheap commuter bike from bikesdirect.com. A $2k bike locked up downtown here would last 2 minutes. They use battery powered grinders, so how uber your lock is doesn't matter anymore either.

It's a really frustrating problem, and has changed the way I feel about this city a lot. Being able to just casually ride around with friends socializing in summer evenings was really great. Now it's everyone taking ubers.
51% is possible, but if it happens someone has wasted (at current valuations) ~$15B gaining a majority stake in a network they are torpedoing. It would be pretty dumb to do something like that to your own investment.
Any details on what changed since serenity?
51% < 100%

The other 49% are still incorporating the 51%'s blocks in their work. There is no way 51% of miners can stay ahead of the combined hashpower of the entire Bitcoin mining population.
Yes, that is what happens when big music takes an interest and everything is flooded. Same with beat, rock, punk, new wave, you name it. HipHop is alive and well, just need to know where to look.
Figure out how to revive https://github.com/coreos/fleet as something native in systemd?
Not to mention that there is nothing wrong with allowing people to see different things lmao. What even is this conversation ?
As someone who bought a Steam Deck almost entirely for the purpose of handheld emulation who also owns two Switches, I can tell you that most of the emulation scene on the Deck is very much /not/ Switch games. It's mostly people emulating games from the NES, SNES, N64, Dreamcast, PSX, and similar older systems. Most of these games would do well if they had proper re-releases with updated graphics quality, but the releases we have seen (on PC anyway) have mostly been the original game with an inferior emulator wrapped around it, being resold without any improvements. Square/FF games have been especially guilty of this sin on PC, and pretty much muddied the waters.

Meanwhile, Nintendo has been smarter on Switch, shipping first-party emulators for NES and SNES (but without the games people actually want in the catalog), and has convinced Square to re-release Seiken Densetsu 3 with an official English translation on the Switch w/ the full Mana Trilogy, which I bought and paid for, even though I could emulate all three games because they had improved graphics and an official translation.

I think the concern you have here is wildly overblown, and for the most part there are a tiny tiny tiny amount of people who are pirating Switch games by running them in emulators. Most Switch piracy is happening /on the Switch/ by people running games off the SD Card instead of buying carts/downloading officially, using patched OS / loaders. Nintendo basically killed this for Switches made after the first run in the first generation, and it's even a non-issue.
I don't think there is any 'danger of conflation', particularly, again, given that SEGM is also closely linked to evangelical organizations, who were trying this sort of thing 20 years ago with intelligent design.

>If you care about kids, don’t ignore the growing body of evidence that suggests youth transition is overwhelmingly harmful. Don’t ignore stories like Chloe’s

I think that the fact that transphobes can weaponize a few more anecdotes about detransitioning this year than last year is not particularly meaningful. In the aggregate, these stories account for a tiny minority:

https://epath.eu/wp-content/uploads/2019/04/Boof-of-abstract...

https://transequality.org/sites/default/files/docs/usts/USTS...

https://www.researchgate.net/publication/262734734_An_Analys...

https://www.jsm.jsexmed.org/article/S1743-6095(18)30057-2/fu...

The largest cohort comprises 8% of the sample, 62% of whom did so because they were pressured by their family, not because they had regrets about choosing to transition.

>The harm will be obvious to all once the lawsuits get rolling

Has the harm of MMR vaccination become obvious because lawsuits have managed to 'get rolling' and even succeeded in that context?
> And no recoil, better accuracy during rapid fire.

Good troll so far, but I think this puts it over the top.
> When I ask for a pay rise for doing the same job from my employer am I being unethical?

You're generally not doing the same job year over year. Your roles and responsibilities grow and evolve the longer you are there, so it makes sense that your pay would also grow with you.
Rakuten 24's investment in Core Web Vitals increased revenue per visitor by
Survivorship bias. You don't hear about the failures. Moreover, many of those things (e.g., lots of Python at Google) was written at a time when there weren't better options, so you weren't struggling to make Python work while your competitor is writing Go or TypeScript.
If they are poor how can they afford a new car?

Sales of EVs will continue, old gasoline cars will still exist. Then there's biking, walking, public transit, and living closer to your day-to-day needs. If anything this will help the poor.

Here's a better thing to think about: why do we as a society in various countries require poor people to buy a car in order to participate in society? Maybe instead of doing that, we should treat cars as luxury objects and an after-thought and instead actually build correctly and in a equitable and afforable way?
Cities will be so much quieter.
Solving for AI’s black box problem
It didn't happen only once and I tend to delete downvoted or closed questions.

There's one I'm currently trying to get re-opened:
https://puzzling.stackexchange.com/questions/117556/reasonin...

I use the same name on Stack Exchange sites. I'm not hiding my opinion :).

And if you're asking me this so you can go and downvote me because I dared criticize SO, feel free :p
So the answer is... do nothing? Aim for nothing? Just give up?
Even the people living in their cars? Or barely making payments on their used ICE car from the 90s? This is literally a modern "let them eat cake"
But without some level of mechanism, arguments for free will and arguments for God end up looking very similar. They both have massive explanatory power, are consistent with many people's claimed subjective experience, and are unfalsifiable.

Why did a meteor wipe out the dinosaurs? God did it; it was the causal result of initial conditions; the asteroid or some other party acted non-causally (free will). Of these, I've seen the most evidence for the existence of initial conditions, Boltzmann brains notwithstanding.
That's a U(k) problem not a me problem. Here people put their cheap base model pick up truck on the highest, cheapest, Chinese lift kit that money can buy with no real effect on the price of their premium. You only pay more when you want to insure the cost of the replacement of your modified parts, which very few people are going to bother doing.
Yeah, I am really surprised they managed to make it work, actually.

Rust is one of those languages it takes time to master... if you write a lot of code in it while you're learning, you're likely to make all sorts of mistakes that later will need to be cleaned up... at least, looking at Rust code I wrote when I was early in the learning process, I can't even imagine any of that code going to production... so I would say it worked for them either because they are highly skilled and can learn difficult things like Rust quickly and efficiently... or their previous code was so completely broken than anything else would be better :D...
> Perhaps, but they are not banning gas stations or driving gasoline cars.

Don't worry, they will do that too at some point.
I’ve noticed that signage in Germany is generally poor. Roads, stations, airports. I haven’t been able to ascertain why. Any thoughts welcome!
Never. PoW is a fundamental part of what makes bitcoin valuable.
This ban is scheduled over a decade from now, and is probably too late to effect change. This is incremental change and it is not enough change to solve the problem. Really I find this whole line of reasoning very strange. It's well-documented what we need to do to minimize climate change. We're already overdue to take action. An incremental plan is fine but the increments must be large enough to solve the problem (and this is actually an example of the increment being too small, yet you suggest it is too large and we should be more cautious.)
It's possible Apple optimizes more for battery life or other benefits. I'd rather have an iPhone that isn't noticeably faster but has noticeably more battery life instead.
SSH Tips and Tricks
nobody cares what you bought
A wax gibbon, even.
You must not have been alive when we moved away leaded petrol. The decision was not left up to the consumer.
But quality varies, subtitles are an issue, and sometimes the movie isn't complete and sometimes it doesn't match the title at all.

I still prefer reasonable paid alternatives
Tangential to the article: i've never understood how the EV transition will work for renters and high-density livers (high rises,etc).

If you are in an apartment complex, how will charging look? Is it realistic to have charging ports at every (or even a majority of) reserved parking spots? It feels like there are some obvious logistical concerns for condo parking garages.
Nietzsche argues that the idea of free will is a remainder of the Abrahamic faiths, who use it to justify certain theological points.

The point on the latency between the body and conscious mind is certainly crucial to any discussion on free will.

I tend to 'believe' that free will and fate are not mutually exclusive - they seem to weave together into something more closely resembling 'destiny'. Perhaps our sciences will get to the bottom of it, but for now, 'destiny' is my working model.
Normally there's a fee to try and send such things to prevent such behavior. I haven't seen anything suggesting thats the case for slasher reports.

The thing here is that the validators don't need to be honest when responding to a slasher report.
You're naive if you think this way. You're not forced to use AR, yet. That's different to never will be forced to.

Smartphones are already all but mandatory for certain locations/demographies. Not owning one carries an immense penalty when it comes to access to government services, banking, and general daily functioning.
Yes. No new projects there (using Fly.io instead as it provides a similar, simple DX but even better and cheaper too unless you are heavily Elements dependent) but am being somewhat slow to actually move things off.. The stack deprecations will probably push me to do it before long though.
For me, a few streaming services make sense even without binging. But people do seem to forget there's a la carte streaming and DVD rental/purchase. In fact, if you want to watch a lot of films, you may be better off with something like Netflix DVDs by mail than another streaming option.
Okay thanks for clearing that up, I couldn't read the actual article as its timing out.
Isn't that what prepared statements solve? Only parsed on the first execution and after that only the parameters change.
Almost all EVs come with built in charging schedule settings and people use them because the alternative is throwing money at your utility company to charge during peak hours for no reason. You just plug it in and wake up charged in the morning.
Most vehicles/chargers have the ability to optimize for using off-peak hours (and if a utility financially incentivizes using power in those hours, users tend to use that capability).
This expands the definition of "bullying" to include things like not inviting a co-worker to lunch with the rest of the group... while it could be a little rude, thats not bullying. Neither is a boss putting you on the spot in a zoom. Articles like this water down the definition of bullying so far that it makes the term meaningless.

You aren't entitled to love your job, your boss, your co-workers or the company and if you do they likely won't return the sentiment. They aren't your friends or your family and as long as you expect that from them you will be disappointed.
I will make no comment on the morality of PRO-US Propaganda versus PRO-Russia / PRO-China propaganda.

Instead, I will state this is just the latest example of corporations having more power than entire nations.

Cyberpunk 2077 may need to be renamed to something a bit closer to current-year.
The evidence isn't like a Youtube video.
I have but only briefly. I needed a pretty high degree of customization for my use case so njs for scripting was a huge value prop over having to do everything in VCL.
To blame unconscious bias over a suffix as a non-trivial force on adoption is silly when there are plenty of valid technical constraints for adoption of SQLite in many projects.

IMO database names are incredibly bland, outside of Cockroachdb, and not a driving factor to adoption given the critical nature of the decision.
Why is the cost zero? They have to cover the cost of making the car.
>well then no beer for you

https://www.merriam-webster.com/dictionary/tact
How is it fair that people who got degrees with borrowed money they cannot pay back are to have that burden moved to blue collar workers who went to trade schools or other forms of apprenticeship where they never incurred such debts? Yes, this burden will also fall in high-earners -- both those who did and didn't go to college -- but in proportion it will hit lower-earning tax payers the hardest.
Yeah, the bolt seems like the good one right now. I truly have no need for a car, but if I did, I'd probably get one.
Why You Can’t Land a Developer Role and What to Do About It
Hypothetically? We’re already there.
Biden canceling $10k in student loan debt for most, extending payment pause
WAL2 mode is still only available in a branch - I've been hoping they'll merge it to main at some point, but I've not been following things closely enough to know if there are reasons that they wouldn't eventually do that.

https://www.sqlite.org/cgi/src/doc/wal2/doc/wal2.md
> Doing anything is better than doing nothing.

Reading the history of man shows that the opposite is many times true.
Well new EVs cost 40-60k. You can get an extremely nice new ICE for significantly less than that. So poor is probably being used relatively.

Telling people who aren't rich to just walk to work is a joke right?

Electric cars will come down in price and I'm all for the push. But the timelines seem unrealistic to me.
Not so unfortunate according to Socrates: 'the hardest task needs the lightest hand..' ;-)
Python tops programming love list – but if you want a job, learn SQL
Having to remember to use a VPN? Hardly a drawback.
My main issue is the free redis and cheap postgres instances they provide for my low-traffic app.
If Humans Went Extinct, Would a Similar Species Evolve?
> The only reason electric cars are more expensive than gasoline cars is because of the lower production volumes at the moment

This is not true, it is because the battery costs 10's of thousands of dollars. It costs Tesla around $200/kwh to build a battery, and it's batteries go between 50kwh ($10,000) and 100kwh ($20,000). This is the estimated cost to manufacture just the battery. Meanwhile you can buy a Chevy Spark for $15,000 retail.

The truth is that the only reason there are any substantial sales of electric cars is huge government subsidies. In the long run this will change, battery cost will go down, but also the subsidies will go away. It is likely that if there is no fundamental cost floor to the batteries that prevents it, electric cars will end up cheaper to manufacture in the long run because they are simpler and have less parts. They are certainly going to be cheaper to maintain and more reliable. However, that is in the long run, the things you are saying are not true yet and there's no reliable way to know when they are likely to become true.
France is now offering a €4k e-bike subsidy to people who trade in their car (road.cc)

https://news.ycombinator.com/item?id=32562475

yesterday
The voters decide which increments are too big. It's pretty simple -- if they would vote to prevent or roll back a given climate policy, the increment is too big.

Small incremental improvement is better than failed attempts to force through large increments resulting in no improvement or negative improvement.
I guess that's subjective, not knowing rust I see a few more lines in the first example but beyond that it does not jump out at me as being "way more complex."
That doesn’t seem very far. My commute is 20 miles per day and I live quite close to where I work by most standards. How are the people that commute for 45 minutes each way going to fair? There are a good number of people that drive further than that too.
RocksDB, as I understand it, is a pretty old piece of software, forked from a Google product, which was already a pretty old piece of software, all written in C++. Doesn't seem to have previously been written in Python, doesn't seem to have a team of non-C++ programmers who decided to just learn as they went, and so it's not clear what parallels you expect to draw.

Maybe they're doing a Rust rewrite too? I'd be interested to read about that.
What if? Climate Scenarios based on data from IPCC
How does this fit with "right to repair"?

Besides the recurring revenue motivation, can this be pretext for restricting right to repair?
If 51% of miners decide to totally ignore the other 49% then their chain will most definitely not be the longest chain for any more than 30 minutes. Because the 49% are still using 100% of miners' work.

The only way they can maintain that chain is by a hard fork.
13 years isn't an incremental approach?
It's a simple question. No need for ad hom.
I'm a physicalist, there's nothing in my view that says biological disorders can't affect the effectiveness of the software, free will must in my view be an effect provided by our bodies and a disorder can surely remove it.

Just as sure as if you were lobotomized, you'd lose free will.

Edit: Plus upon re reading this and not just giving a two second flippant response, you did not clearly read my reply (which I ironically did not then read yours correctly either). I was talking about the ability to prioritize desires, not free will itself on the part you quoted.
This situation seems pretty frustrating for many. My guess, from his most recent public communications, is that idlewords is taking a mental health break.

Step number 1 would be to stop payments to Pinboard if you are not satisfied.

Then pursue a refund and wait $x until he responds. There's not much you can do beside that. People raging on the Internet doesn't seem to be grabbing his attention enough to offer a tangible statement, effort, or refund.
You linked to an issue from over a year ago to support your case? And the solution in that issue was just "switch to the right extension"? That's hardly a compelling argument. By all appearances, that person’s environment was completely broken since they reported the other extension did nothing at all, and a broken environment isn’t really a reflection on the tool. I can set up a broken environment for any tool and then complain about it. The absence of a bunch of other people encountering the same issue in that thread indicates this was not some big issue with rust-analyzer.

If I search for "Rust" in the VS Code Extension Marketplace, it shows the extension you linked to... but it is clearly marked as deprecated, and VS Code won't even let me install it. So, it’s even more of a non-issue today than it was a year ago.

The actual rust-analyzer extension works fine for me. I think Go's tooling is slightly better in my experience, but both are far better than any experience I've had with C++ tooling.
Reminds me of this really cool video about using Fourier Optics for optical pattern recognition.[1] The video happens to have one of the best explanations of Fourier transforms I've yet encountered.

1: https://www.youtube.com/watch?v=Y9FZ4igNxNA
We plan to, but not quite yet. The only thing keeping us on Heroku is the "point in time restore" for Postgres, once another platform (such as Render) has that we will probably make the switch.

Having had to use the point in time restore feature before, it's indispensable.

Just taken a look at Appliku as others have mentioned it (we are a Django app), that on DigitalOcean with their managed Postgres could be a strong option.
Why dilute your community with people who don't do the reading?
Isn't that the whole point of the Web nowendays?

Anybody can put code out there that you'll run on your device?
Arguing that people acting disingenuously is a problem with the Internet seems like going after low hanging fruit.