skysight-inc/HackerNews huggingface dataset:
From what I've seen of Sequel is looks awesome and I've been dying for an excuse to use it.

found [ActiveRecord] to be severely limited in
working with complex queries which use many
JOIN statement and sub-queries

I'd humbly suggest that this is not a flaw of ActiveRecord whatsoever! I think this is AR working exactly as designed.

I would certainly agree that SQL > AR once your queries grow past a certain (fairly low) complexity threshold.

But, AR (wisely) doesn't try to be a complete replacement for SQL. It very happily (and even elegantly, I might say?) lets you use raw SQL pretty much any time you, the developer, feel it's more convenient/productive. That principle is pretty explicitly baked into AR.

Many ORM frameworks don't make this easy at all, whereas with AR it's very painless.

I have a lot of beef with AR but I think this is one of its strong points.
Source in Swiss law?
Indeed. It’s a topic I sometimes wonder about.

I always tell people we have things we are good at doing, and things we love to do, and while they sometimes coalesce, you have to think about the future yourself and plan ahead so you can generate some income doing what you’re good at.

I don’t understand why other kids don’t think about their future the way my brothers and I did. Parents teaching maybe? We didn’t really have the problems of other people, not knowing what’s being phased out of markets, not knowing what we were good at. I always like to tinker to a certain degree with computers and videogames. My parents supported my decisions, but I was no slouch, I knew I had to work in whatever I could and was good at to generate money somehow while I found what I excelled at (and hopefully liked doing it too). Eventually I became a (Computer) Support Assistant, changing keyboards and setting up backup plans, and that started a career which now has me as a DevOps Specialist.

I’ve always thought that even if you like doing art with scraps, why not try to market some of it for money? It’s absurd not to look around and figure there are people who would buy such things. You like doing it (probably on spare time), might as well share some of it for some extra money, while you do what you’re really good at on your daytime (and again, hopefully you liked doing it too).

I’m sorry I didn’t explain more, but I always feel constrained by written forums/tweets.

In general, yes, I think people need to be more conscious about their future. I was a teenager drinking alcohol and doing crazy things too, but it was clear to me the concessions I would have to make sometimes in order to move forward: Stop drinking and go study, or hey, maybe I can drink this time, or hey, maybe I need to go outside, walk for a bit, refresh my mind and come back to work.

Try to educate your children more to be conscious. Just because I skate and with practice became good at it doesn’t mean I don’t really think every time I get on the board that I might not fall; I know I will at some point (and I have). Just accept the responsibility and live with the consequences.
> a non-technical problem

In what way is safely prerendering third party pages not a technical problem?
My university recently implemented a system where some majors (CS/Engineering/Buisness) students would have to pay ~20% more per semester.
Any time you run someone else's code you either have to trust them or trust their auditors.

Solving this problem is the reason I built this:

https://github.com/Spark-Innovations/SC4
If you want to have the market decide, the market has to be in play for the entire process. For example, the loan terms could vary based on the demand for the chosen degree. Or, the loan terms could vary based on the (salary?) success statistics for grads from that school in that degree program.

As it is now, there is no up front penalty for choosing a major at a school that is so expensive the student may be in financial bondage for a significant portion of their career.
and Apple Maps. I was very excited to get turn-by-turn directions while bicycling via Apple Watch; Apple Maps frequently sends me down freeways if it thinks I’m driving, or the wrong way on 1-way streets if it thinks I'm walking.

If the Watch platform was open enough that any Maps app could "snap in," this situation would be just fine. But as long as Apple apps are first-class citizens and everyone else has to deal with limited APIs, I'm not inclined to give Apple the benefit of the doubt on this.

This extends to hardware too, incidentally. It's literally impossible for competitors to make earbuds or styluses that can compete with the Airpods or Apple Pencil, because those use private/secret APIs. Not cool.
"Yes, refuse and take it to higher court."

