skysight-inc/HackerNews huggingface dataset:
Lars here, co-founder of a start-up that specializes in optimizing Amazon Redshift performance. We work with a lot of Fivetran customers who we help maximize their load speeds.

My hunch is that your data science team can solve both issues by using the Workload Management (WLM) feature in Redshift.

Redshift operates in a queueing model. As a user, you can define queues for your different workloads, and then assign them a specific concurrency / memory configuration. The default configuration for Redshift is one queue with a concurrency of 5. If you run more than 5 concurrent queries, then your queries wait in the queue. That's when the "takes too long" goes into effect.

The available amount of memory is distributed evenly across each concurrency slot. Say that you have a total of 1GB, then with a default configuration, each of the 5 concurrency slot gets 200MB memory. If you run a query that needs more than 200MB, then it falls back to disk. Disk-based queries are really bad for the cluster, because they consume a lot of I/O which slows down the entire cluster, not just a specific queue.

You can fix both by configuring Redshift specific to your workloads. As a general set-up, we recommend defining 4 queues (load, transform, ad_hoc, catch_all) to isolate your workloads from each other.

-------------

1) data loading takes too long

Create a dedicated "load" queue in the WLM that is only responsible for loading data into Redshift. These are all COPY statements. By separating your data loads from everything else, you make sure that your data loads are protected from e.g. some big ad-hoc queries that some not-so-skilled SQL user writes. The next trick is to figure out how many concurrent slots you need for all your loads.

2) queries frequently overflow to disk

I assume this is true for some large aggregations / roll-ups you're running, or some massive ad-hoc queries. By giving them their own queue, with sufficient memory, you start eliminating the volume of disk-based queries.

--------

The problem is that it's not straightforward to figure out how to set the right concurrent / memory configuration. The information is hidden in the log files (which Redshift deletes on a rolling basis), and sifting through those log files requires writing really complex queries. That just put more load on the cluster...

However, if you do get it right, you can run blazing fast data loads and queries.

We struggled with this problem ourselves at our previous company, and so with https://www.intermix.io we built a service to solve that problem. If you ping me at lars at intermix dot io - I can give you an extended free trial.

I'll pay you dinner (in SF, or maybe in Vegas at Reinvent), if we can't solve both issues for you. How is that?
Bill Gates denies making that 640K statement, and there's no clear evidence he ever said it:

https://quoteinvestigator.com/2011/09/08/640k-enough/

There's also no clear evidence that Thomas Watson ever made the world market for five computers statement:

https://en.wikipedia.org/wiki/Thomas_J._Watson#Famous_attrib...
Dolphin Emulator (Alpha) APK Latest Download Free for Android – Android APK's
> Scientists were widely confident about the correctness of Newton's 2nd law and the universal law of gravitation up till the late 1800s/early 1900s. Then Einstein showed their limitations/incorrectness.

While Einstein revised them, the Newtonian equations are correct enough that they are still generally used for all kinds of things.

If that the best example you can use to make the argument that the current scientific consensus could be wide off the mark, you've done more to refute your argument than advance it.
Pass using opposing lane: 422

