skysight-inc/HackerNews huggingface dataset:
Let's talk about how this works in reality.

In ActiveRecord, there's a method called find_by_sql. You can't call it directly; it's a class method on an ActiveRecord model. So you have to choose which of your ActiveRecord models should be used to instantiate the rows of your result set. (What if your result set doesn't really match any of your models? Pick one arbitrarily.) Your SQL has some extra columns. What happens to the data in those columns? They get monkey-patched onto the individual objects. (Which is stupidly expensive in Ruby.) Other than that, the individual objects are fine. They even have all your smart instance methods, which may or may not behave properly with all the ad-hoc monkey patching.

If you tried to short-circuit all of that nonsense, you tend to get arrays of hash tables. Which is, in my opinion, already a perfectly adequate interface!
Isn’t that just a query builder? I’m not familiar with Perl or your library, so maybe you could tell me where I’m wrong?
Yep this is exactly the way I think about it. It’s a kernel for a distributed operating system.
A little more for you:

"Document ID: 20190030475 Quantum Supremacy Using a Programmable Superconducting Processor The tantalizing promise of quantum computers is that certain computational tasks might be executed exponentially faster on a quantum processor than on a classical processor. A fundamental challenge is to build a high-fidelity processor capable of running quantum algorithms in an exponentially large computational space. Here, we report using a processor with programmable superconducting qubits to create quantum states on 53 qubits, occupying a state space 2(exp53) ~ 10(exp16). Measurements from repeated experiments sample the corresponding probability distribution, which we verify using classical simulations. While our processor takes about 200 seconds to sample one instance of the quantum circuit 1 million times, a state-of-the-art supercomputer would require approximately 10,000 years to perform the equivalent task. This dramatic speedup relative to all known classical algorithms provides an experimental realization of quantum supremacy on a computational task and heralds the advent of a much-anticipated computing paradigm. 20190801 August 2019 Copyright, Public use permitted Unclassified, Unlimited, Publicly available http://hdl.handle.net/2060/20190030475 CASI application/pdf Mandra, Salvatore Rieffel, Eleanor G. Biswas, Rupak ARC-E-DAA-TN71198 NASA/TP-2019-220319 Computer Systems"

Happily provided by Google. ;)

https://webcache.googleusercontent.com/search?q=cache:Ig1-Fl...
You'd be surprised how not many people need to change trend

And for small browser like safari it will be fast death

And for chrome

On mobile chrome is already (for me) dead coz it not allow extensions
The line about the Swiss, the Borgias and the cuckoo clock is kind-of inaccurate. The cuckoo clock comes from the Black Forest region of Germany, not Switzerland. However, the quote is true in spirit when you realise that the Swiss did not invent even the cuckoo clock.
But taxes is someone else deciding that I should donate to something they decide is worthy.

Sure, it does solve the "collective action" problem, but by removing my consent.
I don’t know which is more likely: China leaning on Apple etal to hush up their spying attempts or USG feeding misinformation to Bloomberg to gin up the trade war. But it’s probably one or the other or both.
Codd's relational model on its own is a more beautiful, flexible, and concise system of data representation than the object oriented model. SQL is a rather poor implementation of it, but it will do, in most instances, for the sake of compromise.

What it is missing is a model of _behaviour_.

I've always (ok well, not always, but for the last 15 years probably?) felt the missing piece in what we call 'middleware' isn't to resolve the impedance between object orientation and the relational model, but to somehow come up with a method of representation behaviour/execution for the relational model itself. And do away with all these hierarchies of classes and whatnot. Something conceptually like what we call a method/multimethod in OO, but consistent with the mathematical, set-based lingo of the relational algebra.

