This Week's PostgreSQL News (#168)

Datetime:2016-08-23 02:19:05          Topic: PostgreSQL           Share

On Uber’s Choice of Databases

Last week we saw Uber’s move away from Postgres to MySQL get a lot of attention. This week we get a few well reasoned responses from the Postgres community which include some areas we can improve , as well as some highlights of why what they were trying to do didn’t make as much sense in Postgres.

Markus Winand

Advanced Postgres Performance Tips

You’ve added the INDEXes, both partial and covering. You’ve VACCUUM ANALYZEd. You JOINed and INNER JOINed everything to a single query. And yet, your report is still taking too long. What do you do when the low-hanging fruit has been harvested?

Thoughtbot #tutorial 

PostgreSQL, Backups and Everything You Need to Know

Backups are key to keeping your data safe, but there is more than one option… And each has its benefits and trade-offs. Here’s a good summary of when and why you should use each.

Compose Articles

Itching for a rewrite? Try a Code Inspection™ from Corgibytes first.

We know the frustration. You see all the places your app could be so much better, but you can't seem to convince your boss. Next time, mention Corgibytes. Our Code Inspection™ can help you explain technical improvements in a way executives can understand.

Corgibytes #sponsored 

PostgreSQL 10 Kick-Off

The next major release of Postgres (after 9.6) will be known as PostgreSQL 10 and development is getting underway. Get an overview and start to follow along with such patches as this one .

Peter Eisentraut

Building A Data Pipeline with Airflow

Setting up a data pipeline with Python that takes currency exchange rates, stores them in PostgreSQL and then caches the latest exchange rates in Redis.

Mark Litwintschik #tutorial 

3 Ways to Work with Time in Postgres (and ActiveRecord)

Time is common in lots of applications, and working with them in Postgres can be incredibly powerful. Here’s a rundown for Rails developers on how you can do it more natively.

Duck Type Labs #tutorial 

apgdiff: Another PostgreSQL Diff Tool

A free database schema diff tool and how to use it.

StartNet #tools 

Why We Lost Uber As A User

Reflections on last week’s Why Uber Engineering Switched from Postgres to MySQL .

Postgres Mailing List

An Unexpected Journey, A DBA's Tale

A look at managing a large Postgres cluster running on Amazon RDS.

Ramanan Balakrishnan

Stop Applying to Jobs - Let Companies Come To You

On Hired, engineers typically get 5+ job offers in 1 week. Find that new opportunity you've been craving and get access to 4,000+ companies instantly.

Hired .​ com     #job 




About List