skysight-inc/HackerNews huggingface dataset:
On this topic, here's a great reference for some common operations on high volume SQL databases:

https://www.braintreepayments.com/blog/safe-operations-for-h...

Has anyone been collating large-scale SQL best practices into a book or similar? I've found high-level overviews such as this https://github.com/donnemartin/system-design-primer, but lacks specifics to scaling SQL...I've only seen disparate blog posts like the one above.
I'm out now but it looks identical. I'll share a screenshot and download link when I'm back! It's my favorite.
The Terrifying Power of Internet Censors
> We now require declaring a license when requesting a download:
> https://caddyserver.com/download/<os>/<arch>?license=persona...
> The value for the license variable can be either personal or commercial.
> …
> We require the license parameter because we feel it's important for the license to be deliberate, not assumed. To ease the transition into this, though, we'll allow the current syntax (no license parameter) to work for at least 30 more days, and a personal license will be assumed.

I think this warning should be more prominent. Lot's of CI builds would mysteriously fail after 30+ days.
May be if the sandwich was going to be consumed by one person. But this "sandwich" will be read by thousands. Well worth the effort of three reviewers.
I open multi-GB files often enough in VIM. Just make sure that you've disabled any plugins, as _those_ will often crush under large files. The `-u NONE` option will disable `.vimrc` and thus all plugins as well.

See relevant discussion on Stack Exchange:
https://unix.stackexchange.com/questions/139254/why-cant-vim...
Firebird 4.0 Alpha 1 release is available for testing
Copied comment from the other HN thread:

$50 dollars a MONTH PER INSTANCE for a piece of software that wouldn't even start a few months ago because LetsEncrypt was down.

I get that software takes time and people need to eat, but holy shit on a stick.

Edit: Oh, and I forgot the part where it also doesn't handle FQDN's properly either.

Previous discussion, from when LE was down for a day https://news.ycombinator.com/item?id=14375022
Is there an option to print yet?
What else, government provided email hosting?
Looks to me like wire transfers are about to go away with the launch of services like Zelle. The banks clearly understand that if they don't lower fees on bank-to-bank transfers they are likely to be disinter-mediated.
Yeah, I have a bunch of side projects that collectively make ~$2/mo. Good thing I didn't replace nginx with Caddy on that server.
Sad part is that I'm not even pro-Erdogan. I vocally disagree and vote against most of his policies/approach etc. But people on this thread want to see a black and white picture conforming to their distorted vision and can't tolerate the reality as it has occurred. Sad.

EDIT: here's the flagged comment:

Downloading the app wasn't the only reason they are under arrest. The app mentioned isn't available to anyone, but could only be used if you were endorsed by 2 members of the US-based cleric Fethullah organization. It's only "one" of the reasons people are under arrest. Most of their logs of conversation, and with whom they spoke is the main reason why they are under suspicion.

The app was used extensively during the military coup attempt, executed by the members of the Fethullah organization - which killed around 250 and wounded 2000-3000 civilians during last years military coup attempt.

Read Sedat Ergin articles on hurriyet.com.tr if you truly want to get informed about the court case against the military coup attempt. He is a well respected investigative journalist (definitely not pro-Erdogan).

[1] http://www.hurriyet.com.tr/yazarlar/sedat-ergin/darbe-sanikl...
That's the key distinction between a democracy and a republic. In a republic, we expect our elected officials to be smarter than we are about how to spend money.
> Seeking a congregation without seeking Him first is a act of futility...

I also see the problem where people become "spiritual" without seeing the need to find a place to belong. Inevitably, when they are their own chief theologian, high priest, counselor, and source of accountability, they have difficulties and make a variety of mistakes.

I suspect a lot of the people "losing their religion" in recent decades fall into that category in one way or another. I'm not sure what the label "Catholic" means if you never engage as a Catholic. It becomes a tribal marker, but we have plenty of those in political parties, brand affiliations, nationalist (or cosmopolitan) sentiments, etc.
Chris-brown-to-my-bed-lyrics-video-clip
Use a company car, and company pay for gas. You can deduct that as expense.

