skysight-inc/HackerNews huggingface dataset:
The problem with joins and reason why most distributed databases don't support them is primarily that the local machinery is complicated to implement.

Given local join machinery, a join between 2 distributed tables can be achieved by joining the partitions of the tables locally after ensuring that tables are co-partitioned and partitions are co-located. That is, if performing A JOIN B ON (A.X = B.Y), ensure that A is partitioned by X and B is partitioned by Y with the same partitioning scheme such that every partition in A has a corresponding partition in B with which it can be joined. A distributed join can then be performed (in parallel) by joining each pair of partitions and concatenating the results.

Ideally, tables are co-partitioned and partitions are co-located in advance. The article describes scenarios in which the tables need to be repartitioned during the query, which can cause a lot of network traffic. However, the amount of traffic is limited in practice since filters and projections can be applied before shuffling any data.

The great thing about implementing a distributed database on top of PostgreSQL is that the local machinery already exists, and it is very good.
I remember playing The Hitchhiker's Guide to the Galaxy on an original Palm Pilot. What a great game.

It turned 31 yesterday. You can play a version released last year here (no Flash, no Java): http://www.bbc.co.uk/programmes/articles/1g84m0sXpnNCv84GpN2...
Is not doing too well.
Good luck with that. It's about as likely to succeed as a ban on porn.
"a fast and powerful"... Couldn't you find a better naming? All newly tools, languages, etc... are: "fast, powerful, robust", but at the end of the day, it still sucks.
OK, I don't normally get annoyed about these kinds of thing, but why the heck is the title of this post 'Woman calls...'? That isn't from the article.

Sure, the campaign leader is Dr Kathleen Richardson, but I don't think there has ever been a post on here that started "Man does X".
Holy Roman Empire started around 800AD.
I don't know where you live in California, but drought, or no drought, I don't think you will have to spend another weekend inside because of smoke. As horrid as the fires are, they are clearing that dry underbrush? Underbrush that has been their for years--for different reasons.

Everyone is focusing on the drought right now, for good reason, but if it's not too late, and we go back to normal rain levels; I have found floods, landslides, and earthquakes to be California's warts. I have seen families lose everything to these disasters.

And while Insurance companies happily accept our insurance premiums--they cover less and less each year.

These policies, which have pages of exclusions, basically just cover fire.

This year they will be paying out, but for as long as I can remember residential/commercial fires are going down each year, but you wouldn't know it by listening to to the media, and the "Head of whatever". Yes, I know this year Firefighters are really busy, and it's because of the drought.

I do know most fire personnel(exception this year) hardly ever see a fire. Modern building codes have have really made structures safe. Most of their time is spent on medical emergencies. Something like 90% plus?

Anyway, I sometimes think California's Insurance commissioner does pretty much what our illustrious Luitentant Governor does; Nothing?

As to leaving California, I think the only reason, I would leave is rent, and housing costs. I can't believe it costs so much to live in California, at least within 30 miles of the coast. It's the rent that keeps me up at night. I am close to being homeless. Most of my income goes to rent in one way, or another. Whenever I hear someone brag about their income, in my head, the real question is "what does it cost to keep a roof over your head? I know my landlord can have a butt twitch, and decide to raise my rent, and I will be homeless. I don't like feeling so Helpless! And it's not so easy to just pick up and move to an area of lower rent. It's kids in school. It's that job, that's only in the Bay Area. It's getting older and not wanting to abandon the few friends, or family members you are close too. It's just not easy I guess, but living off the land in Alaska is looking good? No, I've been in CA too long. I couldn't kill an animal. Yes--I will now shut-up. Sorry about the rant. Tired.
I said in another comment, it's basically enterprise software, bought by one small group of people and foisted on another much larger group (both students and teachers are in this latter group) and suffers many of the same market dysfunctions as a result.
That's gloriously tinfoil paranoid and saturated with meaningless buzzwords. The conspiracy, if there is one, is the ordinary conservative conspiracy against fun.

