skysight-inc/HackerNews huggingface dataset:
Many of us work 14 hours a day, plus occasional weekends, don't yet have kids or a house, and are at the top of our field.

You can call it whatever you want, but its not adding up to a "better life."
Not sure why but some of your previous comments are showing up [dead] in the threads.
STUFF is actually needed in the database layer to not kill performance of your app. SQL server has no built in convenience function the equivalent of mysql's GROUP_CONCAT. Instead, you do a subquery in the selected field, interpret it as XML, pull out the specific XML elements you are looking for as a list, and then use STUFF to join them.

As much as you might recoil in horror at this (and I still do), it's actually fairly performant because the optimizer recognizes the subquery is dependent on the main query, and does the equivalent of a join under the covers or something.

E.g.

# MSSQL
SELECT
movie.id,
movie.name,
STUFF( (SELECT ','+producer.last_name FROM actor WHERE producer.movie_id = movie.id FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(32)'),
FROM movie;

# MySQL
SELECT
movie.id,
movie.name,
GROUP_CONCAT(producer.last_name),
FROM movie
LEFT JOIN producer ON movie.id = producer.movie_id
I believe his foundation is allowing other people to contribute in the way he and Melinda have setup so well. With that said, I like that our largest influencers are tackling problems at various stages. Finding the ideal mix will take time (this is all in the last 15 years for the names being dropped).
Agreed. The resemblance to Usenet and email are what I find especially intriguing.
If this is a game where they are traditionally going to sell no more than one copy to me, and it's 99.9% the same across all those platforms, and it wouldn't cost them money to do so because of clunky licensing agreements, then yes I would want my copy of the game to be portable across those devices.
"Is there anything one can do to reduce the risk of a disovery fishing request on my personal devices?"

If it's fishing, you can push back. If it's reasonably targeted to result in actionable evidence, probably not :)

"Or is simply working for a company being sued sufficient to be compelled to produce my personal devices?"

Probably not quite without a good reason.
To be clear, it's not just companies.
If you were, for example, getting divorced, acrimoniously, expect to have your personal devices subpoenaed (my ex was a family lawyer, this happened all the time)

"This entire concept is deeply troubling to me."

Remember that the goal of the civil justice system is not to let people hide things.
They just want to resolve the disputes.
The best way is "put all evidence and cards on table".
So they try to do that.

In cases where it is embarrassing or whatever, you can get protective orders on who may have access, etc.

But you should fully expect, in any lawsuit, company, your neighbor, whoever, that if they have good reason to believe you have relevant evidence on your personal device, you'll be forced to produce it.

If you don't have relevant evidence, i would push back hard.

But also note. Misuse is strongly actionable:

"(1) Avoiding Undue Burden or Expense; Sanctions. A party or attorney responsible for issuing and serving a subpoena must take reasonable steps to avoid imposing undue burden or expense on a person subject to the subpoena. The court for the district where compliance is required must enforce this duty and impose an appropriate sanction—which may include lost earnings and reasonable attorney's fees—on a party or attorney who fails to comply.

...

Paragraph (c)(1) gives specific application to the principle stated in Rule 26(g) and specifies liability for earnings lost by a non-party witness as a result of a misuse of the subpoena. No change in existing law is thereby effected. Abuse of a subpoena is an actionable tort, Board of Ed. v. Farmingdale Classroom Teach. Ass'n, 38 N.Y.2d 397, 380 N.Y.S.2d 635, 343 N.E.2d 278 (1975), and the duty of the attorney to the non-party is also embodied in Model Rule of Professional Conduct 4.4. The liability of the attorney is correlative to the expanded power of the attorney to issue subpoenas. The liability may include the cost of fees to collect attorneys’ fees owed as a result of a breach of this duty."
Every MVNO has QOS working against them and caveats, like throttled speeds, no roaming, and basically always soft-caps. Most of the postpaid official carrier plans have soft caps too, but these are often MUCH lower(like 5gb instead of 25)
My lunch is included in my day but I know that's an extremely rare situation. The 4-mile, 10-minute drive is pretty nice too.

But serious question: do you think your employer should pay you to commute?
My account is a similar size and I get hundreds of spam follows every year on Twitter. I always report and block them.
I personally use PIA, now the service is slower (than other services), but they've clearly proven themselves :)

https://torrentfreak.com/vpn-providers-no-logging-claims-tes...
That's fair, but the context I'm using is the rest of the article, which is rather grandiose itself.
Maybe I am completely off the marks here, and I'm sorry if this is off topic, but as someone who follows very closely what Apple is (or isn't?) doing in their Pro machines I am very curious how those specs compare to what everyone is asking for from Apple. The RAM is obviously low, fine, but it sounds like the CPU and GPU are significantly more capable than anything that Apple is shipping right now, and Microsoft will sell this thing at a fraction of the price that Apple will sell any pro hardware. What am I missing? Where is the big gap in component cost? How is something like an Xbox so different, and so much cheaper, than a pro level desktop?
why would anyone ins 2016 not have an internet connection, and dont take advantage of online play

