skysight-inc/HackerNews huggingface dataset:
Not specific to Postgres but I found that knowing how to write complex and efficient SQL queries can be overlooked but is a very useful skill, and then understanding indexes and query plans allows to drastically improve performances and thus reduce scaling needs

Edit: wording
Vue.js has also displayed an ability to handle higher frame-rates (10 frames per second as compared to 1 frame per second typical for React) which makes it a better choice for development of applications involving animation.

I'm working on a React app that runs at 60fps at the moment.
I think this is a fair assessment, though it's not like the postgres team is known for "move fast and break things" - they do slow and incremental. Plus, in the press release a DBA from Yandex says they're excited about it so we should know soon :-)
How to Measure Success with Airbnb’s Product Manager
Performing Range Queries Using Bitmaps
GPG keys are not that long, maybe 2 pages (ascii armored). Just print the private key out and store that in a safe or deposit box. You can physically see the key, so you know the backup worked.

If you ever need to restore it, yes it will take ~45 minutes to hand type the key back into a new computer. Oh well, that's the tax you pay for restoring your backup or making a new subkey.

Civilization has long figured out how to store paper. I've grown to respect how powerful a printer and some patience can be for key backups.

EDIT: I think most of the replies are missing the point. I want to keep things barebones. The only thing that should be required to recover is a copy of GPG. No qr decoder, script, or other nonsense. If you depend on something else for recovery, you are putting your trust in that. I trust GPG, paper, and my eyeballs.

Also: https://xkcd.com/1319/
It happens, but when it does happen, people have recourse to a totally different system: the courts. I think of it like raising the issue up out of the system Corporate Management and into the system Legal Enforcement.

It is patently not a perfect system, but the failures are notable because they are not common. Most shareholder lawsuits against management are resolved before anyone ends up in headlines.
A heartfelt thank you to all PostgreSQL contributors for such a wonderful solid, well documented and versatile tool. One of my absolute favorite pieces of software.
https://blog.codinghorror.com/we-dont-use-software-that-cost...

In the Windows culture there is also the MSDN factor where once you get an MSDN subscription you have licenses for an insane number of Microsoft product so your SQL Server and Visual Studio and ... are all covered under one price. You are paying for it, but not for an application at a time, so why go with some vendor that wants more money?
My experience with GCC and compiling C++ has been that performance scales nearly linearly with core count. In other words, compiling C++ gets great benefits from parallelism - provided you configure your build to take advantage of it. (For make use the -j N option where N=num cores + 1; for Code::Blocks it is a preferences option. Not sure about Visual Studio.)

Things that do not parallelize: the final linking step (especially with mingw), compilation if all your code is one giant CPP file (prefer small files).

Assuming you have an SSD, your project is configured for parallel build, and your code is organized into many small CPP files, more cores == more better. I look for the highest core count CPUs with the lowest power. Last year I built a dual CPU Xeon workstation / home server using 1.8 GHz 14-core chips (mostly from second-hand used hardware to save money). I feel that that low clock speed is actually an advantage, because even with 2 sockets and 8 sticks of 8 Gb RAM, it idles at only 75W (at the outlet, as measured with a Kill-a-Watt). With 56 total threads, it builds my C++ project in 2.0 seconds flat, something which takes almost 2 minutes single-threaded. (I think the fact that there are 60 seconds in a minute, that 56 ~= 60, and that the build time went from 2 minutes to 2 seconds is not coincidental.)

Unfortunately a hardware problem with one of the used components seems to be causing the machine to lock up under Linux, and I never had the time to troubleshoot it, and moved on to a different codebase which doesn't require as much compilation so haven't yet had motivation to track down the problem.
> If you go the traditional route, you will always have a company in the middle, taking their cut or selling you out behind the scenes.

The free market sure seems to be okay with this. Those middle men provide valuable services like chargebacks, lines of credit, the ability to quickly provide large sums of money without using wheelbarrows to cart them around.

