skysight-inc/HackerNews huggingface dataset:
The thing is, CTEs are not named subqueries. They are supposed to execute just once, even if used on multiple places in the query.

This causes a number of challenges for the planner, because:

* some of the places may benefit from quickly producing the first row (e.g. in EXISTS) while other places may need all the rows (e.g. when you pass the rows to GROUP BY or something)

* the places may use additional clauses, but these can't be pushed down to the CTEs because that'd influence the other place

There may be databases with planner that handle this in a different way, but in PostgreSQL the CTEs act as optimization fences - each CTE is optimized on it's own, without considering the rest of the query (additional clauses etc.)

People who use CTEs as named subqueries are often surprised by the impact this may have on the plans performance-wise.

Consider for example this:

CREATE TABLE foo (a INT UNIQUE, b FLOAT);
INSERT INTO foo SELECT i, random() FROM generate_series(1,1000000) s(i);

CREATE TABLE bar (a INT);
INSERT INTO bar SELECT i FROM generate_series(1,1000000) s(i);

WITH foo_filtered AS (SELECT * FROM foo WHERE b < 0.5)
SELECT * FROM bar JOIN foo_filtered USING (a) LIMIT 10;

QUERY PLAN
----------------------------------------------------------------------------------------
Limit (cost=36986.19..38236.83 rows=10 width=12)
CTE foo_filtered
-> Seq Scan on foo (cost=0.00..17906.00 rows=510375 width=12)
Filter: (b < '0.5'::double precision)
-> Hash Join (cost=19080.19..63848915.94 rows=510375 width=12)
Hash Cond: (bar.a = foo_filtered.a)
-> Seq Scan on bar (cost=0.00..14425.00 rows=1000000 width=4)
-> Hash (cost=10207.50..10207.50 rows=510375 width=12)
-> CTE Scan on foo_filtered (cost=0.00..10207.50 rows=510375 width=12)
(9 rows)

and without the CTE:

SELECT * FROM bar JOIN foo USING (a) WHERE b < 0.5 LIMIT 10;

QUERY PLAN
----------------------------------------------------------------------------------
Limit (cost=0.42..10.26 rows=10 width=12)
-> Nested Loop (cost=0.42..502029.00 rows=510375 width=12)
-> Seq Scan on bar (cost=0.00..14425.00 rows=1000000 width=4)
-> Index Scan using foo_a_key on foo (cost=0.42..0.48 rows=1 width=12)
Index Cond: (a = bar.a)
Filter: (b < '0.5'::double precision)
(6 rows)

All because the planner was unable to consider the join condition and the LIMIT 10, when planning the CTE.
afl-fuzz gets a lot of press because it's neat, because like Peach it's a well-packaged version of a tool every tester has their own half-assed version of, and because lcamtuf wrote it and everyone likes lcamtuf.

It is not, however, responsible for most security bugs. Most testers don't use afl-fuzz.
Intellectual property in an age of fanfiction
Introducing Vuo 1.1 – Export movies, talk to serial devices, and much more
> A canonical example of a killer app is something like Lotus 1-2-3 for the PC, or Halo for the original XBox -- something so compelling as to drive adoption of the host platform.

True, and I don't think the listed command-line utilities do that. OTOH, I do think that that presentation hints at the truth -- the "killer apps" that are driving Linux adoption aren't a big flashy end-user-facing 1-2-3 style apps, or even apps in the traditional sense, but lower-level more-technical features/tools that make developing on and for Linux attractive, or make Linux attractive for use in cloud deployments, etc.
Sedgewick's course on Algorithms, through Coursera, is pretty good, for anyone who wants to learn more about basic algorithms, or (like me) needs a refresher.

https://www.coursera.org/course/algs4partI
Fog Creek Interview with Peteris Krumins
TLDR; Anonabox can be rooted with minimal effort (backdoor wide open). The attack vector is an undocumented web interface with a hard coded password ("admin"), an open SSH port that accepts the same credentials, and grants root access.

It is clear that they are lazy and a little out of their depth, but are they malicious?
Linus says of the Github platform -