when there was a rumor or intention to make the xbox one require a net connection (a not so unreasonable requirement) most people took it negatively

anything that give the perception of limiting your freedom and choices, will be viewed negatively, even if those limits wont really hurt you

and i think you are correct, most people wont use emulators, most people dont even know what emulators are, so why ban them .. it is just bad publicity
I find Private Internet Access to be pretty good. https://www.privateinternetaccess.com/
Generic drivers would make the life of those developers easy and it would give them some time to some thing useful instead of stupid drivers.
If you click on your profile avatar image you can access your lists.

From that point, you can use the url for a specific list as your entry into "Twitter". So in some ways, the use of lists is better than the mobile app, because they are URL accessible.

On mobile, if you "save to home" screen, then that icon becomes a one click way to get to a list.
On Hacker News, for example, people don't talk about themselves, although they do like to get upvotes.
For one, JavaScript code is actually pretty verbose. It both has a large payload size and high parsing overhead. Earlier versions of Ember's rendering engine worked this way and the change to a data based wire format in 2.10 made a large improvement: Intercom saw a 28% reduction in their whole application payload size. LinkedIn's uncompressed compiled template size dropped by 71%. As the wire format is all data (arrays for the most part) you would expect some parsing speed improvements as well.

And second, generating imperitive code makes it harder to perform runtime optimizations. For example during initial render Glimmer could note if a property lookup yields an Immutable object and use that knowledge to disregard change tracking for properties off that object. There are some fun things we can do here.

