skysight-inc/HackerNews huggingface dataset:
Some of these functions (like SIGN, STUFF, and PARSENAME) set off little alarms in my head that sound vaguely like a full-stack developer furiously yelling "DON'T HANDLE THIS IN YOUR DATABASE LAYER."

Of course we don't always have that option, but I feel like I have to acknowledge those alarms if I'm going to use them.
Exactly. iPhones are completely locked down, and with Android devices that best case is you can install Cyanogenmod or Lineage. They still package a giant binary blob from the manufacturer. You cannot install something like Ubuntu or FirefoxOS, so of course those died.
The only part of this I agree with is his comment on database permissions.

Every modern SQL database has a concept of users and permissions that are divorced from your application, you're left with three options all of which are flawed.

1. Handle security inside your application. This is the worst choice if users need to get a LIST of records they have access to and it's determined by something more than a simple WHERE owner_id = :user_id. Think multi-tenant applications where records can belong to a tenant, and users have access based on a org hierarchy or other criteria. Suddenly you're having to filter a whole list of records out in your application code, and this makes implementing pagination awful (do you requery until you fill up a page, or present a partial page?). You are also taking full responsibility for security, if you modify your queries to filter records out you open up to human error where someone forgets to filter this one query.

2. You implement a method to synchronize your application users with the database, and use the database engines RLS support to handle access control. This is probably the best approach for web applications, but the caveats that come from it still suck. You have to make sure the connection is set as the user performing the action, this is doable with PostgreSQL, MSSQL and Oracle at the least (SET ROLE / EXECUTE AS) without destroying your ability to use a single connection pool - but for all the security you get out of this your web application user still has all the keys and if that account is compromised or there is a flaw that can cause your application to not switch security contexts you just failed at protecting your data.

3. Just use the database directly, it's handles authentication and you never change security contexts for a session - you can safely utilize the RLS functions of your database without any real risk since that database session is fixed to the user it is handling. Downside, you just lost connection pooling and while pooling middleware like pgPool can help you still have Y more connections since you need to maintain a separate one for each user or tenant at best.

Approach 2 is by far the best we have, and you can make it safer by doing things like utilizing pg_hba.conf to limit access to the application user to the servers hosting your applications - but maybe you're using docker and IP addresses aren't fixed anymore (well, shit!). Also, how are you going to ensure the database connection is in the correct state when you make a query? Where are you going to plug that into your request pipeline?

I'd really like to see modern tooling around this problem, I don't know what exactly it would look like but it would be nice to have SOME improvement in the area.
Recipe for an employment robot
I wonder if Bezos will own more of the result?
> So in general if someone recognises they've made a mistake, they should continue on making that same mistake regardless?

Doesn't sound to me like Canonical is admitting a mistake. Quote from OP:

"This has been, personally, a very difficult decision, because of the force of my conviction in the convergence future, and my personal engagement with the people and the product, both of which are amazing." (emphasis added)

My point is that Canonical's behavior, both in 2010 and now, is bad corporate citizenship. They're showing very little regard for their users and their community.

> If enough people want it, Unity can continue to exist as a community-led project, just like how GNOME 2 got saved by MATE.

Honestly, I hope that doesn't happen. If convergence and Ubuntu Phone aren't happening, I'd rather see the resources go into other DEs that already have a strong community like KDE, GNOME, or MATE.
It depends on how complex you want to make it. I like the Big Nerd Ranch and Head First books. Both are very practical and clear. freecodecamp.com and codecademy.com are good places to learn as well. Good luck!
The bank generated that "money" out of thin air. The big scam is that it's all just ones and zeroes.
Well, yes and no. The log will show a different id (public key) which authored the message. But the device itself (iPhone or Google Nexus or whatever) doesn't need to be mentioned.
Is that just a long-winded way of stating that government can be a useful tool to interfere with price discovery, which we should only do when we are certain it's called for?
And here I was wondering what my new anxiety for the day would be.
Ensure a proper and complete master flowchart is in place of the entire business, for each step in the flow chart that a document is attached to it to explain each area, or step itself. Incoming team will have a starting point to keep busy. I tend to use confluence + gliffy for an integrated wiki and diagram, it's highly productive and easy enough to use and maintain.
I've no idea about the guy, but photos from live events can be very out-of-context, so I wouldn't put too much weight in this.
Early agriculture was indeed the worst. But look further back, to a time before agriculture. Hunter gatherers spent significanly less time actually hunting and gathering that we do working today. And while off work we have a hard time mentally letting go of it, hunter gatherers instead had pure free time. I'm not saying life was perfect back then, but in terms of work we can clearly strive further. Agriculture has been fairly brief time in the history of our species, so perhaps we shouldn't be using it as a base line.
Another complaint I have about 9-5 is I can't find time to do certain things because everyone all works the same hours. Certain services such as doctors appointments are only available while I'm working, or if I need contractor services at home, again, only available while I'm working. Luckily I work in a city centre so I can do some things in my lunch hour, but if you happened to work out of town (e.g. business park), or if the thing you need to do takes longer than an hour you're shit out of luck.
And then my internet connection goes down. Power goes out. I run over my data cap for the month. Comcast shuts me down for running a home server. My home network gets DDoS'd. I miss a patch day and I get hacked.

