skysight-inc/HackerNews huggingface dataset:
There are tons of ways to do that, the lazy way would probably be pay someone like Citus (https://www.citusdata.com/product). Alternatively, use a 3rd party tool, do manual sharding, or the PG FDW, or ... the list is pretty endless. Depends a lot on your needs, requirements, how much sharding you have to do, etc. It's not a simple topic.

First I'd make sure your DB sizes really NEED that before going down that road, it's a lot of hassle, and I'd personally push for just sizing your DB box up and up and up before going down that road if at all possible. Simple solutions(read: not sharding) usually win, especially when production falls over and you have to prop it back up.
Slashdot's score weighting is configurable. You could even add a positive score offset to foes.
Funnily enough, every time I see the friend/foe dots/pills on a post my first thought is "that's an old-timer". I'm betting well over 75% of the current Slashdot readers don't even know it exists.
I transitioned from a Macbook Air to the Pixel 2 and got the following at the time:

+ 16GB of RAM instead of 8GB

+ Touch screen

+ Retina display

+ USB-C charger which is the same as my phone now, having a single charger is a convenience I probably overvalue.

+ Very fast startup time

- Slightly more weight

- Severe restrictions on software used

I'm an odd duck in some of my choices though, so I wouldn't recommend my setup blindly.
> Transparency, accountability

These are concepts, not practices. And 'introspection', while arguably being a practice, is really, really not basic stuff. Introspection with actionable outcome is about as basic a practice as "finding inner peace" is.

> If they're violating the definition of the process, they're not implementing the process.

As seen even in just the comments on this submission, if someone follows the definition of the process as laid out in the literature, they are dismissed as being too process-focused and not truly Agile. If someone doesn't exactly follow the definition of the process as laid out in the literature, they are dismissed as not following the rules of Agile.
I was always proud of having a slashdot userid < 262000 :) Definitely spent too much time on slashdot in the university computer lab.
Does a British subject have less rights than a British citizen / non-subject in that colony (e.g., the administrators)?

EDIT: I asked this half rhetorically. Although I don't have citations to back it up, my impression is that natives who were colonial subjects didn't generally fare well. You may be able to argue minutae.

EDIT 2: you ask a fair question, but I couldn't help but be reminded of: https://www.youtube.com/watch?v=jIvYWUVB1Ig :)
He risked his neck to advocate peacefully for democracy in Communist China (PRC)
Bush, Obama, and now Trump have been increasingly adding new judges that have a tendency to be pro-surveillance. I think this situation is only going to get worse in a "boiling the frog" kind of manner, where judges effectively argue that in most practical situations rights such as those given by the 4th amendment are not applied, except in very specific and hard to pinpoint situations.

They're already doing this with online data, which seems to have very little 4th amendment protections.
> It's tricky to explain

This reasoning is fairly simple:

Suppose we have a composite number K that is less than P^2.

Then K = A * B, for some A and B not equal to 1, (which is the definition of composite). Let us say that A is less than or equal to B. (If this is not the case, switch the labels.)

Then A must be less than P:

If A is greater than P, K = A * B > A * P > P^2. But we chose K such that K < P^2.

If A is less than P, then K will have been marked during the cycle of Q, a prime divisor of A, which will occur before P. Therefore, we do not need to examine any numbers below P^2 -- they are either prime or have been marked.
I think it might be a bit tongue-in-cheek, but when I look at the game as written, it actually sounds fun.

-I think the real game there might be inventing such graph for your oponent, so that you have a chance for a draw? :)-

Wow, finally finished reading the comment. This looks quite interesting and deep.
It seems to me like an expensive way to pay. Correct me if I am wrong but these debit cards have higher fees compared to using a fiat based Mastercard or Visa right?

Because for every transaction you have extra crypto <-> fiat conversion which must have some fee attached to it by vendor who does the conversion.
I've been writing little one-page javascript pages to introduce my four- and six-year-old to various mathematical concepts like cardinality, place-value, sets, factors, equivalency, etc, etc:

http://ideonexus.github.io/Explorable-Explanations/

