skysight-inc/HackerNews huggingface dataset:
Understanding your database configuration is important as well. I spent way longer than I'd like to admit trying to improve performance of complex query that would not execute the way I wanted it to no matter what, PostgreSQL absolutely refused to use a calculated index on one table and then do a HASH JOIN to a second, instead devolving into some really hairy execution plan I can't even remember at this point. Turns out, I had done everything right in my index design and query - but due to the sheer volume of data the query planner didn't use the "correct" plan because work_mem was set too low.

Always be mindful of how your database is tuned, you could be doing everything right but the query planner will seem to act insane regardless.
This is great. Can't wait until Python 3.5 support is out of beta.

Just out of curiosity, I'd love to hear from others who've used PyPy for their web apps. Are there any issues to look out for? I remember that a few years ago, packages like psycopg2 were not compatible, which made the migration somewhat difficult. Would love to hear real-world experiences here.
IntelliJ Ultimate has pretty good built in tools as well that handle a lot of different dialects. I've used MSSQL and PG with pretty good results, e.g. code complete that uses the db schemas is really nice to have when exploring databases.
Can you divulge any of those seismic shifts? Would be interesting to hear.
I am not arguing for British colonization, but were they second class citizens? I believe they were British Subjects and therefor entitled to all the rights of any other British subject, or at least that of British subjects in any other British Dependent Territory.
I guess in theory you could build a browser on top of a game engine, or is that just insane?
It has been known for some time that WaveNet can be greatly sped up, and exponentially so. See https://arxiv.org/abs/1611.09482 (Fast Wavenet) for an example.
Better link to the official website: https://dbeaver.com/
Years don't tell much, what kind of CPU is it ? Still very nice to see.
Libraries are even better - disciplined, gets more work done.
Pensieve: An intelligent repository for the million things in your head
Agree. It's probably an issue with the form, nothing underlying. (which means encrypted containers created via the command line should be safe from this vulnerability?)
Is America Facing Another Sputnik Moment?
You might want to remove the 'amp.' from the URL.
I don't know what college or University you went to, but at the large public University I went (University of Minnesota) one literally receives no governmental authority and extremely little guidance dictating what path you should take whatsoever. Students are literally tiny specks of nothing helping to finance an ivory tower and they can do whatever they want, whenever they want, it's an extremely lax environment behaviorally speaking. There are no authority figures, no hierarchy, and professors do not know your name or care if you come to office hours, because you are one of 500 students in a class. There were classes that I never showed up to except for the first day and tests. People who manage to come across the financial means to get a degree are able to finish while others drop out over time - so I think it's seen as more of a financial stability indicator, which could perhaps be a surrogate metric for submissiveness but not necessarily as you purport. I slunked my way through an Electrical Engineering degree while running a landscaping business I had started in high school, because I wanted to build stuff rather than be a landscape dude for the rest of my life. I see nothing in the University world resembling the corporate politics world what so ever. Perhaps you attended Hogwarts?
I use SSSS to store physical copies of the key I use to encrypt my backups with ssss http://point-at-infinity.org/ssss/ . Basically print a bunch of copies and give them to people I trust.
If I understand what you're looking for, you can likely accomplish this using a WITH expression, something along the lines of (untested):

WITH
input_rows (name) AS
(VALUES ('a'), ('b'), ('c')),

insert_rows AS
(INSERT INTO entities (name)
SELECT ir.name
FROM input_rows AS ir
ON CONFLICT DO NOTHING
RETURNING id, name),

-- returned when insert was successful
SELECT 'new' AS src, i.id, i.name
FROM insert_rows AS i
UNION ALL
-- return when there's a conflict
SELECT 'existing' AS src, e.id, e.name
FROM entities AS e
JOIN input_rows USING (name);

As for the sequence incrementing, that's the nature of sequences: it's a trade-off between getting fast, unique values versus the overhead required tracking whether the id is used.
I'll second the recommendation for Toggl.
> What kind of answer would satisfy you?

