skysight-inc/HackerNews huggingface dataset:
> ICU Collation Support

This tiny little mention is a massive win! We now have access to the "und-x-icu" collation. As the postgres docs[1] put it: "ICU root collation. Use this to get a reasonable language-agnostic sort order."

I've been waiting on this forever. Columns containing strings from any/all languages can now be sorted well enough to use postgres in truly multi-language applications. If your application has users writing in English, German, Russian, Japanese, et al, using the "und-x-icu" collation should make your application much more user-friendly (as opposed to using the en_US or C locale).

The ICU root collation is far from a perfect system, but it's the best option available today. I've been tied to MySQL purely for its similarly-purposed utf8mb4_unicode_ci collation. Now I can give postgres another very serious look.

[1] https://www.postgresql.org/docs/10/static/collation.html
I was a big fan of a RethinkDB, but growth has stagnated since the parent company shut down. It’s technically a Linux Foundation project now.
> > They should not have been in charge of the response

> Then who should have?

Better question: what would be an appropriate response? Because this one isn't, that much is sure, but I don't have an answer for this question other than "one that is not so hastily and shoddily implemented."
Democracy is to power what pornography is to sex.

Do you really think that participating in scuttlebutt about the reality show of presidential politics has anything to do with governance?

The first step is to turn off the noise and take direct action to help the people around you.
That's not as easy in at least two ways: having to use docker and know that command line.
* If you don't know how to set it up properly
Off topic but have you read Homo Deus?
Does anyone have any use cases where PostgreSQL falls down/loses to other DB systems? I know sharding/replication has long been a sticking point, but what else is there?

Why do people still choose MySQL/MariaDB/Oracle over PostgreSQL at all?
I enjoyed this book immensely. My only complaint about it is that I knew ahead of time that there was a split. If I had been unspoiled I would have enjoyed it more.
> One of more of those entities, who are all supposed to protecting her privacy failed to do so to extract a few more bucks.

I would suggest that that is not "failing to protect" private data, but "actively exploiting".
Is this conceptually similar to mixing a Raspberry Pi Zero with a Teensy? Or, to be more abstract and less specifically wrong, it's a general purpose computer that also has microcontrollers (which, for my interest, happen to be similar to those in the Teensy)?
I've been using Go on the side since mid-late 2013, so not nearly as long as some here, but I was heavily impressed by both Goroutines and channels as ideas, and by the net/http library.

The general portability and simplicity of the language has made it nice for side-project work.

I've since used go to write a blog engine, several APIs for school projects, and have been working on a scripting language (pisc.junglecoder.com).
I enjoy a little bit of chatting with the person next to me, though I've regretted starting conversations a few times, as some people seem to have to talk on a plane... the entire time.

So, just be aware that some people are just friendly and will keep talking to you because it's polite, but they will still show signs that they're done, like: looking out the window for a while, only responding with head-nods and "mhmm"s, pulling a laptop or tablet out, putting in noise-cancelling headphones, sleeping.
Show HN: Open Door, an appointment based marketplace for experts and influencers
So, call me nuts, but then shouldn’t there be sane defaults? I’ve not set up or tinkered with MongoDB in a looooong time, but that seems like a must for any project.

EDIT: instead of downvoting me explain to me what I said wrong, I’m seriously wondering why it needs to be configured for sane defaults ..
Well, investigators could find a container that had contained the type of acid used in the attack, and lift prints and/or DNA from that, couldn't they? Is there any reason why that's harder than finding the knife, and finding prints or DNA on it?
They are completely different:

Postgres - Solid single-node relational database with SQL standards support, JSON, fulltext search, custom data types, ACID transactions, foreign data access, and more. HA/scaling through replication and some 3rd party offerings for automatic sharding, failover and multi-master if you need it. Great as the operational source-of-truth for your core data.

Cassandra - Distributed wide-column (basically advanced key/value) meant to run as a cluster of machines with native support for multiple data centers. Limited "SQL" support which is really only used for defining tables. Data access is very different (everything is an upsert or delete) with variable per-query consistency settings. Great if you need data spread globally, 100% availability, eventual consistency fast key/value, and some interesting data access patterns.

If you want high-performance Cassandra, look at ScyllaDB first. If you need something in between Cassandra and Postgres, look at CockroachDB.
a developer who hasn’t heard of Go must live under some special kind of rock
I wrote my first fibonacci sequence test program in Go about four years ago. Now I am full-time admin of a large real-time cryptocurrency charting website that pushes 30MM+ messages to clients per minute, written entirely in Go.

I've learned a ton about programming from Go and I'm not sure I would have managed to build the system at all with another language. Go gets a lot of flak for its simplicity, but what it does it does very well. The concurrency model, networking packages, tooling, and simple deployment make it a joy to work with and I owe a lot to the Golang team. Happy birthday!
This is a valid concern, I've seen simple automatic optimizations backfire before. An example I remember from MS Sql Server (older versions) of a very simple optimization of using indexes can backfire with the dynamic filter pattern:

where ((@foo is null) or (foo = @foo))

and ((@bar is null) or (bar = @bar))

Depending on statistics, order of execution, indexes in place and phase of the moon this could produce fast results or have to revert to a full table scan (because it uses a cached query plan with the wrong index).

Devs still have some awareness of how queries translate to actual running instructions and to measure that the results are in line with what is expected.
I don’t see why that’s an issue. Can you name a C compiler that distros use that isn’t written in C?
> British retailers are now talking about licensing the purchase of sulfuric acid.

Banning or controlling something that could be used as a weapon is not the solution. As has been already demonstrated by controlling firearms and knives, criminals will just find an alternative.
I try to re-read the trilogy every couple of years since it's so deeply constructed. Plus the main characters are fascinating. Life is short, bump this to the top of your queue!
Adding guns to the equation just adds more weapons available to both attackers and victims.

Victims don't carry around weapons to defend themselves right now, if they were able to get hold of a gun that wouldn't change. Essentially the only thing that changes is on the attacker's side; great, so now you've added guns to that equation.

Well, if you do that, then I guess you also need to arm the police. Most police force in the UK is not firearmed (the UK has a strong notion that the police are civilians in uniform), but if you're giving more tools to attackers, the police will need to respond in kind.

So effectively, by adding guns, you've done nothing to prevent acid attacks and you made it so that the police making a mistake can end a life.

Edit: I misinterpreted the parent comment!
A 20MT weapon detonation could result in disabling the global electrical production and distribution system, as well as permanently disabling the electronics necessary to move food, water, and medical supplies.

Your thesis is that an instant global economic collapse, destruction of all advanced agricultural systems, transportation systems, waste management systems, water purification systems, etc. won't result in >= 20M deaths.

You really have no idea what the effects of a significant nuclear exchange would be.
Sales and marketing?
Possibly some mobile telecoms route outgoing VOIP calls (regardless of originating application) via their own network? I haven't looked deeply into this, but I've noticed when I call someone on FB messenger, the call shows up in Phone.app with a long "social profile" address beginning with IBTU. Not sure if this address is internal to iOS or global.

Also, is it even confirmed whatsapp encrypts voice calls in addition to texts?
Ha! The last time I looked at apartments in Beijing (late 2015) was depressing. Rents for 10k RMB/month, sells for $1 million USD, has one bathroom with a crappy wet floor shower (rental, the for sale places were completely unrenovated of course). Those buildings are also not meant to last more than 20 years without extensive maintenance (Chinese overbuild on concrete to take adavantsge of unskilled migrant labor, this leads to serious maintenance problems, but the CCP sees it as a feature rather than a problem), they start looking depilated after 5.

My wife owns a villa in a tier 88. It is a nice place, but the standards are so different, the lack of indoor heating makes me wonder how it could ever be livable.

Also, China lacks a property tax, so housing is seen as a speculative asset. It is really just like gold or bitcoin. Lots of house aren't even lived in (e.g. See ghost cities that have completely sold out but no one wants to actually live there).
You still need a full JVM to execute the compiled code, it's mainly just an optimisation to improve startup time.
Do you think that a well structured society has no need for a ban on nuclear weapons? If not, how do you draw the conclusion that such a ban is unneeded for guns?
> NONE of them were on the scale or level of impact of the Equifax breach.

I concede the possibility.

> We are ALL affected by this breach.

POTENTIALLY affected. There's been no disclosure of exactly how many records were accessed...I don't think they know, but it seems highly unlikely that their entire credit database could have been exfiltrated in that amount of time.

> I know that ALL of the credit reporting agencies have similar poorly designed systems

They don't actually. They tend to have above average security. It's just that it CANNOT be perfect. Just like we can't stop viruses, but Windows is still around.

> I am so furious because of your apparent suggestion that there is no line that Equifax or any other CRA can cross that will earn them an honest decapitation.

How about real criminal activity? You keep glossing over the point that Equifax was victimized here as well. What criminal intent, or even legitimate incompetence, can you claim that even remotely justifies that sort of reaction? Do you think this is Enron-level criminality? That was flat-out fraud, proven in court.

> the fact that it happened is all the evidence of negligence that you need

You're sadly mistaken as to the efficacy of computer security. The fact that it hasn't happened before, for a company that must be a target under constant and unrelenting assault, is actually a testimony to the how well they were maintaining security.

> "Not for Identification Purposes" it's time to read the words on the card, and take them seriously.

100% agreement on this.
OP, please don't link to "summaries" or link aggregator sites. Just link to the real article [0] that they link to, like gscott did [1].

[0]: https://www.cbsnews.com/news/d-c-court-rules-warrant-is-requ...