That's partly because of how the kernel is developed, but part of it was that the GitHub interfaces were actively encouraging bad behavior. Commits done on GitHub had bad commit messages etc, because the web interfaces at GitHub were actively encouraging bad behavior. They did fix some of that, so it probably works better, but it will never be appropriate for something like the Linux kernel.

I haven't ever looked at the kernel workflow, nor have I ever heard systematic criticism of Github's methodology. Does anyone else have input on what Linus may mean by his opinion?
Ah, thanks. That part was missing from the issue.
>over-hyped blog post

It's not over-hyped until there's a $1mm kickstarter ;)

Also you're not leaving my co-author a great impression of the tech industry.

She's been reading this thread and you people are being terrible.
The more and more people I talk to, the more the conversation sounds like this.

There was a period of time -- and I hope we're over it, for the most part -- where "biggest, best, craziest, and most expensive" was the motto. It doesn't work; I've personally been to a couple of those huge hackathons and was really frustrated by the experience.

I work for an org that runs a nationwide (in the US) series of events called CodeDays that are somewhat similar in format to traditional collegiate hackathons and those are exactly the kinds of experiences we're trying to create, so we have a pretty strict limit on prize size, we only allow 100 students per city, we market to younger students, etc.

That's worked out incredibly well for us. A couple of the people profiled in this article actually got their start at a CodeDay.

(Interesting, CodeDay is also much much cheaper than these huge hackathons and we engage more students, just distributed across 30 cities.)
Do you know how well this actually works for people in practice? My friends, acquaintances, and coworkers know I'm frugal, but I avoid telling them it's because I donate a lot of my money. People can become very defensive and judgmental hearing about people who donate or are otherwise "do-gooders," and I just don't like that kind of attention.
Very brief history is here:

https://www.gnu.org/software/hurd/history/port_to_another_mi...
so if i understood, when you launch processes in a debugger, it will walk the list of functions and instantiate them.. this means you could craft a bit of cleverness to detect whether app was launched from a debugger with minimal overhead, by tripping up an uninitiated pointer.

none of this works for debuggers which attach AFTER the process starts though.. so if I were a MALware creator, this might be a handy trick to force different code paths while someone is snooping my newest creation. the only way to know it was going on would be to do a static analysis (which i imagine, is more effort).
Firefox supports VP9 but currently does not enable VP9 with MediaSourceExtensions (MSE) by default. You can enable the current implementation via a flag set media.mediasource.webm.enabled to true in about:config

Youtube only used VP9 with MSE but even then not all content is available as VP9, some is only available as H.264/MSE.

You can check https://www.youtube.com/html5 to see what your browser supports.
Definitely not practical in Java.
From a purely financial, self-interested standpoint, how does a donation to charity which reduces taxable income actually help a person? If I reduce my income by $100, it's true I won't have to give the fraction of that to the government that I might have, but now rather than being out a fraction to the government, I'm out the entirety to the charity.

Even in the case where the donation drop the payer to a lower tax bracket, I don't see how it helps. Any insight greatly appreciated.
Thanks! It queries YouTube's API so it doesn't hit my server at all for these requests. Ractive.js makes it easy to show search results using a consistent interface.
> It may be the country's Christian leanings that contribute to this

Maybe so. I was taught to tithe 10% of everything I earned starting with my grade school allowance. 10% to God (which could go to a church or charity) and 25% to the bank. Everything else got spent on Legos and whatnot.