In the real world, with an actual registered company/cooperative, you can call the police or sue people in court as a last resort. This is not possible in a distributed world, so a new kind of recourse needs to be invented, if that's even possible.
You can even go further.

Use WITH select id, name from entities where name in :data AS existing

Then return a UNION of existing and (INSERT into entities (name) :data except existing returning id, name)
> To be mentioned on slashdot was a meant instant saturation for a website.

For quite a while, that was even referred to as being 'slashdotted'...
I'm not sure how a Cold War 2 wouldn't be preferable to a CCP-centric world.
The reality is that a lot of sites query the UserAgent and deliver platform and browser specific sites. Google Search and Image Search are great examples of a crap experience if you're not using Safari on iOS or Chrome on Android.

Microsoft is skirting around this by using each platform's engine and providing the user the best experience they can.

\* Also they don't have a choice on iOS because Apple.
What Exactly Does Chemistry Do Again?
They're interested in their network getting big so they can make money. There's not much nuance to it. You can spin it another way but read the thread. It's a soulless money grab, and it's disappointing because they actually have decent software.

Once you've built a core community that is first and foremost interested in ICOs and cryptocurrencies, how do you get out of that?
> Overall, I like this better than the old mac setup I have.

What exactly do you like more than a Mac setup? I just find it hard to justify the new pricetag of google laptop, for almost the same money I can get a macbook and don’t sacrifice my choice of software for work, but I am wondering what exactly are you liking it more on chrome book apart from a price.
"Architectural reasons" is nonsense. "Architecture" isn't a set of reasons justifying anything, rather it's the other way around: we design architecture for specific reasons. Your claims that we do things for "architectural reasons" don't have any clear meaning. I said the actual reasons are performance. I don't think I'm the one being unclear.
That's the enterprise/commercial version which recently has a cost involved. Worth it for the nosql access.
waayyyy back in the days, like 2002, Yahoo Pool was pretty big and people used bots to make many many accounts that played with themselves (in something like pyramid structure) to boost accounts score. They were usually used with proxies to avoid yahoo protections.
I don't remember if i did it, but I knew how to do it.
There were also 2 big auto-aimers, hell they were fun and tourneys were fun too :)
This retro version highlights what I like about the Thinkpad line -- it is what it is and it's proud of what it is. It's a no nonsense line of laptops meant for business.

Compare this "retro" version to today's version -- there's not too much difference. Lenovo tried experimenting with being hip via sub-brands and technologies (touch bar, Yoga, etc.), which is fine, but the Thinkpad line's core identity hasn't really shifted. If you want a Windows laptop that works and can withstand a decent amount of punishment, go with a Thinkpad.
Wix, Wordpress and Drupal all have layout builders. But they're mostly geared toward designers or admins, and thus separated from the code.

And then once upon a time, there was Dreamweaver, which nobody mentions. There is also Adobe Edge. I've watched a designer put together a nice looking website very quickly in Edge. I've also seen what they could do with the WP theme builders.

But then you still need someone to tweak the css, and add JS for custom stuff separate from the builder.
I'm not certain, but isn't RxJava just a specific inplementation of a monadic pattern with IObservables?

I thought the original Rx was a Haskeller saying "Hey a 'dsl' built on a monad would be really powerful here in C#" and implemented it. Then it spread to other langs from there.
Yes. It's terrible that the author published it and didn't think to include any documentation links. I can understand if someone outside of MS posted it to HN, but they did it. SMH
How-To Guide: Purchasing ICO Tokens
The ex-celeron.
Ask HN: I SMS'd a number and it automatically gave me his name
I sent a SMS message to a number that is not in my contacts and my contacts app Contacts+ automatically fetched his full name. How is it doing this? I do have FB running and the receiver has his number set to 'Friends only' in FB.
Anybody see anything about solid Linux compatibility? I was hoping they'd have more information on that.
Interesting that the jump from 900 to 1000 doesn't seem to be that much of a problem, but companies avoid the jump from 9000 to 10000. At least I can think of no example right now.
Nvidia stopped after the 9000 series, Intel never crossed the 10000 mark in their "Core 2" CPUs ("highest I can find is Core 2 Duo T9900"), and so on.
There’s probably some easy explanation but why is there a need separate code to store variables for the ssd vs hdd version? I would think this would be high level code, abstracted far away from any hardware differences
A discussion when Ryzen was released had quite a bit of info on PC builds:

Ryzen is for Programmers | https://news.ycombinator.com/item?id=14243350 (May 2017, 272 comments)
Edge isn't great if you use tabs; it tends to lose them on crash/restart and doesn't make it easy to have lots of them.

It also seems to suffer from the same weird font rendering as a lot of Metro apps.
Yeah but you'll notice, and resume the simulation from a previous checkpoint or something. The risk is with errors that you don't notice, but that nonetheless change the outcome in a meaningful way. That seems to me to actually be a pretty small space of situations.
This strikes me as extremely confused. Chinese society is thousands of years old and has survived dynasty after dynasty, revolution after revolution. Perhaps their personal exit from politics is more earnest accumulated wisdom than blisteringly immature sentiment.

Contrast with your statement on stewardship, duty, and responsibility. What is behind this besides sentiment?
I've written a game that's a mix of algebra and maze solving. I believe its pretty relevant to this question. There are easy levels but also it can get surprisingly complex even for small mazes. Its called Numplussed and its free on Android or iOS:

https://itunes.apple.com/us/app/numplussed-number-puzzle-maz...

https://play.google.com/store/apps/details?id=com.codeulike....

Example of a hard level:

https://twitter.com/codeulikegames/status/911725658929291264

some easier ones:

https://twitter.com/codeulikegames/status/890246328290332672
Nvidia didn't reset after the recent 900 series of GPUs though.
Look at JetBrains DataGrip - the standalone tool for DBs. IntelliJ's tools are a derivative of that.
yes, this would be capable of waiting, but it doesn't have the abstraction built in so it looks like it would have the same problem I often run into with scapers - you go through page to get links to follow/markup to act on and then have to wait a reasonable amount of time / catch some browser based event to determine if you need to look at content one more time before continuing.
little trivia re Western: Hunger games is a remake of the Japanese movie Battle Royale based on the book by Japanese author :)

(but of course not arguing with Hunger Games movie itself as a very western movie with very western visuals, I understand what you mean)
Every job I've had and encourages engineers to have reading groups, on any topic they want.
It's also my experience that most people ignore these opportunities
Is this also what others see?

Some reasons I can think are people:
- don't want any more meetings;
- are bad at having a merit driven discussion
Perhaps the price of the vault pales in comparison to what else is in the vault.
I found a source for inmate stats: https://www.bop.gov/about/statistics/statistics_inmate_offen...

It's hard to precisely quantify the violent versus non-violent crimes, so I'll be making some assumptions in my summary based on some educated guesses about the kinds of crimes that land you in each category:

Non-violent: 70%

Violent: 30%
Can you try again with other numbers and see what happens?

Then, from a network you can capture traffic, try it again.
Awesomely said. also, tools like pgbarman(from 2ndQuadrant) and other PG backup tools, do all of these steps for you.
You could add -Werror to cflags in the makefile on the condition that some release build specific environment variable is set, though just adding separate release/debug/dev targets doesn't seem too tricky.
Natural deduction for propositional logic? Simple rules, real math. There are lots of good problems of varying difficulty in Logic in Computer Science by Huth and Ryan.

Edit: Perhaps this doesn't qualify as a game per se, but I think it might be a fun activity to work through the proofs together.
The Full Stack Haskell position has now replaced our JS listing:
https://stackoverflow.com/jobs/156727/haskell-full-stack-dev...
16:9 will never be retro. I personally like the new keyboard (T430-onwards) and while I enjoy the new ports, I will stick with purchasing 5 year old thinkpads on Ebay for under $150.
Ask HN: Do you use a Chromebook or Pixelbook as your primary machine? | https://news.ycombinator.com/item?id=15407631 (79+ comments right now)
This is Stallman's wet dream.
Analyzing customer support interactions of telcos with Machine Learning
Good example! Though, for the record, WebVR 1.1 is shipping in EdgeHTML 15. Fair to call it a preview, since consumer headsets won't be available until later this month with the Fall Creators Update, at which point end-to-end support will work out of the box.
This Future Looks Familiar: Watching Blade Runner in 2017
I lost access to my first account because I lost access to the email address. This was quite a while back and it was a moniker less able to be tied to me. So, I eventually stopped posting as AC and signed up with my 'real' moniker.