[1]: https://news.ycombinator.com/item?id=15307939
I think this is a good article to remind us of how fast hate can spread, but I don't think it applied to Trump and the alt-right. By far they are a fringe movement, whose impact is grossly exaggerated. When I look around for the "popular" uprising looking to censor speech I don't see Trump and alt-right racists. I see the antifa and massive amounts of liberal activists that are justifying censorship, violence, hate, racism, and bigotry. I think this is a warning, but its a warning of whoever comes next. We need to be vigilant to make sure when trump is ousted he isn't replaced by a group who is even worse and has the backing of a frothed mob.
I dont like breitbart or infowars - but I think you're possiblly in a different universe than I am.
So Wikileaks posts their opinions along with the raw data, and you can imagine a scenario in which their biased, therefore Wikileaks is less trustworthy than CNN and Fox News. Imagine what kind of stories the networks could have, with their policies of inviting former government officials on to voice their opinions.
Ourotech is taking the guesswork out of cancer treatment Using Hydrogels
Thank you for articulating the difference between the two. Can it not be the case with exhaustion also, that awareness and/or reaction times are reduced? Cognition certainly is affected after strain in higher order animals and muscle cells need to replenish ATP.

Removing brain waves from the equation, it seems like the whole question of what attests for sleep gets blurry.
I've upvoted you but we also need to crack down hard on the people that commit these terrible crimes. Worse than murder, this is a way of causing someone lifelong suffering, and in the lag time before utopia arrives we have to be pragmatic.
Really? I think making guns extremely hard to get has been pretty good for NYC.
Well, naturally I'm discounting the opinions of people who disagree with me :)
Imagine a world where the US and Russia could be allies and use their immense talent and resources for the good of the world.

In the Context of today, the US produces approximately 17 times the GDP of Russia. The US could go a long way in building common ground with Russia thereby influencing them not to return to cold-war era policies before its too late. There is no doubt russia's economy will continue to grow, and the foriegn policy we set now could determine whether they grow into a friend or even greater foe.
Hopefully it's a very good kind of rock where there are no bad languages like Go.
Higher "standards" of spending? Is that the new liberal euphemism for higher taxes? Richer societies can spend more dollars, but percentage wise, there's obviously a limit. We'll find out in the next 20 or so years as the amount we spend on social services crowds out all other spending, and we can't pay back the principal on our existing debt.
You were lamenting about the "delayed" response before, and now you're unhappy with the "hasty" response.

