skysight-inc/HackerNews huggingface dataset:
I think my only real complaint about window functions is that you can't access the 'current' row in aggregates and 'filter' conditions. It means very complex look aheads or look behinds aren't really possible.

It would also be great if windows could be function parameters in Postgres. I like to abstract complicated conditionals and calculations into functions, but it falls down if you're operating over a window.
There's been a launch delay, so there are still ~8 minutes to go before launch!
I think that Boeing certainly would say whatever they can to make people buy their stock. Competition is such a sham, and as per usual: nobody is arguing for why cooperation is bad, ya'll just keep spewing that corporate bs.
I had a goodhearted laugh when I clicked on the "phones" page and saw a single phone listed.
You do realize that e.g. in Germany you are indeed liable if your account has been used for fraud? If by that process you participate in money laundering you'll get sued by the state. Sure you'll probably go free, but the burden is on you.
According to this CNN Money calculator you would only need to make $114k here to match a 200k salary on SF. Even less if you didn't want to live downtown. The housing costs are listed at 75% less than SF!

http://money.cnn.com/calculator/pf/cost-of-living/
Regulations in software tend to encourage compliance theater rather than delivering the spirit of their intent in my experience. It isn't that difficult to conform to regulations technically with an awful and careless implementation, and I've seen it happen many times. It is "best effort", in part because it is obscenely onerous or impossible to ensure some properties in a strict sense.

Best practices also drift over time and vary with context. A challenge is that there are very old, very large code bases where as a practical matter will never be modernized because it is tantamount to a rewrite, with all of the bug creation and cost implied.

Robust software is definitely possible today even in languages like C++, but the development process for software that rarely fails isn't that compatible with the popular "fast iteration" development model nor the current computer science skills of most software engineers.
I wonder how much Trump is responsible for Twitter's traffic these days.

I know I had tuned out of it a while ago because Twitter didn't have any content that interests me. Now it's like reality tv for the election
10 most common mistakes shi**y PHP developers do
"It has become taboo to discuss"

I don't think you understand why you were downvoted. You made no effort to tie your comment into the OP. You then state a contrarian opinion as fact "my self-perceived status is low, my testosterone falls off a cliff." And lastly you use hyperbole "an epidemic" to describe your(?) situation which also expresses a lack of empathy for segments of society that really have it bad.

A reason to strive for status and money is because there is glory in it. The harder the struggle the greater the glory. So turn your "not thriving" situation into a personal battle. Let nothing hold you back. Fight brother! :)
WhatsApp raised "outside funding" of $250k from ex-Yahoo employees before publicly launching the app in November 2009. They then got another $8 million in April 2011 from VC firm Sequoia Capital. However, Jan Koum was already talking to Jim Goetz of Sequoia a year prior to that (Spring 2010) and it took several months of negotiation to close the deal. I don't think people would call Whatsapp a "bootstrapped company".

Whatsapp did charge for the iOS App and also a 99 cent subscription but it's not clear if they were break-even or profitable from November 2009 to April 2011. Since they were a private company, I'm not sure if they have ever disclosed their financial details before the 2014 Facebook acquisition.

[1]https://www.crunchbase.com/organization/whatsapp/funding-rou...
They have blood tests for it, and a little bit of googling shows that there are home test kits too (that use saliva and are less accurate):

https://www.amazon.com/Testosterone-Level-Hormone-Balance-Te...
> feel a bit of strain on the whole holding Ctrl+p

others don't seem to like this, but i've found the following global key swaps effective

swap ctrl->alt
LCtrl::LAlt
RCtrl::RAlt

swap capslock->alt
Capslock::Alt

this enables you to hit "ctrl" with your thumb (next to the spacebar), and capslock becomes the new "alt". so no more reaching for that hard to reach LCtrl key with your pinky.
This was my thought exactly.

The most disturbing aspect to this whole deal is the response of the administrators who I assume represent a good deal of the community.