This is in fact what ProtonMail has done on multiple occasions when we believe an order to be in error.
One of the best things I've done is to challenge myself to buy no packaged food for a week. I made it 2.5 weeks and have reduced my food packaging by about 95% since, about 4 years ago.

I thought it would be hard at first and it was. Then everything changed.

I had no idea eating almost exclusively from CSAs, farmers markets, and bulk would

- save money

- save time

- increase diversity

- create community

and most of all

- taste more delicious.

I'm never going back to mostly packaged food. I wish I could convey what Trader Joes, etc look like now compared to fresh from the farm. Something like a Surgeon General promoting cigarette brands, which used to seem normal.
If I can teach my aging mother(57) to use standard ubuntu 18.04 as her first computer ever then anyone can learn linux. Everything she needs is clearly presented in the bar of application icons and the ancient scanner/printer someone gave her works perfectly. Bonus points for when I go visit and there is a handful of .exe's hacked facebook friends convinced her to download sitting uselessly in the download folder.
the good news is you will get invited to a wedding as a 4.6 to show that the 4.9 doesn't look down on you for extra credit
If I was that concerned, I'd get a burner phone with a prepaid SIM card and create my account from a public computer while covering my face.

Plus, as somebody else already said: having JS enabled seems pretty much mandatory if you want to be able to decrypt your emails client-side.
> good cache-DMA integration but this not working across NUMA nodes. Ideally Intel would improve this feature to be NUMA-aware

How do you propose they do this? You can't magically move the physical devices to the other socket, and transferring the data between sockets is what those "NUMA-scheduling kludges" are trying to avoid. The only solution is to have software put the data close to the device.
But it would help a lot of developers didn't work on technologies that clearly lead to a dystopian future, or for companies that are working toward the direction. I know that would never happen, but it would sure help.
And yet, Germany currently isn't even allowed to issue European Arrest Warrents, because our public prosecutors are not sufficiently independent from government influence.

https://curia.europa.eu/jcms/upload/docs/application/pdf/201...
> and the guidance we got was to use an existing non-google github account for contributions if you had one and wanted to.

This is correct. Use an existing github account, but your contributions should be under your @google email address. There's nothing that ties your github account to a git email. I've committed through github from like 4 different email addresses (@google, @gmail, @uni.edu, and a shared organizational one for a project from a shared machine).
This should be problematic. Uber should not be in the position of choosing who is served by its business.

The whole “ratings” aspect is preposterous. There’s no independent way to appeal a rating and get redress. It’s just as bad as 360 reviews—at least 360 reviews are a blunt tool to unload underperformers.

I think these app ratings systems are worse and should not be enough to ban a passenger.
Germany has (almost) free colleges and it works put well. They make a lot of changes to get there (no campus experience, big classes, little handholding, two exams and no graded homework), and they have trade schools as well (well, apprenticeships). Those are completely orthogonal to college (you can do better financially in the latter).

Having a well educated workforce isn’t a bad idea, as long as we don’t think of it as a pissing contest.
How confident are we that, for example, you don't get rated lower in a given city of you're a member of the wrong ethnic group? Has anybody ever looked at these ratings (for drivers too, I guess) with an eye toward determining which biases exist?
I've been using Angular for a few months now and it's mostly been a good experience. We've been using Angular 7.

My biggest gripe, and this might just be my inexperience, is fighting the change detector to try and ensure reasonable performance when displaying a large number of elements. There are certainly mechanisms to do this but it does seem to take some work.
Always look at your traffic logs before making this kind of decision, but global usage is at 2.3%: https://caniuse.com/usage-table

I personally have dropped it for most of the apps I make (especially mobile web apps) so I can drastically reduce the final JavaScript bundle size by not having to polyfill a bunch of crap that all modern browsers already have built-in (Promises, fetch, fat arrow functions, let, const, etc.).
> And the fervent Hindu/Buddhist/Scientologist/Sikh/Zoroastrian who went through the same process believes the same thing about their religion.

