skysight-inc/HackerNews huggingface dataset:
Agreed.

Years ago, when I took a database class in college, I hated it. Several years later, I began working at a consulting firm on the support team. My primarily role was defect/enhancement tracking and resolution in the product we had developed for them as well as their satellite apps.

The first time I really got my hands dirty with SQL was pulling out a bunch of VBA and Access "SQL" they were using to generate reports and to rewrite it into real SQL so it could be run on the backend, which cut times down from hours to milliseconds. It was okay (I'd hate those queries now) but it's where I really picked it up.

Then the same client started calling me to write (or edit) queries to pull out some information from their database I don't think anyone had anticipated they'd ever need. That's when I started to really appreciate how beautiful and expressive SQL can be. Stop thinking imperatively - SQL will let you do it but don't. No cursors unless you absolutely have to do. You probably don't. Dynamic SQL has its place, but try to stay away from that too.

There are a few queries I still remember with some fondness. One was to determine the number of days particular classes of employees worked on particular classes of projects. Unfortunately, the way their data was modeled made this not-at-all obvious - and the date information was stored in the "start" and "end" date type fields.

There was a lot more to it, but after pulling my hair out - the customer generally needed these in under half an hour - I suddenly realized I could use a recursive CTE to generate a dataset of all days that I could use to join with, filter out any duplicates, and then use aggregation functions to get what I needed. There were a lot of other details because of the complexity of their model, but it worked and it just seemed so elegant at the end.

I've moved on to another job now and honestly, writing SQL is what I miss most. I would have never pictured myself saying that before I worked there.
New York, NY - CB Insights (www.cbinsights.com)

We're looking for:

- Tech Industry Analysts (think Nate Silver meets tech)

- Data Analysts

- Front-end devs

- Machine learning engineers

- Director of Data Products

We're bootstrapped and will be 30 people by the end of this year. Working on hard problems to assess the health of private companies using public data.

Recognized as one of NYC's top enterprise tech companies.

Most of the job postings here - http://www.cbinsights.com/jobs
RJMetrics - Philadelphia, PA http://rjmetrics.com/jobs

We're hiring for software engineers, devops, analysts, designers, business development, sales, and account management.
Some more about us:

At RJMetrics, we inspire and empower data-driven people with powerful hosted software. Hundreds of high-growth e-commerce and software as a service businesses use our analytics platform to collaborate and make smarter decisions using data.
RJMetrics is backed by some of the most successful technology investors in New York and Silicon Valley, but we are Philly born and raised. We are located in the heart of Center City Philadelphia in convenient proximity to all major rail lines.

We are a growing team tackling big problems:
- We want to transform large datasets more efficiently
- We want to push the envelope of possibility for in-browser data visualizations
- We want to make complex data questions easy for anyone to understand
- While we currently work with tools like PHP, Clojure, AngularJS, MySQL and Hadoop, we are looking for candidates who can identify the best tools for a given job and quickly adapt. Prior experience with these technologies is not a requirement.

The life and responsibilities of an RJMetrics developer include:
- Source control using git
- Continuous integration and deployment via our one-click build-and-deploy system
- Milestone and issue tracking with github and Trello
- A commitment to preventing tech debt and tackling the root causes of issues
- Comfortable working conditions and access to the best tools money can buy
There's a plugin for that. It's called "Vimacs"

http://www.vim.org/scripts/script.php?script_id=300
It comes from NeXTSTEP, text fields were given several emacs compatible keystroke editing commands as part of the key bindings for NSTextField and NSTextView.

You can modify the default keybindings and even add more emacs compatible keystrokes if you find it helpful and most Cocoa apps will inherit the new keystrokes: http://www.hcs.harvard.edu/~jrus/site/cocoa-text.html

(it's a good article that also has some interesting info on Input Managers and modifying keyboard layouts)

drdrang wrote an article that linked to several other good sources on the subject:

http://www.leancrew.com/all-this/2011/11/capitalization-keyb...
Definiteky a niche I'd like filled. A few comments.

Mobile doesn't show what you just searched for.

Also the description here is wrong:

http://zonino.co.uk/job/337

Overall pretty good.
Why 'London' and not 'UK'?
This seems to be a good example of not allowing a fundamentally different paradigm to "sink in" but rather attempting to impose a paradigm you're already comfortable with onto it. Relational databases really aren't imperative systems, and while SQL is a pretty good declarative language for relational systems, it is indeed very frustrating to attempt to use it imperatively.
A six game match is not a statistically significant set of data. And Deep Fritz hasn't played many humans in those 8 years since.

The Deep Fritz on the rating list, is that the same Deep Fritz that played Kramnik? (Notably the hardware and software version used may be different - perhaps the Deep Fritz on the rating list is weaker than the one that played Kramnik?)

And also, be careful trying to compare computer-list Elo with human-list Elo. Because participants on both lists are isolated from each other, there is a tendency for one set of ratings to be inflated/deflated compared to the other. We see this in international chess where countries that don't have regular FIDE tournaments, players either seem to be significantly stronger or significantly weaker than the prevailing norms in the bigger pool of players. South Africa, Myanmar are two such examples.
In my opinion, this would be a lot more difficult. I am slightly naive as to exactly how stockfish works, but:

Computers can do a lot of accurate brute-forcing; humans must see the position in a more holistic, intuitive way.

Excellent human players and excellent computer players are presumably doing completely different calculation tasks.

I would suggest that computers are still bad at approaching the task in a human-like way, but they will always be able to improve their method via Moore's law (at a minimum) where humans are stuck at their current level.

Stockfish might be able to tell you what it was doing, but not in a way that it would be reasonable for a human to follow.

What you are looking for is a teacher. You can pay for those ;)
The closest we have got to a teacher app is perhaps a MOOC: not much computational progress has been made.
What gets lost in these discussions is the intricacies of calories in vs. calories out.

Bodyweight should always vary based on calories in vs. calories out. You can't create mass from nothing and if you're burning more calories than you take in then you have to lose mass or else your body is a perpetual motion machine. What people ignore is that:

1. Certain things change calories out. In some women (for example those with PCOS) their calories out drops dramatically and continues to vary based on their calories in. Their bodyweight is still obeying the laws of calories in vs. calories out but the calories out drops and so it feels like there must be something else going on, that cals in vs. cals out doesn't work.

2. What people really care about is not bodyweight but bodyfat. So even though everyone obeys calories in vs. calories out you can still change what your body does with those calories by adjusting your macronutrient ratios (nutrient partitioning). Decreasing carbs can change your insulin response and cause your body to lose more fat vs muscle which is what people really want. Also your body uses carbs to create glycogen which is stored as water weight.

3. Different macronutrients affect satiety differently. If you just binge on carbs you'll generally be hungry again very soon. If you eat high fat then you'll be full longer. There are also microoptimizations that occur like shifting leptin levels.

It's the source of a lot of arguments. One camp says keto is magic, the next says it's just a trick to keep your calories low, and both are right. Diets like keto do help you keep your calories low, you can't binge and eat 5000 calories of meat and lose weight, but there are also other benefits.

TL;DR: Shit's complicated
Mainz, Germany - vastly.de

Currently, SDN use cases only affect the networks within datacenters or campuses. With vast.ly, we address the WAN, one of the last IT areas that exists out of reach for most developers. We think that developers deserve control about which network routes, ISPs and countries their content passes to reach users! It's time for the democratization of the internet backbone.

We are looking for talented software and network engineers. If you are interested to develop distributed software and already had a hand on OpenFlow, BGP or OSPF mail me sspies [AT] sloc.de

We offer a competitive salary and the possibility to work from remote.
When I see people complain about SQL, "mathy" never seems to come up. Mostly it's "tries too hard to be English".
Google Privacy Law ‘Means Total Rethink of Basic Freedoms’
All I know is that, for some reason, I'm feeling rather shocked after visiting that mess of a site.
As Ties With China Unravel, U.S. Companies Head to Mexico
Some comments, which may be obvious:

* I have not tested Kuzu in production yet.

* It has a tiny fraction of the power of real projects like Hadoop, Storm, Spark, and so on.

* I created it because I wanted a simple way to run maps, reduces, and filters over many machines without making big changes to my original Clojure code. For this simple use case, many distributed computation systems seem quite complicated, so I thought it would be fun to write something extremely simple.

* I was inspired by how PigPen https://github.com/Netflix/PigPen offers a very natural interface to Clojure. I wondered if that could work on top of something simpler than Hadoop + Pig.

* This isn't the first time something like this has been done. See net-eval for example http://nakkaya.com/2010/02/16/net-eval-dead-simple-distribut....

* Kuzu may or may not be useful to you, but I'd be interested in any and all commentary.
SEEKING WORK - remote

Consulting on web scraping projects ($100/hr). Also, I built http://screenslicer.com (an automatic, zero-config web scraper which costs $80/instance/month) and am happy to integrate this into your project at a very affordable rate ($15/hr).

dan@machinepublishers.com

https://machinepublishers.com

http://screenslicer.com

https://www.linkedin.com/in/danhollingsworth/
Durham, NC - Automated Insights (automatedinsights.com)

http://automatedinsights.com/careers/

Looking for Ruby developers (front-end or back-end). We just moved into our new offices in downtown Durham overlooking the Durham Bulls ballpark. Come and join us!
Chess is a fun hobby, and I feel it gets more fun the better I get. That's a good enough justification for me.
Star Fleet Battles Oolipu Mimus Huntship SSD
The Oolipu are fierce new empire for Star Fleet Battles. The Oolipu are part of Omega Regenesis,
A very good Saturday essay that two of my Facebook friends told me about, and I'm glad to see that it was already submitted here, as it deserves a read from all of us who have ever commented in threads about "genius" or "geniuses." And the first two comments here, by kenjackson and j2kun, are very good too. What Jordan Ellenberg, a member of the Study of Mathematically Precocious Youth, writes about here is based on the extensive modern research on the development of advanced young learners of mathematics and other subjects. I recently heard a talk about this line of research by David Lubinski[1] (mentioned in the article) and I have been following this research[2] for years.

Summing up the research, yes, it's good to be supportive rather than oppositional to children developing their special talents in their youth. But the most talented young people will not save the world. We will save the world together through lots of incremental improvements, the kind of incremental improvements we discuss here on Hacker News. Personality traits (one could also say qualities of character) like curiosity and persistence matter quite as much as raw brain power in allowing young people to gain the best development from having good learning opportunities, and good learning opportunities are important for all learners.

[1] [vid] http://mediasite.csom.umn.edu/Mediasite/Play/2eeb0fa1c5f6408...

[2] Related articles: https://my.vanderbilt.edu/smpy/publications/david-lubinski/
And yet the people most able to understand the breadth and scope of the surveillance problem are also probably those most vocally against, say, the right to bear arms of significant efficacy.
I get you. I set the draw probability to as observed, whereas you set the number of draws to as observed. But really I just meant to point out you were right (while giving a simulation that didn't involve explicit conditioning).
San Francisco

Full-time and/or Internships for the summer. Go is the language of choice for all of our new projects and we work closely with Docker, InfluxDB and other great OSS. We're looking for platform engineers, ops engineers, software engineers and product designers - https://www.nitrous.io/jobs

We are shaping the way developers work in the future and we are building a product that developers love and use everyday: https://twitter.com/nitrousio/favorites

We've recently been armed with $6.65M in Series A funding from some great investors and we also have on board James Yu (Co-Founder of Parse), Joe Stump (Co-Founder of Sprintly/SimpleGeo), Tobi Luttke (Rails core and CEO of Shopify) as our advisors.

We just moved into a great office in South Park, San Francisco and we're looking forward to some exciting product launches in the next year!
I am not sure what is the situation today; in 2005 when I wrote nested-sets implementation for TSQL and benchmarked it against Oracle's START-CONNECT extension it was a few milliseconds vs seconds for large hierarchies. Of course, nested sets need an occasional rebuild of the whole hierarchy so they are only useful for mostly static hierarchical data.

If you have only a couple of levels, you are probably fine with what your SQL server offers; for huge amount of hierarchical data you need to use something smarter.
What exactly are row types? I believe Ermine also features them, but searching doesn't yield very informative results.
Downloaded and installed.

I tried to use it but the ads were too much of a distraction. I understand the need to monetize, but flashing, rotating ads in your face while you try to do something is too much to take and not worth the time.

Apologies.

Uninstalled.
Boston, MA - Find & Form (Findandform.com)
Mid-level iOS development lead

Find & Form is a digital design and development agency in the South End of Boston focused on creating unique mobile and web experiences for a range of amazing clients.

We are seeking a passionate and talented in-house, mid-level mobile development lead that has shipped mobile applications, specifically iOS products. Ideally you have worked with a range of industries and understand certain pitfalls and best practices. This position requires managing a team of remote developers that consist of front-end, back-end, & QA specialists. You will not be coding all day. You will be communicating with clients, designers, product managers, and strategists.

You will work directly with the founding members of Find & Form creating unique products using the latest in mobile technology and helping to grow our expanding development team. Our clients range from early stage seed startups to trusted industry leaders so there is no shortage of challenges. You will be working with emerging technologies, such as iBeacon communication, mobile commerce & mobile payments, and location based systems.

Read more here: http://bit.ly/1tziL9t
Email us at: shout@findandform.com
I think you're exactly right about SMR. Haven't tried mining the HN lists yet, but that kind of seemed like cheating! All of these jobs come straight from the startups' own sites.
Yeah the SQL vs. NoSQL thing conflates so many different concerns. Sometimes it's about not wanting to do things relationally, sometimes it's about trading off ACID for other concerns, and sometimes (most rarely, it seems to me) it is actually about the SQL language itself. I don't think the language is really so bad (inconsistencies across databases aside), but I'd be interested in taking a look at a redesigned language that does all the same stuff but cleans a few things up.
Just a suggestion: a landing page should immediately show some captivating examples telling me why I should be interested.
How about the opposite? Make 2+3=4, here in C.

add2And3(int *a, int *b)
{
*a = 3;
*b = 2;
printf("%d", *a + *b); //4
}
void main()
{
int storage;
add2And3(&storage, &storage);
}
At least some site that can filter "C++" skill. Thanks!
Yes you absolutely can rewrite history.
SEEKING WORK - San Francisco - Remote - Travel Possible

Experienced pair of software developers with a history in startups. Proficient in:

* Python ['django', 'bottle', 'google.app.engine']
* Javascript ['angular','backbone','node'];
* Clojure '(Compojure)
* Haskell, Go (and other esoterics)

We've helped entrepreneurs develop their MVP, as well as large companies develop core features. We provide services such as feature development, product management, and software auditing. Previous engagements include Getaround, Codecademy, Factset, Wakemate, drip.fm, Swiftstack, and Changetip, among others.

For more info see our page at http://turbines.io, or talk to us at hn@turbines.io
How to Create a Bestselling Novel (2000)
TeachBoost - New York, NY https://careers.stackoverflow.com/jobs/58426/front-end-devel...

TeachBoost is looking for a full-time web developer for our Brooklyn, NY office who can handle all aspects of front-end web application development. We're looking for someone to be a key member of the development team - so experience (or the ability to learn quickly) and attention to detail are massively important.

We're moving from a single-repo PHP legacy application towards a client-service, multi-repo application codebase. To do that we'll be slicing off features from the PHP legacy app and re-writing them into front-end, client applications, in Node.js.

TeachBoost is a performance management platform for education; we help educators improve by streamlining and improving the coaching/evaluation process, and using that data to better inform educator development/training. We're a growing team of passionate, mission driven people - and looking for more of the same!

Get in touch with jason AT teachboost.com if you're interested!
Agreed. Code samples are one of the most effective ways to communicate an idea of how ones library/language/whatever works. Also, a layout that doesn't make it look like the site was written in 1996...
Are there really no good GUI libraries for Go, and if so, is anyone working on correcting this?
My personal reason for choosing homeschooling for my four children, after discussions with my wife about our childhood educations in two different countries, was to ensure flexibility so that we would never be slowing down our children's education. That has allowed them to learn more at younger ages than is typical in United States schools, even in a good school district like the one we live in. This school year, all three of my children who are still minors are actually enrolled in public school programs (one full-time at the local high school, and the younger two full-time in an online public school). Next year we will try something different again. Flexibility and the opportunity to mix and match learning resources with children's needs is why we homeschool mostly, relying on outside resources as needed.

My badly neglected personal website[1] (I've hardly updated any page on it for YEARS), provides some more details of my thinking about homeschooling, current to a decade ago and perhaps not fully representative of my motivations today.

[1] http://learninfreedom.org/
Are suggesting that a multi-million dollar program can be defeated by a three-cent bullet and the will to do the deplorable?

Surely you jest--I suppose next you'll be asserting that you can cause billions of dollars of economic damage using only some box cutters!
Are there any speech to text systems out there that could do this reliably, say 80% accuracy?
Hey, thanks. I've deactivated that job and I'll fix it up later. Really appreciate the heads-up!
While, as you point out, the benefits of modern life outweigh the disadvantages, that does not mean that we can just ignore those disadvantages.

Precisely, and I'm glad you also picked up on what I considered to be the obvious point of the article. The commenter above (despite so magnanimously giving his valuable time over and over and over to educate the rest of us) appears to have completely missed this. As the article author himself clearly states, antibiotics have been a huge net positive for humanity, but this doesn't mean that they don't also have downsides.

It is these downsides that the articles addresses; antibiotics are posited to play a role in the dramatically increasing incidences of immune system dysfunction that are now observed in westernized societies.

Overuse of antibiotics not only leads to decreases in their efficacy, but can also destroy diversity in our microbiomes, damaging our immune systems, making us more vulnerable to pathogens and possibly also leading to developmental problems.

Reducing overuse of antibiotics, especially in young children, should become a central priority for health systems, perhaps complemented with probiotics and similar measures.
Today. If you're planning long-term, it's reasonable to assume a non-zero chance of dividends being taxed more inline with normal income.
I think a lot of these job ads would be much more attractive if they actually listed the average/expected salary or at least the range. I kind-of understand why they don't, but it still frustrates me.
Deep Learning Business Models
Good list, there were a few I hadn't heard of. Most notable omission, and among my favorite fictional computers: the Sophotechs from the Golden Age trilogy by John C. Wright.