skysight-inc/HackerNews huggingface dataset:
You should try to understand how databases in general work, it will help you with your query writing.

One thing you have to realize is that once you get a little advanced, you have to get to the details of the single SQL implementations, it's not about SQL but about Postgres.

I've found these books really valuable

# SQL Performance Explained Everything Developers Need to Know about SQL Performance

https://www.amazon.com/Performance-Explained-Everything-Deve...

This book fundamentally talks about how to effectively use and leverage the SQL indices. Talks about all the important implementations (Postgres, MySQL, Oracle, SQL Server).

# Designing Data-Intensive Applications: The Big Ideas Behind Reliable, Scalable, and Maintainable Systems

https://www.amazon.com/Designing-Data-Intensive-Applications...

This book gets mentioned a bunch around here and for a good reason. There aren't too many concrete resources on making your systems "webscale" and this one is really good.

# PostgreSQL 9.0 High Performance

https://www.amazon.com/PostgreSQL-High-Performance-Gregory-S...

Discusses all the different settings and tweaks you can do in Postgres. It's crazy how much of a perf gain you can get just by twiddling the parameters of the database, i.e. all the tricks you can do when the single instances are bottle necks.

There's a similar book for MySQL https://www.amazon.com/High-Performance-MySQL-Optimization-R...

# PostgreSQL 9 High Availability Cookbook

https://www.amazon.com/PostgreSQL-9-High-Availability-Cookbo...

Discusses how do you go from 1 Postgres instance to 1+ instance. Talks about replication, monitoring, cluster management, avoiding downtime etc i.e. all the tricks you can do to manage multiple instances. Again there's a similar book for MySQL https://www.amazon.com/MySQL-High-Availability-Building-Cent...

Last but not least check out the postgres documentation, people consider it a standard of what good documentation looks like https://www.postgresql.org/docs/9.6/static/index.html

Also last but not least, read up on relational algebra (the foundation of SQL) https://en.wikipedia.org/wiki/Relational_algebra. I've always found SQL to be extremely verbose (the syntax reminds me of idk COBOL or smth) but there's another query language called Datalog, that's for our purposes similar to SQL but the syntax is much more legible.

E.g. check out these snippets from these slides (page 29) (and check out the whole class too)

https://pages.iai.uni-bonn.de/manthey_rainer/IIS_1617/IIS201...

Datalog:

s(X) <- p(X,Y).

s(X) <- r(Y,X).

t(X,Y,Z) <- p(X,Y), r(Y,Z).

w(X) <- s(X), not q(X).

SQL:

CREATE VIEW s AS (SELECT a FROM p)

UNION

(SELECT b FROM r);

CREATE VIEW t AS

SELECT a, b, c

FROM p, r

WHERE p.b = r.a,

CREATE VIEW w AS
(TABLE s)

MINUS
(TABLE q);
I'm sure this is a great resource for those starting or just switching to ST3, but I wonder how the value holds up for those who have been using this editor for awhile now. Can anyone share their experience?
I cannot confirm that. I found the tax agreements within the EU to be relatively easy in the EU & UK. Of course you deal with two authorities, so there is an additional benefit, but recognizing taxes paid in the UK with another country was not that hard.
Such a bug was in an Nvidia driver install script a few years ago:

rm -rf /usr /lib/modules/something/something
Yes. My boyfriend (who is not in tech) was so annoyed that he researched what it was that annoyed him and changed his default search engine to DuckDuckGo as a result.
If there are only a few, a 'shoebox' probably will work because the amount of time spent searching will be approximately equal or less than the amount of time it would take to 'totally' organize them. If there are a lot of receipts, hiring an accountant or a bookkeeper is the way to go...organizing receipts is just part of what they do.
I disagree wholeheartedly, they had a rare chance to rebuild using their acquired knowledge with none of the debt or cruft.

"We have to keep this scene even though it's not quite perfect because otherwise it's a waste of money".

Maybe this is a bad example actually, movie industry is something you launch and market and leave.

But the best architectures I've seen have been demolished, destroyed and rebuilt from the ground up for their purpose.

