skysight-inc/HackerNews huggingface dataset:
> In all other CS domains I know exactly what will happen under the hood for any given action, but for SQL I have zero clue.

In mathematical modeling, it's the same. You write the model, but what happens under the hood numerically is not that transparent -- in complex cases, you normally don't get to set breakpoints and step through numerical iterations, especially for iterative solvers -- so you have to treat it as a grey box (not black box). You can analyze the problem by analyzing its inputs and outputs, and through the intermediates it exposes. SQL is the same. As are many systems in the physical world. I'd argue the situation in CS is actually more the exception than the norm.

> I would love it if I could just write queries and it would automatically add an index or do something else for performance if needed, and possibly report back to me if a query I wrote has particularly bad performance.

You can do this by inspecting the query plan. In MS SQL, you can even inspect the plan live (while the query is running) and figure out where the bottlenecks are. For obvious cases, MS SQL's client profiler returns (imperfect) recommendations on which fields to index.

The trouble is because the behavior of algorithms depends so much on the characteristics of the data (which in a transactional database is changing all the time) and the underlying intention behind the query (which is not always explicitly declared in SQL -- otherwise the language would very extremely verbose), automated optimization is not always possible.

Optimizing query plans is a bit of an art -- it's like trying to give hints to an optimizing compiler via pragmas. Azure SQL does some simple analyses and adds/removes indexes as needed and performance is generally somewhat improved, but if you understand your query patterns, you can actually do far better. For instance, if you know you're going to be joining or filtering on certain fields, indexing those fields will speed up the join.

Or when you're doing a nonunique JOIN where just one to join to any one record (doesn't matter which one), you can rewrite that as an OUTER APPLY -- a query optimizer wouldn't be able to deduce your intention of "it doesn't matter which to join to" from your declarative query.
Too loud for apartments unfortunately. I've tried a few exercise machines (bikes, rowers, and air bikes), but Peloton is pretty much the only thing quiet enough for an apartment. I wish I could have a rower and assault bike, but my neighbors would kill me, and I wouldn't blame them.
drbd is really really hard to use. (ceph aswell tough)

also performance is extremly dependant on so many factors which are not always given.
i.e. drives, network, etc.

for some stuff even a distributed fs is enough, like glusterfs
> whether you pick an RDBMS or NoSQL solution is mostly a tooling issue.

Eh, when the time comes to scale I’d still very likely pick a RDBMS but hand my team copies of Eric Evans and ask them to design data schema and sharding scheme such that any given entity has a bounded context that doesn’t join across the network.

Probably then using a Merkle-like structure for shard selection.

However as you say there’s no need to start like that. A big fat server can do a lot. It may be cheaper just to run a multi-TB database server and do everything in memory, than invest in re-engineering and all the flow-on operational costs of a distributed store. For sure a DBA would have an easier time tuning it, even if NUMA is in the mix.

And building out a distributed store without restricting your ability to pivot requires more experience than almost anyone but the big clouds possess.

edit/addendum: when you take a bounded-context domain-specific approach to your data persistence you will probably will still need to join things, but the option arises to do so periodically rather than on-demand, and in batches i.e it has more of a reporting flavour than OLTP, and work can be managed for quiet times or offloaded to map-reduce spot instances or whatever you like. From the outside it looks like an eventually-consistent application but only with regards to the parts that don’t need to change instantly.
> The meaning of "joins don't scale" is that they don't scale across database servers, when your dataset is too big to fit in a single database instance. Joins scale across rows, they don't scale across servers.

But people have been saying "joins don't scale" for a lot longer than there have been companies that have today's giant's horizontal infrastructure. It's just been a sort of hipster anti-hipster anti-correctness brag since at least 1996, when I first heard it.
> The takedown request is interesting for several reasons. First of all, a team behind an application that is exempted from copyright infringement claims under the DMCA is using the same law to go after another jailbreak app. In addition, the claim itself isn’t without controversy either.