It turns out JavaScript engines are very good at iterating flat arrays and running small, highly optimized functions and that's what Glimmer is doing at its core. When your compiler output generates functions, you're creating lots of functions specialized for each template which means a larger surface for the v8 JIT to worry about optimizing. By instead shipping lots of small, hot functions to be re-used (instructions fired via opcodes), we can get a better optimization result from v8 and other engines.
I started an MVNO called Charge (https://charge.co). It's not as easy as you think to hit 100K subs.
FLAVOR: Ubuntu Desktop 16.04

HEADLINE: Fix multi monitor different resolution scaling without imprisoning the mouse cursor.

Description: This bug here, actual working scaling with different resolution display using xrandr --scale.

I have been banging my head against the wall on this one, it's a reasonably hard fix I can imagine but the benefits with 4K screens coming and real scaling between displays with different resolution actually working would fix my current headache. This is imo such a basic thing when using a multi monitor setup and now with a new 4K laptop and 1080p extra monitor I want to kick a donkey out of frustration.

Mostly because the exact setting I need is there and it scales the display just the way I need it. But it's bugged and the mouse cursor is stuck to traversing the unscaled resolution.

https://bugs.launchpad.net/ubuntu/+source/xorg-server/+bug/8...
Under what context would a Chromebook not be a PC?
A lot of those tools are in TweetDeck. Not sure why Twitter didn't integrate it more post-acquisition.
But many of these services are also available on iOS.

Would you still consider them part of Android?
That's the IE/Safari/Android/vi problem: defaults.
Probably the same reason that "slack == irc" and anti-systemd comments get heavily downvoted. Younger generations want badly to believe that they've invented something completely novel and unique.

This absolutely is usenet + crypto.
Ew.

Your staff using client information to look up non-necessary information about them to satisfy their interests is a massive breach of privacy. In most places with an official privacy policy, that would violate it. Particularly just to gossip with coworkers!

I hope I never do business with your office. Just ick.
Uses less space on the site, and it's much more cleaner that way. Much more customisable I guess.
Great news. I hope we hear more about pluggable storage engine soon though. RocksDB support will be just perfect.
What you just described is a hidden variable model which cannot reproduce the behavior of entangled particles. For details look up Bell's theorem.
Mapping metrics to SaaS growth stages
But I bet Facebook is much larger. If this were to really meet my needs (i.e. people I actually know start using it regularly), I can see this becoming an issue that needs to be solved, especially on mobile. Bitcoin ran into this issue as well, the need for a client to get the whole blockchain. I can see some solutions once cross device identity is done where I get a small amount of the network, perhaps the most recent, then it syncs up with the larger storage on my home PC later.
Actually, that search yields all questions and answers. Adding "is:question" to the search query

http://stackoverflow.com/search?q=nullif+%5Bsql-server%5D+is...

results in 337 answers. This is still a large number though because NULLIF is a ridiculously simple function to use. Base upon a small sample, these questions appear to be due to either misordered expressions or poor grasp of order of operations that happen to involve NULLIF.
How does this differ from pass?

https://www.passwordstore.org/
> MVNO = mobile virtual network operator

I subscribe to the Elon Musk school on acronyms--avoid at all reasonable costs [1]. That said, expanding "MVNO" to "mobile virtual network operator" does nothing for the discussion. If you aren't familiar with the former, you won't be with the latter.

Repairing the original sin of calling such virtual networks MNVOs post hoc is simply more friction than going along with an agreed term.

[1] http://www.ibtimes.com/spacex-boss-elon-musk-threatened-dras...
> The db auth layer is for db management, not frontend auth

Yes, but why? The database already has a table of database users, and the different permissions they're allowed. (Well, hopefully your webapp doesn't just do everything as the root DB user with * privs.) Is there that much to be gained from the database having a second table of users that you've created, and then you get to reimplement a bunch of logic in your app server on top of the database so that you have... users and permissions?
If you like Prolog, but want static typing and no cut operator, you might really like Mercury (https://mercurylang.org/).
"Employment exists to allow you to provide value to a company..."

I would claim employment is an economic pattern our civilization uses to process the resources of our planet. Money is just a signaling and resource allocation tool in this endeavour. Companies are a self organization pattern formed from legal constraints and economies of scale.

There is no intrinsic necessity to organize work into 9 to 5 desk jobs. Lots of the conventions our civilization has are tradition based and eminence based. They are not the pinnacle of human development.

Sure, I don't know a better way to organize all of it but that does not mean that there is no need to, or that we can't or won't.
Blogging is about the same as posting in your own "feed" on any social network.

See, for example, the indiewebcamp[1] people, who are against "silos", as they call Facebook et al., but are recreating their same functionalities with personal blogs and a new version of Pingbacks called "webmentions".

[1]: https://indieweb.org/
360 journalism: The solutions we need
I'm admittedly bias, I love SQL.

That said, I think having the database server worry about being a database is a good thing. In my career I've had a few projects that I've been too ambitious with; by trying to do too many things it failed to do any of them well.

>Databases only talk custom binary TCP protocols, not HTTP. Not REST.

Let's pretend that the database can now talk via HTTP/Rest. Is the database now responsible for handling business rules? Is it responsible for per row authorization/authentication? How does this impact performance? What if we want to export the data in another format, say into an excel spreadsheet, should it be responsible for that as well and the formatting? Where is the line drawn?

>protect against SQL injection attacks.

I mean, how would the database know the difference between a legitimate request that should be allowed and one that shouldn't? This is the point of parameterization.

>Check for XSS

I think it's plenty legitimate for a database to return some HTML data, how would the database know when it's malicious or not?

-------------------

In full I think the grievances the author raises are with middleware, not a problem of the database.
Where in the Washington DC Area is this job located?
Isn't this just re-solving a decades old problem, with the (unnecessary) constraints caused by modern web systems?
Uber's history of subsidies is well-known:

https://www.forbes.com/sites/ellenhuet/2014/07/02/ubers-newe... (2014)

https://www.washingtonpost.com/news/the-switch/wp/2016/08/23... (2016)

https://qz.com/940605/is-the-era-of-cheap-uber-rides-over/ (2017)

But I don't have a breakdown per-market.
Would it be hard to port patchwork to android? I'd love something like this for android.
Where in the DC area is this job located?
miniKanren and Prolog
Uber firing you may not be the worst of it.
You can end up in jail for contempt until you comply:
"The rule is also amended to clarify that contempt sanctions may be applied to a person who disobeys a subpoena-related order, as well as one who fails entirely to obey a subpoena. In civil litigation, it would be rare for a court to use contempt sanctions without first ordering compliance with a subpoena, and the order might not require all the compliance sought by the subpoena. Often contempt proceedings will be initiated by an order to show cause, and an order to comply or be held in contempt may modify the subpoena's command. Disobedience of such an order may be treated as contempt"

Obviously, can't hold you in contempt (or at least, can't punish you) if you validly took the 5th, but ...
8 data visualization tools for UX Designers
> If you own a PS4 or an X1 and the money to buy a PS4 Pro or Scorpio, it seems like the best move is to buy the upgrade of the platform you don't have. Then you've got access to both platforms' exclusives, and at least one new-spec machine for the games that aren't exclusive.