The researches who contributed this project ought to be thanked and rewarded for their participation... not called terrorists.
> It’s always useful to jump back to where you were, as well, which is easily enough done with two backticks, or gi to go to the last place you inserted text. I

And here I was undoing and redoing the entire time.
TalkTalk to Pay Record £400,000 Fine Over 2015 Data Breach
I think you have to try to put yourself in the mind of someone who is receptive to conspiracy theories when replying to people like above.

What you said makes sense, but it is only convincing if you already trust the scientific institutions and believe in reductionism. And that, is unfortunately much less common than we would think.

The guy believes that there are poisons in everyday products, telling them that "damage from an endless assortment of factors cause cells to enter disease states" is not at all a refutation of their belief taken from their point of view. In fact, I expect that it even looks like weasel wording for exactly what they said from their point of view.

I think that on topics like this, it's important to expose the premises, the concrete basic facts much more than the conclusion, the general abstraction.
Yes, I use an Ergodox keyboard. My `-=\ keys are right below my zxcv keys.
Quovo | Manhattan, New York, NY | ONSITE | Back-end Developer (Python, Web Crawling)

We are seeking a skilled Python developer to work on web crawling projects, along with API implementations and other data analytics tasks. If you’ve ever enjoyed feeling like a hacker or data detective, this might be the job for you.

Senior role: http://grnh.se/b0m6d41

Junior role: http://grnh.se/v7qyrc1

www.quovo.com
TalkTalk gets record £400,000 fine for failing to prevent October 2015 attack
Keyboard-monitoring method catches signs of Parkinson’s at home
You mean is it a giant bubble where everyone shares the same liberal views, reinforces each other, and ostracizes any dissenting opinions?
Tech people are lucky enough to have a choice where to work. Cheap rent and low cost of living are not enough to attract talent.. There always has to be a "something cool" on a city to be attractive.
I'm endlessly amused by the attitude people get over websites they like. I'm not sure what your personal argument for forcing twitter to be a utility is, but I'm sure it would make me laugh. Care to let me know?
Great stuff. Sadly, we're still a really far away from Drexler's vision of nanotechnology.
What App can actually save a DNG for me?
Would love to use this on Atom.
Ask HN: 12 hours flight. Best options for offline coding?
Planes and trains are usually a good place for me to focus and I was planning to do some nodejs project but then realise I shouldn't rely on having internet up there so... what's the best/basic things I should preload on my laptop before take off?

Also considering go/Rust as an alternative to scratch the surface of these languages.
DxOMark certainly disagrees with you if you're talking stats. In the real world maybe, but then again, my Sony phone takes very good pictures.
I'm surprised you think Allo is secure that you can send passwords. With a company who's core business is learning as much about a person to shove ads in their face, I wouldn't be too surprised if Allo messages are logged somewhere so their AI learns to exploit you someday.
I will never put an always on Internet connected microphone run by an advertising company in my house. I don't care if it literally spits out cash and cures cancer.
But isn't the idea that you will make more money from the business accounts as opposed to ads ?
Show HN: A Facebook ChatBot to get all information about PM Modi
Is there something similar for /sys and /run?
"One man and a thousand women is a potential civilization, whereas one woman and a thousand men is a horror movie."

Very well put.

"Men, therefore, must strive very hard for 'best'"

Aren't I getting a lesson in this. Spent most of my life in pure abjection until a doctor, with some actual competency, prescribed me some ritalin.

You would not believe how mad I am. Now I'm trying to play catch-up to be the best and it's absolutely infuriating to hear people tell me to "relax".

I went through unimaginable hell because the wrong men were promoted to higher positions and nobody told them to eat shit. I can't even recourse to a notion of ultimate karma and fairness because I've realized how ultimately such notions are a case of the sourest grapes over losing in the competition.

There are MANY terrible and incompetent men and I want to devour them all. But my wants are nothing compared to what I need to do (develop skills and behaviors that are marketable and which act like positive feedback on another). My apologies for the little detour but figured that someone here has an inkling of what I feel and it's nice to know that one's turbulence isn't a lone storm.
I have always found the "everything I do is to carry my genes forward view" to simplistic

- Why do pregnant women have sex

- Why do women have sex after menopause

- Why do men stay with women who are no longer fertile

- Why do 50 % of young people identity as bisexual in some way.

- Why do sperm banks have to advertise for doners

- Why do people adopt kids, its not their genes

And don't get me started on monogamy...
> Why is it a good thing that two separate entities, with the exact same goal, are keeping secrets from each other and inhibit the development towards that goal... Haven't you heard about open source?

Even in open source, there are often competing solutions to the same problem. Rather than have a joint committee decide the best approach (to the code, to the development process, etc), the decision is made by users choosing which software works for them. That's good.

The "keeping secrets" part is what's different. It would be nice for consumers if these companies shared knowledge while they compete, as open source software projects do. But 1) their secrets won't stay secret forever, 2) the ability to have secrets helps them compete, and 3) it's an acceptable short-term loss for the long-term gain of more effort spent on the problem.
actually there are quite a few in Asia and Africa:

https://en.wikipedia.org/wiki/List_of_matrilineal_or_matrilo...

The Akans of Ghana, West Africa, are matrlineals. Akans are the largest ethnic group in Ghana. They are made of the Akims, Asantes, Fantis, Akuapims, Kwahus, Denkyiras, Brongs, Akwamus, Krachis etc.

"Matrilineal" means property is passed down through the maternal line on the death of the mother, not that of the father.
http://webcache.googleusercontent.com/search?q=cache:AwMemm8...
Elementary Linear Algebra by Ron Larson, https://www.amazon.com/Elementary-Linear-Algebra-Ron-Larson/...

Other books assume you already know what they are talking about.
It's a single line, top to bottom at a slight angle to vertical, about two thirds of the way from left to right. I've lived with it since late June, waiting for the next Nexus. Doesn't seem to be getting worse!

I might hang on for another month or so, until a couple more potential replacements are released.
Python let's you get stuff done fast, but it's almost more dangerous than C in some respects. Without a compiler, you run the risk of deploying code that will not run, and you don't know until that section of code is actually executed. Requiring a massive set of tests to actually validate your code.

On top of the additional testing, you also will have a performance problem at some point after success. And then people will discuss or even plan for a rewrite in a more performant, language. But we all know that rewrites usually fail to materialize. PoC's turn into products, products turn into companies, and companies bottom lines can't generally spare time and money to rewrite the entire service.

I'm not advocating for C, but I wouldn't put Python up as a comparable thing.
It's pretty clear that they have value, or the entire VC industry would not exist.

At least, enough of them have value to pay for the ones that don't.

This is basic economics.
The part that galls me about this is not the shutdown – such is life in a world of cheap acquisitions and expensive maintenance – but the communication around it. For months, as Pixate went without updates, the Pixate team would placate the occasional "is Pixate being abandoned?" threads in the support community with vague reassurances that they were "working on something great."

And so it turns out that regardless of whatever this great thing is, there will be no continuity between Pixate and it, and anyone who relied on Pixate's cloud features will have to find something else in the meantime.

Personally, as I currently have an entire team using Pixate Cloud in the field, and now have less than a month to find, test, implement, and train an alternative, I can't say this experience has left me with much faith in whatever Google comes up with to replace it.
Less than 30 days notice to get your data out, not ok.
California Hospitals don't know how many patients die from superbug infections
I think Gary was way ahead of the industry when he did this talk in 2012. Today it's common to look at Erlang, Haskell and other good but previously unpopular languages and retrofit their ideas to your language of choice (or build something like Elixir/Kotlin/Swift).
But back then Ruby/Python/Java/etc devs would usually not look at anything else because functional programming was only something you might have heard in university and OOP was clearly the only way to build practical software.

For me this talk was especially great as he only explains the problems, possible solutions and their trade-offs and leaves the (clear?) conclusion to the audience instead of shoving "you should really use X because it's awesome" down their throat.
What about an Android phone?
I dunno...but, does it matter? Price is also a feature/benefit that people consider when choosing a phone. A killer feature, even, for some consumers.
> why does this article have this tinged negativity toward SV? Why not just highlight MailChimp's success without the jab on VCs?

VCs are easy to hate: they're rich, successful, powerful, and mostly straight, white men who had privileged upbringings.
Project Management Add-Ons and Plugins for JIRA, WordPress and Salesforce
If you need documentation for an language, framework, etc you can take Dash. https://kapeli.com/dash
So, yeah. Window functions are new to me. I was actually asking the team about a month ago if there was a way to do this in SQL. Consider my mind blown, and thanks for posting!
In that case, I would code something to help me automate my computer.
Draw a box: learn how to draw through logical steps
Then use a 3-hour moving average of the timeseries... This does not imply one data point per 3 hours, the rolling average timeseries interval can be (& generally is) far more granular than the window size of the average.
I think "Facebook" here means "Whatsapp", which is owned by Facebook.
Page loads very slow and uses Wordpress. In case it goes down: http://archive.is/JaOXd
So for languages like Haskell, or lets have fun and throw Idris in the mix too as its implemented in Haskell, what/how should they be changed to not have to bootstrap the way they do now so that reproducibility is preserved?

For languages that have effectively abandoned that route, what would satisfy your requirements? Which languages specifically handle things in a way you consider correct? Is the effort involved worth it if only reproducibility is the end goal?

I don't think its safe to say that a bootstrapping compiler is the only sane way. Even if System F is a fairly simple language and what GHC compiles to, having to keep a bootstrapping compiler around just for bootstrapping purposes seems like mostly wasted effort IMO.
Not really; the energy density in the core of our sun is about 100 watts / cubic meter. (Energy density is a LOT higher in more spectacular events, like supernova and the first few milliseconds of a hydrogen bomb's fun-time).

Smaller stars burn fuel more efficiently. Our sun is good for about 4-6 billion years; a much smaller star will last several trillion years.
I can certainly understand people being nervous about academic debate moving to social media. It would be a hassle for climate scientists if every paper got a brigade of climate change deniers criticising it and you had to respond to those criticisms.

But this example - someone notifying you there's a mistake in your paper, when there really is a mistake? That seems like a strong argument /for/ academic debate via social media, not /against/ it.
What I think is interesting is that many of us nerds have probably innocuously fantasized about having a Star Trek-like AI assistant with us, but now that they're taking the first steps towards that, we're starting to realize that in order for it to do everything for us, it has to know everything about us, too.
Well, they came a long way for an advertising company. Most usually die from ad-blockers, but they dodged most of these bullets it seem.

Moving to voice-to-text everything android, just seems as a logical extension to advertise/sell data even more.

Whether is ethical or legal, it doesn't seem to concern them at all when profits are in question.
I wonder if Twitter missed out by not being Patreon. There's a proven business model of paying content creators directly and they already had one of the platform for content creators to communicate with fans.
You left out the sentence before that:

Marriage stops the "natural" dynamic by tying every male to a maximum of one female

That guy must be kidding, right? Monogamy is one thing, but what about other forms of marriage that involves more than one man and one woman?

But the rest of the sentence that you quoted is even worse, but so that it makes more sentence, I'll quote the entire sentence:

In earlier societies where marriage did not exist, the most dominant males had children with many women, and the males at the bottom of the hierarchy did not get to procreate at all.

But in most societies around the world, the poor tend to have more kids. Who is the author of that article?

He's:

a 33 year old semi-retired entrepreneur (I co-founded the Swedish marketplace Fyndiq where I was CTO for the first six years). Nowadays I spend my days mostly reading, writing and photographing stuff.

And making up crazy ideas about society.
Doing some research looks like they're not that close. =(

https://jira.mariadb.org/browse/MDEV-6115
The deal-breaker for me with couchbase is that the community edition lags (in terms of bug fixes, security updates, etc) 8-10 months behind their commercially licensed offering.
That's exactly what I'm thinking of, thanks.
4 common pitfalls of software development projects: NexGen prototyping tips
As a hobbiest photographer, this measurebating/pixel peeping is very reminiscent of the MP wars in Digital Cameras and dSLRs.

Photos from mobile phones will be most often viewed on a service (FB, Instagram, Whatsapp) which will almost always do some sort of resizing and recompression which would render that +/- 5 spread between all the top cell phones meaningless.
Not trying to start a flame war here, but I in recent few years I am seeing Vim being more popular, and I feel it adoption in terms of younger developers (those who weren't programming when original Vi was around) grows. (Ok, please forget about GUI editors, they have their audience, and I am not comparing any of those facts to them) I used Vim for 3 years, and found philosophy and implementation of modal editing amazing. Writing and manipulating code in it went like bread and butter.

But then I told myself, hey, why not try Emacs? So I've been using Emacs for ~6months now and cannot but notice that community is much more niche and humble compared to Vim. Just look at the sheer number of color schemes available for both editors. And I had to agree, Vim was far superior text editor, but that wasn't enough to keep me away from Emacs, since I gave the advantage to other things (everything else) that Emacs does better.

I tried EVIL mode, and it is amazing, but something just felt wrong using it inside Emacs. I wasn't using either Emacs or Vim. I would often shuffle and mix commands, sometimes I would do :w, sometimes C-x C-s. So I decided to ditch Evil until I get more comfortable with Emacs key bindings. I came to Emacs because of Lisp (and general FP audience is much, much, more based around Emacs, makes sense), amazing tools and plugins which I found more stable, better designed, and it is weird to say this but things just worked with Emacs, things like auto-completion and code navigation (ivy, ace-jump-mode) were really fast, hustle free experiences. Disclaimer, I have never touched older versions of Emacs, spent my time in 24, and now in 25, so many of myths and problems that Emacs got known for over the time, I think, aren't there anymore.

And to sum things up, what is really weird to me is that functional programming is on the rise and every year I see it more and more being adopted, but that doesn't help Emacs audience grow. (Maybe because I am young, and I am nerd often found in nerd communities where things like FP are often praised, but in the real world considered a bit awkward or esoteric.) I showed up at the FP workshop few weeks before in local dev/hacker community place, everybody rocking Sublime Text/Vim, but nobody used Emacs, people were looking at me like I was an Alien. Spacemacs is doing good job at attracting people, but maybe Emacs will stay that programmers/nerd phenomenon, the all-mighty lisp OS, that in the end people often reject or overlook. And why is it like so? I do not know. If somebody can sink into and learn Vim, I don't see a reason why it is different story with Emacs.
Because stuff costs money? Financial stress is the leading cause of friction in relationships: http://www.cnbc.com/2015/02/04/money-is-the-leading-cause-of.... Something as small as getting a parking ticket ($50 here in DC) can cause a lot of stress for a family for whom that's not something they can just wave off. Also, high status jobs are usually a lot more interesting. A lot of people would code for free--nobody would restock shelves for free.

And women strive for status and money too. Women outnumber men in college--and it's not because they're trying to improve their prospects on the marriage market.
Vim has “multiple carets” out of the box with visual block mode.
For any Windows devs that happen to use vim inside of mintty (that comes with downloading git), you'll discover that installing fzf doesn't work out so well. It'd be fine on cygwin, surely. In mintty, though, it'll yell about missing ncurses and then offer to install the legacy Ruby version, which also fails for curses related reasons.

So, that said, check out ctrl-p.

https://github.com/ctrlpvim/ctrlp.vim

It's a nice quick way to see a filelist that you can filter, like fzf. You can filter on:

* the whole project, excluding .gitignore stuff

* all open buffers

* Most Recently Used (MRU) file list

In addition to the built in ^p binding, I also add:

nnoremap <leader>v :CtrlPMRUFiles<cr>

nnoremap <leader>b :CtrlPBuffer<cr>
Holiday Activation: Drive ROI Around Black Friday