skysight-inc/HackerNews huggingface dataset:
The code:

WITH dt AS (
SELECT unnest(array[1, 2]) AS n
)
SELECT * FROM dt;

Is more complex than necessary. This produces the same result:

SELECT n FROM unnest(array[1, 2]) n;
┌───┐
│ n │
├───┤
│ 1 │
│ 2 │
└───┘
(2 rows)

I think I see some other opportunities as well.

I know the code is from a section dealing with CTEs, but CTEs aren't needed for every situation including things like using VALUES lists. Most people in the target audience can probably ignore this next point (probably on a newer version of PostgreSQL), but older versions of PostgreSQL would materialize the CTE results prior to processing the main query, which is not immediately obvious.
Microburst Weather Detection for Aviation
If that’s true, then I agree this is a dark pattern.
Small wins like this aren't often the reason for someone switching, but they can absolutely affect customer retention. Removing small frustrations can help to avoid users leaving your product, or be the boost needed to bump someone up to a paid plan.

As a standalone feature there's no significant impact, but changes like these can gradually improve the user experience until they become greater than the sum of their parts.
Tise | Oslo, Norway | Backend + Frontend engineers | Onsite | Full time

Tise is a social marketplace for second hand fashion. Launched in Norway in 2016, in the past five years Tise has become a community of 1.6 million users, with over 100k daily active users in Norway alone.
In 2021 we are focusing on taking leading positions in Sweden, Denmark, and Finland. To do this we need more engineers who thrive when given a lot of autonomy to solve problems.

We are currently looking for both a senior backend (or devops) engineer to join the backend team (currently 4 people), as well as two web and Android developers to join our client teams (currently 2 on each platform). Relocation to the Oslo area is required.

Some of the things the backend team work on

- Turn feature descriptions and designs into full-fledged APIs for our apps
- Extend and improve our search engine, escrow payment solution, and recommendation engine
- Tackle both expected and unexpected scaling needs
- Create internal tools to allow our commerical and marketing teams to work smarter

Technologies

- Backend: Node.js (Typescript), some Django
- Frontend: React, Swift, Kotlin
- Datastores: MongoDB, Postgres, Elasticsearch

We're offering

- Stock options
- Large offices in downtown Oslo
- English as a working language
- A product that is already used by over 100.000 of people every day
- An extremely dedicated team working to promote reuse and quality over fast fashion

Check out https://tise.com/careers
You can also grab a digital coffee with one of us at https://grabacoffee.io/tise/
You are quoting me out of context. In many languages, the term and/or pattern foo(x : int) is a string, if foo : int -> string.
Toptal | React.js Developer | Global | Full-time, Contract (Clients) | Remote

Design your lifestyle as a top freelance developer, with the freedom to work however, wherever, on your terms.

Freelance work is defining the careers of today’s developers in exciting new ways. If you’re passionate about working flexibly with leading Fortune 500 brands and innovative Silicon Valley startups, Toptal could be a great fit for your next career shift.

Toptal is an elite talent network for the world’s top 3% of developers, connecting the best and brightest freelancers with top organizations. Unlike a 9-to-5 job, you’ll choose your own schedule and work from anywhere. Jobs come to you, so you won’t bid for projects against other developers in a race to the bottom. Plus, Toptal takes care of all the overhead, empowering you to focus on successful engagements while getting paid on time, at the rate you decide, every time.

As a freelance developer, you could join an ever-expanding community of experts in over 120 countries, working remotely on the projects that meet your career ambitions.

That’s why the world’s top 3% of developers choose Toptal. React Developers in our elite network share:

3+ years of professional experience

Professional experience with React is required

Experience with system architecture or leading a software team is a strong advantage

Full-time availability is a strong advantage

Project management skills

A keen attention to detail

