skysight-inc/HackerNews huggingface dataset:
IBM takes one small step for quantum mechanics, one giant leap for computing
Aren't CTE part of the SQL standard now?

I'm pretty sure most modern relational servers using SQL (MS SQL, MySQL, Oracle, DB2) support CTE.

PS: even SQLite:
https://www.sqlite.org/lang_with.html
Yeah, I tend to find AirBnB and especially Uber worse. Also, Uber seems to be run by sociopaths.
Sounds like a player getting eliminated at the end of a Monopoly game when one owes a lot of money and goes bankrupt.
I thought Diaspora was dead.
This and other stories are claiming it is an integer overflow, but I've seen no source for that. It seems to be just speculation based on the observation that a 100 Hz 32-bit counter would behave similarly.
Keep your therapy if you need it and your corporate dealings separate if you value your job and your sanity.
People often say "managed runtime" or "VM" but those things are not clearly defined. For example, if we look at Java and .NET, the two best known language VMs, they really provide few completely orthogonal features:

1. OS isolation -- the VM provides a platform-neutral API for OS services, and abstracts away details like clocks etc.

2. Intermediate language representation, a JIT (or several JITs, in the case of the JVM) and dynamic code loading/manipulation.

3. A GC (or several GCs, in the case of the JVM).

Each of these features is completely independent (in fact, some JVMs don't even provide #2, opting for AOT compilation. Golang, OTOH, is not perceived to run in a "VM" -- simply because its "managed runtime" is statically compiled with the program, and no JIT is available -- yet it provides #1 and #3, just like some JVMs).

Now, as to why you'd want to provide each of those features -- well, there are different reasons. #1 is great for cross-platform portability. #3 is great for simplifying programming, esp. in multithreaded settings. #2, the JIT, is actually an optimization layer with some tradeoffs. A JIT can always produce machine code at least as efficient as the most sophisticated profile-guided optimizing compiler, and then some; to do that, it trades off warmup-time, and extra CPU cycles that can make a difference on energy-constrained platforms (although a JIT with caching might enjoy both worlds). In addition, a JIT is an absolute necessity when trying to achieve high-performance when running dynamically-typed languages. Another downside to JITs is that they're very hard to write well (i.e. while they can surpass the code quality emitted by AOT compilers, it takes more effort to even match that quality).

So, in general, there is no such thing as a "managed runtime" -- just a collection of features, each with its own motivation. That name also has a connotation of overhead, which again, is completely false. A GC may add some overhead (RAM, latency) but may also reduce overhead (throughput, more scalable concurrency) -- depending on your application. A JIT may add overhead -- warmup time, extra cycles -- but may also reduce overhead (more efficient generated code).
How big is that one segment, though?

I honestly don't know, so maybe dang or kogir could clue us in. If a significant number of users are on mobile, and it's reasonable to expect that number to increase for the foreseeable future, then placating mobile users makes sense. I doubt that increasing their SEO is really a priority for the HN staff either way.

Also, two out of the three issues on the google site come down to simple typography and UX. Elements being too close together (links, line-height to add my own personal pet peeve) or too small (font size and the oft-complained about vote arrows) or too poorly contrasted (grey text on a lighter grey background) making things difficult to read and navigate. I don't see anything wrong with improving the readability of a site which is meant to be read... that makes the experience better for everyone.
I often wonder what state science might be in Greek & Roman pantheism had persisted rather than being displaced by the monotheistic religions from the Middle East.
Half the fun of Ruby is monkey-patching...how does that play with static typing?

If they go this route, I'm sure we'll see some very interesting spins on it.
Yeah, copy the good stuff. And then leave it in the dust :)
iOS 8.3 jailbreak via TaiG for iPhone 5 – iOS jailbreakiOS jailbreak
I guess you're right, it adds choice, but softly discourages you from seeing an outside therapist. Why not just see the company therapist? There is also some moral hazard involved.
Simply logging into your server once a day and typing "top" is a good start. You can usually spot suspicious processes associated with these spamkits. Also, check /var/log/messages, and check root's email.

Also if you run anything like phpbb or wordpress, make sure you keep it updated.

I also like to disable Apache's suexec (as I once had a rootkit that exploited it, and I don't require it for my systems), limit inbound connections with iptables, and limit ssh access to certain ip addresses. Also, get rid of or disable access to any services you don't really need (like ftp, bind, etc).

It's also very important to check all your php/perl scripts for file/sql injection vulnerabilities, as that is one of the most common methods of infiltration.
Guilty as charged. And I really shouldn't be using any...
I care not for provenance!
If you don't have any industry connections, you may not be of much help. But don't feel bad, it's your job to educate your students, not get them jobs.

There are a few places that can help your students find jobs, like the ones listed here: http://www.ams.org/profession/employment-services/employment... But once you look at the listings you'll see that they are mostly academic job listings.