The boys love some of them (others not-so-much). Based on this article, I'm getting lots of ideas for new ones to code. Most of the code is original, but I try to be careful to give credit to anyone whose code or ideas I build upon.
Edge isn't great period. There are too many janky UI and design choices - probably because it is part of that whole benighted Metro ecosystem.

The thing that really drove me nuts was how the address bar jumps around when you're trying to select part of a URL, which makes it so much harder than it ought to be when you are trying to click and drag with a mouse, let alone a touch interface.
That being said, I'd much rather be the less successful guy than the guy constantly afraid of failure. "Productivity" is only as good as it advances your own personal life goals, and I don't think it should come at the expense of mental wellness.
Yes: https://github.com/invertase/react-native-firebase
What do you think "wanking off" means? I mean literally that phrase, because I don't think you meant to use it in this context.
Teens 'rebelling against social media', say headteachers
Agreed. In my case, being exposed to the subscriber content through links shared by others is what convinced me LWN was well worth the money.
The impression i have is that it gives fores a personal -1 on their comment score. So unless they get some +1s from others, or you have set /. to show everything, they will vanish below the breakpoint.

Note though that anyone can look up who has them flagged as foe on /..
You are outlining a problem instead of solution.

It's likely that China is not going high-income. It's obvious that India is not going high-income. It's apparent that Russia isn't going to be high-income either. Same for Iran, Indonesia, Philippines. So are we headed towards a planet which is mostly authoritarian, and in which most of GDP is produced in authoritarian countries?

Won't islands of democracy become fewer and further between? It seems that Democracy became much more expensive not unlike real estate and college are, and now a lot of communities can't afford it still.
I am testing pupeter/headless chrome, pdf export stil has some bugs, I hit an issue with page sizing and I am stil using wkhtmltopdf for now, the bug is present in main Chrome save as PDF.
Chrome has better font rendering and it knows to embed the web fonts into the pdf where in wkhtmltopdf I have to do it manually.

Link to size bug:
https://github.com/GoogleChrome/puppeteer/issues/666
I feel like Microsoft SQL server is the easiest to use and has the best tooling.

I would say that MySQL and Postgres are generally ok to use I slightly perfer MySQL tooling.

Oracle seems to be the most different one but once I got use to it it was ok.
+5 Interesting
Practical fault attack against the Ed25519 and EdDSA signature schemes [pdf]
As for overgeneralizing the community that is partially true, they do resist introspection and they're a ever changing group of anonymous people, but overall, everything the chans do is for lulz.

>In fact, because the aim of the chans is orthogonal to truth or accuracy, it’s a more fertile plot than any on which to grow disinformation.

Even if the above premise were true, and all info in the chans is disinfo, you still have the power to exercise your discretion on what to believe.

There's been several studies on memetics on viral spread of memes, the higher the emotional valence of the meme, the faster and longer it spreads. In addition, when the emotion elicited is anger, it spreads the fastest because the act of passing it along is one of the ways to provide catharsis.

For me, the problem is not inherently on the chans for producing disinformation but on the system that needs scandal and viral memes to drive clicks as a business model.
Catching Up: The Near-Future of Commercial AI
Never. I did it few times several years ago when I was working on a personal side project and before that during university. But since I only have a day job at the moment I leave my work at the office. There's always another day you can continue where you left previously. No need to lose sleep.
From the linked page:

> There is no group of users that should be using the code in this repository here under any circumstances at the moment, not even beta testers or dare devils.

Despite the warning I attempted to use it, but without any real docs I didn't get very far.
And those that do use the official name of Taiwan's gov't, the Republic of China... which makes PRC look bad since they have a "China" across the strait with democracy and freedom.
How to defeat Ed25519 and EdDSA using faults
This should have been an x70; an oem x62 w/led backlit sxga+. Not some preexisting workstation replacement beast with a classic keyboard slapped on it.

Lenovo has been such a disappointment.
> Also, since Norway is trying (unsuccessfully so far, but still they are trying) to lessen dependence on oil, this loss mattered even more than you might think at first glance.