Further, do you really think this was a hasty response? This is the response dictated by the law, coupled with recommendations from their legal team, and probably with input from regulators as well.
A key question here is what has changed to make these attacks more prevalent. One possibility is it is related to immigration and changing demographics. The area with the most acid attacks by far, Newham ( http://www.mirror.co.uk/news/uk-news/acid-attack-capital-bri... ) is also very immigrant heavy ( https://en.wikipedia.org/wiki/London_Borough_of_Newham#Demog... ). In this NPR article, the example is of a guy with a white/British name attacking someone of middle eastern heritage -- but I know from experience on news coverage in my own region that NPR cannot be trusted on racial issues to select anecdotes that match the real patterns of behavior. Do any of the Brits here have any more insight on how immigration and changing demographics might be related to these attacks?
From what I have read they have a very slow queue so I don’t imagine they’re over committing.

And frankly the rest of the laptop is not very complicated.
Disclaimer: IANAL.

I think "fighting words" is still a real thing in this sense: If I go into a bar, and say the wrong thing about someone's mother, the law is not going to be surprised that they throw a punch at me.

But in our current culture, it has to be narrow. Otherwise, Antifa is going to claim "fighting words" justifies them brawling in the streets. And, legally, it does not justify it at all.
Yes, if you have a need to update large amounts of records. For example, updating a single column of all your records will cause the whole table to be rewrite, thus causing a super high IO load.
I'm biased (I work part-time for the company), but RavenDB[0] 4.0 is damn fast, cross platform, and has beautiful tooling.

It's built on .NET Core, and our current performance is 140k writes/sec. We also bend over backwards to optimize read speeds: we generated indexes automatically based on your query patterns, discarding unused indexes and throwing server resources behind the hot ones. Also, unlike many other NoSQL databases, we support transactions and atomic writes.

[0]: https://ravendb.net
As one who has not reloaded ammunition in a number of years, I’m going to guess that the only reason Amazon won’t sell you black powder (or gun powder) outright is due to shipping restrictions. Which means instead of buying the ingredients with a highly-trackable transaction from Amazon, your low-budget terrorist will have to resort to buying the powder pre-made, and anonymously in a cash transaction from the local gun dealer. Last I checked, they’ll sell you big cans of the stuff for cheap.
Guns aren't a major industrial commodity chemical with hundreds if not thousands of valid non-violent civil uses, however...
Go is actually 50 years old in terms of design insight.
"Better apply for a gun licence and do my 3 weeks of training before I hold up that petrol station." - Said no one ever.
How a Language Created by Scientists Is Now Used by the Biggest Companies
At the time MongoDB shipped with all databases completely public, with no authentication credentials.

That meant anyone could connect over HTTP and get your data.

From the article:

The problem for MongoDB users seems to be that on some systems the default configuration has the database listening on a publicly accessible port as soon as it’s installed. Users are supposed to read the manual and set up access control and authentication after installing the software but it seems that plenty of them don’t.

I think that counts.
Loss of utilities does not result in instant collapse of society.
Actually, all large nuclear weapons states have agreed to do that, they just ignore their treaty obligations in perpetuity.

NPT:

"Article VI

Each of the Parties to the Treaty undertakes to pursue negotiations in good faith on effective measures relating to cessation of the nuclear arms race at an early date and to nuclear disarmament, and on a treaty on general and complete disarmament under strict and effective international control."
They launched Atlas, a cloud service. It sure ain't cheap to operate.
> who were chose to act in those people's best interests.

Are you seriously suggesting this is how politicians are chosen?
The days of "STFU and RTFM" are over. Sane defaults are in the best interest of any product by any company be it a washing machine or database.
> The primary reason most people who eat organic food do so is to avoid consuming pesticides and herbicides.

Let's be clear. The primary reason most people who eat organic food do so is because they desire to conform to the values of their social group. It doesn't matter to them why their social group might have decided on this.

No matter what the activity is, if it's defined in terms more specific than "eating", "sleeping", "breathing", or "reproducing", that is the primary reason most people who engage in it do so.
https://en.wikipedia.org/wiki/Dust_explosion
Citation on that “mythbusting” by any chance?

Or on zero fallout from airbursts?
gcc and clang are both C++ in my understanding.

Regardless, those compilers are usually grandfathered in; distro policies are different for other languages. It just depends.
That command line is basic docker usage. Containers are far easier and cleaner than apt/yum installations at this point but you can just do this too:

sudo apt-get install mssql-server
It's the difference between watching Atlanta or even Masters of None and watching Friends or Girls.

Black people and people of color experience the world differently from white people. Sometimes it's nice to see those struggles shared on TV.

That's not to say I don't like watching Girls or Friends, but it's great to see people of color living their lives on TV too.
Usually you port by cross compiling an initial compiler, and bootstrapping from there.
I'm reasonably confident, as I assume you are, that if NSA actually has a practical weakness in SPECK, they're not going to disclose it, despite having promoted it as a standard.
I'm asking this in good faith. What are the best use cases nowadays for Mongo? I've read that it still makes sense when you are dealing with truly self-contained documents. But even then, what is the advantage over just using Postgres or MySQL and their native JSON types?

I've read plenty of negative comments on Mongo. I'd like to hear the other side of the story, if possible.
It was delayed, in terms of how long it took them to let us know that we could be affected.

It was hasty, in terms of... just look at equifaxsecurity2017.com

Did they run this plan by even one security researcher before it was put into action? If so, that person's advice was either terrible, or ignored. No time at all had elapsed between the time we were alerted to the breach, and when Equifax revealed the 2-day old site that was protected by Amazon certificate.

I am building an HR web portal for employees to submit their identity when they do not go through our background checking service (some classes of employee who are exempt from the requirement to get a background check, for archaic reasons), and I am holding up Equifax's response to the breach as an example of "What Not To Do."

There is no legal requirement for them to put up a website that looks like a phishing scam, and respond to people who put in their information with a random value of "Yes you were affected/Check back later to find out if you were affected". There would certainly have been questions about "who was affected" but it would be better to answer with a blanket response of "everyone with a credit file" than to do as they did, and say "143 million Americans, now fill out this pointless form attached to a random number generator to find out if you are one of them."
> but I was heavily impressed by both Goroutines and channels as ideas

You know they didn't invent this right?
C compilers are ubiquituous. Name a platform which does not have at least one C compiler. Rust might come into such a position at some later time as well, but until then at least a transitional solution besides cross-compiling would make packaging easier and reproducible.
> He says assailants use acid today for many of the same reasons as they did in Victorian times:

Ok but there is a recent rise. Why the recent rise?

I heard that it's because guns are banned. But that didn't happen just in the last few years. So did acid become cheaper to purchase or gun and knifes got harsher penalties recently.

Wonder if there is sort of a copycat thing going on, people hear about it and some say "Oh my, how horrible" maybe the criminals are saying "Yeah, good idea, look how horrified everyone is. I know what I am using next time I am going on a rampage".

What about parts of UK. Where are these attacks happening? Financial district, suburbs, drug trafficking areas, maybe that might provide a hint on the underlying reason.