In general, the companies willing to hire pure math people are large companies that have a lot of money to spend on developing new things. So I would give basic advice to your students to apply to large companies. Small companies want a more rounded person and math PhDs don't often come with enough practical skills (unless they are good at programming or did applied math).

The US military also employs a lot of mathematicians and if that fits in with their moral values and they can get a security clearance (read: not foreign and no criminal record) then there is some decent money to be made there. There are a decent number of non-defense government jobs out there as well, but are usually in some applied field like economics/finance or statistics.

But really, as a professor, if you aren't able to hook your students up with a head hunter or personal industry contacts, they may be better off getting job help from someone else. If you have no industry experience yourself, the best option may be to just keep from offering any advice in the hopes of not steering your students in the wrong direction.
The company is in the UK so there are laws governing use of information.

Hopefully the company chose a BACP registered therapist and so that therapist will be covered by their registration rules too.
A Review of Online Appraisal Sites
Absolutely this. Not to mention the need to prematurely scale up DBs due to the added load. Expensive and hard.
Yep, every time I sign a check for Bay Area rent, I consider how I'm in the wrong industry, since the land owners have to do very little to continue to extract rent from their one-time-purchase of land (I know, tax is a thing too, but pales in comparison to the returns they must be getting on the land).

I'm not super interested in buying a house here, since >half a million for a tiny spot of land in the suburbs with a tiny 2-bedroom house that needs major repairs is absurd to me. I'd much rather live in an office while paying off a house in Fiji, then move into that in 20 years and work a lot less.

Another alternative is living in an RV. I've considered this, and since Bay Area rent can pay off a really really really nice RV in ~5 years, it's s viable option. The biggest hiccup is where to park it; national parks would be awesome, but they're not free, Internet access is spotty, and it'd be a long commute every day. Even working remotely, month-to-month RV park communities can be over $500 a month, so that doesn't quite feel like you're beating the game of rent-seeking by property owners as much as I'd like. RVs also require maintenance and probably won't last as long as a house, but even if you get 20 years out of it, or buy it used and sell it where the depreciation is much less per month than rent would have been, you can come out ahead.
But now you're asking for an entirely different political and legal system. Not to say that I disagree, but in an adversarial system you do whatever you can to defend your client (members). If the other side isn't competent enough to counter you and make sure the truth comes out then that isn't your problem.

Frankly, when the cops in NYC went on a "soft" strike a few months back nothing bad happened. That suggests that we have too many cops. But if the politicians and the people (because, by and large, the majority in many places want more cops, not less) don't have the guts to do what is right, then they get the police force they deserve.
I'd be interested to hear from anyone who's an active user.
"Scaling is a nice problem to have"

Don't write code to handle 1 million users if you've only got 100. Usually just getting something up and running is enough of a problem for most.
That is the point of the software!
While employees should definitely get their own therapists, I'm not sure it's a bad idea for a company to offer one for free while encouraging them to find their own. Removing the barrier to entry and the stigma by making it a standard thing might be worth doing.

Then again, if there are insurance plans that have this sort of thing in mind, making that plan standard and encouraging people to use it sounds better.
I always enjoy reading about new ways of doing things, so thanks! How would you test your logic in isolation with unit tests using an architecture like this?
The classic practical algorithm comes from Bell Labs work in the 1960s. Connect the points in some random order. Then pick two links and cut there, leaving three connected chains. Try all 12 possibilities for reconnecting those three chains, and keep the shortest. Repeat until no improvement is observed for a while.

This was one of the first useful nondeterministic computer algorithms.
According to wikipedia, adding mustard is a French culture thing, and not in the original. I'd say the Hellman's recipe isn't that horrible, compared to standard simple recipes.

Really mayonnaise is just a stable emulsification of oil and egg. That's all that makes it mayo.
I think he meant that it implies that an employer can pick a single therapist for all of their employees, and that there may be perceived pressure to see that therapist over others. In reality it can take quite a bit of visiting different people to find a therapist one feels comfortable with.
Review: The Absolutely Optional Apple Watch and Watch OS 1.0
People will crucify me for saying this but had they choose PHP instead of Rails, these folks would have had a better luck. I don't know any really popular web/CMS/project that is not written in PHP. Well I know some but they all are commercial Java CMSs. The only exception I know is a CRM/ERP built with Python.