On that topic, I wonder if China offered any assurances regarding support for Norway's territorial claims in the Arctic Circle.
"More and more webpages are requiring JS even to display anything beyond a blank page."

Can you provide some example webpages so we can take a look?

Also, I agree with @asciimoo's point about endpoints. One could make an argument that compared to the website design of the 1990's and 2000's, retrieving structured data from websites is actually getting easier not more difficult. I recall one period of time where the trend was to design websites entirely in Macromedia/Adobe Flash.

Here is what is missing from this project (and many others like it): when providing software that performs text processing one needs to not only provide example code but also example output. This enables a user to quickly compare her current text-processing solution with the software being provided without having to install, review and run the unfamiliar software.

For example, without some sample output she cannot test, e.g., whether her current solution produces the same output faster or using less code.
Option A often leads to Option B

For instance, some guys tried to colonize an island that was just around sea level in the south pacific. The king of the next island over found out about it and sent some big guys over to beat them up.
The one thing that the friend/foe system missed IMHO was the ability to tag posters with comments like "suspected oil shill" or "actual Intel chip designer" or stuff like that. That's often more useful than some vague idea that a poster had some especially good or poor posting in the past.
Brings back memories - I was working in a SW startup in 1992 and we were subcontracting for IBM, developing OS/2 network SW. They gave us a bunch of PS/2 PCs but also tossed in an early ThinkPad.
I've thought this for a long time. How do you actually make it happen, though?

If prisons had to refund the state when there was an instance of recidivism, they'd have an incentive to insure former prisoners were able to integrate back into society again.
I've been following this for a couple years, lots of discussion on reddit /r/thinkpad. They basically produced a T470 with a classic style keyboard, and anniversary badging.

As far as what people hoped for, they couldn't do a 4:3 or 3:2 display, as that requires a larger bulk purchase than what they planned for this model (only 5000 units produced). The thinklight wasn't possible because the screen bezel is thinner. Hopefully they will use the classic keyboard on additional models in the future, but there is no indication of that at this time.
Here’s a blog post by the programmer in question: http://dmitry.gr/index.php?r=06.+Thoughts&proj=02.%20Android...

I think that covers most of the main points.

Of course, it may be that it all came down to support contracts internally between Google and the Nexus device suppliers (the Nexus 7 blobs come via Asus, the Nexus 4 was an LG device that used the same Qualcomm chipset IIRC.) but that’s the kind of detail that end users really don’t care about: both were Google devices that Google sold & from the point of view of the end user Google dropped support for one device for no obvious reason as far as the end user can see.
For me, Slashdot was the first big internet community. I wasn't materially involved in news groups before that.

It's a little weird to think I wasn't 20 when I started using /. I was also a little surprised to see there's still a website at the URL. And I can still log in with my old username.

And, for the record, my autoincrement user id was 6533. During the height of their popularity having a 4 digit id give me a bit of geek cred :)
Mike Pence – America Will Return to the Moon–and Go Beyond
I love that line 'Conversations that begin with “Got a minute?” are almost never that short.' Use it so often! :D
This is extremely interesting to me. So much about those machines make them perfect for dev.
For a web interface, especially for data browsing/editing, TeamPostgreSQL[1] is the best I have used for any database.

[1] http://www.teampostgresql.com/
Do you see every market segmentation as a conspiracy? If so, a conspiracy between whom?
SoundCloud's Data Science Process
Google Reveals Blueprint for Quantum Supremacy
What we're doing to limit the number of fundraising banners you see on Wikipedia
I have wanted HN to have a friend/foe system since I first found the site. I'd also like it to have the ability to make notes, like 'farkies' from Fark.

