skysight-inc/HackerNews huggingface dataset:
I think that the biggest problem with SQL is more around the actual syntax of the language and how verbose it feels to write complicated queries.

I would prefer a syntax layer that can be compiled / transformed back to SQL but that does basic things like having a query start with the tables, then joins, then groupings then the final projection.

Also a less cumbersome way to use the "WITH" statement to form named sub-queries.

Perhaps something like:

SELECT
COUNT(*) as columns,
column_type,
table_name
FROM (
SELECT c.id,
c.type AS column_type,
t.name AS table_name
FROM tables t
INNER JOIN columns c
ON t.id = c.table_id
WHERE t.system=false;
) a
HAVING COUNT(*) > 1
ORDER BY columns DESC

Being re-written as:

# Use ":=" to replace WITH for named ephermal views
# Replace "WHERE" with "?", "SELECT" with "|>" at the end
non_system := tables
? system=false
|> name:table_name, is:table_id

# Replace INNER JOIN with "*="
non_system_columns := non_system.table_id *= columns.table_id
|> c.id, c.type:column_type

# GROUP BY columns are automatically generated by non-aggregated columns
column_types := non_system_columns
|> COUNT(*):columns DESC, column_type, table_name

So the final query may look like:

non_system := tables ? system=false
|> name:table_name, is:table_id
non_system_columns := non_system.table_id *= columns.table_id
|> c.id, c.type:column_type

non_system_columns
|> COUNT(*):columns DESC, column_type, table_name

Any thoughts on this?
I think you are mistaken - in the audio:
http://storage.googleapis.com/androiddevelopers/android_deve...

Around 27:55 they discuss that they plan on lifting the limit. Indeed modifying the dex format is talked about and it is mentioned that it is a future goal.

They also speak about multidex, the interim backwards compatible fix which does not require modifying the dex format (but uses a hack) and will make modifying the dex format easier in the future.
I thought LightTable is an IDE, not rethinking programming :) Anyway, great thinking, I've actually come to a lot of the same conclusions. I'd suggest an inspiration: spreadsheets. Can you implement the separation of data model from indexes/optimizing physical model in an ad-hoc spreadsheet-like UI? When thinking "spreadsheets" you should think about not just Excel, but also Lotus Improv (which is a more structured spreadsheet, which is both a strength and a weakness).
It sounds like you're using a PowerPC-based Mac.

Have you considered installing a variant of Linux on it, so that you can use a new Firefox?
I think it's pretty rare to set out to hire a wolf, although a manager of a large, well-resourced team could do so just to shake things up. That would be tough, though, since it is very difficult to come in from the outside and perform as a wolf immediately.

My own experience has been, instead, that a wolf emerges from the herd after 6–12 months. They've learned the culture, they've learned the personalities, they've learned the dividing line between the strictly forbidden and the mostly forbidden. Your juvenile wolf will show a propensity for solving long-standing hard problems that had long been deferred or inventing new trifles. A cowboy may act similarly, but generally gets into more trouble and has less substance behind his solutions. A kludge is a hack that works; a wolf is a cowboy who gets the kill.

It is at this point that you must act to place new wolves in an environment where they can excel. I think customer-facing interdisciplinary teams work well, where success is demanded, glory is possible, market feedback is immediate, and they provide unique skills to the team. You can also place them on more seasoned technical teams, where the burden of management is a bit lighter.