Same username as here.

Anyhow, I seldom post there, as of late at least, but I've met a bunch of them in real life. Mostly, they're good people.

Lately, I've found the HN conversation to be more stimulating. I should try to visit Slashdot later and see who dropped by.

What I like best about sites like Slashdot is the vast amount of intelligence there. You will need to wade through some troll posts, but it is worth it to find the gems. Reading at -1 is not for the faint of heart nor for the easily offended. Still, I find it worth the effort.

The new owners have done away with the hidden trolltalk board. They have disallowed the n-word, so people found a workaround using the few Unicode characters they do allow. Still, no sign of the promised UTF-8 support - which is funny because Soylent News got that figured out pretty quickly.

I do like to point out that Slashdot was never good. No, no it wasn't. I read it before they allowed comments and, as mentioned, even had a five digit UID. (I lost it and now have a six digit UID.) Slashdot was never good.

When people on Slashdot like to talk about how it was so much better in the past, about how the level of comments was so much better, I like to link them to the announcement of VMWare releasing their first VM software.

The comments are mostly people insisting that it can't work, won't work, and that VMs are a bad idea - because they are quite happy dual booting Win95 and Linux. The comments range from mockery to disbelief that such a product could even exist - even though virtualization wasn't really new.

So, no... Slashdot was never really great. I'm not even sure it was ever really good.

And that was part of its charm - and still is. From GNAA to Yoda-in-your-ass guy, Slashdot is just Slashdot. The racism is rampant, the puns are still bad, and mobile is still broken, but not as bad as beta. Slashdot is like your drunk college buddy that you really hope doesn't show up at your wedding. And that's okay.

Yeah, I'm going to have to visit later. If you do visit, I'd suggest reading at -1, just so you get the full experience.
Genuine question: with an extremely strong password on the private key, what's wrong with just storing it on an external hard drive somewhere?
Yeah, but the obstactles they're removing are those very same pawns.
There are 2 fishing industries in Norway. One is traditional one and another one is factory farming of fish. The latter appeared around 1980, earned a lot of money and bought disproportionate amount of influence. The industry treats the fish in absolutely evil way, a complete opposite of how traditional fish men relate to the fish.
Sabotaging a service by posting things on github that china doesn't like?

Seriously. Thats what this is about. People posting true stuff on the internet about china. I am not going to tiptoe around stuff like that, lol.
I actually would _really like_ a service that did that. I feel like I'm googling badly because not much is turning up, because this sort of thing must already be useful in everything from finance to business management to reporting. Clearly you can do it on a case by case basis via wikipedia, SEC filings, domain ownership, etc but you've got me thinking about how one could scale this and release it as, for a stupid example, a browser plugin.

(Implicit in the above is a badly worded ask that if anyone knows of such a service I'd be curious)
I agree. Of course, there is a "spin-up" time and we prefer to select the competent candidate with skill in our tools vs the competent candidate with skill in a different tool; but absolutely a competent developer should be able to adapt to any environment.

Interviews can help accommodate this by allowing the candidate to solve a coding test in a language of their choice, while also inquiring about the candidate's learning plans. (Want to make sure they are willing to adapt to the team's tools and not try to force the team to adapt to them!)

I took a job once where the code base was in a FORTRAN-derivative language. I had never used FORTRAN or anything like it. Not a problem. I studied the code. I studied the docs. I figured it out and did the work. I would expect nothing less of any other competent developer.

Another job had a toolchain based on NodeJS on the server-side. Never used NodeJS. Not a problem. Studied the code. Studied the docs. You know the story.

