skysight-inc/HackerNews huggingface dataset:
Downvoted for the personal attack on the author, but in a spirit of using this as a learning opportunity...

The writer obviously groks SQL. SQL as a language expressing relational algebra sucks. It was a way of trying to make relational algebra "grokable" by end users, in the same way that COBOL was a way to make "programming" grokable by end users.

The author's point is nothing to do with JSON, it's about having a column type that contains structured data.

In "pure" SQL you have to extract that structured data into another table or a hack like "subtables" or something.

The "natural" form of a lot of data these days is JSON. Having a JSON data type is only the start of being able to query it cleanly in SQL.

For SQL to cleanly support JSON, it needs the ability to handle the lack of data types in JSON, and the fact that each JSON element can be an untagged union of potential types.
Biden signs executive order on Right to Repair
Because taxis are heavily regulated in NY. Even though there's demand, we don't want that many cabs around otherwise the streets are too congested.

So it's a problem on both ends.
I don't think they're contradictions, especially if "resources and information" is defined elsewhere, but if we're assuming it's vague or contradicting then:

If it's in Amazon's interest to be misleading or ambiguous, then the lawyers are doing their job. Make the text seem to imply one thing (to get employees to sign it), while text in another part of the contract is explicit in contradicting it.
I would like a typescript style transpiler tool chain for testing out new language features that are seamlessly transpiled down to existing sql.

Once that’s in place I don’t know which features I’d want first… but there’s a lot of them!
> What percent of visits are bots

It doesn't matter.

> how do you detect them serverside?

Instead of trying to detect whether something isn't human you should be trying to detect whether something is malicious.
Somehow dogs can get away with cooling through their tongue but the naked apes still complain about their whole arms being cooled?
Show HN: Row Polymorphism Crash Course
You can see it as a villain, but the way it is presented it does not seem Nowicki sees Roupenian as a villain (though maybe she did at one point).

I think the essay is more subtle than that. She ends by describing "what's difficult about having your relationship rewritten and memorialized", rather than any sharp criticism. She describes herself as angry and frustrated earlier, but having appreciated that Roupenian was sorry.

It's quite nuanced. A lot of the essay also focuses more on other peoples (real world) interpretation of her relationship, rather than on the fictional story ("My relationship with Charles was full of shame brought on by people who assumed the worst—a predatory man asserting his power over an innocent girl").

Part of the essay focuses on how the story "blurs the boundaries between the real and the invented" but also how that affected both Charles and her in that it made him question whether he had acted like the fictional character, and "sometimes, to my own disappointment, I find myself inclined to trust Roupenian over myself" about her relationship.

The essay is just as much about how we tend to assume a lot of fiction is truer than it is when it includes even some details from reality - to the point where Nowicki finds herself trusting a total strangers interpretation of her own relationship - a relationship said stranger had never observed directly.

A key line to me is "I’ve wondered a lot about the line between fiction and nonfiction, and what license is actually bestowed by the act of labeling something as fiction." This seems to get at the core of what this essay is, with Roupenian being more of a prop to discuss this subject grounded in a real situation than a villain per se. Almost every negative about Roupenian is accompanied by a counterpoint, that while not entirely negating what is often critical does soften it.

E.g "At times I’ve convinced myself that she wanted us to know it was about us" - something that if true would certainly tip Roupenian into villain territory - is followed by "But then I remind myself that when she wrote “Cat Person,” she was still in her MFA program. No one knew her name. Submitting a story to the New Yorker was a long shot, and a piece of literary short fiction had never gone viral in this way."

It also goes towards making the argument that Roupenian was likely more toughtless than malicious, and that her thoughtlessness was somewhat understandable and would have meant very little if not for accidents of circumstance.