Yeast is a great vehicle for organic molecule production.
'Isis flag' picture that claims to show refugees attacking police goes viral
Now that they added tagging, I feel like the only things they need to add to replace Evernote for me is real, all-type attachments, (simple) formatting and a web clipper.
Does this mean disclosing relative salaries is bad for a team?
not even that - all you need is a flash-light and a conventional book
West 'ignored Russian offer in 2012 to have Syria's Assad step aside'
90% of sex devices are used by women, and it's not clear to me what is "robot" and what is just "device".

Coincidentally I've never seen women expect anything than raw physical contact from their toys, does it "contribute to detrimental relationships between men and women"?
I was afraid of this, I've spent years optimizing my workflow to store stuff in Evernote, because I love it's search feature. (IFTTT recipes to save everything from twitter/reddit/etc into it). I'm extremely ADD, and even have audio recordings from years ago that I'm hesitant to jettison. anyone know the quickest way to push everything (audio+pdf's) to an alternative?

Also, do One Note/ any other alternative do search within PDF?
Most iconic enemy in Super Mario gets its name from a hilarious misunderstanding
I was hoping to share an opinion. I don't hate C++ when I use it - like every other C++ coder with their sanity intact, I use a subset that I understand and which usually doesn't blow off my toes. The problem is that invariably your safe subset intersects with someone else's and that's when the pain starts.
Well let me be the first to disagree with you directly. As a French citizen, I WANT a United States of Europe. I strongly believe that a more politically and legally united Europe is likely to improve overall economic circumstances and quality of life of the average European. Yes this means my taxes being set by a European body, relatively richer countries (like mine) helping poorer countries, etc, but all these things are the right things to do.
A better title would surely be "Robot ethicist calls..."

I mean, I'm not really sure what a "robot ethicist" actually does, but it at least seems more relevant.
Because client support isn't there for nameConstraints. I really wish it was though.
Workflowy reminds me a little bit of a desktop app called Zim, although Workflowy and Notion are prettier.
>I don't think there has ever been a post on here that started "Man does X".

That's a typical format for a headline. Here are a few:

https://news.ycombinator.com/item?id=8886164

https://news.ycombinator.com/item?id=5369778

https://news.ycombinator.com/item?id=6093785

https://news.ycombinator.com/item?id=2266924

https://news.ycombinator.com/item?id=2281045

https://news.ycombinator.com/item?id=4557726

https://news.ycombinator.com/item?id=2200720

https://news.ycombinator.com/item?id=4319250

https://news.ycombinator.com/item?id=8407364

https://news.ycombinator.com/item?id=6175059

https://news.ycombinator.com/item?id=9762331

https://news.ycombinator.com/item?id=2284007

https://news.ycombinator.com/item?id=5091962

and so on.
> Shitty business models are supported by advertising.

Just because you do not like it doesn't make it a shitty business model: most sports are supported by advertising (e.g. NFL, UEFA). Endorsement deals, sponsoring teams/stadia/leagues and TV rights are just various forms of advertising.

TV shows are also funded by advertising, as is most journalism that is not state-funded (a.ka. propaganda).
My thoughts exactly. This "Woman does X" is unnecessary and might turn the discussion in the wrong direction.
New Zealand checking in. Ticks all your boxes except that I know some Californians. They are good ones.
I interpreted "you must prove control over both the server and the key used in the existing certificate" as meaning that if a Let's Encrypt certificate for the domain has been created in the past, you need to own its key (presumably proved by signing something with it) to get another one.

Is that wrong?

Waiting for certificates to expire could mean waiting for years, unless they have auto-renewing very short-lived certificates (but then you have the same problem for the authentication used to automatically get those certificates).
I mean no more than I would by saying that Minds are affected by Biology in the same way that Economies are affected by the physical world. One supervenes on the other. Just as it is nonsense to say that Psychology is independent from Biology, it's nonsense to say that Economies are independant from the physical realities which underpin them.

I'm not sure what "quantitative mysticism" means, but I'm not proposing anything quite so social-science-waffle sounding.
Robots to increase risk of joblessness within a decade
Nimbus Note is a fantastic alternative: https://nimbus.everhelper.me/note.php
The ld program distributed with binutils refers to this process as relaxation pretty extensively - you can see it in the ".map" file output or by greping the source for ld.

EDIT: The term is even in the wikipedia article for linker [1], although with a broader definition.

[1] https://en.wikipedia.org/wiki/Linker_(computing)#Relaxation
It's also worth mentioning that the Federal Bureau of Investigations (FBI) also served the non-profit Internet Archive (IA) a National Security Letter (NSL) in 2007.

After a joint lawsuit filing of the Electronic Frontier Foundation (EFF) and American Civil Liberties Union (ACLU) challenging the NSL, the gag order and the constitutionality of the NSL on behalf of the IA - the FBI withdrew the NSL as well as the gag order. [1]

As such, the gag order and NSL was never invalidated in IA, Brewster Kale (ACLU, EFF) vs. FBI.

[1] https://www.aclu.org/internet-archives-nsl-challenge
As do I.
Downvotes? Guess that's what I get for being honest & speaking from my own experience... I brought that up because you can only solve a problem when you understand what's gone wrong. And pinning it on homophobia is a swing and a miss IMHO. If there's a real single answer, it'd more likely be about male reputation & maintaining respect in our corporate focused culture. Which I think isn't that far removed from honor culture.
> The European Parliament has no real power.

The European Parliament elects the European Commission and can force its resignation through a vote of no confidence (the latter happened to the Santer Commission).

Jean-Claude Juncker technically has more democratic legitimacy than David Cameron; he was elected by a number of representatives standing for a majority of the electorate.

Practically all EU legislation requires a majority in the European Parliament and a qualified majority in the Council of the European Union (the upper house of the EU legislature, which represents the democratically elected governments of the member states).

The problem is that democratic legitimacy alone does not functioning institutions make.

> The legislative and executive powers of the union are held by the council of Europe which isn't an elected body.

The Council of Europe [1] is an intergovernmental body that has nothing to do with the EU. If you mean the Council of the European Union, that is (as mentioned above) the upper house of the legislature, but has no executive powers (those lie with the Commission and the member states) and all its members represent the democratically elected governments of the member states.

[1] https://en.wikipedia.org/wiki/Council_of_Europe
I routinely weep in the quarterly sales meeting.
Would you really want you credit card details to be sent in plaintext?
https://github.com/copy/v86 has a MIT license.
'Relaxation' seems to be linker terminology:

https://en.wikipedia.org/wiki/Linker_(computing)#Relaxation

It took me an embarrassingly long time to figure out what the obscure ld error messages about relaxation were actually referring to.

Optimising call distances in the assembler is pretty easy, but the big win is in the linker, because this allows you to optimise calls between procedures. Of course, you then need a linker which knows how to edit compiled machine code to change the kind of call. FWIW, I do a lot of embedded stuff, and I have very rarely met an embedded architecture where ld would do relaxation properly, and usually end up turning it off.
Agreed! Giving them hammers won't improve the outcome either.
Hey! I've heard conflicting things on how friendly NZ'rs are towards Americans. What's your take on that, y'all rather keep that gorgeous place all to yourselves?
It's not magical for sure, people still need to put in a lot of effort, but having access to vast knowledge can definitely help.

We can learn anything online, and I can't count how many times the Internet has helped me with normal everyday life: proper ceiling painting, good electrical wiring practices, fixing up an engine, properly cutting glass, mixing cement for various applications, more effective gardening, food recipes, building a solar water heater and integrating it with the existing hot water system (awesome summer savings), and more...

But yeah, people need to apply these things. Another obstacle is that all this information is only available in select languages, mostly English, so the first thing everyone needs to learn is English AND to share the information in their own language (which they often simply refuse to do because why would they share these advantages with other people? Now that is a stupid mindset...)
Hacking X Rebirth for fun and education
And people are getting more nationalists because of the state of the economy. A more unifed EU would be interesting but a bigchallenge because of the diversity of languages/cultures. I would love to see it happen in my lifetime but I'm not really optimistic.
I switched to Nimbus Note: https://nimbus.everhelper.me/note.php
A much closer future we might create artificial uterus, allowing to gestate child outside of woman body. That will result in huge shift in balance of power between genders - removing much of women power that comes from biology and inability of men to rear children.

I can only imagine outcry of both feminist and traditionalist camps.
That one seems to contain less information.

If the Daily Mail is the best source, the Daily Mail is the best source and HN should have it on the front page regardless of its reputation. A similar recent case was https://news.ycombinator.com/item?id=10131399.
One of my banks (BCR Romania) requires a login with a token for initial access (just seeing stuff, or transfers between one's own accounts) and another token OTP, based on the amount and the last four digits of the destination account, for transfers to someone else.
Are you Successful?
...I just use Dropbox and .txt or .rtf files for this? And Dropbox has had syncing across every platform ever, is good for collaboration as well but stellar for single-user usage. I manage all my personal drafts and notes and paperwork using my Dropbox personal folder, especially since it supports offline availability on my mobile devices too for files I use regularly.
Students at my sons school (Australia) use the school computers to research topics, and create PowerPoint presentations. It seems like a reasonable way to introduce early school kids to computer skills, as well as some of the better uses for them.
Note: Most of these links have "Man does X" in the original headline. In only two cases, the "man" part has been added by the HN submitter.
Yeah I noticed that too. However, with current Firefox the "Reader View" worked well, and I was able to read the article just fine.
I do want the United States of Europe.

The alternative is the return of walls, nationalisms and wars, which has been the natural state of affairs in Europe for 99.9% of its history (100 years ago the Ministry of Defense was called Ministry of War for a reason).

The iteration we have at the moment is far from efficient, far from perfect, far from fair, but it's better than anything that has come before.
Mainly the war against the Napoleon empire united the German states in the 19th century and lead to the national movement.
It also doesn't run on Chromium, which I find suspicious.
Oh, it causes ADD, alright. Without a proper way to use it, the Internet just leads people to jump between pages, bits of information and topics, which often devolves in distraction on the many entertainment bullshit resources out there...

You can't read a book properly when you know you can just jump to the middle or the end to see the most interesting bits.
Effective Python: 59 Specific Ways to Write Better Python Interview
Looking for dev help with crowdfunding platform
Hey HN,

I'm looking for some dev help with a crowdfunding platform I built for Makers/Inventors/Developers. We have a couple of hundred users and growing, but I'd like to offset some of the development work so I can shift my attention to marketing and sales.

I'm currently the sole founder/dev. Our stack is Rails/Heroku.

Email me: dan [at] techendo [dot] com
> I think if people want your content they will pay. Publishers just need to bundle it the right way.

This is incredibly difficult to do and all the attempts I am aware of have 'failed' by varying degrees (paywalls, app.net).

If ad-blocking becomes a trend, I hope the websites as the blockers to pay instead of resorting to "native ads" or going out of business. Hopefully, the internet won't be stratified (rich vs. poor peoples versions of the web), but who am I kidding - happens in all other industries.

However, my opinion is likely coloured by my circumstances: I am a biased 3rd-worlder. I'd prefer the status-quo and have the content I consume subsidised by ads targeted at the western middle class. I would not afford to pay for all the content I find interesting on the internet, especially now with the horrendous USD exchange rate.
> Sacramento delta levies

Hmm... as someone currently living in Woodland - which is right on the other side of the causeway across the immediate spill area for those levies - I'm wondering how safe this winter will be. Woodland is an old town, so it's on slightly higher ground than some of the surrounding areas, but apparently that may not matter.
Major Advantages of Commercial Space Over Residential Property
actually, it measures stupidity
This one?

http://dl.acm.org/citation.cfm?id=359474

Interesting paper, by a rather familiar author. I noticed the date coincides with the introduction of the 8086, but the paper makes no mention of it.
Helped keep the peace between the USSR and the USA through the cold war, by giving them something to collaborate on and so build some trust and keep communication going.

edit - there is other stuff as well, but 'peace' seemed the best option to go with given the way you phrased the question - https://upload.wikimedia.org/wikipedia/commons/6/66/Hubble_I...
Have you thought about Europe? It does all those things. Central Europe especially.
A DIY Guide to Feminist Cybersecurity
You may be surprised, but most people fear a world government.

New World Order and all that bullshit.

Of course, they ignore the ongoing massive globalization and how it has improved their lives...
Hipo
We have to remember that bots are written by humans and in this case merely implement a business process. There is no reason that the owner of the bot can't store their own logs of what take down requests are sent and with which version of their bot and therefore (given a well written bot) this should give them an adequate log of the reasons behind the take down notice. It seems to me like this ruling will cause the required sophistication of bots to be greater rather than precluding their usage.
It's actually a pharmaceutical present.

https://en.wikipedia.org/wiki/Lysine#Synthesis

https://en.wikipedia.org/wiki/Insulin#Synthesis_2

https://en.wikipedia.org/wiki/Genetic_engineering#Industrial
Organizes your thoughts instantly as you speak.
I keep the repo sync'd between two computers, and have even cloned it to my Android phone, but I haven't yet summoned the guts to actually put my PGP key on my phone so I can access my passwords there.
Audio note and speech to text note captured simultaneously.
The Internet in Russia – Knowledge Is Power
Hair loss natural cures
There are good arguments for the view that news is actively bad for you: http://dobelli.com/wp-content/uploads/2010/08/Avoid_News_Par... (pdf).
Intelligent Machines: What Does Facebook Want with AI?
I know exactly what you're talking about. I'm very pro-globalization. It's an engineering problem and that's the right solution. But I do fear this world order.
They want to do what we do with all medication: Isolate the active agent and remove everything else.

This has several advantages: It makes dosing possible, as natural products can have vastly varying amounts of the active agent. You don't have to consider the effects of other active ingredients which might also come in varying amounts (this is especially true for cannabis, which contains several different active cannabinoids).

This is exactly what you want to do when you really want to use cannabis as a medicine instead of using the medical system as a trojan horse for full legalisation. It's similar to how you get pills with caffeine at the pharmacy and coffee at other places.

If you let cannabis plants or genetically modified yeasts generate the THC before you extract it doesn't matter. It's only a question of cost. You will get exactly the same extract that is in no way distinguishable. Most arguments against GMO don't apply for modified bacteria and yeasts in biotech - they're not viable to live outside of the lab.

Also it's pretty funny that you speak about organic and not commercial. Most cannabis is grown in hydroculture with chemical fertilizer and produced for a financial gain (other word for this is commercially).
That said:

Support for your browser is coming soon.
Check out Notion on Google Chrome desktop, Safari, or iPhone.

Copy and paste this link into a supported browser to continue:

https://www.notion.so/tutorial

This is a whole lot better than a few other (ehem, Google. And, yes, MS, 15 years ago.)
> You can not ask Italy and Greece to solve the crisis by themselves, when most refugee want to actually go other countries.

If the refugees are persecuted so badly in their own countries (which is a condition for getting asylum), they should be happy for any sufficiently safe country that is willing to give them asylum.
Diversity need not be a reason for non unification. India for example is so diverse that each state has its own language, food, culture etc..
I still don't get why Mozilla and Google don't accept CACerts. Couldn't a lot of this be solved by just removing the warnings?
No, cpach is right. You can't post comments like "it shows your subpar human material" to Hacker News. Personal attacks are not allowed here, regardless of whether someone downvoted unfairly.

There's also the guideline specifically asking you not to go on about being downvoted.

https://news.ycombinator.com/newsguidelines.html
> Prussian who pretended to be a Bavarian who keeps on criticizing Prussians

Dreckspreissen.

The funny thing is that this rivalry with Prussia still exists, except over the centuries the term "Prussia" has become a generic name for all of Germany north of Bavaria.