Fast forward twenty years (I'm 25) and I still siphon away 10% of my income into a separate account that I save for either church donations or charitable causes. At that point the money isn't really "yours" or at least that's what is typically taught in Christian culture. Makes it a lot easier to spend it on others.
“Please help me understand the value of working with a VC”
What about a comparison with HEVC?
Healthcare IT – The Next Big Thing for MSPs?
Even false prediction have truth behind them. Just because the author mentions some truths doesn't mean that his conclusion is right. This is his case, and though he mentions some truths, his conclusion is "laptops will remain in niche markets".
Developers or Engineers?
I think you are over-reducing the statement. What we talk about is John Oliver's dick pick, Scarlett Johannson's nude selfie, and you passing naked in front of your computer/phone. The last one might remain unknown to the vast majority of the public, but I think the first two are being understood.
I'd like to see a comparison of this and x265
UnSend.it Beta: modify / unsend any email after it's been sent
Is there any evidence that Google has indeed changed their selection criteria? Everyone I've talked to observes the "top schools"/"pedigree" barrier as still being in place, no matter how many charming Laszlo pieces published.
As the article states, up until 2008 Oklahoma averaged 1 earthquake per year of magnitude 3.0 or greater. In 2014 there were over 500.

http://earthquake.usgs.gov/earthquakes/states/oklahoma/image...
Yes, it can be easily done with a combination of divs, fixed width and overflow-x: scroll.

But I doubt one can do that with a table only, which is a shame, because it would lose markup semantic.

Edit: Little PoC http://codepen.io/anon/pen/LEoyrK
here is a (fairly bad quality) video of how it works https://www.youtube.com/watch?v=sLYYh_fuCE8
Want to Start a Business? Not Sure Where to Start? Here's Where
Can a Country Really Be Wiped Off the Internet?
>That was hard to watch.

I agree. I had to turn it off and come back to it. The level of ignorance from that random public sampling was utterly terrifying. I cannot imagine what kind of bubble those people are living in that they have seemingly totally avoided even the most basic of information pertaining to such a, or what should be a, massive scandal in American public life.

It was enlightening, depressing and frustrating all bundle into one. It's no wonder nothing is coming of these leaks when you've an apparently massive amount of people who are totally disengaged with what is going on in their country, a heap of people apathetic about it, another heap of people in support of it and a sliver of people outraged but who feel totally powerless to do anything about it.

Similarly it's no surprise that many feel totally powerless when they're surrounded by these other groups.

While I feel Oliver somewhat trivialised the issue, he did make it far more approachable as a topic in doing so. Will this trigger a larger discussion on the issue? I do not know, but I'd be willing to bet that even in the face of proof of these activities, a large proportion of the population would still reject it and toe the government line.
Snapchat will need some features (apps) that make it sticky to this demographics. They tried SnapCash (sending money with SquareCash), and Discover (popular videos content/news sponsored by content providers). I don't know if these are enough to keep the users.

It would be interesting to know what's the percentage of Snapchat users still use it daily after high schools. That would make or break the whole company.
My Vizio p series handles it fine (4K netflix).
Seems to me like the 80/20 paradox:

The "tangential stuff" is the essential 20% of the business that takes 80% of the effort to implement.

The stuff "the world is" is what you see and get celebrated for - which looks like 80% but takes actually only 20% of the competence and energy to realize.

This is why those talking the most - those who make the big plans and work out the "strategies" make the most money and the fastest career - but the engineers who are doing the actual work - who make those ideas real do not get much credit.
On Android, Jake Wharton and Koushik Dutta, always looking for more. Chris Banes and Roman Nurik are great from the design side.
I was having trouble building the neovim package, but I did not realize that I did not have the latest command-line tools. Updating those fixed the issue.
There is lots of money to be made in global business communications. The plan is to use the funds generated by this global communications network to fund a future colony on Mars.
The relative impact of your money vs your time depends in part on your income, you skill-set, and the causes you would choose.

A person with a high income but few relevant skills would probably have the greatest impact by donating money. For example, a trader interested in preventing disease might not have any skills in developing or delivering vaccines. But that trader might have a substantial amount of money to donate to organizations that do have those skills.

On the other hand, a software engineer with a modest income might find a very effective nonprofit that could do much more if only it had access to software development talent. For that engineer, donating time might achieve much more than donating money.
Sure, but even if you find our pricing completely outrageous, that doesn't make it OK right?
It's going to be a while before these cars will be able to handle snow or ice
Shouldn't the URL for an arXiv submission point to the abstract rather than the PDF? This lets one read the abstract without downloading the whole document.

http://arxiv.org/abs/1503.07804
We actually drop the transaction fee once you're actually making money. Check it out: usefedora.com/pricing.

To your point, if there's a free tier with a transaction fee, doesn't that mean it's totally free to use? We handle all the hosting for you, so it's a little misleading to call this system free.

With Fedora, we make money when you do - which is an amazing alignment of incentives if you ask me. This really helps people who are just starting out and want to use a robust product. Right now folks using Fedora teach near 400,000 students in any language you can imagine.

Disclaimer, I Co-Founded Fedora and you have any questions, feel free to reach out conrad@usefedora.com.
"Meeting anyone has some value to it."

Indeed. What is often forgotten, is that it also has an associated cost. Sometimes that cost can turn out to be a lot higher than we expect.
OpenShift has an Openshift-in-a-box-container that includes Kubernetes.
The reason they banned youtube is because the evidence was on youtube. You need to re-evaluate your assumptions.
Glorious hack! I wonder how many HNers are hustling over there for a selfie right now...?

EDIT: Already too late :(
On2, the creators of VP6 were really good at making their codec appear better by doing stills rather than video examples.
See this 2012 thread https://github.com/torvalds/linux/pull/17#issuecomment-56546...
Just backed this. As a former postgres person who's now using mysql, it's hard to explain in words how bad the mysql client is. I'm really looking forward to a better mysql client.
This indeed transforms information about a group of records from a tabular spreadsheet into individual card representations.

The people who are pointing out that this solution isn't "a more powerful responsive label scrolling spreadsheet" are right, but they're likely only after a faster horse.

As an aside, a table can have multiple tbodies according to HTML specs, so there's no need to use CSS generated elements to achieve the card styling in the demo. Just wrap each record into a tbody and style that.
Pretty interesting to revisit this idea. In practice, I never found that automated bug detection or auto-code-quality tools ever really helped when we used it as a tool to pinpoint problems in the code.

That being said, I am a fan of tools like gitprime, to identify opportunities to improve visibility and insight into the dev process. It expands on this idea of risk identification, but applies it to the project not the file.
Is it a firefox/chrome problem, or a hardware/driver issue?

To my knowledge, webm hardware acceleration designs has only been available to hardware manufacturers since around 2011. I also could not find a open mozilla bug ticket regarding hardware acceleration.
Since so much of youtube consumption is audio-only, why not have a codec optimized to show nothing, or a still picture? Here at work we used to remote into a machine just to play youtube songs over the speakers. No video needed.
Shouldn't be - I think it's just the same as most investment accounts in that there is a small management fee that takes a percentage cut. In this way Vanguard is the best as it has the lowest rates I know of for the casual investor, but the minimum is certainly high.
Yea, but the flip side of that is that hardware acceleration is a chicken-and-egg problem: Google's work here makes it more likely that we'll get hardware acceleration working in the future because there will now be a good reason to do it.

(They do mention "More than 20 device partners across the industry are launching products in 2015 and beyond using VP9.", so perhaps some of those will feature working hardware acceleration.)
In most papers I've seen VP9 fared worse than HEVC:
http://infoscience.epfl.ch/record/200925/files/article-vp9-s...
Yes, VLC can play directly VP9, if you have an up-to-date release.

But to play the VP9 Youtube URLs, you need to be able to play DASH format too.

And this, DASH extension used by Youtube is not supported yet in VLC. However, it should be, for the next major release.
Thanks for the info. After visiting the Youtube HTML5 support page and clicking "Request the HTML 5 player", and enabling the setting in FF, the VP9 playback is working in FF.
I'd like to investigate this. What browser and OS do you use? Thank you for the help.
Does not work for me:

- Chrome Version 41.0.2272.118 (64-bit)

- MBP 2014 MAC OS X 10.10.2 Yosemite

Also tried latest version of Waterfox.

Having a rather poor internet connection here, but kept the page open for more than 5mins without any music playing.

Any suggestions?
This pull request:
https://github.com/torvalds/linux/pull/17
An employee can still be very passionate about their career, but don't like specific things about their workplace. Like I can like living in a city, but not like the surprise loud noises that happen at 4am in my new apartment, and I cannot get the police to stop them. I still really hate where I live and want to move as a result, and it was a surprise, but I don't want to move out of my town.
Anime groups are playing with it. Anime fansub groups, in general, are hungry for the absolute best in codec technology. Hardware and media player compatibility be damned. An example: their use of 10-bit color.

There are some groups in the anime scene whose sole purpose is to take releases from other groups and convert them into standard h.264 video that can play on basically any device.
I think both you and the article are in-line with effective altruism (the movement). The crux of EA is objectively and dispassionately deciding what causes do the most good with your scarce resources (time & money) and deciding how to best support them. Reasonable people will disagree on whether working in the industry or donating profits from a higher-paying industry will work better for you. Education isn't a popular EA cause but whether it is or isn't optimal depends on the change you think your start-up will have contrasted against what impact you could have elsewhere.

Check out https://80000hours.org for a way more in-depth exploration of the different career-related EA strategies.
So if you have say 100+ records in a table you will end up with 100+ extra <tbody> and </tbody> tags? Just to style it for mobile? I don't think its a good solution
Crate is a database engine that uses Lucene for storage and leverages portions of Elastic for cluster management. It is a NoSQL storage engine that gives you an SQL API (via REST). It does not support JOINs yet but this work is well underway and we expect a release with JOINs soon. We have several customers migrating from MySQL without JOINs (either handling joins in the application layer, using arrays in columns, or denormalizing data). Transactions are not ACID, we fall into the eventually consistent realm. And finally, not all use cases require user/group security, in fact much of the current SQL usage falls into the single user category.

I also agree that our site is not as clear as it needs to be and we're working on it already.
In MPC-HC, hardware acceleration status is shown in its status bar.
Weird. When I read xkcd this morning it didn't mention anything at all about GNU/Hurd. Apparently my RSS reader decided to cut off the far right side of that image, so it just ended "In Fire." Checked the site and the whole image is there. The alt-text makes a bit more sense now.

Is it Friday yet?
And yes, it's available for Firefox too. https://github.com/erkserkserks/h264ify-firefox
What is interesting in the article is the 4 quadrant analysis that Thiel uses a lot in his book.
What about the right to participate in government? I brought that one up in another comment elsewhere in this thread.

And, even with this one, it seems like such a strain to me to say "the right to a fair trial is a negative right because, even though you're compelling the government structures to act in a certain way, it only applies once you're in the justice system".

It seems tautological to say "it's a right that applies when it applies, therefore it's a negative right".

That same reasoning seems like it could apply to just about anything; access to drinking water is a human right, because once you are in a civilization that moderates your access to water, that civilization must refrain from tampering (as in with pollution, access controls, etc) with your access to it.
Wow, now there's a guy guaranteed to have his name mispronounced 99% of the time (well, at least by people who have never heard it spoken). [ edited for typo ]
Sure there are differences. It's still a blatant clone. OP could have at least created his own UI.
Live Editing JavaScript with Webpack
There's a very good reason for that
Seems like it's an layer over ElasticSearch using Presto SQL parser. SQL queries are translated into ES queries.
> That's not a serious discussion.

You're right. Let's discuss paid content.

There is absolutely a place for paid content on the internet. But I don't think paying for content is a replacement for the majority of things currently funded by ads. The internet is inherently open. Paid content is inherently exclusionary. If we're talking about a genuine substitute for ads, that right there is a non-starter. Whether I'm paying for it out of pocket or through my company, the fact is that there are loads of people out there who are not getting access to that content.

A lot of what sucks about paywalls is the friction, and the trust needed of the host (that the content will be worthwhile). But even in a world that's solved these problems, there's still the fundamental problem that the majority of the world won't have access that content because they don't have the money to throw around.
Hi Ankur,

I very much didn't intend to offend you, copy you or cause you to be upset.

That homepage design is based on what Udemy looked like before their update and that's why I felt okay to use it as a starting point.

That said, I'll update the homepage for the course today with a new design as a gesture of good faith.

I think the platform itself, not the homepage/sales page is what the people using coursify like. I suspect many of them won't even use that homepage. It's just a starting point.

Again I'm trying to make friends not enemies. Hope I didn't offend you.

Felix

Happy Easter.