> I'm on the hype train.

You, and almost every other blockchain proponent are so blinded by hype and greed you can't see the very real, very fundamental flaws in bitcoin and "the blockchain". Bitcoin attracts the perfect intersection of people who don't understand economics, math, computer science, finance, business, sociology, or politics. Bitcoin is deeply flawed in all those areas.
Re: the 'more Dynamic"' version, have you seen the amazing postponed sieve generator?

This is the 'really Dynamic' version, it recursively treats all previous primes as a special case.

https://stackoverflow.com/questions/2211990/how-to-implement...
The British prison system became increasingly chaotic during the 1980s, culminating in the notorious 25-day riot in Strangeways prison in 1990. The response was a five-month public enquiry led by Lord Woolf that prompted major reform throughout the prison system.

Perhaps the most important single change was the introduction of the Incentives and Earned Privileges scheme. Woolf recognised something that seems obvious in hindsight - prisoners on a bread-and-water regime have little incentive to comply with prison rules, because they have nothing to gain and very little to lose. Offering small luxuries like the right to wear your own clothing, access to a games console or a small amount of discretionary spending gives prisoners the opportunity to make rational choices about their own circumstances.

In 2013, the Conservative government made the catastrophic decision to "toughen up" the regime and withdraw parts of the IEP scheme, while also cutting prison expenditure and staffing ratios. The results were entirely predictable - a huge increase in prison violence and disorder.

https://en.wikipedia.org/wiki/1990_Strangeways_Prison_riot

http://www.doingtime.co.uk/how-prisons-work/how-do-prisons-a...
> prisons should be to rehabilitate

What I personally appreciate the most is the simple fact of having dangerous people confined so that the danger to others (including myself) is no longer there.
Why I don’t like Jupyter Notebooks
Exactly.

It's like developing your app to work with MySQL, PostgreSQL, sqlite, Oracle, SQL Server....

Unless that is a business requirement, don't do it.

It reduces you to the lowest common denominator and the chances that you will actually switch from one DBMS to another is low and probably would require lots of work regardless.

In almost all cases, YAGNI.
I though it just required you to be logged in. I apologize.

Summary:

This was reported as a security vulnerability, moved to a Gmail bug report, then closed with the status "Won't Fix (Intended Behavior)". [0]

Anyone can DoS any gmail inbox by exceeding the incoming email limit. Gmail just starts rejecting emails to the target account. They have known about it for years, but don't seem to care.

Edit: The most frustrating part is that I have stopped receiving email for 6 days now. I was told second hand that an employee at google was also affected and the spam team was going to deploy a fix. There was about a 12 hour window yesterday when the email started arriving again. It is frustrating that their bug tracker contradicts what is actually going on inside their organization.

[0]: https://imgur.com/ksYbkEv
Free Forever: Applicant Tracking System
I'd go with a pg_dump to a plaintext SQL file, then run `psql < backup.sql` and see what happens. I'd run pg10 concurrently in a docker container or something to try before trying it live.

If 10 fails, try 9.6 (docker run postgres:9.6) and do the same, to see if it's an issue exclusively with 10.
Once I started foraging and hunting for my pay...I started to feel more free and much less likely to take bullshit from anyone (afterall, there is always the next hunt).

The core of your being is changed when you start with yourself as your mental point of origin and take nothing for granted when it comes to the "mythical job security".

It's doubly so liberating when you do not have to deal with the ghosts of past employers and the shadow of what "future employers" will think.
HighSierra Diskutility stores APFS volume password as password hint
QRuby – simple sql query builder library for Ruby
I would love to hear some thoughts about what I wrote re: Open Source Libraries vs Open Source End-User Software.
I don't know, I hear more of these stories from the USA than from the other two. Granted NK probably has a stricter policy on journalists. But this seems very common for the US.
That's understandable, but it's also worth pointing out that that issue is now understood and affects only processors manufactured before June 2017. Any affected processor should be returned for replacement or RMA.
If you're willing to overclock, the 1700 would be a bit better as the price is a bit lower and it can hit the same clock speeds (after OCing).
> And that is? They're happy to be unfree