Does it put Roupenian in a somewhat negative light? Sure. It was stupid and thoughtless of her not to change details. But villain? I don't think she's important enough even to this essay, to be the villain of it. She plays a perfunctory part of a much more interesting story about Alexis and Charles, their relationship, and how seeing it reflected in the fictional story affected them.
Steps for Building an Inclusive Workplace
lily.ai | US, Hybrid | Machine Learning Engineer & Scientist | Full time

We are a well funded startup fueling the next wave of innovations in product discovery and personalization. We are working on use cases such as deep product attribution, visual search and psychographic profiling of consumers, among other things. We are a team scientists and engineers specializing in Computer Vision, NLP and Recommender Systems. We have a range of interesting problems to solve. We lead the industry in terms of the depth of our taxonomy.

There is full freedom to own, shape and execute our vision irrespective of designation. We are goal oriented than task oriented. Empathy and well being are a big part of the company's culture.

We are augmenting the ML team with a Machine Learning Scientist and a Machine Learning Engineer.

Find out more about the roles at https://www.lily.ai/careers#job-openings

I am the hiring manager, feel free to reach out to me directly at anand AT lily DOT ai

NOTE: We are predominantly looking for candidates based out of US, but willing to make exception if we find a good fit between us outside US as well. Feel free to reach out.
> We wanted the language to be simple enough that ordinary people could ‘‘walk up and use it’’ with a minimum of training.

In that case it has been an abject failure. I have been using SQL since the mid 1980s (so pretty much since the start of its widespread adoption) and I have never met "ordinary people" (by which I assume intelligent business-oriented professionals) who could (or wanted to) cope with it.

I like it, but the idea of sets does not come naturally to most people (me included). But I once worked with a programmer who had never been exposed to SQL - I leant him an introductory book on it and he came in the next day and said "Oh, of course, it's all sets, isn't it?" and then went on to write some of the most fiendish queries I have ever seen.
Dealt with this recently. Something like half of Americans are using some sort of privacy blocker on desktop [1]. It's not as high on mobile but still sizable. My guess is it's higher with the HN crowd.

I dealt with something similar so I had my back-end fire server-side events to compare to Google Analytics and other client-side reported data. Sure enough, 50% loss on desktop and 30% on mobile.

1. https://www.forbes.com/sites/tjmccue/2019/03/19/47-percent-o...
well, except "FROM dual" is an Oracle-ism because they require a FROM in a SELECT.
I used RethinkDB for a while, before migrating to Azure Table Storage, and it was nice to use.
RethinkDB is mentioned in the article.
Your can get bare metal servers with unmetered bandwidth from Hetzner for way less then $100 per month. These ips aren't in the ranges that are usually blocked by cloudflare etc.
Crucial Facts About Driving Schools and Driving Profession
Driving instructors in Ottawa believe that people who are jobless should get themselves trained as professional drivers because it can prove a great source of income. More on, freight and carriage companies also hire truck drivers for delivering luggage. So, there won’t be a lack of jobs in this field.
I'm pretty sure you can only enter Svalbard from Norway, that's why it's visa free. And unlike mainland Norway it's not in Schengen so you'll need a passport in, and also when coming back to Norway entering Schengen.
What I really don't get is that he seems sometimes to take very pro-American actions but then he also basically sold Academi/Blackwater to China and worked for them? But the links to Trump aren't surprising given he was related to Devos. Either way, dude is well on his way to either being a supervillain, dictator, or mysteriously disappearing.
> neural network based anomaly detection system

Valve has already been doing that for a few years: https://www.pcgamer.com/vacnet-csgo/
I think for your site that's true but not for HN. Your users are advanced but regular users. HN, on the other hand, are not regular users but professionals.

Car enthusiasts vs mechanics in a way.
My point wasn’t that it was invasive, but that even 5-second namedrops annoy me. The prominently placed logos on clothing and all over stadiums, even in stadium names lately, also annoy me. However, then I can just focus on the game and ignore the ads. With the “sponsored by” and actual ads, you just can’t ignore it. It is force fed. I think that’s an important difference, and also why forcing me to say some brand name because they renamed the stadium to “COCA COLA ARENA” or something similarly obnoxious is so grating.
The terminology used is a bit confusing. Execution model and application architecture are not the same dimension, so it shouldn't be a comparison between 'monolith' vs 'microservices' vs 'serverless'.