Company phone. Company pays your data plan. Deduct.

You register your company at home, okay you can make an office, you can then deduct some expense as facility operational costs. (Of course there are a lot of regulations for this, and you have to document how big the office is, and it can't be bigger than X% of the house, otherwise it'd be income tax hiding - because it'd be the company paying your rent or just giving you money to heat your bedroom, which is not a business expense.)

Company sends you overseas on work? Business expense. But if you go there for 2 weeks and then post beach photos on Facebook for every day, you're in big trouble.
lol at this guy putting a tip jar at the bottom of the post
Did you know that there are rich distributions that have done that for you? You can literally install those with a few simple steps and have fully functional super environment.

Key words for Google search: Emacs Prelude, or Spacemacs
Editor no, IDE yes.

I'd be able to function without intellij ultimate but it would be incredibly painful and I'd permanently be slower.
Adam Johnson, serverless monitoring and the NoOps myth
I use Sublime mostly for large files and it's awesomly quick and useful search. I've switched to VSCode for most other tasks however.
A free CDN for npm packages
To be clear, the DOCTOR/NURSE example is an example of "semantic priming" as mentioned near the end of the blog comment. There's decent experimental evidence for semantic priming.

The "priming" that's mostly being discussed in the comment and blog post it's replying to, on the other hand, is macro-behavioral priming, for lack of a better term: priming significantly affecting complex physical or social behaviors. Things like "seeing old-age-related words makes you walk slower" or "holding a hot vs cold beverage for a few seconds before an interview radically changes your opinion of the interviewer". The evidence here is... well, that's a lot of what the non-replicability fuss is about.
I'm glad someone referenced the classic AI of a PacMan Ghost ;) Id's Doom from the early 1990s is another deceptively simple yet surprisingly engaging instance:

http://doom.wikia.com/wiki/Monster_behavior

An agent's set of possible actions is conditioned on its environment, other NPCs as well as the players actions. Even for a finite number of variables you can quickly see how the problem becomes computationally expensive for a single agent.

You want to to build unsharded persistent worlds with complex character behaviours and allow millions of online simultaneous players all sharing the same game state? Then you need to take a page from architects building scalable cloud computing infrastructure and applications that serve billions of request per second with low latency.

Companies like improbable.io are abstracting game state and logic with SpatialOS. But I think there is still a lot of room here for some startup to combine "Unreal Engine + AWS". Creating a true "cloud native game engine". Even if its just HTML5 based and targeting games such as Slither.io.

Quest - An iOS "io" Game from Improbable

https://improbable.io/games/blog/quest-an-ios-io-game-from-i...
Other thread got duped...reposting here:

It seems that his staff feel ambivalent about his comments:

JPM Blockchain Lead: "¯\_(ツ)_/¯"

https://twitter.com/AmberBaldet/status/907675559492288512

Former JPM Director of Global Macro: "Jamie, you're a great boss and the GOAT bank CEO. You're not a trader or tech entrepreneur. Please, STFU about trading $BTC."

https://twitter.com/agurevich23/status/907692985424371712

Got these sources from Fortune's Term Sheet:

http://fortune.com/tag/term-sheet/
Because he is not replying to GP, he is replying to the parent:

> Every Apple device, from Macbooks to iPads to iPhones to Airpods is built to be a personal device. (...) Apple doesn’t want to sell one shared device to a family. They want to sell multiple devices to every family member.

Not sure why people are having problem understanding that.
if I am reading things right the radeon vega 56 is always faster (sometimes significantly more, like in koro) than an nvidia 1080 for rendering, that is quite surprising.
Sublime, vim and emacs are three different animals. It does pay to know the basics of the latter two, especially if you expect to have to edit files from the console and/or find yourself using a random UNIX environment (which most likely will not have Sublime installed on it).
Because if you are a contractor then it's your responsibility to provide healthcare for yourself and think of the costs of that and factor that into your prices.

But if you don't set your prices, because you're a one-of-a-million driver, then you're shit out of luck.
Emoji fans take heart: Scientists pinpoint 27 states of emotion
I used to think that, until I discovered the IDEA suite (PyCharm, PHPStorm, etc). And many devs use Windows as well. The OS is no less important than the text editor.

I still use VIM often enough to stay proficient with it, mostly via SSH, but I'll happily use the closed source IDEA editors when they are available.
That's like something out of SV (HBO's show).
Being good at cooking makes it hard not to be a buzzkill sometimes at restaurants. My friends will be all excitedly praising a place and I'm just sitting there mad about how much I paid for something I could have done better myself.
I think the headers are there so they can see if commercial sites are using the personal version and get them to pony up.
> Why's that? (And even among your technical visitors, how many of them actually inspect the response headers?)