Same with code.
Ouch, seem to have struck a nerve here. What's with the down votes HN?
The 3DS and Wii U use some WebKit fork; they don't use Presto.

Opera Mini still uses Presto, and there are some TVs which in principle are still supported that use Presto.
Looks like top tax bracket in Sweden is $90k -- at $90k, CA marginal is 42%. So a delta of 14% -- still probably worth it, especially at lower incomes where student loans and health care a higher percentage of earnings.
They basically needed a WW2 Japan in WW1
> all for naught?

I bet you they were suddenly industry experts in source control and data backups.
I have a lot of sympathy for companies trying to make decent email apps. The economics are just awful.
Suspicious that everything has approximately the same number of votes.
I meant that "users perceive it as something XMPP can't do", so it's not a protocol-level issue, as the feature exists, but a branding and compatibility issue. Those, depending on how you define XMPP, are part of XMPP's problem.
What's your theory for a reason that absolves this? Or did I misunderstand your implication?
Hey HN-- I'm the author of this post. Feel free to post questions!

We are a very small team building this app. Hopefully you can focus on what's new/good and not what is left to do! :)

If you find bugs, please post them here: https://github.com/nylas/n1/issues/
They used 256 samples. Isn't that a bit small for machine learning? Especially considering that part of these samples need to be reserved for validation.

(didn't read the paper)
In the end it was all about immigration. Without immigration, people wouldn't have voted against the EU. Other reasons (judges in Luxembourg, EU regulation) are used as placeholders so that others won't think you're xenophobic. But most discussions with Brexit voters sooner or later end up being about immigration (esp. from Eastern Europe).
As a linux neophyte, I once struggled to remember whether the trailing slash on a directory was important. So I typed "rm -rf", and pasted the directory name "schoolwork/project1 " (with a trailing space), but then I waffled and decided to add a trailing slash. So I changed it to "rm -rf schoolwork/project1 /".

That's my theory as to what they did.
If we remember anything from history it should be that we don't remember. :(
ALLPlayer
He doesn't work at StackOverflow anymore.
They have some machine learning projects: https://kevinmontrose.com/2015/01/27/providence-machine-lear...

Also, they do get a lot of comments. You can read about their setup here: http://nickcraver.com/blog/2016/02/17/stack-overflow-the-arc...

http://nickcraver.com/blog/2016/03/29/stack-overflow-the-har...
Wait, so Nylas was free, then it was paid and now it's free again? Did I understand correctly?
$150,000 Innovation Challenges in eHealth
There are several categories:

1. Tools. People who can configure and maintain security products. Firewalls, IPS, SIEMs, Identity and Access Management, key management, email security products.

2. Analysts/Incident response (IR) These are the people who research and diagnose the alerts spewed by the above products. They usually recommend compensating controls for the people above to implement. They work in a SOC either at a big company or an MSSP. This is where knowledge of networking is most valuable.

3. Malware analysis. Considered the elite they reverse engineer code samples, create signatures, and try to determine source and purpose of attackers. Usually work at security vendors.

4. "Researchers" These people look for exploitable bugs in critical (or any) software. They may work for the dark side.

5. And yes there is a need for people who can build teams to do the above. Requires experience in the above.

The one area discipline there is no shortage in is cyber policy. :-)
Thanks for your advice!
Love this idea and also the execution looks well done. Kudo's on the launching customers (how did you land all of those?).

Could this also work as a music curation for in our office? Would save the SONOS battles that can turn ugly pretty quickly.
I really appreciated the fact that one of the ways they ramped up the difficulty was by increasing the required objectives.
Slack is the worse offender on my 2011 MBP. I have to kill it all the time because of runaway resource usage.
But we need the £400mln per week we'd pay for that to fund the NHS! /s
Yes, predicting fuzzy emotional reactions to uncertainty is a lot harder than the analyzing the clear, solid legal and economic changes which are to come.
Video Games Aren't Allowed to Use the “Red Cross” Symbol for Health
Don't give up. It is possible to have a career in physics. It's not the easy path: academia has its many challenges, and software is in it's glory days. But the Universe is still there, and there is still so much to learn.
As has been mentioned on this thread before you posted, those analyses were based on the announced policy that article 50 would be triggered immediately. It wasn't. Long term Brexit is absolutely going to be disastrous for the UK economy, unless parliament can get us on to a soft-brexit EEA membership track.