You are just assuming here. Like I said before, I think you would be extremely hard pressed to find a Scientologist who was converted by praying to the Eighth Dynamic, studying it out, and then receiving an answer that they recognized, confirmed Scientology is true. As long as we are throwing out assumptions, I would assume nearly 100% of Scientologists are converted by: birth (tradition of parents), peer pressure/fellowship (esp. in celebrity circles), or confidence tricks ("auditing").

> I imagine you’ll say that such people didn’t do it right... because they didn’t reach the conclusion you did?

Well that's the thing about religion. People can say anything they want. They might even tell a little lie and say "yes" if you asked them if they received an answer from God that their religion is true, hoping it will convince you to join. There's no way of knowing if they are telling the truth or not. More generally, there is no empirical evidence someone else can present to prove their religion is correct. The only evidence to be had is anecdotal, and thus religion is a very personal and individual journey. You have to actually go through the process yourself if you want your own anecdotal evidence that God exists, etc.
I never made an argument about the Rust project assuming that. I'm talking about people using the availability syntax highlighting to dismiss a negative aspect of a possible choice. I was making that argument in general, but spurred by a specific comment here. I used the context of the Rust community discussion as an example, but never did I assume Rust was using this as a metric (just noting that it has been put forth in arguments from the community).

My argument at this point (as illustrated by the Rust discussion) is simply:

- Rust/rustc takes in unicode text as source

- Since it has no knowledge at the source level of syntax highlighting, using that to mitigate the downside of a language level syntax for a feature is problematic

- We as the public should keep that in mind when discussing the relative merits of one possible implementation or another of a feature.

That's not denigrating or assuming Rust actually did this, it's a note about the community level discussion and how some people approached it, as evidenced by a very specific comment in this thread, and how I thought it had some problems when applied to language level decisions.
You don't get to pick your driver, so the driver ratings really don't matter to any particular user for a given ride.

IMO the driver ratings make sense, and give the driver incentive to not take purposefully long routes, to not ignore your requests to adjust the A/C, to not talk on their phone, etc.

I have been in countless cab riders where it is clear the driver does not care at all what you think about the ride or the overall experience, and they know you can't really do anything about it (other than maybe not tip them).
Parallel PostGIS and PgSQL 12
CO₂ and Other Greenhouse Gas Emissions
That what they have been saying for years, not what the REAL reason.
If they allow enough In app purchases not to go through the store then they have no way to collect money from anyone, Since all apps could then just collect their money that way.

If you limit it only to an anointed group of large companies then you have formed a cartel, which itself is likely illegal.
> I don't know how old you were at the time of 9/11 - but there were loud, public voices in the Intelligence Community telling everyone that the WMD situation was fabricated.

Sorry, I didn't hear those voices from US government sources, and not really from major US media outlets. I'm sure they did exist, but if a single mouse speaks up while the lions roar you'll need a good microphone to pick that up.

That time, they correctly figured they didn't even need a new Nayirah to testify, they just made it up and most of the media went into war mode: it doesn't matter if it's true, now is not the time to ask questions, support the troops and embed your journalists. Very few keep their professional distance when the bombs are falling, too luring the heroes' song.

Sorry if it's too harsh but "trust us, this time it's different" doesn't cut it for me, Bush summed up my feelings on that issue quite well: "There's an old saying in Tennessee—I know it's in Texas, probably in Tennessee—that says, 'Fool me once, shame on...shame on you. Fool me — you can't get fooled again.'"
Today it's Uber's jerks, tomorrow it's people accused of being jerks elsewhere on the internet.
Show HN: High-performance JavaScript lib for large network graph using WebGL
I had a roughly 5.0 rating over a hundred or so rides in the Midwest US, but mine dropped to around 4 after taking 30-40 Ubers in India. It was a different experience there, and I always wondered if rating scales are different culturally (and we did have some GPS/language barrier difficulty, as well as some drivers who refused to be paid with Uber and made us give them cash that I’m sure affected it), but the ratings still stay with you global.
I am pretty sure Google doesn't "filter" e-mails, they're almost surely doing a full rewrite through HTML-internal-HTML where internal is a safe representation of that e-mail.
Thank you for keeping the web usable. Cheers!
> College needs to be a business decision on the part of the individual.

