Postgres Weekly
Archives| Latest| RSS
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.
« Prev
Next »
Postgres Weekly
Issue 168 — August 3, 2016
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 
Introducing Tgres: A Postgres-Based Time Series DB
Gregory Trubetskoy   #tools 
apgdiff: Another PostgreSQL Diff Tool
A free database schema diff tool and how to use it.
StartNet   #tools 
Osm2pgsql: OpenStreetMap Data to PostgreSQL Converter
OpenStreetMap   #code 
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 
« Prev
Next »
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.