The paper seems to use 'microservices' to mean 'containers', but you can make microservices using serverless tech. Heck, you can easily run a monolith on serverless too.

Another example: the paper claims that for microservices (aka containers?), most of the security concerns remain for the app owner to deal with, whereas serverless hands much more of that off to the cloud provider. Not really true. The container-based services on GCP/AWS are almost exactly as compatible with the rest of their offerings as FaaS is. You can front container services with CDN/API gateway auth logic the same as you can for FaaS. In fact, you can do that for durable resources too.
Uber is a great service for the customer. It made getting places within cities convenient and reliable. I don't think there's anyone who misses calling cab companies late at night.

However their pricing was never real. They took billions of VC dollars to make it seem like Uber could be better AND cheaper which drove every tradition cab company out of business. It also meant that all of the benefits of Uber accrued to the rider and the shareholders, the driver's didn't do so well.

Now they have to raise prices to a rate that's actually profitable. Meanwhile the taxi companies got their act together a bit. They have apps now, they take credit cards. So things will end up better across the board, just maybe not cheaper.

Consumer benefit aside. Ubers pricing strategy should probably have been illegal. You should not be able to flood a market like that. In international trade this is called dumping [0]. I wish we had a similar law for tech companies that want to destroy incumbents with VC money.

0: https://en.wikipedia.org/wiki/Dumping_(pricing_policy)
Postgres allows you to run python in the database, Oracle has support for java, Postgres can do limit 100, you can build subqueries using views, and reuse these in larger queries...

Problem with query optimization is that it needs to be done at runtime, you can't optimize it in some procedure language easily. The optimal way to retrieve data depends on the number of records in your tables, the where clauses you use, the actual values you are filtering by, the records already in cache, etc.

99% of all programmers would not be able to program better performing queries when doing this with a procedural language or streams expressions or it would take them way too long.
It seems to allow it here. Fully up-to-date, default settings.
A more pragmatic view in that article: https://blog.nelhage.com/post/some-opinionated-sql-takes/
I think that GA samples the data anyway (unless you pay?), so it might not be a reliable "hit counter" these days.

I guess the value comes from seeing "trends" in your site content - I.e. how people move around within the site, which sites are sending traffic etc rtlather than seeing absolute 100% accurate counts

Log analysis will always be much more accurate counter if you just need a hit counter.
https://en.wikipedia.org/wiki/Bluetooth

In the most widely used mode, transmission power is limited to 2.5 milliwatts, giving it a very short range of up to 10 meters (30 feet).

If I read correctly a cell phone is using more like 1-2W so 800 times as strong. One could also use something, the horror, with a wire!
No. They still feel accomplished. It is self deception, but many people are good at double thing.

The sense of accomplishment comes from beating someone for many people. Cheats dont change that.
Looks exactly like all the tonnes of 4 and 5px wide fonts commonly seen on home computer systems from the 80s and 90s with relatively low resolution, like the Amiga, Atari ST etc.
Remember, Google Can Ban Your Account
Had this happen today, thankfully hitting Try to Restore worked. Scary.
I’m guessing the gas savings add up pretty fast when you’re driving 8+ hours per day. They are also reasonably space efficient, so you can comfortably seat most rides.
> English is often called French (lingua Franca - the language of the Franks). It is routinely used as an intermediary language because it is very simply structured and can take quite a lot of abuse and still remain intelligible.

You didn't even for a second stop to think why English language uses a Latin term to call a language the language of the Francs?

Latin was the original "lingua franca" of Europe. For historical and traditional reasons.

Then France was the largest, baddest, most powerful country, and everyone wanted to be like France.