The tragedy is that the British economy was going well through the beginning of 2016 and after a bumpy road immediately after the vote that momentum has held up over the last 6 months. That won't help us if we really do crash out of the EU hard.
Hey, sounds like we worked at the same place! That, or the "wedded to Oracle for life" is a common antipattern. I'd add "shared everything architecture" to the horrors.

Yeah, once you get that deeply entrenched in Oracle, it's almost impossible to get away, and after that experience I vowed never to work at another Oracle shop.
It's hard to convey just how incredibly huge and powerful was the East India Company. For example, they used to donate their used time-served warships to the Royal Navy as an act of charity!

The closest parallel today would probably be something like a merger between Halliburton and Academi, the varied enterprises of which profit hugely from foreign adventurism of their host state and which have autonomous military potential in excess of that of many countries. But even that would fall well short in terms of revenue. Perhaps throw Apple into that mix as well and you'd get close.
> Where you get me arguing about the massive drop in the pound I don't know?

Because, Apple has changed it's prices because of the drop in the pound?

The pound dropped because of Brexit.

You said that Brexit wasn't the cause of the price change.
Practical Deep Learning Part 2 – Integrating Recent Advances and Classic ML
The “Synthetic Sensor Input” Problem in AV Verification
It just says you're out after two years, which will be very interesting if some regional parliament decides to block the deal the EU makes with the UK. And I'm sure there will be a parliament which is unhappy with the deal.
You can apply the same argument to fresh water access. Urbanization is not conducive to individualized sustainability. You either come to terms with that or move out to the sticks and adopt a DIY attitude toward survial.
Show HN: React-Sinatra – React on Sinatra Integration (Server Side Rendering)
I'd disagree, the fairly newish DC we're in is designed for supplying and cooling 20kW/rack. That's enough for 40 or so 1u servers burning ~450 watts.
The Davos Disconnect
So much higher: http://www.xe.com/currencycharts/?from=GBP&to=USD&view=2Y
Tell: Gitlab is down
it seems that gitlab is down.
But there's a difference between a remote island and a full continent with regards to having enough fauna to sustain human populations.

If you can hunt big prey all the way, it's is substantially easier than the places where you have to go by sea.
This is great:
http://sqlbolt.com/

https://lagunita.stanford.edu/courses/DB/SQL/SelfPaced/cours...
https://lagunita.stanford.edu/courses/DB/SQL/SelfPaced/cours...
https://lagunita.stanford.edu/courses/DB/SQL/SelfPaced/cours...
https://lagunita.stanford.edu/courses/DB/SQL/SelfPaced/cours...
https://lagunita.stanford.edu/courses/DB/SQL/SelfPaced/cours...
https://lagunita.stanford.edu/courses/DB/SQL/SelfPaced/cours...
Watch out, hackers can listen to your Facebook Messenger Chats
If I'm remembering correctly, one of the things that made the higher difficulties more difficult was the fact that you were not allowed to kill anyone.
Past: https://news.ycombinator.com/item?id=11770273
20xfaster than what?
The font cache re-runs every time you change your fonts folder.

It's like what you do with `fc-cache`, but on Windows you get per-application caches for apps that uses fontconfig (they carry their own copies of fc). Every time you install a new font or update your system, you have to do a recache for each of these apps.
> it was a key stated pledge of the leave campaign

Which leave campaign? There was a few of them and they didn't give a consistent message. None actually have any power to implement anything so how can they make pledges anyway?

Also, that link has the picture of the bus as the first image... a 'pledge' completely based on lies that was dropped literally minutes after the vote.
I don't think it relates purely to the EU, but to politics in general. I'm all too often hearing quick-fix solutions mouthed by politicians when what's plain to the eye is a profoundly unsexy root-and-branch analysis is necessary.
I made a mistake like this once, I feel most that are really dogmatic about backups have something like this.