> “The code for Chimera13 is original code that I have written in Swift that relies primarily on the public techniques,” Coolstar writes, pointing out the various pieces of open source and publicly available code that’s included.

> “The only 3rd-party code in this repository is Jake James’ time_waste exploit. However, this is under an open source license (GPL),” he adds, highlighting the license in question.

> According to Coolstar, the original notice was sent in bad faith. He further accuses the sender of committing perjury and abusing the DMCA process, a claim he repeats on Twitter.
There may have been many reasons, but we do know they were very adept at sailing very long distances. They could identify the direction of land a very long way away (based on cloud formations, wave pattern, sea birds, fish and I am sure other signs).

I have not read any literature about the motivations, but they may have gone a long distance and turned back if they found no land. They were probably explorers with the same human motivations as European explorers, the desire to find out what is out there whatever the cost, and we remember the ones that succeeded, such as Kupe

https://en.wikipedia.org/wiki/Kupe
The future of work–the good, the challenging and the unknown
The first 3 flight test aircraft were donated:

ZA001 Went to Nagoya, Japan.

ZA002 Went to Pima Air and Space Museum (as you noted).

ZA003 Went to the Museum of Flight in Seattle.

As for the other three:

ZA004 may still be with Boeing.

ZA005 was scrapped.

ZA006 appears to have been sold to Mexico for a VIP transport.
Though rogue waves are infrequent I wonder if their vessels were able to navigate them or do those vessels have the same issue as a small fishing boat does?
When the first line of the commit is just "Fixes 1429", that's annoying. It belongs on a subsequent line.

I can look through the list of commits for recent changes that seem like they might have caused a new bug, but a list of numbers is no help at all there.
Screen flickers on: 10 second Ad of Conor McGregor taking up the full mirror inviting you to take part in his 30 day fitness program - just say "Doubt me now" to begin. Your account is instantly charged $9.99 by Mirror.

Could of been a great purchase by Google - matching your Youtube video viewing with celeb/fitness instructors.
The second email address uses the Cyrillic small letter O, which renders the same as the Latin small O in almost all fonts. You can see this in your hex dump, too: Instead of a single o, your hex dump shows two bytes for the second character in the second email address.
Other industries faced similar problems and materially improved representation. Ours steadfastly refuses, and instead comes up with increasingly silly special pleadings. The last CS gender debate I saw devolved to an argument about the behavior of monkeys in laboratories. People saying there isn't a problem in the industry are making an extraordinary claim, and pretending otherwise.
I'm actually in the process of building a low-frequency trading bot on top of the IBKR API haha.
Libtorrent adds support for the WebTorrent protocol
I don't disagree with you, but Peloton is definitely a thing. Maybe they're doing the UX better than everybody else, but I have a friend who wasn't into riding a stationary bike before she got one, and she's really into riding all of their rides "through" various scenic places now.

EDITED TO ADD:

Also: you're approaching this like a set of arbitrary components you plug together: An exercise machine and the entertainment. Maybe for some people it's easier when they're together and you don't get one without the other?

I mean, I can listen to a podcast without getting on a rower (or exercise bike, etc), but if you can't "ride" the scenic routes without your Peloton, I can see that being a motivator for some people.
As a user, I could not hate Snap more, along with whoever thought it was a good idea to release their crapware "for Linux" through Snapcraft only. If "desktop Linux" is going to be anything like Ubuntu and whatever Canonical stands for, I most definitely do not want it. That said, I do not really know what "the year of the Linux desktop" is supposed to refer to as I have been a happy Linux desktop user for way over two decades.
Orsda 4K HD Super 15X Macro Lens for Smartphone Anti-Distortion
People who are into fitness don't need apps to track their fitness. Their fitness routine has nothing to do with technology and they get questionable value out of something they could do much better with a notebook and a spreadsheet.