But I'm probably not smart enough to figure that out. I hope someone does. I don't think 'stored procedures' is even close to it. Maybe Datalog has it, but I haven't grokked it well enough to say.
Very cool! I didn't see this at first, but glad to see it's there. Awesome work
I upvoted you because you explained your downvote
Too little, too late. Delete FB/Whatsapp/Instagram.
Thus Spoke Zarathustra
Just travelled to Osaka and I can confirm They have vending machine with alcohol here although I literally only found one so far in my trip.
Almost everyone I know only buys games during the big seasonal Steam sales, perhaps with the exception of the occasional “must have.” By not allowing resales, game developers are forced to offer big discounts during these sales in order to capture the “clearance bin” prices that would otherwise go to the secondary market. If reselling were possible, game publishers would never offer those discounts since resellers would always undercut them.

I have personally purchased some Steam bundles that included games I’m actually interested in playing for less than a dollar.
Oh no, it isn't. Look, I get that you've seen enough to either know the shit is happening or believe it is based on what you've seen happen. I'm in the same boat. I'm just saying you're hurting your already-good credibility saying things like that.

No, it's not acceptable if it's a highly-controversial claim in an industry or topic that normally comes with proof of exploitation. They should've got it even if it was independent party vetting it that most would trust who wouldn't give too many details that would compromise an investigation. They could get money and/or advertising for doing the review. Otherwise, present it like it's information coming from anonymous, unvetted sources who could be full of shit.
> You know how I keep my kids protected?

I'm guessing if you could move them out of a violent, dangerous country, and into a much safer (and more economically stable) country, you would risk quite a bit to get them there. Sorry, I get the personal responsibility angle, but your comment comes off as deeply disingenuous.
That’s pretty decent. I think Renesas has a devboard around the $125 price range. But it’s not as well specced.
I tend to use Active record for simple queries. And for anything complex, I write a SQL query to define a view and build a view backed model. That way I can use SQL when I want/need to, but I can keep it contained in one place, and I don't have constantly rewrite tedious queries.
Is it ActiveRecord? I find it to be very flexible and convenient for 95% of my use cases. There are a few places where we drop to raw SQL but AR makes that very easy.
sqlc understands ALTER statements, so it can parse your migrations directory.
If a site doesn’t work with desktop Safari well, you can tell them to just use Chrome.
> state-sponsored agitprop

as defined by the board of Twitter, Inc.? I stand by my "ignorance" then.
> totally believable because it's in line with the last 10+ years of their product direction.

yet they have shitware called uBlock that's there intended to confuse them with ublock origin, just sitting there in app store...
As commented in 2 recent discussions (I got upvoted once, downvoted once, on them):

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

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