As much as I agree, can we just step back and think about how much pressure is put on these 17, 18, 19 year olds? Parents, counselors, and other adults have to do a better job helping these kids to make sound decisions around their major and college they attend.

I didn't have anyone coaching me to think about my debt load vs. what my career prospects would be, so I basically lucked out that I chose computer science as my major in my freshman year after coming in undeclared to a UGA, a public school. Pell grant and Georgia's HOPE Scholarship helped to reduce the amount of debt I took on, and I lived in Athens, a cheap college town, and paid $265-300 a month for my rent.

I feel so bad for people who didn't have such luck and are now getting crushed under the weight of an un-marketable degree and a heavy student loan burden. Seems so unfair.
If TPMS is tire pressure, then you are being unfair. There are cars like Toyota and Audi that have sensors that don't work well and even frequent service can't keep them off (to the point where some will not-quite-suggest disabling them).

So if you are going to downgrade for that, at least have a look at the tires directly and see if one is obviously lower than the others.
Thanks, great to hear you find it useful!

Yes, I do/did exactly the same - that's why I created Webframe! I've got a couple of ideas to possibly monetize it, but the main priority right now is making it useful!

I hope it's around in a year or two also!
Agreed, don't pick any random CC. Pick your final university and then find CCs that have agreements on transfer credits. I did 1.5 years at a CC in the same city as the university and on the sign up sheet for classes they would star the classes that could transfer and I had a list of classes I could take that would directly meet requirements for my future major at the university.
Sure, but it’s unclear whether that’s a problem that traditional antitrust regulations can effectively solve. If Apple’s forced to open up iOS, would your privacy focused App Store really be able to win on the open market? Remember that you can only protect privacy in that context by rejecting apps consumers would otherwise want to install.
I would bet skin colour and gender show up in these scores, as would many disabilities.

"problem users" doesn't necessarily mean what you think it means.
If I were creating the rules to analyze this data, I'd have to question the entries that were the difference between the driver and passenger is high.
Please answer one simple question: Do you perform real-time surveillance of users? Yes or no?
Most surprising thing in that was that the request to generate a report on the management of food waste reached a support level of 25%! I am really surprised that this is an important issue to Amazon shareholders.
China is not the source of our problems – corporate greed is (opinion) – CNN
In addition to @softwaredoug's comment is his book "Relevant Search", it's a great starting point! https://www.manning.com/books/relevant-search
The beautiful thing about this comment is that the sentence "Just act like a normal human and you won't be a problem user." would have fit _perfectly_ in 1984.

Just accept 2+2=5 and you won't have any issues!
The evidence that was presented by the author can be summarized as:

"I live-tweeted it, so they said it. If they didn't, I wouldn't have live-tweeted it.".

I'm sorry, but that's a pretty weak argument, even when it's a he-said-she-said type conversation.
It feels more likely to imply that "we have no hard evidence". So the argument still boils down to "because China", not "because spying". Which isn't a strong argument if you like to (at least try to) draw your own conclusion and not be fed one.

Are you worried that your iPhone or Tesla will be hijacked the same way? You already know this happened before with the knowledge of the companies involved (secret subpoenas or national security letters) or without it (beacon implants).
The other thing - this engine does orthographic projection, which preserves (IIRC) the distance aspect between points without any distortion.

It's a commonly used projection method for when you don't want scaling issues, where the need for measurement accuracy is more important (such as for CAD drawings - which inherited it from the standard technique for 3D model projection from the regular 3-view top/plan/side of pencil/paper drafting).

