skysight-inc/HackerNews huggingface dataset:
Location: Chicago (CST Timezone)
Remote: Yes
Willing to relocate: Yes, if the pay is right
Technologies: Python, Django, Flask, Postgres, JS (Node, Backbone, ES5), D3, PySpark, Hadoop, Couchbase, Saltstack, Linux, BSD
Résumé/CV: http://stackoverflow.com/story/tony
Email: see profile
Github: https://github.com/tony
OpenHub: https://openhub.net/accounts/git-pull
Website: https://www.git-pull.com

First priority is remote roles, but open to relocating if compensation is good enough.

I come from open source so have a lot of code / public examples of collaboration with others. Like working in teams as well as independently.

Working on book in the spare time, The Tao of tmux (https://leanpub.com/the-tao-of-tmux), set to release this holiday.
From above, but:

I'm currently working on nightlies for ARM and Intel linux-based systems (including Raspberry Pi and [Chromebook, Android] <- under Debian jails).

I could really use one or more Raspberry Pi 2/3 testers on a Debian distro (ideally Raspbian) for early feedback.

Hoping to announce the project on HN properly myself when it's ready (it's a very early state, although extensions are working), so I'd ask for discretion of whoever feels like helping me out.
3 samples I just took (which actually made me realize i get a ton of ads cause I didn't scroll very far for this):

https://i.gyazo.com/5d48e7d926ad5e237536c9dfb99d6aa1.png

https://i.gyazo.com/0194219ec43f3ce6e386f9d5b2443bc3.jpg

https://i.gyazo.com/e7904940fab2d6b610cbac5f83d119d8.png

The last one is a gif or video.
Is there a good sql autoformatter? For cleaning up ORM-generated queries so I can read them. I've used python's sqlparse but it produces output that's often still unreadable.
So I think it is much easier to read if you can line up like clauses:

SELECT spf.blah_blah,
count(*) AS cnt
FROM jv_CTLG_ENTITY_ATTR_PROD_MAP prod_map
JOIN jv_SSA_PRODUCT_FACT spf
ON prod_map.prod_ref_id = spf.PROD_REF_ID
WHERE prod_map.INVSBL_IND = '0' AND
spf.LSTG_END_DT >= date_sub(from_unixtime(unix_timestamp()), 2) AND
spf.LSTG_START_DT <= date_sub(from_unixtime(unix_timestamp()), 2) AND
spf.lstg_site_id = 0 AND
prod_map.ENTITY_ATTR_TYPE_DESC IN ('BMPN','GTIN') AND
spf.CTLG_ID = 1075 AND
spf.LSTG_TYPE_CD NOT IN (10,12,15)
GROUP BY spf.blah_blah;
> At the moment there are few enough that they could fetch a list of all of them and cache it (the public registry lacks a documented API for doing that right now, but we can certainly provide one)

Might I suggest having a bloom filter containing all the existing type declaration (which would be quite small) and only querying the registry if the bloom filter reports the type declaration as a positive.

Since the filter can be really small it will probably scale a lot better than a complete list of all type-declarations, and a new filter could be downloaded by the clients every now and then.
Can they publish a package that contains a list of all their other packages under @types?
Ask HN: How's your work ethic?
How would you describe your work ethic? What do you do right? What do you wish you can do better?

I'd like to think my work ethic is about average.

On most days I can work well for 3-6 hours, but at times, I can go off-task for hours on things I find more interesting at the times.

How would you describe your work ethic?
Techincal Cofounder | San Francisco Bay Area, CA | Tixit | Full Time or Half Time | Equity: 10-20% | REMOTE welcome

I'm Billy Tetrud, the Founder of Tixit. We're a small (7 person) team building an extensible project management system that lets users create custom interfaces and build frontend plugins in javascript.

We're looking for a 2nd technical cofounder to accellerate the development of our product, which is currently alpha-stage. You'd be working with me (the other technical cofounder) in designing and implementing the core backend as well the web frontend. We value our test-driven development, clear internal and external documentation, and doing things right rather than rushing things. Our stack is node.js and mongodb.

I'm happy to chat with you over the phone about what we're doing. Email me at billy@tixit.me and mention you're from HN, I'd love to hear what you've been working on.

More info: https://angel.co/tixit-1/jobs/114395-technical-co-founder

https://tixit.me | Contact: billy@tixit.me | https://angel.co/tixit-1
the counter-argument is that when you fire someone, their co-workers, generally speaking, become at least a little uneasy (usually the level of unease is directly proportional to the level of agreement that the person getting fired wasn't good enough or otherwise had it coming, but there is still some unease even when it's obvious that it's the only way forward.)

Now, you can try to get around this by a real trial period (either contract-to-hire, or being super clear that the trial period is actually a trial period) - if you fire an employee of a obviously lower class, employees of the higher classes won't be as disturbed as if you fired one of their peers, but then you have the contract-to-hire problem, which is that people will usually choose a job perceived to be long-term with a low risk of being fired over any sort of 'trial period' - a large portion of your top applicants will turn the job down if they have to spend time as a lower-tier of employee first.
Isn't it the other way around? Life decreases local entropy?
32 million is a senator's pet project. A "build my bridge, and I'll sign your bill." It happens in every bill.

I first realized how much money is wasted is when I read the grants in The Stimulus Recovery Act of 2009. I was looking at the money that went to my county.

Just in my county, I was shocked. The nonprofit I used to work for got close to a million for the founder's "I won't say, because I don't want any scrutiny, but the money was wasted."

And I won't even bring up the 200+ defense contractors--that bleed the tax payers yearly.

I'm a liberal guy. I don't believe in waste.

I could care less about 32 million.

Plus, the hit piece didn't have a way of accounting for any Goodwill 18F created.

What scares me is Obama is going. He knew enough about technology to fear it. In an interview, someone asked him, "What keeps you up at night?" He immediately said, "Hackers". (I will never forget that look he had. It was honest concern.). He then caught himself. He had the look like, I was just too honest. I think we are all going to miss his leadership in a few months from now.
Applying queueing theory to dynamic connection pool sizing with FlexyPool
React with TypeScript and MobX
Doesn't it seem wasteful that 18f spent all that time on the standards, instead of maybe a guide/theme on how Gov't sites should adapt, already open-sourced (bootstrap), frameworks?
"This era" here means the era in the context of the discussion, not the current era. "That era" would also be correct.
Cool, good to know. Cheers.
Another vote for Poor Man's.

But I think it's an important caveat that the whole team use the same formatter and the same settings.

Otherwise diff's turn to useless noise* because Cubicle Bob has personalized his settings.

*Yes, I've tried the Winmerge plugin. It's helpful but not ideal.
I was introduced[1] to Lojban[2] by a friend through my shallow interest in programming. I don't know much about it, but maybe it comes close to providing an answer to your 'new language' question. Their website[3] provides links to learn about it's architecture.

1. https://youtu.be/QdlGxgKt7nc
3. https://en.wikipedia.org/wiki/Lojban
2. https://mw.lojban.org/papri/Lojban

Edit: updated video link
They unfortunately have datacaps and don't offer fiber only openreach FTTC style connections at best and at about 3 times what I pay for 1gbit up/down in London ATM.
Amazon beats Flipkart, Bigbasket beats Grofers in customer service: Forrester
I admit I was guilty of this. After failing in my first startup I realized that I was playing the startup game rather than creating true value.
They are removing battery status API because it was used to track users by ads networks and alike.
We did this cause it's the new hot thing. Makes sense.
Will it come to on-premise SharePoint 2016 (or later) too? Or is this just a cloud-only service?
But this is a conversation about startups.
Robert Graham: In which I have to debunk a second time
I'd hesitate to call a lot of the work I do cleaning data "engineering".

I think perhaps the problem here is the term science covers a lot of disciplines.

I propose harder stats be data theoretical physics, with data biology and similar referring to cases with harder messy real world complications. I'm sure we can come up with a full spectrum.
there is a book called "creativity inc." by ed-catmull which also is pretty good. it is more of an exposition of management style at pixar than anything else though. might not suit everyone's fancy :)

edit: but if you like that kind of thing, then it's the kind of thing that you would like.
But they only act on what they see when it satisfies their own ends. It isn't really an effective force for the general good.
As some other people wrote as well - everyone should try to work in a start up at least once. You can learn a lot, especially how not to do things. It will be useful when the day comes of having your own start up :)
While ORMs solve 80% of the needs, you still need the power and flexibility of SQL for those 20% of the needs. Anytime you need reporting, complex joins or aggregation - SQL is a natural choice.

But generating dynamic SQL by hand is error prone and has lot of repetition, especially when your query grows big.

JinjaSQL gives you the flexibility of a template language (Jinja), without having to manually track your bind parameters. It's not a replacement for an ORM, but is meant for those 10-20% use cases that require the power of SQL.
Estonian residents and e-residents can now open bank accounts remotely
I read somewhere that IBM patented editable blockchains
While I'm not sure what hardware was used, if you want to try it yourself the benchmark is pretty easily reproducible [1].

[1] https://github.com/hivesolutions/netius/blob/c431b9c258baa0b...
"I never looked around, never second-guessed

Then I read some howard zinn now I'm always depressed

And now I can't sleep from years of apathy

All because I read a little noam chomsky"

- NOFX, Franco Un-American
Yes I keep hearing this, but can you tell me why?

What are the moving parts now, and how exactly will a blockchain make them go away, given that any blockchain a bank would use won't directly represent the assets the bank claims to have? How can it ever be different from an authenticated messaging system?

I'd be very interested to read a detailed, technical explanation.
That seems odd because if I happen to be browsing from abroad I might be put off by the shipping costs, which would turn out not to even be accurate for the destination I want.

> They want to factor shipping into the price transparently from the start

I guess if they made it obvious that that's what they were doing (stating their assumption about your destination) it would be fine.
Lenovo Phab 2 Pro is shipping now;1st Google Tango phone delivers true AR gaming
Dear Dorine,
I am a graduate student at Stony Brook University, major in Computer Engineering (Expected to graduate in December 2016) and would like to apply for Software Engineer role at IMC. I have keen understanding in Java, Python, MySQL, REST API, HTML, JavaScript, and C++. I would like to pursue my career in the similar area.

I worked as Backend Developer Intern in Filtrest, and I designed a backend system to fetch articles from various social networks based on user’s interest using Python and Django framework. My two years’ experience in Infosys Ltd, has helped me to acquire valuable fundamental skills and acumen required for a software engineer and gain the sound knowledge of Software Development Life Cycle. I am comfortable performing a broad range of job duties and grow in IMC.

My coursework & the experience in the software industry has added an extra dimension to my profile. Given my experience and interests, I believe myself to be a suitable candidate to work at IMC, as the nature of work matches with my interests and I feel I possess the required skills. Please give me an opportunity to go through selection procedure of IMC.

I have emailed my resume to you. will provide you with a greater understanding of my qualifications. I’d be happy to provide greater detail about my skills and experience during an interview. I look forward to hearing from you in near future.

Thanks for your time.
Do you have any online resource that could tell me what these foundations of CS are?
No, because it is easier to find good react developers vs. finding good backbone ones, because it is more widely used.

note: no affiliation with pinterest.
Announcing Enlambda, consulting for the Nix ecosystem
Why not this?

WHERE A
AND B
AND C

Or better, this? You can comment out any part easily.

WHERE 1
AND A
AND B
AND C

(With keywords capitalized, as g-d intended. :-) Or not.)
http://www.jsonml.org/