This disturbs me, given that this is illegal everywhere but Residence Districts (except in the rare cases where the lane divider specifically allows it, like the #2 image... but they proceeded to drive over the hashed markings indicating a solid barrier anyway, which is seriously illegal), and I can't imagine that a very high percentage of meaningful test driving would be in Residence Districts (given that there isn't much difference between driving in SF RDs vs. RDs elsewhere in the Bay Area.
How to Rip Blu-Ray Movies to SBS 3D Videos
They are. Just a lot more racist due to the (perceived) anonymity.
Here's a working example: https://github.com/noprompt/garden
Keep up on the good work
Domain+email box (looking for cheap solution)
Hello,

I want to acquire a domain TLD (be it any,com net,etc) together
with an email address, this address can be forwarded and /
or accommodation with email box ..
(i dont need http hosting)
but I'm looking for a extremely cheap solution
(priceless), can someone tell me the best service / site for this solution?

-domain(cheapest TLD)

-email address with option for forwarding and mailbox

thanks.
Google Clips Wireless Smart Camera that takes photos automatically
First you have to make the case that it's actually a problem. Test scores didn't go up. So what? Is it actually a problem if the scores just stay the same? I mean, they can only get so high before you have to start screwing with the test to get different results. Why not just accept that the same scores year-over-year mean we're pretty much doing fine?
Did they carve out just your house, or some group of houses?
More helpful than the percentage of scientists who think it's true (a bizarre metric in science) would be the confidence they place on that conclusion. It can't be exactly 100%. Showing causation is notoriously hard, especially when you can only look at historical data, and even more so when there's only one example (one case of humans causing global warming).
Legally speaking you are not allowed to run one
People have been proposing some of these for a long time (nearly 400 years)

https://en.wikipedia.org/wiki/Irony_punctuation#Irony_mark
Congrats. You poked a hole in the meta-consensus, proving the point.

You ignore the others, that dogma leads to shallow thinking.

All the world is the blend of chaos and order; acceptance and rejection, yin and yang. Your contribution helps drive the analytical consideration of acceptance or rejection.
Only if you know about it prior to installation. Opt-out is simply never acceptable and it should be considered spyware until it's fixed. I can't believe there are so many apologists for this sort of behavior.

All that's missing is hiding the information in a basement, without stairs and a sign saying "beware of the tiger".
Is running dev tools (compilers etc) on production servers a thing? I have always built on my machine (or build server) and then deployed to production.
How to Have a Better Relationship
> There is no real way to enforce it, nor any penalities

Sure there is. Break the rules and you get Permabanned!

> What if you share with a friend who works for a newspaper? Or someone who works with a blogger.

Permabanned!

> Insert other weird edge case here....

Again, Permabanned! No exceptions.

Don't think its fair? Well I don't care. It is their site, they don't have to be fair.

Don't want to lose access to the hip neighborhood social network? Then don't break go around making things public that were supposed to be private. Don't toe the line with weird edge cases either.

Yeah, sure, you could go all secret agent and take all the precautions and not get caught, or try and get around onerous multi-account protections that they have in place. But that sounds like a lot of work that most people aren't going to do. People are lazy, and you don't have to catch 100% of everybody in order to make people afraid enough so that they mostly follow the rules.
My first reaction was "if you're really worried about accidental/malicious exfiltration I'm sure you're running your servers WITHOUT unfiltered outbound access to the internet, RIGHT?"
And who is making the lithography equipment for TSMC for its "3nm" Fab? I guess ASML?
my bad i just zero'ed in on the AI comment
Heads up that many charter schools are public. Rocketship (mentioned in the article) is a network of public charter schools that serves primarily low income students, and that's true of many charter schools in the state and across the country.
What you and Mz both pointed out makes the article's headline (rather shamelessly) misleading, so I replaced it with language from the subtitle.

Edit: I also turned off flags on the article, assuming that people were mostly flagging the (rather shamelessly) misleading title.
Wait, so the ethics of journalism require accepting TOS/EULAs? If that's the case, then quite a lot of very important investigative journalism in the past few decades is ruled invalid! (despite the touch of sarcasm, I'm also genuinely curious)
And banning people for minor slights isn't corrosive?
I haven't experienced it, but I've heard the same of other neighborhoods in San Francisco.
It's not that a certain percentage of people are stupid. It's that no matter how intelligent people are, they are very inconsistent about what they apply their intelligence to and there's always going to be some super intelligent idiot who doesn't have his head in the game and fucks shit up for everyone else because he wasn't paying attention to the right things.
account 17 minutes ago. nice.

Hover: https://www.hover.com/email -- $5/year for email forwarding.

Freenom: http://www.freenom.com/en/index.html?lang=en has free domains.
Is racial profiling actually considered racism?