Just because you love healthy food doesn't mean you go around on the street shoving salad in people's mouths.

> You said a lot, but not one word about your own, personal perspective. If I asked other Chinese people

He said:

> Majority of people in China are happy with their lives, we certainly do not see the need for help from other countries in the way you wanted to.

Which I'm pretty sure you can interpret as being how he and his immediate peers feel.

> I did take care of my backyard.

Unless you country is void of any problems or internal conflict, you've missed the point. Your backyard is your own government not your own appreciation of yourself.
How to Build a Self-Conscious machine
Every answer to that question is different! For most people, however, it will involve tasking risk, probably a lot of risk.
I think the key thing is that even without understanding the technology most consumers could see "before I couldn't get access to this information/correspondence/map/ticket/catalogue/advice/news/opinion/porn and now I can" as an obvious life enhancement in a way which having anonymous miners as counterparties rather than the company providing the service and their bank isn't (not even if expressed in terms of a 3% fee reduction). Whereas with blockchain it seems like it's often the evangelists not understanding the consumers: to use examples from the article, I really care that flight delay information is easily available which is why the internet was much better than call centres but I really don't care whether it uses a distributed database or not and wouldn't fly with anyone I worried wouldn't honour the terms of my ticket. I care that ridesharing services have good availability, routing and safety, I really don't want them to be transparent about my location and payments to any interested party.

Now, there are many technologies which are very useful for certain use cases despite the consumer failing to grasp what's going on behind the scenes, from Java VMs to graph databases to torrents, but certain things tend to be true of them
(i) they weren't as exciting opportunities as the internet even if billion dollar businesses were built on them
(ii) the developers explaining why existing solutions were good enough if not more optimal in many respects were often right.
I should also say that it seems like a stretch to say Virtua Fighter didn't do well in arcades, but that had more to do with the graphics.
> processed fish are a fungible commodity and could be sold for the same price outside of China

yes. right. that aspect of this story puzzles me. i thought that was how globalism worked.

i mean, can't Norway just sell the fish to, say, Canada, which could then sell its farmed salmon to China, etc?

i can't quite see what difference this will make. is Norway geographically closer to China than other salmon producing nations? how do they explain this?
This was my thoughts exactly, but felt a slight bit guilty, and wanted some external validation. :)

As a note to anyone reading this, as a former LWN subscriber a couple years ago, and as someone who will probably renew at the $40/year level here today again, definitely consider throwing them a subscription. It's one of the best tech publications on the web.
Thanks! This is definitely something I need to get around to once I read up a bit more on vendoring.
An interview with Bjarne Stroustrup, creator of C++
Web rendering is hard. You'll probably have to scale horizontally at some point, and balance load between servers. But a microservice architecture makes this not terrible.
I’m one among many I know who upgraded my work system from Windows 7 to Windows 10 and regret it even after a year! The upgrade process was smooth, but every once in a while, it won’t allow me to login - it will just repeatedly throw an error saying my credentials are invalid (though they’re not). The solution is to try switching login methods, turn off the network, wait for several minutes or some combination of these. The number of times I’ve been away, returned to my system to get into a Skype for Business call, only to find I can no longer unlock my system is not even remotely funny anymore. I have learned to be around several minutes before any call so I can fight, if necessary, to get in! I’ve read forum posts on many sites, but don’t have any solutions. My system is set to auto-update Windows. So it’s not that I’m not on the latest or that MS has fixed it.