But in the past several centuries Britain and then the US were the biggest, baddest, most economically powerful countries, and it's beneficial to know and speak English.

People didn't use Latin or French because they were simpler. People don't use English because it's "simpler than French". If that was the case, everyone would've switched to Turkish, for example, as it's very, very, very simple compared to any European language.

Chinese was the lingua franca of Asia for centuries before English even became a thing in the 19th century. Because it was the biggest baddest empire around. Don't get too surprised if Chinese becomes the lingua franca of the world 20 years from now.
First, people who cheat in multiplayer games are awful, and it's unethical and unconscionable.

However, cheating in single-player games is perfectly okay in my book.

When I'm cheating in a solo FPS or other game, I still enjoy the game. The cheating is a way to tackle some aspect of the game that I don't enjoy, while still enjoying the rest. I can actually put on god-mode and unlimited everything and still enjoy moving through the game and doing things. Even the battles can still be somewhat fun under those conditions, even knowing that I can't possibly fail.

So it doesn't surprise me that the rush of beating real people still exists even when you're having the computer do most or all of the work.
Agreed. I used to support my hosting costs via google adsense. Over recent years the impressions and clicks dropped off a cliff.

In the end I realized I was just as guilty, after all I run adblock too - so I removed them all.
This is exactly it. I've seen nobody upset that Roupenian borrowed details, but at keeping enough details unchanged to give room for those who recognise the people to question which part is fiction and which is true in a way that casts shadows over the people it was at least party based on.
The author seems to think that putting structured data in columns is a good idea. That is pretty clearly contrary to the basics of the relational model itself, never mind SQL. In fact it's quite close to how document databases work, so a very NoSQLish proposal overall.
OpenAI – Code Pilot – Codex – Paper Review
A Look into CBL-Mariner, Microsoft’s Internal Linux Distribution
GraphQL is very limited in expression power compared to SQL. I doubt you could do 20% with GraphQL compared to what you can do with SQL.
Similar experience in automation. When the factory was prone to that behavior or the project we got was already "escalated", we had a 2nd guy working as a "Linebacker" who would stop the whole shenanigans, allowing the first guy to work and concentrate.
If you have a project that you don't want to embed in another project, doesn't build on windows, doesn't have any spaces in filenames, and do'nt mind manually ordering dependencies wrt the quirks of your toolchain.
>By far the most common case for joins is following foreign keys. SQL has no special syntax for this

That's because there can be more than one FK relationship between the same two tables. For example, if we model a binary tree, there could be references to left, right and parent nodes.
Finnish adds an interesting twist to this. That language is completely different from the ones you listed, so casual mutual intelligibility flies right out the window. My guess is that Finnish and other Scandinavians mostly use English or Swedish to talk to each other.
DNS geoblocking doesn't exist.
If you have issues resolving domains with your ISPs DNS then just switch to googles public DNS 8.8.8.8 and 8.8.4.4

Geoblocking is a different thing entirely where the (web) server refuses to offer content because of your IP address. This can't be circumvented without some kind of proxy or vpn
Dvorak-intl-code user here, SQL has so much more engineering than the QWERTY layout it's hardly comparable at all.
I am an American with a life long love affair with Canada. I follow Canadian news and media pretty closely.

Claims like these are what I read about all the time in Canada. As an American, to me their culture has moved to a very strange place as far as worry and blame.
Very few non-bot visitors refuse to execute JS.
Digital Traces (Escape room game)
I don't understand how this practice of using VC money to offer services below cost to undercut competition isn't illegal. In Ireland loss leading (offering certain goods below cost to entice customers who will then spend on other goods/services) is illegal. Not sure about other countries but doing what Uber did is straight up theft with huge negative externalities for society.
I don't think that NoSQL ever was about better query languages for relational databases. It was about making databases faster and easier to use by using simpler data models with fewer guarantees.
FAA: New tool limits disruptions caused by space operations
Ask HN: How to keep Scala codebase idiomatic?
Clever people often get seduced by the expressive power of the language and start writing Haskell in Scala.