...in effect we are not competent to solve this or our other key problems while rejecting the creator (and basic rules like honesty and the Golden Rule), and that none of the current events should be surprising at all, though they are sad. These are predicted, expected, and it will get worse, but we can be at peace and seek good things, and really, we can be OK. Linked to details on why I think that, and more info (a simple site: http://lukecall.net/e-9223372036854581820.html)
okay, you win... let’s call it an illogical or even obtuse analogy.
This is a really slick little utility! I'll definitely be adding it to my data munging grab bag.

For those that deal with this sort of thing often, here are some similarly useful tools:

⠀

Really useful for generating table definitions and/or importing data from a csv to a variety of databases (bunch of other useful utilities in the repo as well): https://csvkit.readthedocs.io/en/latest/scripts/csvsql.html

Similar to cq for querying a CSV file directly: http://harelba.github.io/q/

Not used often, but really handy when you come across a csv file it's designed for: http://colin.maudry.com/csvtool-manual-page/

Diff csv files: http://paulfitz.github.io/daff/

Can convert flatfiles between a bunch of different formats. Useful blunt tool to get things to and from csv files (among others): https://github.com/dflemstr/rq

And for searching JSON:
jq: https://stedolan.github.io/jq/
gron: https://github.com/tomnomnom/gron

Or use in2csv from csvkit or rq to get the JSON over to CSV and go from there.
Being shot on US soil by a Chinese policeman operating as one would constitute an act of war.

Just saying.
After a while, in my opinion, he just wrote the ~same novel, again and again. There's always the tough young woman. And the wimpy guy, typically a druggie. And often, the Case equivalent.

But I still like them well enough.
> We need the federal and state governments to do something

Mostly you just need your city government to legalize housing.

> politicians don’t gaf because liberal cities are going to vote for Democrats anyway

Well, the awkward truth is that non liberal cities mostly don't have this problem. It's mostly created by liberal cities.
I didn't know [we] PC and VPS users went anywhere, if anything the already established and really skilled release groups were solidified while others were extricated, or in some cases and very unfortunate, immured. I would make a partially substantiated and educated guess that a driving force in any potential, acute, theoretical or otherwise increase in freedom of information; The renaissance of the information era, our time, is suddenly presented with a market filled with VPN providers, most of them blatantly crude in their pitch. With promises of hosting end-points in nations unburdened by draconian laws, well outside any jurisdiction legally obligated to abide by federational - european, american or otherwise - demands or requests of private information. They also always make it a big deal to point out that they don't even generate logs of user activities. The latter sounding unlikely since it's crucial for any service providers survival and growth as well as preserving the capability to offer an equally distributed quality of service.

Piracy is not a fitting name. There's no rape, murder, malintent or even direct physical, psykological or directly provable damages made by sharing information. The argument that one album downloaded automatically equals the loss of one sell. That is similar to comparing bank-robbers to successful hedge fund managers because they aspire to collect currency or assets in large numbers. Wait.. That actually is comparable.. Well, I digress.
He wanted an electric car. But not anything more than that.
Your example makes for good SQL but a simple ORM example:

employee = new Employee() { Name = "Bob" }
employee.Manager = new Employee() { Name = "Jill" }
context.Employees.Add(employee)
context.SaveChanges()

This would insert a new employee record for Jill, grab the primary key, then insert the record for Bob with his ManagerId field to Jill's id. If Bob wasn't a new employee, it would perform and update instead. If there were more related elements and different levels of depth the ORM would order the inserts/updates to get the necessary keys and wire everything up. After this block of code, the objects are all updated with their new primary key values. Everything is executed in a single transaction.

The ORM is performing operations on objects -- it's pretty much right there in the name -- it's going to be a poor choice for bulk updates because that's not what it's for. But again, nothing stops you from using the right tool for the right job -- whether that be an ORM or raw SQL.
The way I'd put it is: "learn SQL then use an ORM". If you understand exactly what SQL is being generated and what the implications are, you can use an ORM effectively and benefit from it in many ways (readability, security, composability, etc.). You'll also know when to use it and when it's better to just drop down into SQL. It's when people don't really know what the ORM is doing underneath that they get in trouble.
One significant factor is free or low-cost healthcare. Medical bankruptcy is the single largest type of bankruptcy in America, even among people with insurance, and bankruptcy can lead to homelessness. Untreated mental illness is also huge, and that's related to availability of care as well. Losing a job and then losing employer-sponsored health insurance is another version: COBRA coverage is very expensive and temporary, so people with chronic or expensive conditions may fall behind on rent etc between the one-two punch of loss of income and loss of insurance.
Inline assembly is part of the C11 standard as Asm("assembly goes here")
prism is generally thought (by my understanding) to be snooping on lines between data centers without the complicity of the companies targeted
How to Go to the Bathroom in Space
>Mozilla's rr (Record and Replay framework) only works on Intel for example

Can you source that? I can't find it on the Wikipedia page[1] or its homepage[2].

[1]: https://en.wikipedia.org/w/index.php?title=Rr_(debugging)&ol...
[2]: https://rr-project.org/
To be fair, this is one point that I think they've actually gotten correct. Discrete log is easy <=> Integer factorization is easy.
Browsers need a bright line between documents (HTML and CSS) and applications (electron-like, notifications, complex APIs, access to features that affect the user's security).

Plain HTML documents are SEO friendly, are a11y friendly almost by default, back/forward navigation works, and HTML doesn't chew battery and bandwidth on JavaScript.

For our web app the biggest pain points are: security (hard to integrate third party libraries), control over the viewport (an app header and footer that don't get lost when zoomed - like an App), control over data entry (the hacks we have to do for fast reliable time and date entry are rediculous, and other stuff is just too hard), and control over navigation (browser back/forward is broken for applications that POST data).

Unfortunately Google don't seem to want to encourage plain HTML documents (instead the insane AMP shit).
The "coherence and familiarity" argument for native apps is only half the story though. Cross-platform coherence and familiarity is also important. And as an app developer, when you have to make a decision regarding whether you should be familiar and coherent to the rest of the operating system or the other installs of your app, that's pretty much always going to land on the "my app" side.

Especially with Microsoft office, which was completely chock full of custom controls and didn't feel at all like part of the OS last time I used a natively installed version (on windows 7)
This why I like Democracy Dollar proposal, giving each voter $100 to give to candidates.
> Nobody should be writing raw SQL.

What?!? That’s an absolutely foolish and naive assertion. Please don’t give any of your fellow junior devs that “advice”...
Have any of the naysayers used rails' ActiveRecord? I used to not like ORMs much, but honestly it's a whole different ballgame. Very easy to slip into SQL for bits (or big pieces) as well. People don't really complain about in the rails world (my respect only increases) and it has a lot of miles.
The latter. When you go past all the rhetoric and the individual human-interest cases it boils down to the following policy issues/grievances (whose merits you may or may not agree with; I won't be litigating them today) in rough reverse chronological order:

- The current administration is super-racist

- The last administration wasn't much better because it used immigration enforcement to appease the right in hopes of obtaining political concessions

- After 9-11 DHS was set up, which was a Bad Idea, and what used to be the Immigration and Naturalization Service was split up into separate administrative (USCIS) and enforcement (ICE) wings; this was bad and correlated with a rise in anti-Muslim sentiment

- Most of the current immigration law dates back to 1996, when an imperfectly working system was swapped out for one that was far more draconian and arguably designed not to work but instead to maximize the number of people deemed 'illegal', which it definitely did

- since the late 60s/early 1970s the primary drivers behind stricter immigration policy have been white supremacists, most notably a guy called John Tanton who set up tons of front groups like FAIR, CIS, US English and so on to promote his extremist views

- but when you get down it US immigration policy has been characterized by waves of racist reaction towards Mexicans, Chinese, Irish, Germans, Italians, etc.

- not to mention the whole slavery/civil war thing, which I mention because today's Abolitionists explicitly model themselves on John Brown and also have fundamental philosophical disagreements with the role and scope of police in society, and finally

- indigenous and non-White (=/= non-caucasian) people are really sick of colonial bullshit.

To sum up, while you might or might not agree with these political stance, and the movement doesn't do the best job of communicating it, Abolitionists are fundamentally opposed to the existing order of society, are solidly grounded in the liberatory traditions of the Enlightenment, and mean business.
A complex combination of factors that touch on timing, investment, strategy, people, mistakes, and way too many other factors to fit in a HN comment.
Andrew Cuomo and the Curious Case of the $81M Elevator
True, but it's both.

Just as a link in a linked list is often the list and the node in the list.
The linked article about defining typed CSS properties using a mix of script and style tags seems perplexity complicated to me: https://web.dev/css-props-and-vals/

Was this intended to be tied to some other feature or framework not mentioned?
Politicians and big business in their district don't have to collude. They already have the same interests.

If the Big Company does badly, voters will lose their jobs, and it will be a tough reelection. The politicians don't need to be bribed.
The [Intuitive] Monty Hall Problem
I wrapped a probability distribution around this very phenomenon a few years back:

https://statisticsblog.com/2013/05/30/uncovering-the-unrelia...

The expected duration converges to exactly double your wait time so far. I've found the "unreliable friend" distribution to be very useful in my modeling!
These are all nice promises, but there isn't a whiff of how any of this is achieved...
Eight Useful JavaScript Tricks
>> Throwing money at social problems doesn't typically fix them.

I don't know where you read this because it simply isn't true. It is, however, commonly used by conservatives to argue against funding social programs.
I was never in to reading as a kid, and it drove my dad crazy as I am wired personality-wise like him. Reading would become too hard after 3-4 paragraphs and I just thought I was always lazy. I found out I had a print-related disability when I was an adult, specifically severe convergence insufficiency, after I was diagnosed with a rare disease.

I use screen readers now for immersive reading, specifically Voice Dream Reader (iOS|Android) and Kurzweil 3000 (Windows|Mac|Web). I finally got in to reading habitually after reading some history books. It can still be physically painful for me to read, but it is worthwhile.
No, it’s the most efficient in liters of fuel per hundred kilometers of distance traveled.
Fair enough -- and if I claim that my statement doesn't actually apply to specific future circumstances in a way that supports my current personal beliefs feel free to ignore me.
https://github.com/mozilla/rr/issues/2034
What's funny about what you linked is a government demand led to the vulnerability at a point when owners or main people were thinking of walking away. A conspiracy around that would be more believable than most. Let's ignore that, though.

The thing is, they add vulnerabilities in a number of ways. They can do it directly with code. They can do it indirectly with standards hard to code correctly w/out vulnerabilities or side channels. There's lots of options. Whatever they do will usually look like a helpful contribution or useful requirement that went wrong in a way that leads to an attack. The better ones are those that look like common or inevitable errors. That's because obvious backdoors make folks run away from a project or supplier maybe forever on top of question who put it there. So, it's usually these flaws that look like obvious errors that still get the job done with everyone around defending the person that put them there.

And I'm not saying it was an NSA job. I have no idea. They've been doing too good of a job on most things for me to know. Could've been an accident. Even probability supports it's an accident just like it did all the times it was a subversion. At $200+ mil a year budget for backdoors/hacking, you bet there were a lot of accidents that, in non-TS version, had nothing to do with the NSA. ;)

Edit: There's lots of questionable things in this article. My favorite is this:

"And this group are the best of the best of the best."

The OpenBSD team doing LibreSSL had all kinds of summaries, live updates, and even presentations of what they found. It was about as far from that quote as you could imagine. Although my memory sucks, I think at one point they said there was even code that checked to see if endianness changed while it was operating. They at least had that covered. There were so many oddities about that codebase.
It's not a matter of supposing that certain things may be happening, or even that they probably are. It's a matter of believing with certainty that they are, without concrete evidence and sometimes even when there's evidence to the contrary.

It's a pernicious bug in certain kinds of psychology that makes it quite hard for someone to tell the difference between nightmarish fantasy and reality. I don't want it.
And therein lies the problem. These ORMs (by and large) have become so complex and abstract that it's nearly impossible to understand what they're doing underneath (I'm looking at you Entity Framework (in .NET))

You wind up having to have a deep understanding of the ORM and SQL, at which point I would argue why bother with the ORM at all? For .NET, I'm much happier with a very very thin layer over the base .NET database client library called Dapper. Unfortunately most shops use Entity Framework by default.
All the ORMs I've used love views because views are just read-only tables. The dumbest ORM might not even notice the difference.
You just said "you know, if you wanted to have a shitty burger, you can get it right there for half the price of a national chain and it will be at least as good"
Have you considered having a government that doesn't go to other countries and attempt to subvert or bomb them into submission in contravention of its own founding principles, only to turn around and complain about the refugee crises of its own creation?
Even Wittgenstein admitted his earlier work was wrong.
And how exactly app outside browser \wo api for filtering can filter page content?

MitM like "antiviruses" do? Nice
This is also one of the reasons these types of businesses are hard: I don't want to build on a platform that might suddenly set me into fire drill mode where I have to basically stop all work and port to a different technology. Going with a startup is always risky.