I thought it was its own category because it's not a form of prejudice, but instead refers to the use of race based statistical reasoning.

I'd rather we keep the line drawn. and not muddy the racist card.

e.g. RacialProfilistDoor is more apt
> I just do not like discrimination based on gender

if you feel that way then maybe don't drop into a conversation women started to tell them their likely misinterpreting situations and need to provide better evidence before you'll take their claims seriously. maybe don't go point-by-point refuting their experiences as conjecture then center discrimination concerns against men. maybe don't engage others who, like you, don't like discrimination based on gender with the opening line:

> People today get upset about fucking everything.
> They aren't going to not take your money because you have no proper affiliation.

There is no fee for the conference I mentioned, nor for most conferences in my field. I feel sorry for anyone in a field where they have to pay just to visit another university and present a paper.

I will have no problem presenting a paper at that conference because, again, people vaguely know of my past affiliation. However, proposals for papers are screened by an editorial board just like journals before the person’s registration is accepted, and it may well be that someone without any affiliation would find themselves unwelcome.
If only Houston produced carbon and the rest of the world were carbon neutral the 4 million residents of the metro area wouldn't be able to raise the temperature of Earth a degree in a millennia at current emissions rates.

This is why Climate Change is hard. Individually nobody is causing that much damage (except maybe Californian cows) but the sum of the parts causes an extraordinary problem.
What MS junk?
It collects redacted usage data for dotnet development commands - e.g. dotnet restore for package management - not run a backdoor on your production servers like the title implies. If you scroll down the thread you'll see that it doesn't even collect arguments you pass to the commands.

If you think that npm or any other tool you use doesn't do the same you are delusional.
this used to be common with txt files and IE's terrible practice of sniffing content. It would see a txt file that contained html and display the html instead, it could then pull in a secret silverlight file that was mascarading as a docx file as they are both simply zip files. Even more amusingly silverlight and docx contents don't clash so it could still be a valid docx file if you opened it, and the txt file would look like txt even though it was really rendering html with a hidden silverlight app.
> I don't think most coding toys actually are mostly aimed at boys ... They're just marketed to boys ...

Aren't "aimed at boys" and "marketed to boys" pretty much the same thing?
That isn't entirely true. How much is it worth to upgrade from a "once every 500 years" system to a "once every 5000 years" system? If it's more than the expected damages...
Why do I care about any of that? I just want to leave a comment on some random blog and maybe read a couple of replies. I have backed out of commenting numerous times because of this nonsense.
Wow. Practice tests are abysmally convoluted and don't even give results feedback.
Samsung Galaxy S8 (Snapdragon) Can Now Be Rooted Without Tripping Knox
One wonders how long 3nm chips will operate. Electromigration becomes a more and more serious problem as features get smaller and you can't afford to lose many atoms from a feature. This is worse for devices that are electrically active doing something; an idle flash drive doesn't suffer from this.

Will it be possible to fab a CPU at this density, or just memory devices? With memory, you can use error correction to compensate for faults. That's hard to do in logic. (Not impossible; it's been done, with CPUs that have self-checking. IBM has done that in their mainframe CPUs.)
Gender reassignment is an statistical anomaly, less than 0.1% of the population.
And it was organically and democratically determined.
Yeah that's definitely a musical symbol.
"Obviously its difficult in many scenarios to grasp the larger context, but if we promoted this definition we would as a society optimise for core ethics and be less apt to being manipulated by a minority."

Doesn't this mean that you already believe that we need to be first manipulated by the minority that holds the definition you advocate, since that definition is not already generally held? And if your definition is generally held you lose your complaint, don't you?

To be fair, I think your point about the importance of correct context is completely valid. I just don't think minority vs. majority is a factor. Failing to think, or not knowing how to think, rationally and independently puts you at the mercy of wrong minority, or majority, opinion.
By central government, I meant for the US the federal government, and in particular the present administration.