I am a wolf (it's been over a decade since I told my first manager I wanted to become "the wolf", a la Pulp Fiction). There are downsides. The more process-driven the management, the more battles you will have to fight. The wolf often wins, but not without injury. Corporate combat is exhausting and, worse, can become an end unto itself. Also, being always on the hunt often precludes working on a single large project for a sustained period of time. A wise wolf must remember to hunt big game instead of feasting on readily-available mice.

In other words, it's easy for the wolf to become the asshole. Both proper management and self-awareness can keep this from happening.
Sorry man, the needs of the many outweigh the needs of a few nerds.
Another problem with so many of today's "appified", needlessly animated websites is that they are rarely as accessible (as in, usable by people with disabilities) as their simpler, text-and-image-based predecessors used to be.

Just because <canvas> and cool CSS3 hacks are part of the W3C standard doesn't mean that you can use them wherever you want. If you use CSS3 hacks to convey meaning, that meaning is lost not only to old IE users but also to anyone who is visually challenged. Sooner or later, this is going to become a taboo, and all of us who did it will drop our heads in shame as if we'd used tables for layout. (Tables were, and still are, a W3C standard after all.)

On the other hand, I do want to discourage people from using IE7. How do we do that without turning every webpage into a shiny animated app? My answer would be simple: wrap all my CSS and JS links in a conditional comment that hides them from older versions of IE. Give those users the authentic Lynx experience. After all, it will probably be prettier, not to mention more accessible, than any "graceful degradation" hack that I can cook up.

Older design? That's too nice. What about no design? (Remember, your site should still work fine with no design.)
SEEKING WORK: Vancouver or Remote

Same as last month. I'm booked for September but open for October. Probably need 30 days of lead time for an engagement.

I have been building iOS Apps since 2008. Build Android Apps, too. I'm also somewhat of a passable Ruby/Rails developer. I was a game developer in a previous lifetime. I have been writing code for more than 15 years now. I have built and managed teams.

Github: http://github.com/kaler
LinkedIn: http://ca.linkedin.com/in/kaler
Website: http://parveenkaler.com
Contact: pk@smartfulstudios.com
> The reality is, however, that people are joining much, much faster than they're leaving.

I'm not saying this is the case with Twitter, but early adopters leaving (or reducing use) -- even while total adoption is on the rise -- might be a sign of unsustainable growth: http://data.heapanalytics.com/what-unsustainable-growth-look...

If your growth is always in new markets, that might be because "they're not onto you yet". Eventually you run out of markets. If your product is unchanged yet early adopters leave because some quality you have no control over changes the experience, that could be a really bad sign.
You should check out TenFourFox. Some heroic developers have ported the latest versions of Firefox to old versions of OSX, including, it looks like, 10.4.

http://www.floodgap.com/software/tenfourfox/
Hi! I'm looking for the right opportunity and I'm in no rush. I'm very good at iOS development and if a job exists that lets me stay in my current location while working on something awesome I'll definitely consider making the switch (currently I'm doing freelance work). Get in touch if you have something that fits!

Location: New Jersey

Remote: Yes, preferred

Willing to relocate: Reluctantly

Technologies: Expertise is iOS. Expert in Objective-C and all Apple Frameworks; Familiar with Rails, Django, Frontend Web Dev.

Resume: Check my website for more info, http://juliusparishy.com

Email: boss@jparishy.com
Marketo (http://www.marketo.com/)

Locations: San Mateo, Portland, Atlanta, Tel Aviv, Dublin

Background: Marketo provides easy-to-use marketing software that turns marketing from a cost center into a revenue driver.

Roles: Software Engineer, Solutions Consultant, Product Manager, Account Executive

Apply: http://jobvite.com/m?3HryEgw5

=========================================

Any questions? Please email me at mmanzur@marketo.com
Websrvr – Deploy your websites to cloudfront using dropbox in a jiffy
Ask HN: Is 25 too old to get your first job at a startup?
I live in Los Angeles and I don't have a ton of prior work experience. I worked at a PE type shop for ~8 months and then started pursuing a skillset in technology. I have a BS in Economics and minors in Marketing & Biz Admin (so not tech related at all). I taught myself html/css/sass and am pretty capable with JS and JQuery. I am doing a 3 month bootcamp so I can polish my skills and learn Ruby and about a few different databases. When people come out of these bootcamps they end up working at small web dev shops and frankly that isn't very compelling to me. I want to work for a start up but am worried I am too old for entry level and possibly won't have the right skillset. Anyone have experience interviewing or hiring someone like this?
For sensitive sites like this, users should not be given the option to use the same username/password as other websites: The username should be issued by the site in the form Sally379687 or Fred965912
Just a few suggestions... first: post to a local mac user group forum near you. second: consider a virtual machine or dual-boot to a linux OS...

I don't know what programs you use regularly that tie you to OSX, and can understand the need for them, that said, there are options that are available to you.
I follow a small number of people. The people I follow are followed by a small number of people.

This creates more of a small room atmosphere. If you piss all over the place, you're going to be back online tomorrow with the same folks.

Over and over again I learn the lesson that Twitter as a broadcasting medium sucks. Twitter as an open chat room is tolerable. More accessible than IRC.

I suspect others are coming to similar conclusions.
Saving money by using an long-life PC is not a "nerd" thing.
Also, when you're writing scientific code (Monte Carlo simulations, for example, or disordered systems), the folk wisdom is that you must to keep track of what seed you used. I've never had to use these records myself, but I can image wanting to go back and reproduce exactly the same calculation, for (e.g.) debugging or verifying new code. Now you think about resurrecting some previous grad student's code that only works when used in exactly the right way and has documentation scattered through comments and notebooks---which is perfectly natural, since he probably didn't think anybody else would ever use it---and a change in PRNG algorithm could be immensely frustrating. Or think about trying to re-run old code to compare with new analytical results: you'd want to verify that you're getting exactly the same results, as a way of checking that there isn't some other bitrot hidden away somewhere.

(Now, why one would be using Java for Monte Carlo simulations I haven't the foggiest idea.)
If it's specified, I don't mind people relying on it. That being said, Java is over-specified in many ways, this potentially being one of them.

I know Python does not have this guarantee.

Personally? There should really be a couple different RNGs in Java's standard library - all combinations that make sense of [insecure/secure, can set seed / can't set seed, thread-local/global] (local/global being without distinction if one cannot set the seed). The default being secure / can't set seed.
Right, but it's declarative. You only care about how the DOM looks right now.
This (what you described) is basically how most optical illusions of the type of "look at this thing then look at this other thing" work, but this one is a lot stranger than most in that the effects of it can reportedly last for up to 3 months.

I can't vouch for that directly, but I'm still seeing it an hour later and some other responses here have mentioned that they actually are still seeing it months later.

Other optical illusions that rely solely on the mechanism you're talking about fade in under a minute.
Circum,provide a local mobile anonymous sharing space for every crowded area
The problem isn't the resources. It's the avoidance of creating an unelected bureaucracy with a lot of power. As it is, the judiciary is really quite lean. The Justices have a secretary, and four clerks, usually recent grads that only spend a year on the job. And that's really it in terms of staff, discounting court administrative staff. The lower courts are all just as lean. If you add a staff of researchers, you're adding a whole new class of people with influence.
Quantopian (https://www.quantopian.com/about), Boston, MA

Quantopian is hiring software and operations engineers to help us disrupt the world of finance. We've built the world's first web-based algorithmic trading platform, and we're growing our team to support our rapidly expanding user base and to build everything on our ambitious product roadmap.

We're well-financed by some of the savviest investors in the business (Spark Capital, Khosla Ventures, GETCO, and various individuals).

We work on interesting problems, such as:

* Running arbitrary user code on our own servers, with all the associated security implications

* Designing and building intuitive and powerful research and development tools and APIs for our users
Designing data stores to model real-world financial data and optimizing them for high throughput when running trading simulations

* Communicating with broker APIs to trade real money on our users' behalf

* Metering and autoscaling our cloud infrastructure to respond to varying load

* Designing and building an amazing user experience, both on desktop and mobile

So far, we've built Quantopian with Python and Ruby on Rails (and a little Node.js) on AWS and Heroku. We depend heavily on Redis, and our Docker usage is rapidly growing. However, we are very pragmatic and our highest priority is shipping user-delighting features built with the most sensible technologies. Be sure to check out Zipline (https://github.com/quantopian/zipline), our open-source backtester. We have several other projects that we plan on open-sourcing as well.

We've assembled a top-notch product and engineering team here in Boston, and we're growing fast. We're open to all levels of experience, from still-in-college to seasoned veteran. A financial background is not necessary at all (but is always nice to have).

We're still small enough that you will have a material impact on our company's trajectory. Our small size and ambitious goals dictate our approach to talent acquisition and retention: we believe in hiring the best engineers and giving them hard problems to solve and the autonomy to solve them.

Ideally, you:

* have a solid background in computer science fundamentals

* have good communication skills

* thrive on designing, building, and shipping mind-blowing features that delight our users

We provide:

* All the standard stuff (fully paid health and dental for you and your family, 5% 401(k) matching, gym and phone reimbursement, pretax transit, weekly catered lunch).

* Your choice of computer equipment

* A beautiful new office (in October) in downtown Boston

* Fun and intellectually stimulating work environment. We ship early and often. We have lives outside of work. We like each other.
Let me clarify. I love good code, but many investors do not know the difference and are more interested in the pitch instead of the product.

It does not mean I approve or code in that manner myself, but that I have come across hack jobs worth buckets and great code worth nothing.

It is just a fact of life.

Also yeah... wolves get bored and can be very destructive or just check out to other projects.
> It is amazing for mining connections between people

What do you use for mining Twitter's interest/social graph?
Capitalism is pretty new to China. Check back in 20-50 years.
More UX change is on the way, http://www.businessweek.com/articles/2014-08-28/daniel-grafs...
Thank you for pointing out that this paper of Sheldrake's was indeed peer reviewed. That paper also mentions that three independent scientists were invited to attempt to replicate Sheldrake's work.

In this paper by one of those scientists http://www.richardwiseman.com/resources/psychicdogreply.pdf one of the scientists (Wiseman) reports that they were in fact not able to confirm Sheldrake's findings, that Sheldrake had criticized their criteria for measurement _after_ they had led to failure, and badgered them into arbitrarily establishing other criteria for success.

Wiseman also complains that he and his colleagues were badly misrepresented in Sheldrake's paper, and that Sheldrake tried to present excuses for the failed trials.

This post hoc selection of evaluation criteria is one way in which crackpots massage experimental data to substantiate their claims. Honest scientists usually do their best to avoid it.

In conclusion, in the one instance where an attempt was made to verify Sheldrake's strongest results, he was seen to be acting in a manner suspiciously characteristic of trying to introduce a bias in the direction he preferred.

Even if he isn't intentionally dishonest, this man is almost certainly a crackpot.
The parent actually has personal experience working with Steve Jobs, which isn't something a lot of people on this forum can say. That makes his views on the man much more interesting than yours or mine, whether or not you agree with him.

The 'Wolf' type we are discussing is basically a cartoon superhero outfit for aspiring engineers to wear. Lopp is adept at these kind of character sketches of fantasy nerd stereotypes (he doesn't play by anyone's rules, but he also works miracles!). The fact that no one in the thread seems to be able to agree quite what it means demonstrate what a nebulously defined concept it is.

I'd much rather sit and read some Steve Jobs stories from someone who was actually there.
How to Increase User Sign-Ups with Examples ( Justdial.com, Cleartrip.com)
The skyline problem
This can be made to integrate to CI to perform regression test.
Exactly. At best, abortion is a fallback rather than a default. Surely you'd like everything you can along the lines of sex education and birth control (free condoms, free implants, etc) before you even get to abortion.
The article is light on facts, but al-Qaeda and ISIS are in fact enemies. They are separate groups that share a similar ideology, but ISIS is pushing out al-Qaeda instead of working with them.

The article also does not imply that the US and al-Qaeda are working together, only that stopping ISIS benefits both parties.
Drug warriors and arms dealers get paid well to put poor drug users in jail or coffins.
Try these changes instead. Untested, but it should work

# String is read only.
.section .rodata
msg: .asciz "hello, world!\n"
# Put string length in a variable instead
.set STR_SIZE, . - msg
# <snip>
mov rdx, STR_SIZE
>People are growing out of things, thinking platforms are getting old but forgetting that sometimes it is simply them that are in fact struggling to adapt to fast evolving ways to use a concept as generic as Twitter.

Yeah, but sometimes services, even as generic as Twitter, simply fade off too.
So, incredibly off topic - but do facilities like this scare anyone else? I've always had this incredibly irrational fear of really large things like this when they're connected to water. And anyone ever see pictures of water sinkholes? Seriously gives me the creeps.
"I have found that my greatest frustrations with Twitter come not from people who are being nasty — though there are far too many of them — but from people who just misunderstand."

This is not different from life outside of Twitter (or Facebook or Instagram or The Internet for that matter). It's life. A fraction of people will always 'misunderstand'. The Internet has generally attracted open and eager people to the platforms it builds, but as things go more mainstream, you're going to get some 'normalcy'. The Internet population becomes the rest of the global population.
From memory, he made those comments after he'd been working for a long time in C/C++. He's since seen that language like Haskell and Ada which enforce much stricter requirements have a huge benefit to developers; the inital extra work to learn the language pays off when you get used to spotting even more bugs before you write them because you've been punched in the head by the error messages in the past. You begin to think about code not just from a "how doI get this done?" standpoint, but a "how do I get this done properly, safely and clearly, and make sure the compiler will catch me WHEN I make mistakes". Fixing bugs at development time is vastly less expensive than in testing or after release, so the extra errots can easily be justified.
The Passenger Pigeon lived in an environment where flocks were found everywhere. An individual pigeon could safely "wander off" and find a new flock. Once the population level descended below a critical level, the species was doomed. In order to bring them back, you would need to breed them by the millions before releasing them.

A more practical worry is the Rusty Blackbird, which has declined fast in recent decades and may be headed the way of the Passenger Pigeon.
I miss Jon Stokes articles. They were the best thing of Ars, along with Siracusa's writings.
Do you have any other sources? When one company bashes a competitor in general I'm skeptical. I also know that the Ecosphere company sells larger installations for businesses and museums which gave them some credibility in my eyes (back when I first bought one).

It wouldn't surprise me much if you were right.

I don't plan to buy another though. It's been neat to watch, but after 6+ years (since I've had two spheres) I'm satisfied.
And certainly don't throw it out. Take out the hard drive and sell it. If it's a working Mac of any kind, you can usually get a fair amount for it.
As soon as you sign up for websrvr, we create a folder named "websrvr" in your Dropbox, any folders added to this will be created as sites on cloudfront. So, you don't even need to login to websrvr after the first setup to create new sites.
>most of the conversations could have happened in twitter-form, and not much would have been lost

Actually all the nuance would have been lost out of the Republic in that way.

Philosophy (and literature for that matter) is never just about the concepts or "plot", it's always about the way in which they are conveyed.
I understand that the article explains Putin's position, but explaining Putin's own reasons for his actions doesn't come anywhere close to implicating the US or Europe.

And even so, it's not the article's main focus. This is: "the United States and its European allies share most of the responsibility for the crisis."

Most of the responsibility? Really?

It would be one thing if he said "Putin's crossed the line, but the US and Europe could have played better politics to prevent this crisis." Then, maybe, he'd have a point.

But he's putting the responsibility of the invasion of a sovereign nation and the annexation of its territory with no regard for the self determination of its peoples on the shoulders of the US and Europe, which is just backwards. Mearsheimer can't make NATO responsible for Putin's thuggery, for the same reason that you can't make the twin towers responsible for 9/11.

I have to dismiss your analogy outright because clearly, Ukraine didn't get to vote to have itself invaded by Russia. If there was a whiff of credible evidence that Ukrainians en masse had a democratic desire to be a part of Putin's Russia, it would be a different story.
I've found it interesting that Twitter is a completely different experience for Chinese speakers, where it acts more like a 70-word limit would for us.
Reddit has been drowning in anecdotal evidence for years.

Low-fat, high-carb flat-out kills people.

http://reddit.com/r/keto
This is fantastic news. It's a feature I've been missing since you introduced 2FA (which was also a great move)