So no, there are very, very good reasons, IMO, to stay on Windows 7 or 8.1 (where this problem didn’t exist). I actively recommend others not to switch to Windows 10 because of this. Of course, YMMV!
"The problem here is the same problem we’ve seen with big core parts and Windows 10, however: these large processors can only take so much before having to move threads around, to keep both the frequency high and the energy density low. All it takes is for a minor internal OS blip and the single-thread power begins to dissipate. Windows 10 famously kicks in a few unwanted instruction streams when you are not looking, and as a result the average single thread performance seen on the 8700K might be equal or lower than that of the previous generation. It becomes an infuriating problem to debug as a reviewer."

I didn't know this was a big issue with multicore processors, very interesting. Does this mean that if you OC a single core to the limit to get the best single threaded performance, you will see drops in performance when your other cores start getting utilized?
Probably, but in most cases it would be a small gain.

Maybe "Watson for Cancer" would get you a 55% survival rate instead of a 50% survival rate. Just doing the study to prove it is 5% better would cost billions!

The low-hanging fruit is things like

* getting people to really take their maintenance meds

* avoiding stupid mistakes such as https://www.ncbi.nlm.nih.gov/pmc/articles/PMC2963580/
An air-gapped system is really just for key generation (or generating new subkeys). You really shouldn't store your key on the air-gapped system when you are done.
Love that vault suggestion, but for a lot of folks, a safety deposit box might be sufficient (with your own enclosure within it using tamper evident stickers).

Having moved 5+ times in the last decade, I'd dread thinking about having to move that safe you linked to.
One of the biggest reasons I can't use Edge is I think it's impossible to actually inspect an HTTPS certificate.
I'm sleepy, so I shouldn't post, but here goes. Confidence is really important for a programmer. Writing good code is very, very difficult. On the other hand, writing terrible code that barely works is not so difficult. There is a pretty big gulf between the two and if you don't have confidence that you can achieve something better, it is unlikely that you will even look.

Having said that, our industry is full of a lot of people who probably are not well suited for the job. Quite a few people look at the 6 figure salaries that you can get in some places in the US and figure it's a cushy way to get rich. Similarly, there are tons of jobs. Everybody is looking.

But here's the catch. "Everybody" is not looking for the average programmer. They are looking for the top 1% of applicants. Anybody who is hiring (i.e. everybody) can verify this. How man CVs do you get a month? How many do you interview? How many do you hire? And even then more than half the time I reckon companies are dissatisfied with the programmers they hire.

So there is actually a huge supply of average programmers that nobody wants. The average programmers aim at the "barely works" bar, and having hurdled it think they are senior programmers. A year or two under their belts, they demand their incredible wages.

At the same time, we all ask ourselves, "How can we protect ourselves from the hordes of untalented hacks knocking at our door?" Whiteboards, puzzles, trick-du-jour. It doesn't matter, because the real problem is what I stated at the top.

Confidence is important because writing good code is very, very difficult. Writing terrible code that barely works is not so difficult. We think we need to protect ourselves, but we don't need binary barriers to protect us from the untalented hacks. We need a better attitude. We need to realise that programming is a skill that takes time and effort to develop.

Some people should not be in this industry -- not because they don't have the chops; but because they don't actually want to put in the time and effort to develop their skills. And it is an overwhelming task. There is so much to learn that you will be drowning in it for years (another reason people put their fingers in the ears and think they are amazing).

So to any "young" programmers (of any age), my advice to you: Have courage. Have confidence. Love what you do because it's a crappy, horrible job if you don't -- no matter how much you get paid. And for those who don't love it... there are lots of jobs that are not programming, but are still in the industry. Quite a lot of them even pay more than programming! Seek them out.
This is not correct as far as I know. The Norwegian government wanted to join the EU because in the current state they have a lot of obligations to be allowed to the single market and they even have to pay a large sum for it but they get no say in it. Voting rights are limited to full EU members. They are getting a bad deal, just like the UK will, simply because the population does not want to join the EU.

I want also to point out that this would not have happened if Norway had been in the EU already in 2010 because China would not risk trade with all of the EU because of such a small incident.
Does this mean that if you OC a single core to the limit to get the best single threaded performance, you will see drops in performance when your other cores start getting utilized?