http://jsml.org/
Monthly Internationalization and L10n Roundup – October 2016
I discovered Karabiner too late, after upgrading to Sierra, now I'm waiting for it to work on Sierra :-(
The point zdkl was making was that you're not running what people describe as a startup - that is, a high growth, early stage business. And that if you're not running a startup then it is only logical that you are much less likely to 'play startups'. Do you see what he means?

Also, you talk about raising money like it's a bad thing. Don't forget that plenty of fiscally responsible high growth companies have raised angel & VC rounds. Just because you take on less responsibility doesn't make you more responsible, as a founder & business owner.
Amazing fight of Undertaker and Brock lesnar
The hottest WordPress Trends to watch out for in 2016
Yes I read to the end to find the answer to that. I guess you have to buy the book.
Completely removing the feature seems overkill. Presumably there are good reasons to have it (full-screen kiosk style apps perhaps?) so would it not be better to leave the feature there but add a permissions gate as seen with location information and full-screen use ("This site wants to see power management information about your device, should we allow this? yes/no/always-for-this-site/never-for-this-site").
Disclaimer: I'm a contributor.

First and foremost, Skate is a web component library designed to give you an augmentation of the specs focusing on a functional rendering pipeline and clean property / attribute semantics. It's about a tenth the size of just React itself, doesn't require any extras and utilises both custom elements and shadow DOM out of the box.