I dislike this for a few reasons. Firstly, it honestly comes across as petty. I'm using the server for personal reasons, it's for a non-commercial site which I don't make money off. I don't display ads, and suddenly I'm now being forced to serve ads to my visitors. The medium of delivery is utterly irrelevant to me.

Secondly, it makes it more difficult to take steps to make it less obvious which web server is being used. I'd do this to make it slightly more difficult for script kiddies looking to exploit recent vulnerabiltiies - not because I think security through obscurity is a good idea.

> It's good to know that price isn't the bottleneck, then. Does it make any difference to know that commercially-licensed Caddy builds don't have that header?

No. The point is, you've annoyed someone who liked your software, used it for personal use (costing you nothing) and would've happily recommended it to colleagues.
It involves adding an import, and the plugin registers itself. Extension/plugin/addon -- call them what you will, I guess. We chose the term "plugin" before Go 1.8 had its experimental plugin package that, on Linux, allows dynamic linking of libraries. (There are a lot of limitations with that, for now.) In Caddy, all plugins are statically linked and compiled in.
What's wrong with that? Atom aims to compete with Sublime and there's nothing wrong with a review comparing the two.
There's also the new Sublime Six which is very promising: http://www.sublimesix.com
No, it wasn't. I believe TextMate had a feature where you could edit multiple lines at once, but it was part of a column selection mode, it certainly wasn't free form multiple selections.

Multiple Selections were one of the earliest core features built for Sublime Text, and weren't inspired from other software. I don't think TextMate existed when I implemented this.
> Do you actually believe this or are you just saying something striking to illustrate an underlying principle?

It’s where I get if I’m thinking about moral justice instead of incentives/the economy. I’m not saying my proposal is workable. It’s just my observation that the last decade has been a tale of two cities for millenials. My friends who are “good at math” have been living in a different economy from everyone else.
I concur with this. I'm appreciative of Atom -- and recommend it to folks who aren't professional programmers and can't imagine paying for a text editor -- and I've heard similar great things about VS Code, but ST and its ecosystem has just been so dependable for me. It was inconvenient to switch over from TextMate to ST initially, but ended up being a great move overall. I haven't yet seen anything on the horizon that would seem like the next phase from ST for me.
Its available in Lineage OS for mobile as well.
To your first paragraph: Take another issue, like marijuana or alcohol prohibition. I don't have to personally be into those to say that it's not a legitimate role of government to tell me whether I can use them. Also here, you can find that some will die every year because of them, and make the same argument you made: that government should jump ahead and not allow it. If they dont, then they aren't protecting society, so your argument goes.

Unfortunately here it's clear that life is far from perfect, but the moral question to ask is how can we make the best of it for all people? Should we ban everything because a few die: cars, sugar--what about swimming pools? Back flips? You see, I don't think this argument you made logically leads us to a very good world. Government can't protect us from everything. At some point we have to rely on faith in humanity. Not to mention with every power handed over from the people is given into the hands of government's propensity for corruption...