None of these things are a concern on traditional social networks. They have to be solved before the world has any chance of moving to a decentralized network.
Not mixed up with someone else.

https://en.wikipedia.org/wiki/Matt_Ridley

He was made a board member because his father had been a board member. And then he was promoted to chairman of the board. His academic training was in zoology but he wrote for the Economist.
I worked on school papers high school through college. Administrative review served a very useful purpose and kept the quality of the papers higher. I respected every administrator I dealt with.

They have a much harder job than it might appear at first blush -- even the slightest hint of repressing a valid story turns a very harsh spotlight on them.
...or point-to-point IP connection, so the device count not reach the general internet, just your white-listed endpoint?

I just want a pipe.
"[..] Exchange, as practised by people for about the last 100,000 years [..]"

We know that exchange is just one more activity that humans do, but, historically, in the thousand of years context, it was not fundamental.

We could argue that in the palaeolithic the social organization had little to do with markets. We could argue that in the neolithic, the social organization was, in most cases, hierarchical and top-down.

So, the implicit assumption of markets as the 'natural state' of human organization has not real basis. Even money is an invention of the state.

The idea that markets are powerful tools don't need to be defended. It's the idea that markets know what is better for us what many reject.

It's like saying that we should just start the lawnmower and leave it to decide what to cut. Then, when we don't like the garden, we have to accept it's for the best, because if a better garden was possible is what we would have.
A Fluent Interface to Rapidly Interact with APIs
> Wait, isn't there a million of these already?

If there is a million of them, there must be business here, and if an entrepreneur thinks he can do it better than his average competitor, he should definetly go ahead.

A company doesn't need to be revolutionary to be a success-story. Distruptive ideas are exceptionally scarce and they represent a microscopic share of the economy as a whole.
The articles point is that there's a bit more to Stack Overflow than the four database servers it sits on, and because MS SQL is treated as a monolith,a stupid amount of development time, the world over, goes into doing things the database, arguably, could be configured to do itself.

I click the accept answer button on my web browser, stack overflow stack reads the cookie my browser presented, does a bunch of logic in the app server, then does a database lookup. It then takes the web request, does a bunch of other logic with it in the app server again, then... runs some more SQL against the database.

Stack Overflow, and I, and presumably you as well, have written tons of custom code that sits between the web browser and database, but the article's thesis is this is stupid because if the database "just" spoke http, then it could do the majority of that natively, no Ruby/Python/JavaScript/.Net or anything needed.
In my area McDonald's is a pretty large employer of physically disabled people. Not a single one of them has the dexterity or strength to load a plane. Coincidentally I know some people who work at my local airport and they don't have any idea what they're loading or unloading or where it's going to unless they happen to speak to the pilot.

Employment does not exist to fulfill your personal sense of self worth. You're providing a service to someone who is paying for it. In fact, most of those jobs that do fulfill your personal sense of self worth often pay less due in part to that.
Energy Impact Partners launches credit group for energy-focused growth companies
When the author talks about the Collective Brain, or the Cloud, it is really referring to the Market, or the Marketplace of Ideas. Conservatives like the market over government for the very reasons outlined in this article. I'm glad these fundamental ideas are getting updated with today's nomenclature.
I used to think they were two different people, as chairing a bank and being a science writer are not normally found on the same CV. However, it seems that he's just one person (https://en.wikipedia.org/wiki/Matt_Ridley).
I think he made the mistake of ignoring half the connotation of the word. "Barbaric" really implies a combination of two underlying ideas. He's right insofar as the 9-5 is backwards and unsympathetic to human beings, which I think is his point. He's wrong in that it isn't physically brutal. The problem is he picked a word with a complex connotation when he needed a simpler one.
Hey OP! I've been using it extensively and it's definitely more than good enough for most tasks you'll be doing. If you're going this route, I'd highly recommend following the Keras' authors guide on how to set up the instance and connect to it with a jupyter notebook: https://blog.keras.io/running-jupyter-notebooks-on-gpu-on-aw.... This will boost your productivity a ton in the long run.

Best of luck!
Depends on the satellite. A cubesat is very cheap, a large commsat might be in the 100s of millions range, military surveillance satellites might be in the billions. But in general we should expect a world with cheaper launches to lead to an equilibrium where the average satellite gets less expensive.
I dont think there will always be open source software. All it takes is a new law to be passed and then become illegal.
Overall, a well written review. Technically, it misses the core issue.