React is nice, and if you're can't invest the time to learn something new, Standalone is definitely a good choice. That said, the time it takes to learn Standalone you could have probably learned Skate. In my opinion, right tool, right job; hammer principle etc :)

Would be interested to see what jpnelson thinks as well.
you are so god damn boring, such a fake, holy-than-thou, prude. Everyone can see thru your BS
Even if you had to, the algorithms are so darn well documented there's no need to keep the details in your head. If you really need to implement one, you look up the details.
Sys-Bit Digital Solutions. Integrating Open Data Spaces. Yeah. Tech-Bit Data Solution Systems. Creating unique cross platform technology. Technologies. Techno-Jeeeesus. OH FUCK! Infatroid. Cloud based disruptive platforms. Disrupting the cloud of ... I said cloud twice, shit. Making the world a better place through cross platform business facing cloud -- SHIT there's that cloud again. Infatrode. Infatrode? What the fuck is infatrode? What is that? It's all just fucking meaningless words! Ok, no no no no no no no. Making the world a better place. Making the world a better place. Making the world a better place. Making the world a better place. Making the world a better place. Making the world a better place. Goodbye. Making the world a better place. Making the world a better place. Making the world a better place. Making the world a better place. Making the world a better place. Making the world a better place...

KNOCK KNOCK KNOCK KNOCK -- Sir, are you OK in there? He's been in there all night. I should call the sherif.