As someone who owns both consoles, after seeing the lack of enthusiasm at the PS4 Pro launch event I decided to hold off until Scorpio specs became known - I much prefer the Xbox "experience" but outside of exclusives it never gets much use since my "high-fidelity" gaming goes on my PC, and "console exclusives" usually are better on the PS4 (looking at Final Fantasy XV in particular here).

I'm glad I waited, there are games I want to play that are console exclusives but not tied to one platform or the other (Kingdom Hearts 3) - it looks like Microsoft hit this one out of the park. Seeing as the HDD in my OG Xbox One is going to fail soon (man is it noisy) the Scorpio looks like a good upgrade path.

> I think the most interesting thing is going to see how compatibility works out long-term for Scorpio. What will the cross-compat story be for the next console, and the one after that? Will they re-platform and lose compatibility again (and bring it back via emulation) or keep re-spec'ing the current platform? When will we see games that will play on Scorpio but not X1?

I believe the intent is that we are entering an era of smartphone-esque spec bumps to consoles, and getting rid of the full generational gap that has historically existed.

From here on out, expect new hardware every couple years that will be compatible with your existing library - after existing hardware is X generations old it will stop receiving software support and you'll have to upgrade. Likely, when the Scorpio+1/2 is out you'll see the original Xbox One and Xbox One S losing support for some newer titles (but they'll likely continue receiving support from indie developers and less intense games along with system software updates for a while after that).
AMD vs Intel components is one part of the equation.
I actually figured out an alternative for this particular case. I would create a client-side JavaScript object and store stuff there, then when they leave, it makes one call to the server with the object passed as JSON. Problem then becomes cleaning the output. I was just thinking, if you can edit stuff in the browser console, can't you edit the contents of an array? I guess actually you wouldn't see that displayed in the code, it's a state maintained in browser memory I think. But I'm still considering this potential problem and making a known/limited pattern eg. numbers only separated by a known symbol like a dash to use for exploding/splitting.... anyway will try it out.
Yeah, I've been working on something similar to this off and on. Functionally, the mechanics need to be similar to a distributed filesystem like Tahoe-LAFS or Freenet. Content has to be entrusted to the swarm.
He's prolly one of those disgusting trolls!
"IBM and Intel have centralized planning on an immense scale"

Right. In fact, is there any human group that don't have some kind of central planning?

Ironically, the only kind I can think of is the anarchist meetings where, somebody told me, nothing is never decided.
We've technically speaking got a lot of US startups on Atlas, but we're happy to have more. Today's announcement also includes a number of other improvements we've made the last few months.

I'm happy to answer questions if anyone has them.
I've never seen anything in an apple desktop that suggests they aren't ludicrously overpriced. You can piece together a monster of a desktop for 2k, so I don't get it either.
That could leak information a user doesn't want to be leaked, like at which hours he is at work (using the work computer) etc.
Which id belongs to which device could probably be inferred when the service is used actively.

I understand that transparency might not be a design goal or techinically possible, I'm just raising the concern.

Can't I just share my private key across multiple devices?
Hopefully everything works fine for the student at the first run ;)
Putting another barrier in front of it is not what's needed for people to use it. Treat it like email (or heck, early Facebook), get big clusters of users in by convincing universities and colleges to run a campus server. Businesses would also be a good idea but a harder sell
No, you're not. If you were that would mean you would be interested. If you were interested you would have more to say.