So while I don't approve of every group that will use free speech same as I dont use marijuana or have a swimming pool, but I don't think it's a legitimate role of government to regulate any of that.

In other words, I think more people will suffer w/o free speech than w/ it, but no solution will be perfect.

Ok, however your second paragrapah is really concerning me.
What are the key differences between Caddy and Centminmod? I would like to know the comparative speeds, use cases and disadvantages if any.

Also congrats to you Holt for taking this bold step to sustain development. Quite recently WangGuard became a victim of freebies and the nonreciprocal donation from users. I hope this endeavor pays off
> trump etc

> Hollywood and Silicon Valley which should be bastions of freedom and expression.

It's funny you mention this: anyone who supported "not Her" during the election was silenced and ridiculed at every turn.
GNOME 3.26 Released
I agree. This follows the standard practices of the Republican party: Reduce regulations and lawful protections for the public in order to enrich the already rich.

Look to major mergers occurring now. Look forward to increased cellular bills. Look forward to less reliable wireless. Look forward to more throttling. Look forward to more bandwidth caps.

You will receive no benefit from FCC's position unless you own large shares of the wireless companies.
Not easy for an editor to support. There are much better tools available to print code or reflow plaintext into a .ps or .pdf.

Enscript[1] is my (the?) preferred way and a plugin would be a fine tay to achieve this. Will format code in almost any way you could ever imagine.

1: https://www.gnu.org/software/enscript/
I wasn't really trying to be that much of a smartass. When you read the parent article and a couple of others that have been posted recently dealing with replication problems; it makes you wonder if we have facts to enact sweeping societal change.

When Bill Nye starts calling for burning of the heretics:

http://www.washingtontimes.com/news/2016/apr/14/bill-nye-ope...

I wonder if fact or emotion is guiding us here.

Does a couple of hurricanes prove this? For those with faith it does. Congrats.
> Implying that someone is 'clumsy' is implicitly judging their physical ability.

I'm not sure what point you are trying to make here. If someone has difficulty with fine motor control that's called 'clumsy'. How is that 'judging'?

All I'm saying that if you're constantly dropping your phone that is a problem with you and not the phone. This is as dumb as someone in a wheelchair saying we shouldn't make bicycles anymore because they can't use them.

> Those things usually don't cost hundreds of dollars AND are an everyday item.

So I guess you don't wear glasses ?

> No one said that people shouldn't have phones; just that their cost/risk benefit of phones has convinced them to stick beneath a certain price point.

That's not what was said at all. What I am arguing against is the following statement: "Except it's really easy to accidentally destroy or lose a phone."

They are making a general statement implying that people accidentally destroy or lose their phone all the time, which is simply not true. It may be true for them, but that's not what they are saying.
It's because everyone wants to fit in. Apple is as much a style product as a functional product. It has virtually nothing to do with the underlying OS.
JPMorgan's Dimon says Bitcoin is a fraud that will eventually blow up
The article made me realize I do this frequently. I keep an eye out for serendipity. Encountering new problems often makes me take up an adventure from months or years ago where I learned a new piece of technology or a method that _seemed_ like a dead end at the time, but becomes a stepping stone in hindsight.

A dead end only means you're looking at the wrong direction at _that_ moment.

Always chase the yet unlearned.
Apple sales rep here.

>When I hand my phone to my daughter she should see her apps, my son, his. And when I hand my phone to my wife, she should unlock it and see.... her phone.

Don't be so cheap. Visit the next town square and buy everyone their own iPhone. This isn't a problem with our phones, but with your bank account.
It's discouraging to me that a tool that's excellent, actively developed, and inexpensive still can't get support from professional developers like yourself.
2 great examples I know of:

http://strml.net/
http://verekia.com/

I think the basics will do for most people. I don't think you should spend much time on it and go with the style of the second. A simple list of skills, previous projects, basic mission statement, and method to contact you is all you need to get hired as an employee or contractor. References and your ability to sell yourself over the phone/in the interview is what will seal the deal.