https://www.youtube.com/watch?v=hsr-QfgFRh8
Yet for me it's provided every single job I've ever had except my first straight out of University.
Fasttext and Torch: A fasttext implementation based on Torch
I don't follow the 'Why run Cassandra in a container and not just on the whole machine?' arguments. The first two seem to argue against the concept (because you need to coordinate what machine the container is running on). And the third talking about something completely different (its talking about a single cluster vs multiple clusters, nothing to do with containers).

I'm curious how they can start up one new node in a cluster per minute, when last I saw Cassandra required 2 minutes after bringing a new node online for things to settle before starting a new one. Its a pain point for me running tests that need to startup and teardown Cassandra clusters, and I'd love to know when and how it can be avoided.

(Maybe I need to watch the actual talk)
I don't want a schema, I want to preserve types between serialization and deserialization thus avoiding conventions or having to specify those types "out of band", the same way you want to make it clear that an int is an int and a date is a date, I want to tag an object to tell that that object is a city, a person or something else, each program should register a function to rebuild the actual object but at least it's not a convention anymore.
What business does a government agency have spending nearly 800 hours (plus inevitable expenses on stationery, biz cards, signage, etc) on a logo? How does this benefit the taxpayer? Why do they need this logo?

One thing that bothers me about government websites is the boosterism of whoever is in office. Secretary of State websites are particularly bad in this regard. Usually you go to the SoS website to do something related to licensing, like the DMV. Both Illinois and California have had headshots of the Secretary of State displayed prominently in the header. It is labeled/named something long winded like "Secretary of State Joe Blow's Department of Motor Vehicles Website". Is it on a .com or a .gov or a .(state).us domain for any given state? The generic "(welcome and platform) message from the Secretary of State" is often front and center.

Really, who the Secretary of State is is so secondary to the actual services being provided, all this does is serve to tell everyone who is responsible for this crap website.