Edit: i'm obviously talking about open source plateform.
I think a lot depends on whether you gain or suffer from their services, and also on the coolness factor. Your garden variety extortionist, mugger or trigger man is boring, but articles about drug trafficking using UAVs or microsubmarines tend to gain traction among tech crowd. Uber and AirBnB have just a huge coolness factor - because they have a mobile app! - but generally, it's a typical pattern of "let's make money giving a group of people some value, dumping externalities on someone else, social order be damned".
1) Your app is now tied for life to a third-party vendor.
2) There's is a steep yearly licensing fee. (starting at 300 USD PER developer, PER platform).
3) Xamarin Forms is notoriously buggy if you're looking to also use it for cross-platform UI code.
4) It's debatable how much easier C# is to learn than Swift.
Bitcoin Shop (BTCs) Announced Merge with Spondoolies
I think it's potentially more than just soft, as it could also lead to an in-group of people who are seeing the company therapist.
Can you point to one instance where GS argues that it was the secret algorithm? They merely say code related to the trading platform. Lewis had access to the source code because it is presented as evidence in a trial and therefore matter of public record.

No one from GS has said that what he has taken was an algorithm or anything related to decision making. Not one person.

I never said the Second Circuit resolved a dispute about it being proprietary code. The defendant's own lawyer doesn't dispute that it was proprietary. But merely being proprietary is not sufficient for a trade secret violation. If you modify a config file for Apache that modified config file becomes proprietary but it is most likely not an essential trade secret that is the core of your business that someone else couldn't have come up with something similar to solve your problem.

GS lawyer's say that proprietary code WAS trade secret and essential, whereas defendant says no it was modified open source code used for queueing etc. The jury is not sophisticated enough to differentiate between the two. See any patent case where a BS software invention is held up as unique.
Stored procedures, functions, triggers, etc, are very useful tools. They are used regularly in Microsoft SQL Server and Oracle systems.

But, one has to be very careful to use them when warranted. The out-of-the-box tooling for debugging, maintaining, versioning, and testing code that lives in your database is not nearly as robust as what you have for most other development environments.

The key here is to use the tool when it is most useful.

SPROC's are good when:

1. You need extreme data security and you are able to pass authentication tokens from application to database. You can apply authorization rules when you read/write the data, rather than transporting more than you need over the network. This eliminates a number of potential attack vectors. I have worked on HIPAA compliant systems for government agencies that held sensitive data that required all data access to be through stored procedures with proper access permissions, in addition to an authorization tier in the application logic. Very common use case.

2. You need to churn through a bunch of data and need very close data locality to pull that off and meet your performance requirements.

2a. Your database nodes are network IO bound and this is due to applications requesting more data than it needs, and that logic can be performed in the database.

3. You have a very strong DBA/Developer that can manage your data access layer that your application uses as well as code the database. This can abstract the "how" of data storage from the application developer, which can be very useful in a data-centric large application.

However, SPROCs are bad if:

1. You have to switch DB providers due to scalability, or cost issues, etc. The switching cost can be huge if there is a ton of logic buried in your database.

2. Your database nodes are CPU bound. In this case you'd want to do as little logic as possible in your DB. This is more rare nowadays, but used to happen.

3. SQL (or whatever-sproc-language) is not a core language you want your team to have to become experts in.

4. You don't like adding more code. You'll end up generating and writing yet another layer of code, this time for stuff that lives inside your database. This code has to be maintained, versioned, etc.
Not to mention you can actually afford a mortgage there.
I had some troubles with an employee of mine in the past and think he would have benefitted from a shrink (I suspect he was heavily depressed), but as the boss, I found it complicated to do that for various reasons: 1) conflict of interest 2) free will of the patient to go there 3) we're bordering on medical territory and it's a minefield for a company.

There is no happy ending, I left the company without having acted on it and the employee left recently, but as far as I know he's living erratically and unemployed now.
In most of the example he gives, these solutions are ensuring the integrity of the data stored, which I personally have no problem with; that is the job of the database in my view. If I try and store crap the database should refuse, be that via constraints, triggers or stored procedures.

As for returning the data in JSON, again, I see no problem with that; you were going to get the data out in rows and columns, what difference does JSON make, especially if it simplifies things, as he is arguing.

My main concern is business logic; should business logic be stored in the database. At this point things become a little grey, primarily due to the difficulty in maintaining and managing SQL code. I suppose that PostGres is better that most of the DBs I have had to deal with in the past in this respect in that it supports a wider range of languages for this purpose, but I'd be interested to hear others opinions and experience in this regard.
https://ghost.org/ ?
For what it's worth, I have the same locking behaviour in my Chrome browser.
Iridium – Secure Browser
Another way to look at this article: the latest (and arguably most promising) HIV prevention techniques involve treatment-as-prevention[0]; in other words, taking HIV antiretrovirals as prophylactics. Ten or fifteen years ago, this wouldn't have been possible[1], because the treatments were unpleasant enough that nobody would want to take them daily if they didn't have to.

This is an incredible paradigm shift for HIV prevention, because it completely overturns the way we've been conceptualizing it. We've always thought of HIV like polio, which we are eradicating with a vaccine. Instead, the end of HIV/AIDS may very well come in the form of the same medications we've already developed. More importantly, we already have a great distribution mechanism for HIV medications in (e.g.) sub-Sarharan Africa, which means that we don't need to re-train people and create new programs; we would just need to expand the ones we already have.