If you’re interested in becoming part of the Toptal network, take the next step by clicking apply and filling out the short form: https://topt.al/aVcVwn
MVP right here
If the marketing people are only running online ad campaigns, then they often believe they can disregard people running adblockers. For non-online campaigns they use bigger product metrics, I've seen. GA is not always the end-all be-all, but for online ad tracking they use that.

I'm also personally shocked at how FEW people relatively end up using ad blockers. Its a night and day difference
It's basically doing what happened to AMC and GameStop a couple of months ago
I think OP meant that the info coming to the server gets sent directly to GA. IP Address, etc.
> Basically the studios realized that catering to older audiences was not a good long-term strategy.

Or perhaps believed instead of realized, but that conclusion was not necessarily borne out in the data.

Fox News' later success (absolutely dominating cable news both in the demo and out, more or less since its inception) seems to demonstrate that the demise of all of these shows at the same time left a vacuum for a certain type of programming that probably still persists to this day.
Definitely agree age and stage of life is a factor. Which makes me more surprised how I've become so friendly with people at my current company. Our age ranges from early 20s to late 50s, singles, married with kids, etc. Most of us don't even live too close by. The only distinguishing factor I can think of, is as I mentioned, my ex-boss, who really had a knack for bringing people together.
Anecdotally, I use Yahoo Finance daily and Yahoo News (they have decent business stuff sometimes) a couple of times a week.

Yahoo Finance is a great product.
SoK: Decentralized Finance (DeFi)
Toughbyte | Full-time | REMOTE | https://www.toughbyte.com

At Toughbyte, we're building a tech recruitment platform that helps developers find their ideal job. We're bootstrapped, profitable and growing with the biggest startups in Europe such as TransferWise as our clients.

We're now looking for a Ruby developer to join our team of over forty people. No prior work experience required. For more info and to apply go to http://tbyte.co/hn

PS. even if you aren't into Ruby, we may have some other positions for you, so check out our site above
What does write off mean to you? If you lose money the government is not giving you money for that loss.

The vast majority of businesses are small businesses, if they go broke the owner is just as broke as the employees.
Personally I feel requiring vaccinations at workplaces (or schools or public spaces) is a step too far, and violates the fundamental rights humans have to health autonomy (making their own choices for their own bodies) and health privacy. Although these are not protected traits in US law, I feel we should protect them legislatively so people are not discriminated against in the workplace based on health choice or privacy. It also doesn’t make logical sense to coerce people to take an experimental vaccine only approved under EUA if a person is comfortable with the risks. I understand the argument that others that can’t get vaccinated may be at risk, but that slim minority is free to quarantine themselves indefinitely or wear PPE everywhere, instead of forcing others to alter their own bodies to accommodate them.
I don’t see any use cases for it except tax avoidance or illicit transactions, neither of which I have any need for. Why use it for anything else when I have no way to know that it will be worth anything tomorrow? I realize the same could be said for paper money but I have less confidence in Bitcoin.
gut.org invest GmbH i.G. | Frontend - Rails - Hotwire | Berlin and/or remote | Full-Time

We are building a platform that lets people make a financial impact for the common good.

I am looking for a friendly and competent colleague to help me build the product and take on the responsibility for the UI part.

We would like to go with server side rendering on rails and the hotwire framework for the MVP.

Ideal candidate:

* You should be very comfortable writing maintainable CSS and javascript

* You do have an eye for design and building the user facing part is what you like most

* Broad experience and exposure to many different languages and programming concepts is a big plus.

* You care about security

Personal:

* modest enough to listen to crazy ideas

* strong enough to push back against crazy ideas

* Bonus: you’ve worked as a freelancer or ran your own company at some point in your career

* Bonus: you also speak German

Sounds interesting? Send us your CV and links you consider relevant for us (your GitHub profile, websites you worked on, Blogs) to: sventantau@googlemail.com
A University of Iowa Reply-All Email Became Ground Zero for Cancel Culture Wars
FF had tabbed browsing for years before Chrome ever showed up.
Monopoly does NOT mean being the only seller. According to US law, having 50% of the market can be enough.
*any UNIX-like distro