You're just trying to imply that I must suggest an alternative before commenting on the poor state of "social networks".
> pollution is the perfect example

Many forms of pollution can be addressed by property right systems and the law. Meaning, just like everything else.

There is a long history of rivers being divided up and pollution was handled just like if you throw waste into your neighbors yard. This is just one simple example but there is a huge amount of resources around this. There is a hole field called Economics&Law or Property rights economics.

Pollution of things like Oceans and and the Atmosphere can not be handled like that. Problem is, our current state system fails as well. The current system fails for the exact same reason, there is no system of property rights.
This wouldn't scale. If we replaced twitter with this right now, that's:

500 million tweets per day.
140 bytes (140 characters * 8-bit ASCII) per tweet.

140 bytes * 500 million = 70GB

Thats 70GB per day before metadata. Use this social network for a month and we've exceeded the 1TB mark, twice.

Remember this isn't just 70GB per day on one server, this is 70GB per day on every users PC.
Because broken algorithm and vote manipulation. It only took votes from 8 friends to get this onto the front page.
Great shot, 17 years ago I predicted that within 10 years you would not be able to tell the real from the computer generated. This is the first screen shot that qualifies IMHO, because this comes damn close to looking real.
Same here, I don't think this is a particularly great way of starting with Prolog. I have found these videos helpful for understanding Prolog:

https://www.youtube.com/watch?v=SykxWpFwMGs

https://www.youtube.com/watch?v=G_eYTctGZw8
> we mostly bypass that and build business logic in the stateless layer.

> This is just (initial) design / programmer laziness.

I disagree, it's just good practice. I've never seen a system evolve towards SQL based business logic, only away from it. SQL is meant for storage, that's it, obviously there needs to be a coding layer to move data in and out of it efficiently but that's where it should end.
For a second I was happy that Yamaha decided to, for what ever reason, release some sound library for machine learning or something.

I guess the article was targeted for some other population on HN. Possibly the one that often looks for Yamaha YZ250 Dirk Bike sound effects library but doesn't know where to buy it form. /s
> This is sane and good design. The db auth layer is for db management, not frontend auth (are you seriously advocating this?).

The auth layer of PostgreSQL is very advanced, up to row level security if you need that. [1] It was never intended to be "just for administration", quite the contrary! Moreover, some applications rely exclusively on a central PostgreSQL service rather than a central web service, such as "Artikel23" which is (was?) a CRM whose user management, encryption and security stuff is 100% handled by PostgreSQL.

[1] https://www.postgresql.org/docs/current/static/ddl-rowsecuri...
Traditionally consoles are sold at a loss at first and the as components come down in price it evens out. Last gen though xbone and ps4 were essentially sold at cost. Most likely this is sold at cost and then they make money off of games. Apple needs to cover costs of OS and make a profit off of the computer alone and people are willing to pay a premium for Apple.