Well said in Effective Scala [1]: "Above all, program in Scala. You are not writing Java, nor Haskell, nor Python; a Scala program is unlike one written in any of these. In order to use the language effectively, you must phrase your problems in its terms. There’s no use coercing a Java program into Scala, for it will be inferior in most ways to its original."

While pure FP code can be a good fit for some projects, it makes hiring much harder. IMO, it is never going to be key component of project's success, but can be a significant contributor to its failure.

Good examples of what I consider idiomatic Scala are projects from Odersky, Haoyi and Twitter.

Most of closed-source projects I've seen are either Java or Haskell projects in disguise.

What is you experience with Scala projects in this regard? Did you choose idiomatic mix of FP and OOP or some other approach?

[1] https://twitter.github.io/effectivescala/
Summarizing an entire language, and thus everyone ever spoke it, with economics is a good metaphor of the current shallow consumer culture we live in. If it is not on Netflix it doesn’t exist.
> People: write simple, portable code!

How do you memory map a file, or spawn a subprocess simply and portably? Every way that I've seen it done that doesn't hand the logic off to the build system is an unmaintainable error prone mess.
Looks really nice, pity it doesn't seem to feature accented letters yet
If people like fonts like that, it's great that it's available, but it's not for me any more.

My vision isn't even bad and I don't require glasses, but I have turned 40 and I want retina monitors and a 18pt font.
The journey begins with a single step: climb the freedom ladder
Expressive Animator: free software vector animation and motion graphics editor
I don't understand which "DSLs" the author is arguing about.

Also, as other have said, the author's definition of "distributed system" (here, basically a "multithreaded" , concurrent system) seems to clash with the conventional definition (a system that has to involve multiple _computers_)

It is true that there is some overlap (having concurrency forces you to handle "some" of the problems with functional part of your program not being collocated on the same stack, you kinda have to introduce callbacks / promise / futures / actors / etc...)

But the moment you really have different programs o two machines (or , worse, two replicas of the same peogram on two machines), then I don't see how the single program would work / help.

Unless, of course, the "single program" is meant to be run as "one of the replica of the full system" ? Then I would love to hear the author's strategy for handling sharing info and workload between the replicas.
Agreed, that would solve my aesthetic concerns and kinda solve OP's XY problem with JSON.

But the performance of auto-created tables for every union member would kinda suck if you never take advantage of the relation and still pay the cost. You'd also have to auto-create indexes so that queries that read full objects is as fast (IOPS) as storing BLOBs.

I was imagining a future database that takes this a step further and lets you define named parameterized queries next to your tables and chooses the best implementation of unions based on your queries. That's what I meant by "without thinking about it". We already do this for algorithms (query optimizer), and I'd love to see it work with data structures
I don't know if it does depend. If you have low margins, but do a ton of volume in any industry, you should be able to generate more money by retaining good shipping ppl. That has a ceiling where competition won't pay more, or the business can't realistically afford you for some reason, but at that point you should probably move to where you can generate more with the same time, supposing that other factors aren't more important than the gain in $
The coupon code is a slap in the face (2013)
as it walking using surface tension it is somewhat like a space worker using magnet boots.
So its crap because you don't like it? What an odd position to take.
It's a extremely crass act so I'd say that crass phrasing is apt.
Thank you for updating us with the outcome.

https://www.paycheckrecords.me/
Which is frankly a good thing. You wouldn’t want to share the exact questions for a driving license before the test either, would you?
Send me 1 million and I will send you back 3 in two weeks.
No bamboozle.
"cargo update" will update the packages along with Cargo.lock content. As for not updating them without a manual trigger, I consider it a feature, but I guess it's a matter of opinion.
And? Using compiler extensions apparently doesn't bother C developers.
My fav is anything with Seth Lloyd. He is straight out of central casting for a MIT professor.

So great, so nerdy, so interesting.