This is how all CPUs with some form of "Boost" work, yes. People who overclock generally lock the multiplier to avoid it. So you will tend to have this problem when you do not overclock.
This have help me in discover extra powers of sql:

http://modern-sql.com/

And

http://use-the-index-luke.com/
> There's no way a VAT or flat tax would be progressive enough to fund the government without crippling vast portions of the taxpaying base.

That's what the UBI is for. You can have something like a 35% VAT with a $15K/year UBI and then the effective rate on someone at $60K/year is 10%, but at $100K/year it's 20% and it only goes up from there. This is very much in line with the existing effective rates, and you can make them whatever you want by adjusting the tax rate and the amount of the UBI.

It also replaces a huge swath of social spending programs because you're then giving someone who makes $20,000 a year $8000 more than they pay in taxes.
Throughput: It depends on the link, but I'm getting 16mbps peak where my connection to my ISP gets me 20mbps peak.

Mobile: You have to use the APIs that are available on the platform to hook into the network layer. After that its pretty straightforward though - you open some TLS connections, do verification, and encapsulate network traffic in some simple structs.
Blockchain Could Help Us Reclaim Control of Our Personal Data
So you have two easy options. You can do an in-place upgrade with pg_upgrade: https://www.postgresql.org/docs/10/static/pgupgrade.html
I've personally never used this tool.

I normally schedule a maintenance period, and use pg_dump / pg_dumpall: https://www.postgresql.org/docs/10/static/upgrading.html

Then I create a new server and install the new version of Postgres, and apply all custom configurations, turn off the database to external access, use pg_dump / pg_dumpall to create logical backups, restore them to the new server, configure a new replica, test my application internally, then when i'm happy i'll turn everything back on for external access.
I have been working in Agile or "Agile" for the past 7 years, across 3 different companies and noticed similar patterns:

- complete failure to adapt to unplanned interrupt driven work, such as mid-sprint escalations, QA issues etc. Management rarely pull anything out of the sprint when a developer gets pulled to work on unplanned tasks.

- countless meta discussions about what constitutes a story point and whether it should be tied to time and just exactly what it means to be "agile". Agile discussions are starting to turn into "no true Scotsman" arguments.

- grooming and planning discussions often overlap in scope leading to exact same things being discussed twice

- management/senior staff pressures to trivialize tasks complexity leading to pressure to underestimate and little thought is given that not all developers work at the same pace across all technologies.

- sprints rarely finish exactly as planned, so a lot of tasks either get carried over to the next sprint or if they are finished early, it leads to even more unplanned meetings to decide what should be pulled into the sprint. I recently noticed among my colleagues who complete tasks early to just "ride them out" until the end of sprint.
Postgres continues to astound me and the dedication of the people working on it is wonderful. Thank you to everyone who ever contributed a line of code or to testing or to documentation. Everything is top-notch!
At a previous job, the code (written in C) had a large chunk of database handling code for both MySQL and Postgres.

And used Postgres-specific features in the schema.

sigh
Encryption. If you encrypt files with the public key you are going to want to keep private key around long after the signature key is expired. The alternative is to decrypt and re-encrypt your files when you rotate keys out, but there is always a worry of forgetting something.
This Simple Note-Taking Method Will Help You Read More and Remember
I miss reader service cards. :-/
This manual indicates the UK prison system is much more like the US system than I expected.
e.g. shared prison cells.
>We give coding challenges to our intern applicants, and most fail.

Cool, we can finally remove CompSci degrees from job postings.
I would absolutely love to commute by bike. Distance is a factor but that is not the primary issue. I am in south-east Georgia and bike lanes are an absolute foreign concept. I mean even if we had them, people would use them as passing lanes and all that.
I've seen plenty of 'sleep hack' articles recently; trying to do more with less where sleep is concerned. To me that is a complete non-starter. I truly just need more sleep.