None of this would have been possible with the drugs we had in the 90s, even if we had wanted to get FDA approval for PrEP (which of course, would have been political suicide).

[0] https://en.wikipedia.org/wiki/Tenofovir/emtricitabine

[1] Technically the drug that's used for this today came out 14 years ago, but it wasn't as commonly-used, and most of the drugs back then still sucked.
>You should simply ask for the range up front or state your requirements, if you don't do that and fly out to an interview without knowing if there is overlap that's sub-optimal, it also exposes you to the sunk-cost fallacy.

Have you actually tried that? I have. I have never got a number in reply to such a question. Usually the recruiter himself does not know neither does the hiring manager. All salary talks I had were with the CEO/GM/etc. If I refused to talk with any recruiter/hiring manager who does not have a range I'd never been employed.

>Remember: recruiters approach you, they are technically in the least favourable position during the negotiations and it will benefit you to keep them there as long as possible.

This is the thing I don't understand. The recruiter is still trying to hire me if I said or have not said my salary requirements. Not saying does not appear as a strong leverage, in fact, it does not seem like a leverage at all. I ask straight what I want and am willing to negotiate down for non-monetary perks and use the scarcity of qualified applicants on the market as a leverage (e.g. mention other offers I have). I'd love to strengthen my position but I just don't see what I gain with withholding my requirements.
I don't think that RoR is the cause of Diaspora's failure. And in my opinion, saying this sounds a little bit like cargo culting.
It depends what you do...

If you need to manipulate a lot of data that ends up travelling on the wire, you can save a lot of time by running it on the server.

On the other hand, the language on the DB servers are often a bit harder to reason with.
One alternative is to live below your means and build up some savings so that you are not living paycheck to paycheck as a freelancer because that is even more of a recipe for disaster.

Look, $30k/week does sound ridiculous to me too, but Patrick doesn't strike me as a bullshitter either. He's just a great combination of programmer, businessman and marketer. As far as I remember, he never claimed to have a continuous stream of $30k/week projects lined up, those are words you're putting in his mouth to make it appear more embellished than it actually is.

The very terminology you use—"saturating" one's freelance schedule—is a mindset I've been in before, and I now think is dangerous. If you are overworked and stressed about money and billable hours, there is no free time or headspace to move up the food chain. Even worse, the quality of your work can slip due to minor hiccups like scope creep, unforeseen rabbit holes, or just getting sick for a few days; then you are undermining your future pitches and word-of-mouth!

Admittedly it's not easy to start charging more, you need to find the right clients, and you need to shift to a value-based billing where you take more risk on yourself. This is phenomenally difficult for anyone with expenses and wage-earner's mindset. However I wouldn't write off Patrick as being too privileged, lucky, or any other excuse—those things may be true, but that doesn't mean there aren't lessons that can be applied to people grinding it out at a lower level.
I agree with you 110%.

pencilblue.org is a node CMS I just read about today, but... in general, for wide adoption, PHP is still king, and even 3 years ago, it was pretty easy to predict it would be king in 2015. I'll even predict its kingship for another 2-3 years. containerization and virtualization may play a part in its downfall over the next 2-5 years, but PHP will remain one of the major widely deployed systems for a long time (and PHP7 will likely strengthen that hold).
Heavy stuff, viruses are nasty and HIV is one of the nastiest. Fortunately there has been fairly steady progress in halting the worst aspects of HIV but the stigma remains and for some reason HIV sufferers are viewed in a totally different light than say cancer or ebola victims.

When the epidemic hit in the 80's I worked with a bunch of people producing a newspaper about Amsterdam and I vividly remember the first descriptions of a new and mysterious disease that was attacking various subgroups in the clubbing scene (mostly gay people and drug users at the time, since then it has spread well beyond that and but even today the association with those groups is strong, stronger than probably warranted, HIV is a disease that certain groups are still more susceptible to but it's gone mainstream and you'd be a fool to think that because you're not in an elevated risk-group that you're somehow safe or immune).
>It's a shame because in England the therapists would not be allowed to share anything with the employers, but there's no easy way to provide that reassurance.

Additionally, if you build a relationship with a therapist, you might want to be able to continue with that therapist beyond your current employment.
Author Joel Savage
How can we possibly assume other aliens will behave exactly the way we do? That seems presumptuous. A very human centric view of life.
One thing I would likely miss living in a small forever is the intellectual input. Sure, it is nice to have exchanges through the Internet for that, but sometimes it is good to have some intriguing discussions with other driven people.

OTOH, the vibe/'cutting edge' in big cities is just a fad/false religion more often than not.

But I do think it is easier to find like-minded people or people to connect to in bigger social groups.