My question still stands.
I find that interesting, because I live in South Texas and I don't really see any racist posts in my neighborhood. Mostly it's just people complaining about people's car alarms going off at night and reporting when package thefts occur. It's pretty low traffic, in general, honestly. I maybe look at it once a month and review all the prior threads for the month.
index in bull market, defensive stocks in bear market. threshold on a few global parameters and back testing (mostly volatility)

idea is to preserve capital during extended downturns.

been in the index side since 2015 except for a few months during brexit.
Is there a systemic reason for why they can't or do you mean that only "none of the known bacteria don't" (build sensors)?
People use it; it's real.
I assume NextDoor is doing an AVS check and expecting a match.

The cards you mention fail AVS checks, but with a 'U' code for 'UNAVAILABLE'. Many online sellers will let those sales through. NextDoor likely does not.

You can see some of the possible AVS responses here: https://www.chasepaymentech.com/address_verification_service...
For long-term growth investments, I buy stock in companies that make products that I use and love. i.e. Coca-cola, General Motors, Apple, etc...

For income, I put a portion into high-dividend stocks, and either draw the dividend or trade them away pre-dividend for more than the dividend would have paid... re-buying later after the price drops post-dividend.

For short-term money trades, I look for depressed stocks with what I call rebound-potential... e.g. something like bad news or earnings miss can depress a stock 5-20% depending on the day/mood of the market, I buy and hold some of these I think have a potential rebound in a moderately short-term ( say a week or 2 ), for a modest profit.

The main thing is to stay diversified, and always keep some cash available to buy a potential dip, you cannot have all of your money in 2 or 3 stocks and expect to do well unless you're extremely lucky, and just like in Las Vegas, luck doesn't always go your way. The more and different stocks that you hold, the easier it is to sell a winner, and re-invest that profit in the next.

Also, you need to be able to hold through the short-term market flux, and not sell out of fear... i.e. kim jong shooting fireworks over Japan can shake the market temporarily, you need to be able to hold steady until the market recovers, and even better, buy the dip.
I missed the video, and it was sort of a borderline call to begin with since the older article lacks the current context. So maybe I would have left it had I seen that. On the other hand, IIRC what they did with the text was flat-out blogspam, i.e. cribbed completely from the other source, and it kinda galls me to reward that.
In my eyes, standardized tests are bad because they will always shine a bright light on differences between groups.

We don't like to admit it these days, but humans are not identical. We can accept some basic differences, such as skin tone. We get extremely uncomfortable extending that notion to cognitive skills. To be clear, I'm not singling out any group -- I'm not linking skin tone to cognitive skill in any way.

So, we bring in standardized tests to level the playing field. At first, those tests are deeply flawed and filled with bias, making them especially harmful.

Then, we iterate, and remove those testing flaws. And we trick ourselves into thinking that will solve the problem.

But, suppose we arrive at the perfectly fair test. Suppose the test is highly predictive of, say, success at a 4 year college.

Now, what do you do if that test habitually ranks some group lower than other groups? To me, it feels like we are right back at square one.

Personally, I would prefer to focus our energy on helping each other out. If one person, or group, is falling behind, you find a way to help, and also to integrate each group into the whole.

I know I'm oversimplifying -- I just think standardized testing is a fruitless exercise.
TL;DR be an african 30 something male with a PhD and start a business in telecom
No way: you can just kill -9 it from another terminal.
CSV is a pretty poor format in that it mixes the presentation and the underlying values. There is no standard for dates (dd/mm/yyyy or mm/dd/yyyy ?). The "standard" RFC4180 is extremely vague when discussing value interpretation. As proprietary as XLSX is, at least the Excel format separates the raw values from the presentation.
Atomic radius of Silicon atom is 0.11nm, which results in width of about 0.22nm. So even tightly packing atoms will make the barrier only ~13 atoms thick.
Van der Waals radius is about twice that, resulting in 7-atom-wide barrier. Quantum tunneling [0] is apparent at 3nm, and gets worse from there, so I don't see how they would be preventing electrons leaking through the barrier, unless "3nm Fab" would have a shovel of marketing salt to boot.