The key skill is a developer's willingness and ability to learn the tools that are desired for the job at hand, and to accept and learn new tools when the time is right.
Cool. Nice to learn of another option. What would be the advantages of using this over wkhtmltopdf (https://wkhtmltopdf.org) ?
I suspect that "extracting" this part of chrome into a library would result in the same thing: a library that starts up the full chrome environment and prints a page to PDF.

The PDF-ization isn't the part that's hard to extract (there are libraries to create PDFs from scratch already available, and they're small/intelligible). Rather, it's the rendering of a webpage for display that's the hard part, and what most of the code in any web browser is concerned with. Whether that display is a monitor or a PDF doesn't change much.
Related, https://hn.algolia.com/?utm_source=opensearch&utm_medium=sea...
I read the Slashdot FAQ on the Friend/Foe system, but I still don't understand it. Is the idea just that it lets you filter a comment thread to emphasize comments written by people you're interested in (friends)? Does it hide the comments of foes?
Reminds me of some code I wrote for a codeeval challenge for returning the sum of all primes up to n inclusive. IE: sum_primes(2) = 2, sum_primes(3) = 2+3 = 5 = sum_primes(4)...

It's odd that this version doesn't use a set(), but dictionary/list.

Anyway, I'll have to refactoring my code and measure against op - although I only used the python as a reference to sanity-check my naive c++ code:

https://github.com/e12e/codeeval/blob/master/4-sumprime/prim...

(I believe, like most(?) codeeval challenges, this is from project Euler)

[ed: should probably add that this isn't a sieve]
How Galantis Became the Hottest Music Group in 5 Years
My apologies if I misunderstood. What did you mean by faulty hashes then?
Oh no, china is going to come after me for posting information about them on the internet that they don't like!

Oh no, my anonymous github account will be hacked!

Seriously, this shit doesn't happen. There are too many people doing too many things in the world for a government across the world to do much of anything to anyone.

I am not ever going to live my life in fear of something dumb, like that. I am going to criticize and offend whatever world governments deserve to be offended.

If they don't like it, they can send their secret james bond assassins after me for posting stuff on the internet that hurt their feelings.
We have made alot of progress over the past few years, especially with compatibility . An example of a web stack is crossbar.io who recommend it for production and even got their stack running with PyPy on a rasberryPi [0]

[0] https://crossbario.com/blog/Autobahn-Pi-Benchmark/
Token reminder, consider donating to the EFF, a registered nonprofit as they help maintain our freedom / privacy online:

https://supporters.eff.org/donate
Or we should shun it, so that if anyone else decides to use their monopoly power to try to destroy the web, they know the consequences will be long lasting.
I've heard this one is pretty good :)
http://reza.codes/2017-07-29/how-to-train-your-own-dataset-f...
The moral issue isn't one of technical competence, but rather of having the integrity to perform the appropriate due diligence required of a company handling such sensitive information.

No security professional is going to argue that you can or will prevent every vulnerability from being exploited. However, when you leave a critical vulnerability open for months on end, you knowingly and unnecessarily expose yourself, and any parties associated with you (by choice or otherwise), to a level of risk that is unacceptable.

If this were a 0-day exploit, then the conversation would be different. If their exec's hadn't sold off so much stock a such a suspect moment, then the conversation would be different. If the IT department had appropriately began remediating the vulnerability within a respectable timeframe but had already been exploited, then the conversation would be different.
I've seen (and implemented in code) some pretty brutal liquidity algorithms. I've no doubt God could use such algorithms to always ensure positive performance on those dates on which liquidation is possible.

Funds might be locked up for two years, and afterwards only redeemable on the first day of the fiscal quarter. On the first liquidation event, only 25% of the funds are redeemable. If you submit notice on the first day of the next fiscal quarter, 33% is redeemable, followed by 50% and 100%. If you miss a quarter, the sequence starts over.

That one is not even terribly complex.
Does anybody have a recommendation for a book on category theory?
IObit Smart Defrag Pro 5.7.0.1138 Crack and License Key [Latest]
Been looking for something like this, as i have been using RES over at Reddit for a similar purpose.