The only thing about a smoke detector that matters is will it go off when there is a fire because people are much more likely to die if it does not. A phone app only makes this less likely to happen because it adds incidental complexity and because that incidental complexity provides a wide attack surface for IOT bot nets, malware, etc.

Proper engineering of smoke detector software/firmware is one line of code per programmer per week. Like NASA. Move fast and break things means some of the things likely to break are human lives.
Shameless plug for a CLI *say derivitive that a coworker and I made: RabbitSay. http://www.rabbitsay.wtf

$ pip install rabbitsay
$ rabbitsay "shameless plug"
┌───────────┐
| shameless |
| plug |
└───────────┘
(\__/) ||
(•ㅅ•) ||
/ 　 づ
Google OAuth in embedded browsers will stop working in 14 days
I am not much of a social networking type of person, but I have wondered how nice it would be to network with a community like HN. For example, I see a nice comment chain going on in some news article, but as the article dies so does all the conversation within it.

Maybe it's just me but if I see an article is x+ hours old (15+ for example), I don't bother commenting.

What type of social networking would HN use for non personal(not for family and immediate friends) communication? (I've tried hnchat.com, it's mostly inactive imho)
> Really, barbaric?

Yes. Think of it in terms of a larger picture. Most men are spending the better part of their lives making the top 1% rich. That's what a 9-5 day job is. Or, as Mr. Bukowski likes to say,

> It was true that I didn’t have much ambition, but there ought to be a place for people without ambition, I mean a better place than the one usually reserved. How in the hell could a man enjoy being awakened at 6:30 a.m. by an alarm clock, leap out of bed, dress, force-feed, shit, piss, brush teeth and hair, and fight traffic to get to a place where essentially you made lots of money for somebody else and were asked to be grateful for the opportunity to do so?

And if that doesn't convince you, this letter Bukowski wrote just might: http://www.openculture.com/2014/07/charles-bukowski-rails-ag...

edit: I just remembered: this reminds me of an article called 'why a medieval peasant got more vacation time than you'[0].

[0]: http://blogs.reuters.com/great-debate/2013/08/29/why-a-medie...
I thought about subscriptions for publishing in the past, very tricky. Surely I don't want revenue share to go "per view", quality is only going down that way (it's exactly the same situation as with ads, with publications struggling to get eyeballs, continuing in the clickbait practices that are killing the good stuff).

On the other hand I never felt like clicking the flattr button. But as things are now I prefer to opt in after reading a good article than ending up on some actual fake news by mistake and knowing I contributed to make them rich.

That is without even talking about the problem (in my opinion) that even the more innocent subscriptions (music, tv, movies) have with stuff like geo restrictions and exclusives...

And to be clear, I use uBlock Origin because ABP's idea of trusted publishers would be stupid even if it was not a shakedown business
Why Functional Programming Doesn't Matter
Do the features micro-G provides require only installable software, or is there a service component that's provided/required?
if you want to participate in the comments a baseline level of understanding isn't a big ask.

Thats not fair. I came to the comments after reading the article to learn more about the article. I think its considered poor quality to make a comment like ADF is the worst. Without referecing what ADF is first, or without being referenced in the article.
Traction channels I’ve tried for our travel startup
I really Hayek fan and I agree that he was wrong here.

Allende was not as socialistic and not as much in control as Hayek thought. Since WW2 Hayek had a huge fear of democratic socialism turning into what we would now call stalisim.

This fear never really came to pass because there is to much vested interest in the markets, thus the change happens slowly. Most democratic countries realize that they have gone to far, and then go back.
I do recognize I have large gaps of data missing. This was written as a hypothesis on travel and randomness. To support kids activities in a southern US city, random time/source/destination of drivers is removed. Most people have to drive to the same location at the same time to send their kids to school or other activities. Thus, the event yesterday added more randomness to the travel patterns by removing the kids activities.

I don't have real-time flow of all data, thus I could be completely wrong. All I have for traffic data is a few Google traffic maps.
Why is Twitter so aggressive with image caching? The nature of the timeline is that it's unlikely you'll see an image more than once.
> It's such a dramatic leap forward from the way most humans in history--and many still today--have had to scrimp for survival,

It's not actually. Farmers did not work 9-5, and only worked when weather permitted it. i believe 9-5 is a remnant of industrial era
1) I think you're understating the amount of free time people had in the past, especially with respect to hunter gatherer societies.

2) Joining an autonomous hunter gatherer society obviously isn't possible now, because they doesn't exist. The paraphrased "it's your choice, if you hate the 40 hour a week routine so much, just become a hunter gatherer in the Rockies" line doesn't cut it.

