skysight-inc/HackerNews huggingface dataset:
Ok, so let's be more precise.

What I expect an accessible work to do is to explain things using terms that are as simple as possible. This does not mean to explain it like the reader was a child but, most of all, to avoid one simple pitfall:

Imagine you learn A, then learn B (which builds on A), and finally learn C (which builds on A and B). Now you have the knowledge to explain A more correctly and elegantly in terms of C, and you do so.

However, your beautiful and correct definition of A depends on C, which depends on B, which depends on A. So your reader has to understand C in order to grasp A and A in order to grasp C.

This pitfall has nothing to do with necessary complexity -- not avoiding it is simply bad didactics.
The method of interest here is loading data into BigQuery:

https://cloud.google.com/bigquery/docs/loading-data

Which has a limit of 50,000 loads per project, per day.

edit: corrected limit.
From what I've read and seen in the docs, faq, presentations, etc., it appears to me that IPFS really pulls in a lot of stuff about the network layer, because it's trying to be, well, an Interplanetary (distributed) File System.

DAT is fundamentally a portable, self-contained, data repository. Replicating DAT archives across a broad network and whatnot is definitely a problem that needs to be solved, but IMO that should be solved at a different layer, without rolling in all sorts of complecting concerns such as network ports, routing, and payments for storage and whatnot.
Even if they did, would it matter? It would be some chemical term, like the one you see in an ingedient list, that is meaningless to most people.

And these are places, not products...with gardens. Even if they use organic pesticides, they probably still have to put up the warning.
There's a bunch of twitter-likes. Since I don't know what you dislike about Twitter, I don't know if they fit your definition of "minus everything everyone dislikes about Twitter" (there isn't one list of "everything wrong with twitter", nor a non-contradicting list of such lists). And of course, they all have some issues with growth/lack of critical mass (how big of an issue that is again depends on the users and their preferences)
Interesting, local VCs or FDI? Do you have a link?
The economic prescience of J.B. Priestley
I remember that they were promoting Segway as the way of the future. That it was going to change the world. They literally said that their device was going to change the world like Ford did.[1]

Fun fact: One of the original promotional videos shows cops using it.

[1] https://www.youtube.com/watch?v=7rNw5nI_3iE
Yes, and tech giants used to be seen as 'saviors' from that, is the point. Now they have been revealed to be just like every other business.
Not just poor but absent entirely more likely. Or rather based entirely on the sentiment of popular news media. I watch the BBC sometimes and they make it seem as though if you visited India you'd get raped as soon as you exit the airport. If you visited the USA you wouldn't make it out of the airport, shot dead at the baggage claim. If you visit Brazil, you'd dance around carnival style. When based on violent crime stats from these places, the first two are orders of magnitude safer than South America. With the terrorism stuff, it's just weird, as long as it wasn't a middle eastern looking person doing the killing, it's not something to be worried about even if more people were killed.
> However the development of consumer/end-user services, such as weather apps for smartphones, seems to me more properly done by the private sector (by which I do NOT exclude open-source projects).

Why? NOAA is producing all this data, why shouldn't they aim to make it actually useful to people?

We probably shouldn't sink a huge amount of money into it if it's going to be provided just fine by the private sector, but I don't see an issue with putting a small amount of money into it if a lot of tax payers get a benefit from it.
Torture works at hurting people. That is what it is for, that is what is always has been for, that is what it always will be for. Everything else is just a way people try to justify things.
"Power is not a means; it is an end. One does not establish a dictatorship in order to safeguard a revolution; one makes the revolution in order to establish the dictatorship. The object of persecution is persecution. The object of torture is torture. The object of power is power." - George Orwell
I'd say 95% of IoT devices right now are from companies looking to jump on the bandwagon. The "iPod" of connected devices (i.e. actually useful) hasn't been discovered yet. Most products right now are just looking to tick a box for shareholders/investors.

Sidenote, those earbuds sound interesting. Could you point me to them?
Specifically that article is by Damian McBride, who was Gordon Brown's SPAD. It's continuation of a political brawl by means of a newspaper column. Not a very nice chap:

"On 11 April 2009, he resigned his position after it emerged on a political blog that he and another Labour Party advisor, Derek Draper, had exchanged emails discussing the possibility of disseminating rumours McBride had fabricated about the private lives of some Conservative Party politicians and their spouses. The emails from McBride had been sent from his No. 10 Downing Street email account."
I don't know why, but I always felt that there was a market for a no-bullshit movement, but I fear that the appeal of more money perverts the movement, and then it just becomes like every other commodity. I think most things probably start as well-intentioned, and whether it's money or power, something happens along the way and subverts the whole thing.
Great news! I added it to https://github.com/qutebrowser/qutebrowser#active now.

Now I wonder, where does the Penta -> Tri come from? Is it intended to be usable with three fingers? (SCNR)
MariaDB is a fork of MySQL... which already had its heyday when Postgres was more immature.

I've been using Postgres since 7.x (early 2000s) and everyone loved MySQL back then. In fact, the late 90s up to maybe 5-6 years ago, MySQL got more attention than postgres.. that's a long time for any software package.

There are a lot of reasons for MySQL sort of losing its position -- from the Oracle takeover, to the fork, to the various compromises that were made early on (that Postgres didn't make)... and together + Postgres continuing to make steady progress during that time, has put Postgres in the lead.
Yeah this is a very tricky thing to do well as it will always be abused. Glassdoor has been struggling (they've raised a bunch of flat rounds) and there are so many cases i've seen of bad reviews, followed by HR getting wind of it and burying them in a ton of fake positive reviews.

I run a site called TransparentCareer (https://www.transparentcareer.com) and we've tried to make all of this data quantitative and verify that the person actually worked at the organization and what role they were in. We are getting ready to release a qualitative type review/question answering system using the same verification method and you will be able to see what department within the company the review is in reference to.

I would love to hear how people think this could be done better as we are currently developing the product and would love if it could solve this need in the best way possible. Is employee verification the biggest problem or is it something else?
Balena – A Moby-based container engine for IoT
I'm currently experimenting with CodeMirror for one of my projects, and it shows that you spent a lot of time to refine its design and API. You did an awesome job, seriously.

I haven't tried ProseMirror yet, but I'm pretty sure that the same level of quality is there.

Thanks for your work!
Sorry. Inspired by DiCaprio's Movie :)
> that is meaningless to most people.

Therefore no people should be allowed to know?

For what it's worth, I'm not in favour of California's labelling requirements either. But just because something is meaningless to the majority of the population doesn't mean it's meaningless to the entire population. And it is specifically the population that is interested in knowing it that finds it least meaningless!
Why antibiotic-free chicken actually matters
(EU citizen living in UK) Yes. Brexit tipped it over the edge. Because of brexit GBP went down which become big lost for me when investing outside of GBP. Even more interesting, current startup that I am working for, decided that it's a good idea to move dev team to EU so essentially I will be working for the same company but from outside of UK.
I think straight line distance of NYC -> DC is a little further than Tokyo -> Nagoya, but even the current Nozomi Express Shinkansen would be a huge improvement over Amtrak.
I would argue that without the prior information, the statistics are also irrelevant.
Agree on that. They are both BitTorrent variants. I liked Dat's design a little better, and it's more focused on mutable data streams which is better for Web content. IPFS is good though and may end up getting supported in Beaker again at some point. Dat's the protocol we chose to start with.
Had not heard of "Blue zone"s before [1]. (EDIT: Added [2])

[1]: http://www.npr.org/sections/thesalt/2015/04/11/398325030/eat...

[2]: http://bluezones.com/recipes/
Bitcoin Is Now Bigger Than Goldman Sachs and Morgan Stanley
I'd try to take a cellphone video of every room in the house, opening closets and drawers as you go. Move at a deliberate pace; you will need to review the video and write down what you see in it should the house burn down, and sweeping too quickly through will make that difficult.

A 32GB thumb drive with scanned copies of your important documents is a nice-to-have if you can swing it.

I would only try to grab medications, three day's clothing, then irreplaceable items first, followed by what you have room/time for. If you have firearms, they are likely only covered up to $2,500 on a basic homeowner policy. Please be sure any left behind are unloaded, the heat will cause them to discharge otherwise.

Anything that is essential to earning your living (tools, laptops, photography equipment, etc.) is high priority.
The article dismisses torture almost immediately, and talks extensively about how being curious and open produces vastly better results than any other style of interrogation.
Hmmm, while bigger patterns might emerge in a connected network, it is still driven by individual choices and actions. Emergent behavior still depends on individual choices.

I do agree that it might be skewed. But I believe there is a sufficiently large middle class that can still drive creativity in the right places if it was so inclined.
This statement implies that effectiveness is more important than moral implications.
Free trial scams are fraudulent, but credit card companies make victims pay
To me - and this is completely anecdotal - is that there usually seems to be 3 criteria that strangers look for before they open up. They are somewhat overlapping, at least in the way that you can use these them to your advantage: Empathy; being impressionable; appearing weak/ignorant in one or more aspects relating to the topic.

So, you don't ask what they did or why they did it. You ask about topics that they may have led them to doing something that they did. Better still, don't ask. Lead the conversation in a way that will make the question will seem more natural.

Then you respond with something like:

"Wow! How on Earth did you handle that? (Impressionable) If that were me (Empathy) I would have [something outlandish]!!! (Weakness/Ignorance)". So now you seem relateable, and somewhat flawed, even moreso than they themselves. Often, they will try to "teach" you about why your reaction is bad, and what a better reaction would be - often with a "real life" scenario as an example.

"Aaah! That's pretty smart! (Impressionable) But I'm not sure I'd be able to handle it as well as that (Weakness)"

From here they feel they are in a position of power. Especially if you seem more impressed by some more arbitrary aspect, than concerned about the more obvious implications (Weakness/Ignorance). They often open up more about other things they've done, which may or not be related to the original question. But you're still gaining their trust. Eventually you subtly stopped being impressed by what they are saying. And this is just by body language, not words. Your eyes don't light up when they are "expected" to (Impressionable). You don't smile wryly before they end their sentences as if to say you know you know where it's heading (Empathy).

The other person starts thinking:

"Why is he/she impressed any more? Is it because they're really that ignorant? Or maybe what I'm saying isn't really that impressive to them? Perhaps I should fill in more details, and maybe I'll tell about some other thing I did"

Now I'm not saying this will work interviewing terrorists/criminals. But this has been my own experience for as long as I can remember. People tend to tell me their darkest secrets (even without me asking) within about 30 minutes of meeting me for the first time, especially when alcohol is involved. I rarely ask directly. People just end up telling me things.
Start with being nakedly honest about what your strategic or business goal is in investing in content creation. If it's just growing inbound volume, and there is nothing wrong with that, use attention arbitrage. Find out where your tribe is hanging out. And join the conversation. In an authentic, genuine way.

But if you have a larger mission. More than growth. Priming humans for a multi-planetary future for example. Then you need to think deeply about design and innovation. Not just for the messaging, but also the channel you will be delivering upon.

It's like the difference between a marketer who reads an article in Wired and thinks "we need to get our brand on VR". Then they assign a budget, hire an agency to make some thing fast and drop it. Adding another bit of litter to the already noisy and crowded airwaves.

Versus some thing like LEGO or IKEA's experiences that allow you to virtually place new products in your living room and purchase on the spot. Serving as an incremental move to a place where consumers can customize designs and even 3D print products.
僕にライセンス情報を日本語で見せてね！
僕の国連ZIP NAME情報から調査料金貰ってね。
PASSPORT NO. MU2840701/誕生日:1975-08-08/固定電話番号/81787421588/吉都紀　貴夫
Hey! I’m one of the creators of Beaker. Beaker is built with Electron, a wrapper around Chromium, and it doesn’t include any UI elements like tabs or the URL bar. We made those ourselves, and have taken inspiration from a number of browsers.

What you see here is actually the “old” version of Beaker - a lot has changed in the upcoming release. Here are a few tweets with screenshots if you want to see a preview:

https://twitter.com/taravancil/status/906583737789542400

https://twitter.com/pfrazee/status/910988429881675782

https://twitter.com/taravancil/status/918232881641779201
Best used for cross-DC traffic over public networks if you have access to multiple physical links, and no transparent DC-Internet routing
I find the phrasing so funny, "known to the State of California to Cause Cancer", as if the State of California had any bearing on evidence or scientific truth.
I wouldn't take everything on Glassdoor at face value, but if there are recurring negative themes in the reviews then that can be a red flag. I read them the same way I read reviews on Amazon, I look at the distribution of scores and then read a handful of each rating.

If there is a low distribution of 1 star ratings, then either the 1 star people are outliers or there is some sort of incentive for the higher ratings (either pressure from management to give positive reviews, or the company could just pay for fake reviews). Sometimes this is obvious, like a bunch of positive reviews that sound the same posted in a short timeframe, and sometimes it isn't. At the end of the day it is going to be a gut feeling.
A lot of microblogging/social network is "stuff people don't want to pay to host". Some of the rest is "stuff people would pay to host, but for reasons they want to post it on services that don't allow them to pay to host". With a P2P system, you at least have the option to pay to host (=setup a server or pay a service to help serve content that's important to you around)
That would be cool. But consider that some people have thousands of wildcard vhosts
On my 6+, the sequence is: press home button, tap Settings, Wi-Fi, Off. That's 3-4 depending on whether you count the home button.

On a 6s or newer, with 3D touch, you can cut it down to 2-3: unlock, force touch on Settings and toggle WiFi from the menu that appears. (That might be 1-2, I forget whether you can force touch and drag to what you want to activate, or whether it has to be a separate tap.)
I prefer Mysql/MariaDB's `show tables` vs Postgres' `\dt`. And other commands. More like sql.
Negative reviews seem to be pretty reliable, you have to have a motivation to post them, even if the content may not be objectively accurate. I worked for a company with terrible management and every time an employee would leave they would leave a negative review.

However, glassdoor is not completely objective-- companies can get negative reviews removed simply by complaining about them, and the quality control on this is not good. So that means that over time the HR department can just keep making accounts and complaining about the negative reviews and they disappear.

Thus if you leave a negative review you have to be a watchdog... and if it gets removed, even without cause, glassdoor won't let you leave another one.

However they can't hold back the tide, here's a comment from a recent review (redacted for privacy):
" Forced "culture". It's explicitly stated that culture fit is a huge part of this backwards company. If you are too tired to go to a happy hour when the XXXX crew comes to town prepare for awkward questions why and being told you're not supporting the culture if you don't attend - by the CTO."

Reading the reviews of this company (that I worked at and know first hand) I see a lot of negative recent reviews, but the overall score is 2.4... way too high to be accurate.

HR is still grooming the reviews and leaving fake positives, to keep that overall rating up, and the negatives are all relatively recent (though they describe problems that have existed for 5 years.)
Does it support rerouting?
I suppose my question is illformed. And perhaps it's not possible to make my question properly-formed.

I mean very similar to Twitter, in that it's a centralized service.

But, they'd do a better job of protecting users when threads go hostile. Perhaps I'm too focused on today's boycott.
Show HN: Check whether you favourite NuGet packages are .NET Core ready
There is a finite amount of vertical space on one's screen, and thus a finite number of lines of code that can be displayed simultaneously without scrolling. Reducing the amount of scrolling that needs to be done to view the entire body of a method can itself be an improvement to readability.
I'm a big fan of your work Marijn!

Do you have a Patreon or other donation method on your site?
Yes, thank you! I've favorited it so I won't lose it again.
I was dreading the big "BUT + <arbitrary rant>", and indeed, it never came.

I share many of the views of the author. It's a great piece of software.
Companies are generally pretty good at not letting people who aren't company cheerleaders do interviews.
I made a script which would automatically check my visa application status a couple of times a day:
A simple selenium script which went to the embassy website and downloaded the latest new PDFs for visa decisions, and search the PDF text for my application number.

I wanted to complete it by adding a telegram or text message push, but I got lazy at that point. One script which simply printed out the result on my terminal was good enough.
The ease of repeating a calculation against a data set or recording such a dataset from instrument readings is not exactly the same repetition of a lab or factory recipe outcome. Science concerns data collected and copied yesterday. Tekne concerns repeatable outcomes reproduced tomorrow. Distinctions between the endless feast of science and endless labors of tekne are pretty clear.
First, a key reason for police interviews is to find people's associates, roll up terrorist networks and prevent future crimes.

Second, I find it odd that you think putting killers in jail is "a waste". Should we just let them go and have another try?

Last, you assume that these individuals murder innocent people because they have some valid point about society, which policy-makers need to learn and act upon. What point would that be?
I work at Google and authored some of those posts.

The limitation is per table[0] and for "batch loads" only. If you have per row inserts, you can always use bigquery's amazing streaming API, you can also do materialization and federated query loads.

Batch limits are there to help folks from creating too many small files, which affects performance (I believe Jordan's book explains this in greater detail).

Would love to know more about your use cases since this type of thing shouldn't be the deciding factor in choosing an analytics data warehouse and should be easy to architect for. As someone pointed out, most quotas are negotiable. If anything, bigquery ingest process is pretty amazing and unique in the industry [1].

Apologies for brevity, I'm out of office on paternity leave.

[0]https://cloud.google.com/bigquery/quotas#import

[1]https://medium.com/google-cloud/paying-it-forward-how-bigque...
Do your clients know from the off you will be using SquareSpace — and, more importantly — do they know what SquareSpace IS?

Kudos to you, I'm just amazed people will pay that for what I tend to view as a DIY service!
Or how much of it there is. Parts per million/billion?

I'm pretty interested in how much cadmium and mercury gets into my system because they're bad news for the brain. At the same time, mercury is also in air so it's kind of inescapable. Parts per billion is interesting information because then I can control how much I ingest the way I do for food that is fattening.
I'm not in a position to answer your question, but I thought you might be amused to know that there was once a day where a question like yours would have been "why does MySQL get all the attention while PostgreSQL is largely ignored on Slashdot." I probably asked that question on more than one occasion. PostgreSQL was already more capable and mature than MySQL at the time.
> weakened crypto that will be the demise of your Android rather than exotic exploits of your wifi.

I don't think there's any truth to this - if the crypto were weakened you'd see it broken by that quite quickly - but it's quite strong and follows well accepted stands in the cryptography community, have a look yourself if you like. It's using dm-crypt and dm-crypt is fairly heavily tested and reviewed. Debian and likely Purism use the exact same, so certainly wouldn't be any better in that way.
If your goal is to get people to stop torturing, I would personally value effectiveness at getting them to stop above all else.
Postgres has similar SQL commands.

Commands that start with \ are shortcuts in the psql client that are translated into SQL commands.

You can always use SELECT * FROM pg_tables; and operate on those tables as if it was a normal SQL relation (because it is).

Additionally, if you use psql -E, it shows you the SQL it runs for such shortcuts. For \d (Show relations) it runs:

SELECT n.nspname as "Schema",
c.relname as "Name",
CASE c.relkind WHEN 'r' THEN 'table' WHEN 'v' THEN 'view' WHEN 'm' THEN 'materialized view' WHEN 'i' THEN 'index' WHEN 'S' THEN 'sequence' WHEN 's' THEN 'special' WHEN 'f' THEN 'foreign table' END as "Type",
pg_catalog.pg_get_userbyid(c.relowner) as "Owner"
FROM pg_catalog.pg_class c
LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
WHERE c.relkind IN ('r','v','m','S','f','')
AND n.nspname <> 'pg_catalog'
AND n.nspname <> 'information_schema'
AND n.nspname !~ '^pg_toast'
AND pg_catalog.pg_table_is_visible(c.oid)
ORDER BY 1,2;