A long time ago I had a hard drive fail that had a bitcoin wallet with about 10 bitcoins in it.

At the time it was worth a hundred USD or so. I tried to fix it myself, ended up failing and throwing the drive out.

Right after that bitcoin started its meteoric climb. Every now and then I check the prices, then I go check that my backups are running, that my restores work, that my offsite backup is setup correctly, that every single one of my devices is backed up.

It was a $9,000 life lesson (as of right now...)
He was referring to Jeff's conversation with Nick Craver who does work at StackOverflow.
This is cool but I have to wonder: what's the use case for this?
Idk, it's still best GUI editor in terms of performance, but I don't like it because
of the price and it's not open source(but I can see the price being justifiable).
I used ST2 for some time until I moved to Vim, and after few years of Vim I moved to Emacs.

And I think I've finally achieved what I wanted from the beginning, programmable environment.
Editing speed is not nowhere near close to my proficiency in Vim, but the things that
really make my code better in the end is not faster typing but REPLs, and all those nice
interfaces and plugins (I don't like to call Emacs plugins, plugins, because I believe
they are much more than that, they usually provide you completely new environment
with huge array of possibilities). So in the end I think it always comes down to Vim and Emacs.
You hit the limitations pretty fast with other editors, your needs and technologies you work with
change, so ST3 can be fine for you for some period, or much longer than it did for me, but I think
it is worth at least trying to learn one of those 2 pesky old editors that everybody goes crazy
about. Because people go crazy about them for a reason. ST3, hmm, not so much.
India at the World’s Most and Least Miserable Countries in 2016
I get the point about picking and choosing where to spend your time and where you delegate things to others, but if living within your means expands with your means to that point, it's no wonder you find what's honestly a windfall to not be lofty.

And to take a different track than the anti-materialist route, I would ask you to think about how not taking advantage of that salary to save an amount of money that could be the salary of a few people put together is basically abandoning a ton of leverage to just leave a job or take other risks that would be infeasible to someone who's standard of living closely tracks their salary.