Lay people who are not into being fit are the audience for all these ridiculous things that don't help them get or stay fit because what it takes to be strong and fit cannot be derived from apps. You have to know how to prioritize, fitness has to be in the top of that priority list, you have to have the skills to create and stick to a routine. You have to know how to manage your time, how to get enough sleep, how to eat, how to move your body - like how to hip hinge for example - what activity you enjoy, how to achieve goals. A fitness app isn't going to do any of these things for you.

These things are ridiculous. As a powerlifter I'm trying to imagine what intelligent doo-dad they'd try stick with us, and the most interesting things I've seen are the bar velocity tools, but unless you're strong enough to compete, I doubt you give a shit. I don't think barbell sports are a billion dollar investment market though for a gadget.
Libyaly Evacuation of Oil Workers During Arab Spring 2011
Just because some rich a-hole tweets and blogs something doesn’t mean that anybody actually believes them. In fact, most people have a decent BS detector, see these fluff statements for what they are, roll their eyes, and move on with their life.
You are ultimately responsible for your own actions so losing 15k$ is this individual's fault. This is no different than buying on credit and thinking you don't have to pay back what you buy. Or taking on student loans. Money isn't free.
Pacific islands had very limited population caps. It was a necessity to continuously explore that embedded itself in the culture and evolved into surprisingly (to us) good navigation techniques and technology.

Some of those ideas fuel the passion to head out to Mars which has a similar cost/benefit. If we establish there I’m sure a new horizon will appear with some of us driving ourselves towards it.
k3os aswell. but yeah k3s is really something that should be kept alive.
> "I dislike Gnome Shell. It's clean and fast but the GUI is "locked" to the main monitor and I can't even switch windows without looking at it."

In case you didn't know, check out the workspaces feature, it can make managing lots of windows much easier via the keyboard:

- Change Workspace: ctrl + alt + up/down

- Move Window to Workspace: ctrl + alt + shift + up/down

You can lock a workspace to a particular monitor too, while cycling other monitors
I thought the UK would have been higher up, I wonder if the fact that most people use a US based host skews the results? I don’t know how listennotes do heuristics for “podcasts by country” but I’d be interested to see.

In terms of dead podcasts, most podcasts don’t actually set the complete tag (most likely to leave the door open for future eps) they just stop. So that figure will be way higher in reality. When crawling Podcasts I came across a lot of RSS feeds that were still up but hadn’t had a new episode for over 3-5 years etc
FWIW, some sites—like Amazon—allow multiple users on the exact same email address (distinguished by password or other identifiers)
The article's beginning and very ending was very informative and made clear nuance of the situation of keeping kids/college young adults from school.

The author lost me completely when they started injecting in one sided political perspectives and hindsight bias:

"...opposition to public-health guidance."

Which public-health guidance? Not all of the "opposition" was bad. Example: Any guidance from the W.H.O early on in the pandemic [0]

"Had Trump implored his supporters to wear masks and be patient, case counts might well be dropping across the country. "

Author chooses to show a particular political bias again and fails to mention the other major event that caused a uptick in cases (nationwide protests).

This whole section seems very out of place with the rest of the article, almost like The Atlantic had a requirement to show a left leaning bias to be published...

0: https://www.businessinsider.com/who-changes-timeline-first-c...
SAMLtest is a free SAML 2.0 testing service
This also annoys me. Even just allowing arrow keys to seek back and forth would be enough for now.
It seems conceivable, although probably unlikely, they might have learned the technique from Polynesian flotsam.
Concept2 is one of the most interesting businesses out there.

C2's production is largely still in the USA, with quality paramount. The PM computer, I think, is done overseas. Profits are slim. How have they not ended up like Cannondale Bicycles? (production shipped to China in late 90s, with quality inevitably suffering)
Yes, if people are rational actors, whatever they do is rational according to their private utility function. So, if anything they do is rational, then how is it "rational", which supposedly depends on some objective metric?
> Side question: is fly-by-wire an obviously good idea for passenger airplanes?