On Slashdot, you simply add them to a friend or for list. On Fark, you get to flag them in certai colors and then leave yourself a note (other people can't see it but admins probably can) that I use to remind me of why I put them on the list.

I'd like a combination of those two things. A simple friend/foe list with comments that show next to their name. I'd have no use for ignore functionality. Also, I usually use said note to write polite things that help me remember the user.

I think it encourages getting to know the other people and humanizes the pixels on the screen. Both sites have led to my meeting people in real life and making real life friendships. That's easier, for me at least, when I can more easily identify them as individuals and remember them.
Expensive and hard to get in Europe :(
Regarding replication, the logical replication in pg10 should make this significantly easier. Between that and "Quorum Commit for Synchronous Replication" I'm really excited to see how these pan out in production. Pg doesn't normally hype or talk about (or let into production) things that don't work.
I'm not sure where you're from and prison effectiveness tends to be dramatically different throughout the world. However, where I'm from, federal penitentiaries have a first year recidivism rate of over 40% (for non indigenous males) and nearly 60% (for indigenous males). In Canada, the provincial correctional system houses people sentenced to two years less a day, so federal penitentiaries tend to house more violent criminals.

I'll agree that it's nice having them off the streets, though I hate knowing that we release people knowing that on average, over 40% for reoffend within their first year.
Aside from tooling, those systems often perform much better than PostgreSQL for large queries or transactions, as they feature much better optimizations. Even outside of newer optimizations like "columnar" storage, several of those systems do code generation from queries to avoid function calls, branches, etc., which can have huge performance implications. I worked on the internals of PostgreSQL once, and the number of function calls in the innermost loops were very high.

PostgreSQL also used to be (is?) single-threaded, which limited performance of a single query on multi-core machines -- I haven't looked into it to see if there has been any fundamental change in the architecture in the last 4-5 years.
On that note, i seem to recall some physicist's personal web page that got a massive attention on /., Reddit and some other site all in the same day, leading to quite the surprise from the server admin.
5 Mistakes Employees Make When Challenging the Status Quo
Not strictly mathematical, and maybe not exactly 5 year old difficulty (some of these are HARD) but here goes:

https://www.chiark.greenend.org.uk/~sgtatham/puzzles/

There's an Android version of these puzzles and Linux packages (usually called "sgt-puzzles" or something similar). Apparently (I just found this out) they also work on the browser, which is pretty cool.
I'm not familiar with Windows nowadays. If it wakes up locked and asking for a password you are fine. That's the setup of my Ubuntu laptop.

Lock the PC, leave it on a desk, it goes to sleep. You come back, wake it up, type in the password to unlock. The weakest link is remembering to lock the pc. Auto lock after some minutes is ok only at home.
Further reference material:

- PgSQL mailing list thread discussing Uber's post: https://www.postgresql.org/message-id/579795DF.10502%40comma...

- Slides from "A PostgreSQL Response to Uber", a talk that provides the PgSQL-perspective counterarguments to the Uber post: http://thebuild.com/presentations/uber-perconalive-2017.pdf [PDF]

- Previous HN discussion on the above: https://news.ycombinator.com/item?id=14222721

- Slides from "Migrating Uber from MySQL to Postgres" (2013), in which Uber's prior migration _to_ PgSQL is discussed: https://www.yumpu.com/en/document/view/53683323/migrating-ub...
I typically see stuff on HN first and then on /. a day or more later.
I imagine bit errors are highly unwanted on any domain when they occur in pointers, especially on those that are written through. Some languages make that more likely than others of course with heavy use of references.
TL;DR: If you look at the best stocks, measured by 5-year performance, they sometimes go way down within those 5 years (mainly because of recessions). Not very surprising.
maybe the benchmarks are not so impressive and the workloads not super common, so they didn't want to mislead you? :)

Anyway, some more info http://rhaas.blogspot.hu/2017/03/parallel-query-v2.html
What a bunch of senseless FUD.

WireGuard is based on the Noise Protocol Framework [1], designed by the same fella as the Signal Protocol, and already used in production by millions of devices all around the world inside of WhatsApp. Not only that, but we have a formal verification [2] that the crypto is correct in the symbolic model. The WireGuard paper itself [3] was presented to the academic community at NDSS [4]. It's most certainly not the hastily-made nonsense you imply it is with the phrase "rolled our own crypto".

Meanwhile your project, "subnet", tunnels TCP over TCP, which is well known for having pathologically bad performance characteristics [5]. It also has no binding between certificates and the IP addresses that a certificate is allowed to be inside the tunnel, and, unless I've misread, it allows different peers to hijack each others' IP addresses simply by asking [6].

There's a lot of work that goes into doing tunneling well. I encourage your effort to make a fun toy project; it's a great learning opportunity. But please don't spread FUD about other projects without first understanding them.

[1] https://noiseprotocol.org

[2] https://www.wireguard.com/formal-verification/

[3] https://www.wireguard.com/papers/wireguard.pdf

[4] https://www.ndss-symposium.org/ndss2017/

[5] https://www.google.com/search?q=tcp+over+tcp

[6] https://github.com/twitchyliquid64/subnet/blob/50fc8fe2b6ccf...
Yes there has been. This release expanded it significantly.
This is super interesting (car sales). I know you have probably a lot of better things to do than answering strangers' questions, but, if you could, would you mind spending 60 seconds trying to find the post and post it here?
Because they really don't care what I run now, as long as I do it in their cloud.
Humdog's Pandora's Vox: https://gist.github.com/kolber/2131643
Every time I read it, it feels like the first time. I first read it one month before graduating with my undergrad CS degree and it profoundly changed me. She sure was ahead of her time.
The original title emphasises that NumPy and Pandas now are functional on PyPy.

The PyPy JIT cannot look inside C code, and crossing the python-c interface is slow, but give it a chance and you may be pleasantly surprised how fast your pure python code can run.
The military, Wall Street, healthcare financial services, and government (size, reach of power), win after every single election.

I don't think Obama is a particularly good or bad man, I think he's just a good politician who went in there and did "what he was supposed to do." Stupid and evil wars existed before and after him. He didn't do anything to fix it, but he didn't start it either. The President doesn't have as much power as we may believe.
I check the comments from time to time, but i fear the place is crawling with paid shills these days.
My post literally adds nothing to the thread. I'm just saying hello.
You need to be less than or equal to 203094 to be one of the cool kids.
To further complicate things, some of the larger many cored parts have a favored core which will turbo higher than the others, but only if the OS schedules work on it.
The Go implementation is not done yet! But it will be soon. In the meantime, feel free to use the Linux kernel implementation, which works quite well and has extensive documentation and man pages:

- https://www.wireguard.com/

- https://www.wireguard.com/quickstart/

- https://www.wireguard.com/install/

- https://git.zx2c4.com/WireGuard/about/src/tools/wg.8

- https://git.zx2c4.com/WireGuard/about/src/tools/wg-quick.8
In other comments the author seems to already be aware, but for anyone wondering why TCP over TCP is less than ideal, this is a good read: http://sites.inka.de/bigred/devel/tcp-tcp.html
How many of these things came from their current CEO? Of course, many of the current executives were also from the war-on-linux days, so there is that to worry about.

But it is possible that Microsoft is transitioning to a services company, similar to the IBM transition a while back. In that case, if they are being friendly towards Linux, it may be useful to show them that this is the right move -- hence the current level of what seems like unreasonable support.
First-ever AI face stabilization app for buttery-smooth action videos. Thoughts?
San Jose Mayor: Why I’m Not Bidding for Amazon’s HQ
Liu Xiaobo always has supporters.

Far as I can remember, at that time (Around 2009, 20 years after Tiananmen event), there are some people says Liu Xiaobo should be awarded with the peace prize for against CCP's dictatorship.

Some people event had a debate about it. Some say Liu is a hero for democratize China, others say he's wants China to be invaded and controlled by ... may be the US?

That debate later end with Obama's prize.

I'm not saying Obama is bad or anything though. It's not appropriate for an outsider to comment your president.
>>I feel like Microsoft SQL server is the easiest to use and has the best tooling.

Agreed. SQL Server Management Studio is fantastic and is one of the main reasons I enjoy working with MSSQL.

Unfortunately Postgres severely lacks in the tooling department. PgAdmin 3 used to be good, but PgAdmin 4 is simply horrendous. It makes me dread interacting with Postgres.