If there was consistent branding, and that branding was strong and recognizable, citizens would be better served. You wanna toot your horn, put some metrics up like the last 6 months of turn-around time on license approval, website and phone service response time, help topics researched, costs to provide the services, etc, and show me how access to state services are improving over time, which is the SoS's actual job. Government agencies usually have weak branding because it gets upset based on term lengths (except for services like the IRS, which has pretty consistent branding and methodologies).
Strict I/O is absolutely fine for most of those "process-a-file" use cases and io-streams works for the rest.
Case Study: BI Tools and Consulting Help Pharma Biz Consolidate and Analyze Data
Hi what is this?
Shameless plug: Portier is a FOSS project to replace Persona, https://portier.github.io/. We also just had our time on the HN frontpage, https://news.ycombinator.com/item?id=12837669. Lots of questions were answered there, but feel free to ask here as well if anything is unclear.
I'd love to get HN feedback on a library I wrote to make SQL more manageable - https://github.com/hashedin/jinjasql.

The library is built on the Jinja template engine. You can create macros, functions and other reusable sql fragments, and then use them to create the query. You can also write loops and conditionals, so you can do all the things you routinely do to generate HTML.

The library tracks bind parameters, and doesn't let user input into the query. At the end of the day, you get the generated SQL and an array of bind parameters. You can use these two to execute the query using whatever database & driver combination you like.
If you're a fan of the idea behind Persona, it looks like there's a spiritual successor from some Mozilla veterans called Portier, which can be self-hosted (and is written in Rust, if that's your thing :P ). Recent announcement and HN discussion here: https://news.ycombinator.com/item?id=12837669
>>>I am a professional web developer ... working with an amazing graphic designer/illustrator who designs everything you see on System76.com.

But doesn't design it using ElementaryOS, seeing as it has no graphic design software —or design it using any Linux, for that matter, seeing as no Linux distro has any professional grade design software...

>>The column view is a nice option for those of you used to that in macOS...

Except it doesn't have the preview pane from the column view in OSX Finder. So is nowhere near as useful.

Don't get me wrong, I applaud what you're trying to do with elementary OS and appreciate that you probably see the general disappointment over the latest MBP as a great opportunity to get elementary on the radar of disillusioned Apple users. But to try and pass elementary off as a viable alternative is just daft.

* A crippled Finder-lite

* Some pretty notifications

* A dock

* A mediocre email programme and browser

* A terminal

* A text editor with syntax highlighting

* An image viewer

* A PDF reader

* An app store which is completely empty, apart from what comes with the default install.

Did I miss anything?
Does that not depend entirely on the size/stage of your business, the size of your customers and your industry?

I don't think it's unusual for an email list to be managed by one dude at an early stage tech startup.
Dunno if it's the quality of the posts here, but I find interesting to see that when we talk about SQL nobody complains about it : nobody says there are better alternative, nobody talks about the great schism between the last 2 major revisions of the SQL standard,...

(IMHO, SQL is one of the oldest languages and it is still super powerful and used like hell in production environment, but that's just a point of view)
Anything that opens "web pages" automatically uses the current app for opening web pages which can be FF. If you install FF it will prompt you and you can tap FF and then tap "always" to skip the prompts.

Many things like Facebook and Google search will initially use their own internal browsers for speed, unless you configure them not to. Even in an internal browser, you can generally reopen the page in FF.
"Please just make me rich"
This makes me think of ISPs and the whole conundrum with their false definitions of unlimited. How do you abuse unlimited?
Previous discussion of the original announcement (Jan 2016): https://news.ycombinator.com/item?id=10884893

A decentralized way to authenticate users securely and privately would be an exceptional addition to the open internet.

Unfortunately in this case the financial incentive and favors those building "information silos" where the purpose is information collection for profit.

I wonder if SMTP would ever see the light of the day with the current mindset as opposed to a "Facebook Messenger"-like multitude of services, much like what happened with the IM fragmentation.
That covers the simplest case.

What would you do when you're selecting 20 columns from 5 different tables joined together?