Unfortunately, Windows support is not there yet (or am I wrong?).

I stopped using Linux as my main distro. I was tired of maintaining my OS with the only argument "but I can do whatever I want", and I've been doing that for 10 years (with Debian, Gentoo and even a LFS at some point), no more.

Windows 10 works well. The WSL works well. Docker Desktop works well (unless you use WSL2, then it's CPU/RAM/Disk IO hungry). chocolatey works well.
I've never taken an IQ test and never plan to. I took the SAT, but it has significantly changed over the years; my score today would not be translatable to my score then.

OT, but I really love GlaDOS and hope there's another Portal soon.
Fake sense of urgency on sites, e.g. “10 people are looking at this booking”

Really scummy way to manipulate people via psychology of being left out (FOMO).
Honest question -- why do you need analytics on an open source project like the one referenced? What information could they possibly get from it that matters to what they're doing?

I've used GA once on an open source focused blog, and the information was entirely "interesting" but I didn't get anything useful out of it other than a vague "hey people are visiting" picture that really changed nothing about what I was doing.

Has analytics changed to be more useful? Who cares what countries people are visiting from? I feel like people don't question their need for analytics as much as they should and just automatically do it.
GA's users are being paid with access to a product they find useful.
That's a nice explanation of what's going on. My point remains that I found the syntax confusing though.
Doesn't DRM limit copyright infringement?
firefox definitely had tabbed browsing and private mode before chrome was released.

pretty sure opera had tabbed browsing as well.

i just recall chrome being very minimal, clean and fast when it was first released. plus as kreeben said, Google was pretty revered at the time.
It is because Musk is making claims that are not technically possible, and may never be technically possible. Experts have warned him against making these claims, but he is in contempt of them. So, it is no wonder why people are leaving.

Knowing how Silicon Valley operates, it would be likely that he would copy somebody's groundbreaking research (without giving proper credit) and make a few changes (to commercialize it, with gimmicky features) and have his claim to fame.
> But Amazon is also a marketplace. In that role it acts as a "rentable retail space".

Most brick and mortar retailers also sell space to manufacturers. Product positioning in the store and even on the shelves isnt solely due to UX
what's the definition of "democratic institutions" and what exactly has been dismantled?

I still go stand in line to vote just like I have the last 25 years. The elections results are announced, the winners take office, the losers go home. Same as it ever was.
Yeah, those two phrases look too similar. What happened to good old "login" anyway?
This logic doesn’t follow.

iOS apps that use system controls generally have far better accessibility than web pages do, indeed accessibility is a primary reason for creating a native app.
KeepassXC (and its browser extension KeepassXC-Browser) does this. Not sure why anyone would even consider a different password manager.

(Just don't forget to donate, if you have the means.)
High performing code doesn’t have to be hard to reason about.

You wouldn’t say the plan for a safer building is harder to read.

People excusing their poorly written code as “highly-optimized” is the oldest cop-out we’ve got as programmers.
SEEKING FREELANCER | Remote | Contract
Design your lifestyle as a top freelance developer, with the freedom to work however, wherever, on your terms.

Freelance work is defining the careers of today’s developers in exciting new ways. If you’re passionate about working flexibly with leading Fortune 500 brands and innovative Silicon Valley startups, Toptal could be a great fit for your next career shift.

Toptal is an elite talent network for the world’s top 3% of developers, connecting the best and brightest freelancers with top organizations. Unlike a 9-to-5 job, you’ll choose your own schedule and work from anywhere. Jobs come to you, so you won’t bid for projects against other developers in a race to the bottom. Plus, Toptal takes care of all the overhead, empowering you to focus on successful engagements while getting paid on time, at the rate you decide, every time.

As a freelance developer, you could join an ever-expanding community of experts in over 120 countries, working remotely on the projects that meet your career ambitions.

That’s why the world’s top 3% of developers choose Toptal. React Developers in our elite network share:

3+ years of professional experience

Professional experience with React is required

Experience with system architecture or leading a software team is a strong advantage

Full-time availability is a strong advantage

Project management skills

A keen attention to detail

If you’re interested in becoming part of the Toptal network, take the next step by clicking apply and filling out the short form: https://topt.al/GAcAe3
The people who have jobs in zombie firms are fragilizing their careers. If you are just managing a process, your job will be automated. Your leadership won't hesitate to lay you off. If your firm is protected by intellectual property which isn't respected by China, and your firm doesn't even have the skills to defend its own network, you can't keep your "property". If you train your Asian partners how to work within your regulatory framework, they will just hire a few members of your staff away, then open a competing firm in your own country and completely dominate you. The whole western system is being dismantled, thank you McKinsey & Company.

Why don't people leave? Because they want their buy-out. They want the package that comes from grinding all of those years away at the zombie firm.
Let’s use bold, beautiful hearing aids to celebrate deafness
Only thing inspiring me to code in free time is that I need it or I have motivation for it. I code things that are I am really interested into rather what is a general interesting thing.
A Short Introduction to the History of Catholic Evolutionism
You keep asking the same, What then? which leads me to think we are parting from very different scenarios.

Perhaps the difference comes from you thinking in a limit that applies as per number of products sold, and you could find yourself on that situation of "what then?" the product being on the shelve but you are unable to buy it.

I'm thinking in a scenario where the limit is on the production, similar to what I mention before, the EU controlling vegetable productions.

So you don't get to find the product on the shelve if it's already gone but you'll find some other brand, the ones that are better will be more scarce and more pricy as a consequence.

Now, do I want as a consumer that the best things are also cheap and available?, yes! of course!

But the question is, is that sustainable? and what happens to the market when we have this huge player that outcompete everyone else, and dictate the rules, and they are in a position to set the quality standards, long term we might be free to buy just from them under their own rules. Is that freedom?

I'm really not familiar with those proponents of the 10% market, I was just talking from my common sense, I don't think is crazy to put some limits, and we already have some in some industries, for better or worse.

I'm dropping it here, but thanks for sharing your point of view, I'll read you if you reply, always learning and open to change my opinion.

Cheers!
Question, if I have a CSV file that I'd like to do some quick SQL queries on before moving the results into Pandas. What would be good resource to do this?
Preferably compatible with the rest of the Python-dataframe ecosystem and as simple as pd.read_csv()
Revisionist history... Firefox and loads of niche browsers (MyIE2/Maxthon which I used in the era where IE was sometimes mandatory for site compatibility) had tabbed browsing.
Amazon is pushing people towards Fulfilled by Amazon. It makes sense as a marketplace, providing a more consistent experience. However when they compete in that marketplace, it means they're charging you to get data to outcompete you (via FBA fees). It also means that if they do enter that market, they're double dipping. They're taking away your revenue stream for their own profit, while simultaneously increasing what they charge you because it's harder to get your inventory out of Amazon's warehouses via selling it. They can also almost always outcompete you, because they don't have to pay the marketplace fees (they get the service at cost). They can also use the money they make from marketplace fees to undercut you, selling their competing product at a loss (but net zero after you pay your fees) until you get off the marketplace. Amazon also has a perverse incentive to not sell your goods because they don't have to pay for them, so they're totally okay if they can ensure that no one buys your product.

Costco has to buy the goods they sell. If it's on a shelf, Costco wants it to sell. If they don't want something to sell, they stop buying it/carrying it. They can't make any money by buying a competitor's product and letting it sit in a warehouse.

The incentive structure for Amazon is bad for everyone else. Their ideal profit scenario is to have warehouses full of other companies' stuff that never sells, and to sell an Amazon branded alternative to each consumer with demand. Costco's ideal profit scenario is to never buy third party products and only sell Kirkland goods (assuming demand stays the same). Amazon needs to pick one; they're either a marketplace, where their ideal profit scenario is to sell literally anything they have without preference, or they're a retailer and their ideal profit scenario is like Costco.
Oh totally, I know you :) It's interesting how our perceptions are different though, I think a lot of the "dumb" questions went away since NLL. I wonder if there's a way to quantify this.

So, I think this is the thing: I also think that it was easier to learn lexically, personally. I too was worried that it would make things harder. But, I just don't think that's been demonstrated to be true across most people. It is, however, only my gut-check feeling for what I've seen. I could be wrong.

(And, the borrowcheck documentation is very minimal, and didn't really change with NLL, other than needing to add some println!s to make things not compile again. So it's certainly not because I wrote some amazing docs and explained it in a good way, hehe.)
Free Access to Machine Learning Nanodegree
It is funny that AMP pages could have GA without being penalized.
> Costco and Amazon collect and analyze sales data from the sale of both company and non-company products.

It's similar, although personally I think the relationship between the companies is meaningfully different:

Costco purchases product from manufacturers, and may choose to source product from other manufacturers (including under its own brand name). It uses it's own sales data to make this decision.

Amazon acts as a marketplace for other businesses to list and sell their own products. These businesses are online retailers which use the Amazon platform, and pay Amazon fees for this service. Amazon is then using other retailers sales data in order to inform it's own business.

The difference is with Costco it is their own sales data, while in Amazon it is the sales data of other retailers. It would be an issue if Walmart had access to Costco's sales data and not visa-versa (this would provide Walmart with an unfair competitive advantage). Similarly other smaller online retailers do not get access to Amazon's sales data, but Amazon get's access to the other retailers sales data who use their platform, and will then use this to compete with them.
Looks similar to https://birdeatsbug.com
Save you a click - 1 GB file size limit

which they don't mention anywhere on site, until you try to upload something bigger, how hard is to mention it clearly in advance?
> I have doubts that Waymo will ever get to Level 5 without 3D mapping the entire world

Waymo is not trying to get to L5 at all. They are a strictly L4 technology and their focus is clearly on servicing where the market is, metropolitan cities.

L5 is a pipe dream for anyone; it's a moving target no one can ever reach. It essentially means the car can drive anywhere, in all conditions and without the driver needing to take over at all. So it really means Tesla can't declare FSD as "done" until it works for everyone, everywhere and in every condition. How close do you think they are for that to happen? Does that also mean if it encounters a unique situation and gives up, their L5 claims fall flat? Given their current poor performance [1], they have a long way to go to even let drivers take their hands off the wheel, so I'm not holding my breath here (vision stack or not).

The real end game for self driving is L4 because that's what you can reasonably promise to your users. That it works in a defined, tested area and when required conditions are met. This is why literally every SDC company is L4-only, they never promise L5. Either Tesla is focusing on the wrong problem instead of providing value to its paying customers or they are blatantly misleading customers by promising "L5 by the end of the year" every year.

[1] https://www.youtube.com/watch?v=antLneVlxcs
Holding those names was an investment failure, as was holding the majority of tech names at that point in history. Trading those names, on the other hand could be lucrative. A friend of mine paid cash for his college education and his car by playing Hand, the maker of palm pilots.
There was a vendor we had, they used the free version of a popular screen recorder for ALL their support tasks.

Put in a ticket asking how to do something? They sent you a link to a very slow-moving screencast of going in and turning an option on/off or configuring a setting. No audio!

Their knowledge base articles were just a collection of links to screen recordings! It was so annoying.

Guess what happened when that company shut the free version of their app down...
Or nearly any other field, e.g., mechanical engineering, electrical engineering, chemistry/chemical engineering, nearly any of the sciences involved in the medical field (from pharmacology to psychology to name a few). Even "softer" fields like law and literature have present day geniuses pioneering new ground.

I understand that HackerNews is tech centered, but some times when I read "the best minds of my generation are doing X" I wonder if the commenter can see the flashes of brilliance shining beyond their field or what they know as "tech."