Once you have electric control, you can start putting logic between pilot inputs and actual control surface movements. You can create dynamic, real-time-conditions-based safety stops that prevent pilots from doing common mistakes like pitching up too much and falling from the sky.

With direct control, it's up to pilots to figure out where the limits are and ensure that they are not crossed. With advanced fly-by-wire, pilots can resort to setting goals and it's up to the control system to figure out how far the aircraft can go (within safety limits) to meet them.

This is really difficult to get right, but saves lives when it finally works.

It's like memory safety in computer programming. If you're really good at programming and you never make mistakes, then you don't need it, but most people make mistakes from time to time and are better off when something checks that their buffers don't overflow and variables don't go uninitialized.
Section 230 was explicitly written to allow a hybrid between platforms and publishers. It stemmed from a court case where a financial forum run by Prodigy was successfully sued for a forum post by a member. It was designed to allow forums like HN etc. moderate without being liable for users' posts.

You can argue about what you think the law should be, contact your local reps and push a bill to do that. But just repeating the argument about how Twitter is behaving like a publisher won't get you far when there have been court cases that ended in the judges saying what they do is the intent of Section 230. Again, you're arguing like it's 1992.
Four score and seven years ago our fathers brought forth, upon this continent, a new nation, conceived in liberty, and dedicated to the proposition that all men are created equal. Now we are engaged in a great civil war...

Plagiarism?
> Unfortunately there’s too much institutional inertia behind SQL for any of the DBMS vendors to go-it-alone, and beyond trivial queries all of the SQL implementations are incompatible with each other anyway.

I'm not sure which alternative query language is sufficiently general to match SQL. A datalog implementation on top of Postgres (via libpq?) would be really interesting though.
For me it is seeing the results. I'll happily do the same 6 motions for months if I keep seeing improvement.

IMHO learning proper motion takes so long that after working out constantly for 8 years, I don't think I'm confident that I know 40 different strength training motions to a sufficient degree. Heck I was benching for a year before I got /good/ at it. (This was before the plethora of YT fitness videos, it is much easier to learn now!)
/u/maxwellhill, the first Reddit user to reach 1M karma, is Ghislaine Maxwell
Have you heard the Good News about the Lightning Network and off-chain transactions?
Well, I think a new microarchitecture means a major bump. So between that and version bumps to to actual major software features, you get to 11 within 13 years or so.

Also, GCC 9.x compatibility may seem minor to some, but is significant for others. I also think there's some C++17 support in kernels - that's something too.
You and David himself have posted about this, and I am glad you did. This looks pretty shady considering the parties involved and their past actions. I appreciate the context you bring to this post.
Wow that seems awfully presumptuous!
They never cover the success stories of small time traders who have been enabled by Robinhood and such brokerages who require no minimums and no commission fees.

To me, this just sounds like gatekeeping as usual. The boomer investors don't like the young blood coming in and ruining their game, and realizing how much money can be made by essentially shuffling money around on the stock market while doing nothing concretely valuable to society.
Modern smart watches can track real-time caloric burn with reasonable accuracy based on heart rate and body size.
I’m convinced, sending my kids to bars this fall instead oof schools.
Here are the commit messages written by the developers of Git itself: https://git.kernel.org/pub/scm/git/git.git/log/

The most recent commits are a load of merges, but the slightly older ones have very long commit messages. The first one I clicked [1] has 11 changed lines of code, and a 32-line commit message.

[1] https://git.kernel.org/pub/scm/git/git.git/commit/?id=23c431...
Was she using the Peloton classes on a tablet you already had? I know a fair number of people that have gone the cheap-Amazon-bike-plus-tablet route and it seems to work well. That would be a fair comparison; it seems a bit sillier to compare entirely self-directed bike workouts, though.

Sometimes a big spend CAN drive bigger use. I pulled the trigger on a(n expensive to me) carbon fiber road bike about 12 years ago; ultimately I justified it to myself that I'd feel guilty if I spent so much and DIDN'T ride it. So far, that seems to be working! and I don't have the itch to replace it, either.