Most ordinary 3D engines use a true perspective projection, where distance from the view camera (or view plane) is taken into account, which causes objects (and parts of objects) to look smaller as they recede from that plane.
I instinctively find this utterly repulsive, evil, no different to China’s social credit scoring.
How can an average of 4.6 be meaningful for determining fitness to ride - that’s a rediculous number.
A mechanism for preventing truly abusive or violent riders should be based on specific reporting and video evidence, not a dumb aggregate score.
I am generally against regulation if possible, but this insane policy requires urgent remedy by regulators, Uber is becoming an important part of our travel infrastructure, so requires regulation just like rail, air etc.
VR Stylus for CAD
I just don't think this 'enemy' rhetoric is all that accurate. Dealing with the police is like handling volatile high explosives; sometimes you have to do it, but they definitely have their purpose, but you'd be a fool to handle the interaction carelessly. Reducing that to merely 'enemy' conflates them with harmful things that serve no purpose at all. Like stupidity.
And in three years we'll get leaked data showing there's a racial disparity in ratings, and there'll be some lawsuit about the racist algorithm.
You also need to buy an Apple computer to use Apple dev tools.

Apple prices out the lower class and third world countries from developing. They are actively contributing to income disparity.

Edit, anyone want to argue the opposite? The upfront cost to develop for Apple is terrible for the lowest income developers.
My friends dual Pentium Pro system is capped out at 2GB of ram. Many older machines got maxed out ram wise if you bothered to upgrade them at all when previous gen ram goes super cheap.
Well the simplest explanation is the classic nature vs. nurture, paired with selective breeding. If you are raised by hippie shroom eating chimp parents, you'll probably be attracted to a different sort of mate than if you are raised in a warrior clan. This sort of taming can happen within 3-4 generations and have permanent effects.

Dmitry Belyayev was able to produce a tame variety of the red fox within 4 generations of breeding:
https://en.wikipedia.org/wiki/Dmitry_Belyayev_(zoologist)#Be...
By that logic, any manufacturer who doesn’t produce a commodity is automatically a monopolist.
Who gets to decide who counts as a jerk? You? Think of somebody who's a jerk. Would you want that person at Uber deciding whether you should get a ride?

This question of "who decides?" is essential. I see snarky response after snarky response that ignores how power and authority corrupt decision-making.

I hope we can all agree that the decision to bar someone from participating in important ways in society should not rest on the unsupervised whims of people in Bay Area meeting rooms.
You are right. I have seen Harvard University ads in DC metro trains where it tries wring some money out by peddling JS/Frontend courses.

I wouldn't be surprised if there are 'summa cum laude' in ReactJS or some such by next decade.
The original PlayStation didn't even have real 3D texture mapping, it used linear transformations rather than perspective transformations.
> This is a great argument against all OTA devices

Indeed. And for life safety uses it's appropriate. In safety-conscious settings such as those involving line voltages requiring NRTL (UL for ex) listing OTA updates are forbidden: One must have physical access to the device to perform a permitted [0] code update.

[0] And the code updates themselves are subject to IEC 60730/UL 1998 or it's back to the NRTL for more testing
I disagree, the ratings are averages, so outliers should be naturally smoothed out. You should not need to appeal any 1 (or 2) bad ratings, if the rest of your ratings keep your average up. However, if you are consistently being rated such that your average is in the 3's, maybe you need to think about how you conduct yourself along the way.
> or trust their auditors

if it's open source and you can build it yourself, sure
Will this cause riders kicked off to shift to Uber's competitors, say Lyft, thus poisoning those services for drivers?
The nontechnical problem is the prevalence of bad website design. AMP is not needed in order to have performant websites. The case Google makes for AMP is "web designers suck".
That leads me to the following question: is earth the onnly planet in our system which has a molten core or do they all have molten cores?