In choosing to buy the degree of things you buy and dismissing the sort of leverage a more "frugal" lifestyle could buy you (quotes because I'm using frugal in terms of still spending 6 figures a year), you're selling freedom of a different sort.

(That said, I don't know enough about you or what you spend your money on or what percentage of your income you're spending outside of what you detailed in your post to suggest you do anything other than think about that angle. I don't mean to suggest anything negative about your character.)
Excel has the annoying habit of outputting localised CSV. What does your CSV look like? This should work:

"A","B"
"a1","b1"
"a2","b2"
In what way? Article 50 can be revoked once triggered:

http://www.independent.co.uk/news/uk/politics/brexit-article...
The article is interesting. It might be better to submit it as a regular link rather than as a question because Hacker News submissions without links are weighted differently and also less likely to be noticed.
Show HN: Friendly-error – Show uncaught errors friendly in Node.js
No one can stab another country in the back by being a tax haven. If a country allows companies to use tax havens, it's up to that county to adjust its laws.
But this is mainly a language issue. If you had a common language, you'd probably have it easy to sue people in other countries as well. And you can sue as a non-Italian without any problems.

The EU will never have the level of integration the US has, simply because there are different languages at play. But that's no fault of EU politicians.
Yes, I play with little robots built with microcomtrollers. For some of our little boards my friends and I make we leave off the LEDs because they consume more battery than the CPU. (Of course the motor makes up for that quickly...)
I've seen a whole company killed by technical debt. Because the software was written so badly far more developers had to be hired to firefight than the company could afford. The technical support team was similarly bloated to deal with the endless problems the customers had. Sales were low due to the bad reputation.

A rewrite was started, but never got anywhere. The company folded under the weight of its massive salary costs.
It's because people of diverse backgrounds need diversity in their community/social life as well. In Texas you have two kinds of diversity: white and Hispanic.
This is definitely a huge problem, especially with socially-competitive charities. Things like breast cancer awareness and helping the local needy around Christmas are so popular that they're locked into ugly advertising struggles. And if people don't do their homework, the most efficient fundraiser will be the charity that spends no money on the cause (or just enough to stay exempt).

This seems like a good time to plug Givewelll. Their entire goal is quantifying the good done by charities and promoting the most efficient. They compare globally, but even if you want to give to something specific like animal welfare or local homelessness, they have some good efficiency tips.

http://www.givewell.org/
Boulderdash! Young students have been able to go to universities all over Europe since ever, when universities were a new thing in the Middle Age Europe, but even before in the Antiquity!
Since I work both on Windows and Linux here are my tools.

IntelliJ as an IDE, mainly Java/Android but I use it too for any other supported language (shell scripts, python, whatever, if there is a plugin I use it), sometimes even for some single files, since I have it open nearly all the time.

Notepad++ for any quick edits on Windows.

vim for quick Linux edits (mostly stuff that needs root)

Edit: Sometimes I need a hex editor, for that i use Bless.
And I'm also pretty sure they reworked their backup and validation tools as well.
Ah, I see. I agree. I think "management" includes lots of quasi-technical roles, in which people and project leadership are the core skills, with one's technical base serving as a platform for managing others with highly focused technical skill sets. Hopefully you are also right that these jobs are increasingly in demand.
There's still a paid version (in fact I think this is a price bump?) - but there's now a free tier too.
Same. Found out about it a couple years ago right after buying some new shoes. Played with some styles for a while, then forgot about it.
Both consoles use NetFront (from Access)
France Tells Office Workers to Stop Printing to Save Power in Big Freeze
They actually work a lot for the people. The reason the EU is often unpopular with businesses is due to laws protecting people (labor laws, customer protection, minimum standards, ...). I'd argue that is politic for the people, just not for businesses.
Authoritarians Distract Rather Than Debate
That was considered but it would of course take some refactoring on the back end, and it would still cost quite much in hardware.
The thing with JSP and JSF is, they do ok as long as your content is relatively static, because then rendered content can be cached.
In case of this company, their most visited page was the list with search results which by its very nature was not very static at all.
Since I'm a long time /fit shitposter and lurker when I read that list of acronyms I laughed a bit, but then it dawned on me "that's a pretty good bunch of definitions, but still it doesn't really truly convey the whole meaning of the words". You actually have to experience those things to completely "get" the meaning of some of those words.

This makes me sad because one of my other hobbies is classical literature and I don't think I will ever properly understand Plato either no matter how well I read the definition of an Attic Greek word or see it appear in 10 different contexts. Something is irretrievably missing and unconveyable. I find the same problem when I try and translate words from my second language to English.
I can verify the claim, but can't point to specific years. That was however not specifically Apple, but merely electronics in general. I used to import hardware parts through an American friend when he came to visit because it was so much cheaper, and I would say it was more than 5 years ago. Now the difference is negligible.
Looks like somebody got tired of paying for PhraseApp http://jmp.sh/HYBObM6

Looks like an interesting project, especially if you don't mind managing the install yourself (vs. paying a company like PhraseApp).
> "The open solution to a faster mobile web would have been so easy: just penalize large and slow web pages, without defining a dedicated mobile specification."

A million times yes. As to why this didn't happen, I feel it would have been too restricted to "merely solving the problem", and not active enough on pushing Google's agenda to tighten its control on the web.

All other things being equal, option A being "efficient & neutral" (just penalize slow pages) is, as a business, inferior to option B "more convoluted but with potentially profitable side-effects" (AMP).

Other takes?

EDIT I should have better read the linked article before posting this, what I'm writing here is close to what the article "Lock In" section says.
This is exactly the kind of thing I was looking for thank you.
An Introduction to AlphaGo Tech Talk
Yeah, maybe if author would charge 7 bucks in total instead of 7 bucks per month he would not have this problem.
There are many many thorny issues to be untangled. It's not as simple as saying "we're leaving"; Britain's membership in the EU is a complex thing that's going to take a lot of work to dissolve. The Article 50 negotiations are about those issues, not a future trade deal.

If you just walk away, you leave a mountain of chaos that would have to be handled in courts.
Nylas has a keymaps.json (as well as the UI of course) which is a +1 in my book. Unfortunately other things missing from textual config, such as mail rules (filters).