We also have a Peloton bike and Tread, FWIW. And I, too, struggle mightily with productivity systems, and the Peloton classes don't solve entirely for motivation.. it can help make the difference at the margins, though.
Things like this make it hard to take Firefox’ stand on privacy seriously. They keep making “mistakes” like this all the time unapologetically.

I marked the email as spam because that’s what it is.
At least some other industries with problems (law, medicine) have an oversupply of practitioners that is limited by cartel behavior. This does make this problem a bit more tractable.
Do people usually change their email accounts when they marry and take their partner's name?
Learn any martial art, to any level of competence, at any time of your life. This will give you 100 times more self esteem and leave you feeling more centred than any self-help book you could ever buy.
OAuth 2.0 for Native Apps
No, the disadvantage is racialized. White households at the 10th, 50th, and 90th percentile of income live in neighborhoods where the median income is a double digits percentile higher than black households at the same income level, and the effect amplifies the lower your household income is.
It really is just a funny parallel. In objective, pragmatic terms, we've already been way beyond telescreens for a while with smartphones. They are as mandatory for upper-middle class status as telescreens are in 1984, but far more invasive.
Yup! I was surprised they're rendered the same. The hex dump didn't lie even though everything until then did.
The protests largely included people wearing masks, and the hotspot problematic areas are not those aforementioned protest hotspots.

You have a political bias and it is showing.
honestly disgusting behaviour IMO, everyone should use noscript or ublock origin to turn off all js by default. Even though it's a hassle it gets easier once you've established your allow/deny list for frequent sites over time. First time visits remain a bear though since sometimes you have to do a bunch of guesswork to determine which js bits are required for a given site to work
"People who are into fitness don't need apps to track their fitness."

Fitness apps are very common among "people who are into fitness". In lifting, running, cycling, and other realms. Your No True Scotsman claim doesn't mesh with reality.

I lift three times a week, and have for years. I use and very much enjoy Fitbod. It tracks my activities in a way that would be a giant pain otherwise...why would I use a notebook and a spreadsheet when there are tools perfectly suited?
This is just meandering junk, is this the latest instalment in Virtue Signalling? B grade magazines just put Black <random word> Matter and they get advertising $ and upvotes?

The Birth of a Nation is related to the killing of George Floyd because a $2,000,000+ (present day $) movie used a camera and random people on the street used a camera?

If you bothered to look specifically at The Birth of a Nation and movies you would see movies continually move civil rights in the correct direction, outliers like The Birth of a Nation have little effect overall. That for instance might be an interesting discussion.
The JavaScript running it isn't minified or obfuscated.

It's basically a weighted random number, with the weight being determined by the colors of the neighbors.
I highly recommend Michener's Hawaii, which provides one possible reason in the second(?) chapter. The book is fiction, but is a pretty good read.
https://www.goodreads.com/book/show/12658.Hawaii
And it is an unbelievable pain in the ass. I accidentally ended up in this situation somehow, and it took me forever to figure out that I had two different accounts with the same email.

If I log into AWS using one account (the one I've had for Amazon.com for more than a decade), I get the console with no resources in it. If I log in with the same email but a different password, I see all of my resources. Absolutely insane.
> This is a bad analogy.

The analogy I was going for was this person took what sounds like his entire savings and then took loaned money against his house and put it all into trading super high variance options.

I'm not an experienced trader but I occasionally talk to some. They all say options trading like that is a massive gamble. There's a big difference between long term investing into an ETF and doing what this person did.

He could have chosen to put $500 into his account and hand picked some stocks or ETFs and then watched it grow or shrink over time as he learns how to trade but instead he chose to use 15k+ and then 2 big loans on high variance moves to either hit it big or go bust in a very short time frame. It just happened in this case he busted.

I think he would have had the same outcome on another platform if Robinhood didn't exist.