If you are looking to showboat or are in a particular industry that lends itself to showing off skills on the site, there could be a place for a unique website like the first one I linked to.

Play to your strengths. If that's a couple stints at big name companies, discuss those a bit and segue into what you are doing now and looking for.

If it's open source contributions, immediately link to your top projects on GitHub/your profile there.

If it's interactive design, you may wish to have a video demo reel, and perhaps do something creative with the overall site, like the first site I linked to.

Good luck, and above all keep it simple.
A bad, hard to understand one is worse than none at all.
at this point i agree its similar to tulip mania and its going to collapse there is no "ifs" just when it will happen.

that said there is utility in bitcoin mechanism. the value of the mechanism is the questionable part.
It's enough if nobody but the site maintainers will see them, that's what can annoy them into upgrading.
Thanks for building a great editor that just works and is fast enough. It has the lowest barrier to entry and is mostly free due to unlimited trial. 5 years ago, when I started writing code professionally, Sublime made things so easy because I didn't have to learn an IDE to write code.

Many kudos and one day I will definitely buy a LICENSE.
I've been out of the 3D scene for years now. I have never used Blender but have used 3DsMax, Lightwave.

How does Blender compare against contemporary 3D suites? Is it the whole GIMP vs Photoshop non-debate? (I can't stand GIMP BTW)
Considering that if you really dislike it you can apply a different theme in about 10 seconds, probably.

Personally I'm not too big of a fan of the styling there, but it's far from a critical issue.
Emacs with vlf can open very large files by splitting them in chunks. Quiet useful.
To give commercial users an incentive to pay for the open source software they use. Can you name an open source project that does not offer extended features for commercial versions and that sells? Because I can't
Least squares as a generalization of PID controllers
Coming from 'old school' texturing pipeline with hand assembled specular, normal etc. maps to get something akin to realism by just painting with the selected material and having the program automatically fill in the various channels feels amazing. I was not really pushing the program but the workflow enabled by it. If substance works as well that's cool to know.
That just gets the legal guys on the case.
The phone before that, where the camera was flat, is the one where everyone's pictures got foggy after a while. It's because the little lens cover would get scratched over time, since it sat flush. The protrusion is intentional to ensure the outer ring is scratched, instead of the lens cover. That's a feature.
Not surprised to see this kind of article exists; extremely surprised to see it at the top of Hacker News.

>I am not a scientist (in the English sense) and not qualified to comment on the natural scientific experiments carried out for the article I am about to discuss and their results.

That much is _very_ clear.

This entire article is just an unsubstantiated hit-piece, likely written by someone yearning for a return to the misogynistic past and current(which, as I see this kind of absolute drivel gaining traction looks more and more like the trumpish future.)

I want to ask every single one of you reading this and up-voting to look inward and think about the narrative you're promulgating.

What does a child reading this think? What are you _empowering_? Nothing. Just spreading hate, misogyny and outdated/irrelevant gender norms; because you can't cope with strong women and change.

Grow up.
Let me rephrase that.

Major kudos to these guys for enduring distributing their software properly on Linux!
> Inability to understand this is a distinguishing marker of religious persons

On the contrary, Christians just believe everyone trusts many things and thinks many things are true. It's not a question of "whether" you trust and think things, it's a question of "what" you trust and think.

You trust medications from doctors, for example. That's believing medicine will work and that's having faith in a doctor.

When a Christian talks about "faith" or "belief", they're mostly saying they think Christian theology is true and trust it to some degree. Thinking it's false and trusting other things (saving for retirement, the golden rule, "not thinking about it too much is best") is no less of a belief system.

So we can come up with other words for things, I guess, but all this is fundamentally a conversation about what words mean. I think religious people know what atheists mean when they say they have no faith. I don't think it's true that atheists necessarily understand what a theist means by "everyone has a religion".