[0] https://en.m.wikipedia.org/wiki/Quantum_tunnelling
It could be worse. When you sell a PDF ticket on Stubhub, they actually send your original PDF to the buyer with your full name still on it! This has always been the case and continues to this day.
Came here to say the same. Also tested it to confirm and the single quote mark inside the double quotes does indeed force interpretation as a string instead of a formula. In both Excel and Google Sheets.

Interestingly, in Excel removing the quotes entirely also causes a formula to be interpreted as a formula and text (even with spaces) as text and numbers as numbers.

In my testing, quotes are only needed when a field contains a comma to prevent it being interpreted as a delimiter.
I'm sure this recently discussed on HN.
Did you spend time thinking about me? I like that.
Yet another crypto-miner for the web
A couple of these reminded me of musical symbols I'd see on staffs and so they were already associated with something in my mind and couldn't be re-associated with whatever the authors wanted.

Aw hell, I'll just mark up my text with a bunch of musical punctuation. Throw pianos and fortes all over everything.
Well, there are problems with that approach too.

At the far end, any programming logic you put in the DB will be impossible to scale if needed. You can only have one DB, but any number of Rails servers.

Database constraints are a matter of preference and skill set. They make some things much harder when you have to delete things is certain convoluted orders, and I can get the correctness through tests. Your decisions may differ. That's fine.

You should always put indexes on things you query by. Be vigilant. This is the one case where "only optimize when you have a performance problem" rule doesn't apply.
Fear mongering, it's relatively benign telemetry. Also needs (2016).
That's the way to do it, use a build server, deploy with something like Octopus to production.
So many people fall in love with this idea. I just can't believe it.
Remote code execution on rubygems.org
Does anybody have a year for it? I went with 2009 via https://web.archive.org/web/20090601000000*/http://www.zoon.... but it feels like it might be older, especially as the author had been dead for 9 years.

Edit: a comment (now deleted) helpfully pointed out the Whole Earth Review, Spring 1987 reference at the bottom. Thanks!

Previously: https://hn.algolia.com/?query=Basic%20Laws%20of%20Human%20St.... Interesting annotation by pg at https://news.ycombinator.com/item?id=817703.

Url changed from http://harmful.cat-v.org/people/basic-laws-of-human-stupidit..., which points to this.
So wrong.

I thought this thinking was 10 years dead at this point.
MS really doesn't understand why people don't like their products. And that's a bit bonkers. People get paid lots of money to think about that problem everyday, and they still can't figure it out.

Nobody trusts you. They don't trust your vision. They don't trust your commitment. They don't trust your ability. They don't trust your execution. And they don't trust your intentions.

no one trusts Microsoft. Well maybe some people do, but how's that working out for you?
SNES Classic Hacked to Play More Games, Add a Very Welcome Feature
> If one person, or group, is falling behind, you find a way to help.

And how do you know if a person or group is falling behind? To do this, you need some type of metric; and standardized testing is the best metric we have at scale.
Yes, that is correct. Not sure what triggered this renewal of the campaign on the part of the opposition. Maybe this post on today's Microsoft discussion (re: Windows Phone abandoned)? https://news.ycombinator.com/item?id=15434859

Microsoft/.Net Foundation added telemetry to the dotnet command line last year | https://news.ycombinator.com/item?id=14836737 (Jul 2017)
How can someone seriously propose I put a copyrighted symbol in my text to let them know it's sarcastic? [rhetorical question device] I'll bet the world will be a better place if they profit off every sarcastic sentence someone writes. [sarcastic sentence device] If you're too dumb to work out what's sarcastic, why should you benefit from my help? [friendly period]

(nb. There's a missing "sarcastic sentence device", but I don't know where to put it, when it applies to a piece of punctuation.)
Yes. But that doesn't make it less of a joke.