Even when hunter gatherer societies did coexist with more sedentary civilizations, states had to constantly fight to control the bodies and labor of the people it ruled, because they constantly were calling it quits to join the hunter gatherer societies.

The transition to agricultural, state dominated societies was a slow, contested, emergent property of collective violence, not something most individuals wanted.
This 4k screenshot is really impressive, and as the benchmarks at the top show, there's lots of headroom:
https://cdn.gamer-network.net/2017/screenshots/Forza-Tech-Sc...

Takes a minute to load, I think their cdn is a little overloaded currently.
What about complex programmers?
Why bother with rounding errors in the budget when every large spending has some biased influence on the population?

Of course it's much harder to make real effective changes to the budget than bicker.
If I understand scuttlebut correctly, your stuff is broadcasted to whoever it might concern and the pubs. If you still have your private key, you should still be able to access whatever is in the ether, right ? You somehow become the recipient of your own messages. Only the thief will also have access to your private key, so the account can be considered compromised.
Ahh, the old "nobody's holding a gun to your head, you didn't have to spend $50 for dinner, you could have had Kraft Mac & Cheese!" argument. Good one.
Lance: real time JavaScript multiplayer games without worrying about synchronisation
I think you are artificially connecting the two. I think you can have economy of scale without having rich corporations. There are many kinds of wealth and risk aggregation schemes that are potentially better than giving huge amounts of wealth to a single point of failure.
> As far as I know, federation has only worked for ancient stuff that has nothing to do with social networks, like email and DNS. Basically, it is a part of core functionality and thus can't be co-opted by commercial interests (though GMail has made quite an inroad!).

Email only works _because_ of big players like GMail. Running your own server spam free and away from black lists is an endless task.

DNS is going a similar way with more and more ISPs resorting to hijacking DNS lookups for all sorts of nefarious reasons. This protocol seriously need a broadly embraced signature system to validate origin.
Hey, Timescale team member here. Thanks for the <3. Looking forward to hearing how it goes for you.

Would also love to learn more about your use case... If you feel inclined to share more, please shoot me an email andrew@timescale.com. Thanks again!
I figure anything which I wouldn't be doing on my day off should be counted as work time, including commuting and ironing shirts.
I did google it, thats not the point. It wasn't a "word" I didn't know, it was an abbreviation of a topic that was the main source of the top comment (at the time).
Does anyone know anything about the "Hovis method" they reference for fine tuning the power profile for each chip? I'm having a tough time understanding how tweaking the voltage rails from board to board can improve power consumption/heat dissipation without impacting CPU performance.
This amount of money seems like it would be a good candidate for small claims court. Can anyone tell me if this guy can use small claims court (which is easy to initiate) to recover the money? I feel like even if he lodged a motion against the branch manager for negligence it might be enough to get things cleared up.
Hayek was an absolute fabulist and quite dishonest too. His arguments against central planning rely on a sleight of hand where any government planning is identified with something like GOSPLAN under Stalin. How people using the internet, created by DARPA and NSF can fall for that is beyond me. Clearly, governments can plan well or badly. For that matter private corporations can plan well or badly - IBM and Intel have centralized planning on an immense scale.
You can write a JavaScript component to read out the feed in the background and transform it into an RSS feed. Current U.S. law prevents someone from offering this commercially, especially in a SaaS package.
Is this a result of net neutrality rules being over? Or net privacy rules being over?

Also what are the implications of Comcast subscribers already using Xfinity hotspots for free?
Go tool trace
Update: A one minute demo video - https://youtu.be/RBiDL5neWDc
You can cut the irony with a knife. I left Comcast after they imposed data caps in my area which I struggled to stay under.

I have several roommates and we generally consume media via streaming services; primarily twitch and netflix. It seems to me that Comcast is using data caps as a 'streaming tax' for cord cutters.
Snapchat launches Stories search and Facebook hasn't copied it yet
Yep, hence:

> In powershell from memory:

in that comment - I was on an iPad, and didn't have access to Powershell.
I think it's enough data to form an interesting hypothesis, but a lot more data would be needed to support that claim.

I've often noticed that my commute is much faster on days without school in Chicago, especially my commute home. I think an equally plausible explanation is that people without kids plan necessarily plan their entire schedule around them.

For instance, if there is a school inservice, is traffic better because people aren't taking their kids to school, or is traffic better because people stay home with their children?

Another thing is that school holidays tend to be local government holidays as well. The local government is one of the largest employers in almost any jurisdiction. If the kids aren't in school because of a holiday or a severe weather event, there's a pretty good chance employees of the local government are not going in to work, not to mention the fact that the school staff probably are probably also not going to work.

The research wouldn't be that hard once you had some data, but of course, gathering data is the hardest part of most research.
Probably used by movie/TV studios which explains the price... B2B is where it's at.