skysight-inc/HackerNews huggingface dataset:
Move a little bit north and you describe me right now, ha-ha.

Although the company I'm at right now should be considered cool (or at least, to me).
Hubstomer
Chat-based CRM, Payments and Onboarding tool.
Looking at it, the libs/arch/.so files are just compiled JNI/NDK libraries compiled from source of jni/* files (that's completely standard for native code on Android). Usually the compiled libs aren't checked into the source control though.

Taking my paranoid glasses off, I'd guess they're checked in so contributors don't have to deal with setting up NDK to compile the app.
Dude, if you saw the source, you'd faint.

About it being unknown, may I remind you that much of Apple OS X or Microsoft Office are just as "unknown"? Have you read the source of LibreOffice recently?

EDIT: I've included the source in the .zip now. Maybe i should have put an EULA like the "trusted" companies but anyway, you wanted it, you got it. In BASIC.
Site Feedback: Revlio builds SMS network to make everything shoppable & more.
Watch out, the extension does not create "temporary indices". They can't be used in queries.

It only creates virtual indices, whose only purpose is to observe how the query optimizer would behave, if they were real.

I find it quite a curious idea, although an important parameter of the indices is the cardinality, which I don't see customizable.
Partially related: I had a personal blog and after 8 years or so, I let the domain expire.

After a month it was not only bought, but replaced with an identical mirror outdated of circa 2 years. Even the infinite scrolling js was working.

They replaced all the adsense with their own ads, and put textlinks inside the posts (usually sex/abuse related keywords).

Not knowing what to do, I just reported it to google (and that led to no appreciable result).

Luckily it went away after a bunch of months (the domain is still there, but the website does not load nor it appears to be indexed in google any more)

Needless to say, being the website domain my real name, I felt pretty embarrassed about it. :)
Ehm, the "jni/" directory contains the source for those files. Running "ndk-build" (from Android NDK) in top-level dir will recompile them.

Looking at the source the libraries contain AES code, libjpeg, libwebp and libyuv to handle image decoding, some image blur algorithms and video NV21-YUV conversion routines.

Nothing out of the ordinary for an Android app - offloading CPU intensive stuff to C/C++ where it's almost always noticably slower.

Can you please, PLEASE, check your facts before jumping the gun next time?
Infographic: Integra Gold Launches $1M Contest to Find Gold
They don't want people paying mobile app prices for their office suite.
INTP programmers: what do you think of test-driven development?
Also, what strategies/approaches have you noticed work well for you?
Pretty interesting. Wrote a web scraping api you can paste in to your browser and download results last year but took it down to work on another project. You can take look at what a url could look like.

https://web.archive.org/web/20140420162639/http://scrape.ly/

For example if you wanted the profile of authors of today's stories

http://scrape.ly/s/{http://news.combination.com}
{'ueoma87'}*{'next':'Next Page'}{'karma':'331',
'username':'ueoma87'}

Would've returned all the profiles of each story's author today and yesterday and so on.
Has anyone given presentations directly from your phone or tablet? I'd love to hear your experience with the process -- setting up, projecting, navigating, presenting.

More generally, I'd like to know if we have gotten to the point where work (maybe not yet for coding and other heavy-duty stuffs) can be done on phones and tablets, so you don't need to lug around your laptops. What are the main hindrances? Screen size?
Meet the Mysterious New Hacker Army Freaking Out the Middle East
There's a python package called dex (https://github.com/mongolab/dex) that helps assist with index recommendations by looking at mongo's oplog and query response times. It's not perfect but better than nothing for alerting people to a missing index. Unfortunately I think it is not under active development anymore and beginning to fall behind with changes in mongodb.
I think of options as lottery tickets. Sure, things might turn out, but they're ultimately a tax on the financially ignorant.
Yeah, there is nothing more frustrating than someone who agrees with you but for totally horrible reasons.
There were big libraries, like the one in Alexandria, that were destroyed. Nobody knows exactly what was there, although we have several lists of books that have not made into the modern world.
I'd love to see a study like that as well. And you're right, not all trans fats are bad. There’s a good trans-fat called conjugated linoleic acid (CLA) that is mainly found in meat and dairy from pastured ruminants. Grass-fed cattle produce 500% more CLA than grain-fed [2]. Only man-made industrial trans-fats are bad.

[1]: http://chriskresser.com/can-some-trans-fats-be-healthy

[2]: http://www.journalofanimalscience.org/content/78/11/2849.ful...
> IIRC, 97% of climate scientists believe it's happening and caused by humans

No, you didn't recall correctly. It's published papers taking a position on AGW and even that number is questionable at best:

To manufacture their misleading asserted consensus, Cook and his colleagues also misclassified various papers as taking “no position” on human-caused global warming. When Cook and his colleagues determined a paper took no position on the issue, they simply pretended, for the purpose of their 97-percent claim, that the paper did not exist.

Morner, a sea level scientist, told Popular Technology that Cook classifying one of his papers as “no position” was “Certainly not correct and certainly misleading. The paper is strongly against AGW [anthropogenic global warming], and documents its absence in the sea level observational facts. Also, it invalidates the mode of sea level handling by the IPCC.”

http://www.forbes.com/sites/jamestaylor/2013/05/30/global-wa...
I see where you are coming from on this. The difference is that people know and roughly trust MS and Apple. And hundreds of devs have worked on LibreOffice.
50km up, actually. (Venus' atmosphere is scary thick.)

And it's better than you think: the atmosphere there is largely carbon dioxide, which is denser than air; so you don't need hydrogen for bouyancy. You can use breathable air and live inside the balloons. The inside's at a slight overpressure, so any leakage will be outwards rather than inwards, and the pressure differential's pretty small so it's likely to be pretty unexciting.

You're above the clouds, so there's plenty of sunlight. Luckily there's this really big surface to spread solar panels on; your balloon. Then you can electrically break down the carbon dioxide into oxygen. Or just use plants. What is it they like again? Oh, yeah, carbon dioxide...

What you don't get is much in the way of heavy elements; light organics (CHON, mostly) can be extracted from the atmosphere, but that does solve your immediate life support issues. Metals you'll need to go to the surface for, which may be a little exciting, but is perfectly doable (by machine, preferably). You're probably better off building out of organically produced carbon fibre, i.e. wood.

Venus really is one of the most hospitable planets in the solar system, after Earth. If you like planets, of course.
Hair comparison seems questionable on the surface. I can pull two hairs out of my head that look very different. I have some sections of hair that are very fine and lighter and some sections that are thick and darker. My hair has also changed texture over the years which seems common for my family.

Here is another sad story of a man put to death based on pseudoscience

http://www.newyorker.com/magazine/2009/09/07/trial-by-fire

There is also the partial print of the Madrid bomber fiasco... https://en.wikipedia.org/wiki/Brandon_Mayfield
T-Mobile iPhone Users Seeing Frequent Random Restarts and Blue Screens
> About it being unknown, may I remind you that much of Apple OS X or Microsoft Office are just as "unknown"? Have you read the source of LibreOffice recently?

To the sentiment of the parent; Apple, Microsoft and the Document Foundation are all large entities with years of good faith trust building relationships, where you are "just some guy" on the internet asking people to execute arbitrary code.

I understand you not wanting to release source, but I also understand the parent's hesitation to run your binary.
Yup. I ended up quitting my day job to work in a startup just a week before my options would have vested at the 2 year mark. That was several years ago and that company still hasn't been sold.. those options would still today be worth nothing.
I'm very surprised when I discover how uncommon it is for [even] our industry to invest in equities. Somehow stock in a company makes more sense to most than compound returns.

It's even more surprising when I find 30 year olds who haven't figured out to use the company match on their 401k yet.
There are companies which do original-pronunciation Shakespeare and make a point of showing wordplay and rhymes that don't exist in modern English pronunciation. This video has an example:

https://www.youtube.com/watch?v=gPlpphT7n9s
I don't wish to be argumentative, but I googled the term before I posted, too, and I don't see many references to it that predate Fowler's first article on the subject, or, indeed, many articles that don't actually credit Fowler for the term.

Maybe he didn't invent the term, I don't know. It just feels to me like it's two words which, when used in combination, don't really add a whole lot of useful meaning to something that many of us will have been using for quite some years.
Serious question: What happened with the Hindenburg then? Why didn't that fire put itself out quickly?
Meet the 27-Year-Old Shishito-Pepper Baron of New York
Is anyone familiar with the DarkMail key management architecture?

re https://www.youtube.com/watch?v=TWzvXaxR6us
Cafe Trieste is my favourite spot in SF. Really awesome vibe at this place.
Lack of integration with OSX notifications drove me away from outlook.

Just use the damn OS provided features. ugh.
Except if you need a form of energy that you can distributed at a location, have abundant electricity and water at a specific point at that location, and don't have infrastructure to efficiently move electricity around. But yeah, transporting water itself probably isn't smart.
Try using libtextsecure instead of interacting with websockets directly. We publish artifacts, and while the API might change over time, if you stick with a versioned artifact you'll be good. http://open-whisper-systems.readme.io/v1.0/docs/textsecure-j...

We have a few bots in production that use libtextsecure and have been running fine for almost a year without any maintenance.
OpenVPN: Connecting VPCs between regions
Apple and Microsoft have much to lose if they are found distributing malware. You on the other hand have just written your first GA program and have admitted that the source is ugly. What is the last time you were OK about running an executable from a shady site?
There's also the pretty standard *these scientists' intuitions about causal links between human activity, atmospheric CO^2 and recorded temperature might well be right. But you're not convincing me to pay carbon taxes or cycle. Which is less unreasonable than it sounds when you consider the evidence of human ability to slow or reverse climate change (at all, never mind through eyecatching civic initiatives) is in rather shorter supply than the evidence of human ability to adapt to climate change.
I think it's neither sad nor happy, it just is. People make the tradeoff between quality and cost, and it's simply down to their tastes. There's no metric to use to say what the right tradeoff is.
The PoWA project (https://dalibo.github.io/powa/) + pg_qualstats extension is doing most of this work.

The pg_qualstats extension will gather statistics on WHERE clauses (number of execution, selectivity...) on the fly, and the powa UI can show you which are the most expensive queries, and suggest index creation based on your real workload. It's then your choice to create the indexes.

hypopg should be added soon to compare query EXPLAIN with and without the hypothetical indexes.
SQL Server has all this information saved (I'm not paid by Microsoft, I swear). I would suspect something is available for other engines as well.

For example, I can easily grab (what it thinks are) the top 10 most impactful missing indexes and create them. The big issue is that, well, they can be really dumb when looking at a macro level. Do I often query a 10 column table for 8 of the columns? It will likely recommend I index those 8 columns. In a vacuum that might be a great index for this specific query, but now I'm basically maintaining two copies of the full table.

To be able to weigh these pros and cons would be a really nice feat, then DBAs will have to abandon the "It Depends" mantra!
It doesn't matter if it's a bigger cut of zero. That's the problem.
Spatial References I can understand - when you want to create a map of a single country/region, a custom projection centered specifically around that region can provide a more accurate approximation of equal-distance points, parallel lines etc, something that is not possible with a worldwide projection.

Note that Redis Geo uses the infamous Web Mercator, used also by Microsoft Maps, Google Maps, OpenStreeMap, MapQuest, etc. but apparently rejected by the standards body EPSG with the declaration: "We will not devalue the EPSG dataset by including such inappropriate geodesy and cartography." Ouch. [1]

[1] https://en.wikipedia.org/wiki/Web_Mercator
There simply isn't a lot of fresh, liquid surface water:

http://oceanservice.noaa.gov/facts/wherewater.html
It's very easy for shares in a liquid-seeming exit to be worth nothing, even with no shenanigans. For instance: raise a B round, and then sell for low 8 figures. Liquidation preferences will wipe out most of the outcome. People lose perspective about this, because they only see the final number (and the "employee shares worth 0"), but if you raise 20MM and then sell for 20MM, it's not hard to see why the shares aren't worth anything.
Same as using 1Password — you don't.

You're trading convenience for increased security.
I'm happy for these guys but is it just me or is a 5% transaction fee nuts? I know, I know, Kickstarter, Indiegogo, you name are all roughly the same, and yes, there is value in the "platform", publicity, etc. -- but you're basically just sending money from one person to another. Venmo (which is basically free) could roll out a platform like this in no time and charge 1 or 2%.

I just wonder why, in 2015, with all our technological progress and all the "innovation" in the payments space we're still tolerating really high transaction costs. /endrant
Generally causation and correlation can only be distinguished by running experiments.
Given that we only have 1 earth climate, long time needed to gather reliable results, and the quite apparent correlation, which experiment would you like to run for next 50 years, slow down co2 output to see if climate warming slows down, or continue increasing co2 output, and see where that leads?

Infact, increasing co2 output would be kind of boring experiment, we've tried that already.
Toy-box-house
Temporary index and Hypothetical index are two different things.

Temporary index is a real index that's usually dynamically created by the optimizer to speed up a query. But it's kind of useless because most of the time the cost of creating a one-time index exceed the cost of not using it. Afaik only DB2 as this feature

http://www.centerfieldtechnology.com/PDFs/DB2%20Temp%20Index...

An hypotetical index is just a way to "trick" the planner into thinking that there's an index and see what the query plan would be if that index really existed. The cost of creating this is close to zero.
> In North America alone, nonprofits are a $300 billion-a-year industry. There’s a lot of fat in there. If we do our jobs well, we can remove friction as it relates to giving

Well that sounds scummy as hell.
That liquidity is important at the point of compensation - if you hold cash, you can invest it in what you choose.
I am not a scientist but I've always had a sneaking suspicion that blacktop converting light from the sun into heat had something to do with it. I'd actually LOVE to hear what a scientist thought of this hypothesis.

I also wonder if all the coal we material we burned for heat (coal and such) didn't have a cooling effect - particularly in the cities where a lot of the accurate temperature measures were taken. Again, not a scientist - truly curiously.
root ls always shows dotfiles on BSD
Let's not beat up on the OP too much for not releasing source. It's a very complex program and in an initial state is surely messy code (we've all been there).

Good work OP.
I should be more specific: unicorn chasers that aren't huffing their own farts :)
Implementing Functor in OCaml (2012)
This is really cool, thanks for making it.
What about gravity+water->electricity->hydrogen->methane->electricity (assuming storage/transportation of methane, so there's a point)?
It seems to me that there's less of it now than even 5 years ago.

Are we just not paying attention to newly-flooded parts of the world? Is there a floodplains in Malawi that's seeing record high water levels?
Just in case it came out the wrong way, kudos to the OP for getting the job done. I just found his argument that the source-code isn't needed because Microsoft doesn't release its sources way off mark.
Security Knowledge Framework
I think the parent refers to a specific optimization that MySQL doesn't perform:

SELECT ... FROM ...
WHERE field IN (
SELECT field2 FROM ...
)

MySQL doesn't acceptably optimize such queries (at v5.6, as far as I remember).

This is a more complex case than the one you're pointing - the field2 records may be an intermediate result, logically and/or physically.

For example of the latter, in a typical mysql execution with a relatively large number of records, the subquery records are likely to reside on a temporary swapped table. In this case, the optimizer would need to be able to create the intermediate table with optimal data structure[s], which (if I remember correctly) version 5.6 is not capable of.
It didn't come from another common license. It came from the EPL (Erlang Public License http://www.erlang.org/EPLICENSE). Erlang users have been asking for the change for years and OTP 18 finally delivered on the promise.
Your scenario is valid for "index organized tables", where the data for a given row is stored in one of the index's leaf pages. Synthesizing an index on-demand for those involves an extraordinary amount of random IO.

In postgres, a table's data is stored in the "heap" (a disk file representing the table, itself; indexes are separate disk files). Consequently, you can do a sequential pass through the table, and then calculate/build the index in RAM (assuming you have sufficient "maintenance_work_mem", in postgres configuration terms, otherwise you'll spill to disk at this step, too), and then write it out sequentially as well — and only then walk the index depth-first to get to the leaf page that points to the disk page in the heap that contains the row you're selecting.

(And even that random depth-first traversal of the index will probably actually happen in RAM, because postgres significantly defers to the kernel's buffer cache to mitigate IO costs, and the index you're traversing is pretty much guaranteed to be cached at this point.)

EDIT: It would apply to MySQL using InnoDB, however, as IIRC that does store table data on the leave pages of the primary key index. Can someone corroborate that?
No, they're not. Google paid me well to be the equivalent of an NCG python script kiddie. I'm the one that got bored and failed to convince them they ought to be making using of the skills that made them notice me in the first place.

I'm no van Rossum, but I'm pretty good at the thing I do.
This is waaay over simplifying things. How much options are we talking about? 10% of the company? That's hardly worthless. Public company? Private? What stage is the company at? Secondary markets exist all over the place.
I covered that in a different post, but hydrogen makes a very poor storage medium. The multiple conversions are also very inefficient.
Because 5% may be way more efficient than what we have now? (If it's not, there's no point in doing this.) But then, in a year or two, Venmo or whoever can charge 1 or 2% and eat their lunch.
Chrome Credit Card Autofill – Full UX and Code Example
50% is a huge over estimation unless there already exists a liquid secondary market / the stock is public. 10% is more accurate.
> I'd work my ass off without options, but the options really make it easy to say "I will do everything in my power to make this succeed" instead of "I'd rather go spend time with my friends tonight"

Just curious: are you under 25? Not meant as ad hominem -- I know tons of engineers who have this attitude from 22-25, but the closer I get to 30 the more I realize on a deep level that I'm going to die someday and I have a finite amount of time to love others, watch sunsets, laugh, meet interesting people, etc. It's gotten to the point where I have trouble relating to newly-minted engineers because they seem stoked to work until 9 PM in exchange for Nerf guns and the illusory promise of a liquidity event.
As a hiring manager I have found that this adjustment already started occurring about two years ago.

Firstly, the market for technical talent is so competitive right now, that cash is an easy way to compete for people and salaries have been driven up.

More importantly, people have become far more sophisticated about options and what a payoff is likely to look like. Ten years ago I would never be asked a question like "how many shares are there outstanding on a fully diluted basis" but now I hear it essentially all the time.

edit: grammar
Is there some advantage to not having the "handle" null check the first "Where"?
> Telegram is not truly open source.

Here's Telegram FAQ [0]

Q: Why not open source everything?
All code will be released eventually. We started with the
most useful parts — a well-documented API that allows developers to build new Telegram apps, and open source clients that can be verified by security specialists.

[0] https://telegram.org/faq#q-why-not-open-source-everything
Saying they are worthless shows that you have zero skills at probability. A way to look at options is the way a good poker player tries to play when the bad beat pot is particularly high.
Is it really a clean-room implementation (in the GPL-enforcement sense) if you're looking at the git internal documentation?
Yes, in this case hypothetical means conjecture. "Let's get information about how the system would function if there existed an index as such..."
These are actual, not advertised speeds.
Show HN: A tool that crawls a subreddit, downloads images
This is a tool I coded in AutoIt that crawls a Subreddit RSS and finds images to download. If the link leads to a gallery, it crawls that gallery for other images.

This is intended for private use only. I don't want you to vacuum pictures off the various image boards this program crawls and call them your own and blame it all on me. Just use it if you want to get cool wallpapers every day or something that's not copyright infringing.

Source is included this time. Yes it's a mess, yes I didn't use switch(), yes I should have added more comments and I should name my variables better. And yes, I should put more things into functions. But I wrote it iteratively from a 10 line program I came up with late at night and by the time I was finished, it was 4:30 early morning. The list of URLs to fetch is in sitelist.txt Add your own there.

Download it here: https://sites.google.com/site/bryanbottebell/bryan-bottebell-s-projects/RedditImageGrab.zip