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 166 — July 20, 2016
Our Journey From Graph Databases to PostgreSQL
Graph databases have their time and place but just because you can do something in a graph database doesn’t mean it’s ideal. Here, follow a journey taken from Mongo to Neo4j to Postgres.
Engineering at Hipo
When to Use Unstructured Datatypes - Hstore vs. JSON vs. JSONB
Postgres has had schemaless data types for years. With hstore, JSON, and JSONB there are various trade-offs, pros and cons, as well as the broader question of when to use them at all.
Citus Data
PostgreSQL Conference Europe Registration Open
It’s in Estonia on November 1-4.
postgresql.​org   #news 
Corgis Eat Tech Debt for Breakfast
Need to crank out features faster? Corgibytes cleans up technical debt that gets in the way of rapid release cycles. One client doubled their productivity with zero new hires. Don’t let tech debt slow you down. Call the Corgis.
Corgibytes    #sponsored 
Optimizing DISTINCT Performance
Counts in Postgres tend to be slow, but if you need faster counts there are a few things you can use from sketch algorithms like hyperloglog to custom functions which can utilize indexes as shown here.
EXPLAIN EXTENDED
Inheritance: One More Reason to Love PostgreSQL
A brief look at table inheritance in Postgres, if you’re not already familiar with it.
Hans-Juergen Schoenig   #tutorial 
Thinking in SQL vs Thinking in Python
Benn Stancil   #opinion 
Query Array of Objects in Postgres
Storing data in a JSON column in Postgres can be very handy but a bit more difficult to query than normal tables. This quick tip highlights how to query and filter if you have an array of data in a simpler way using some of the built-in json/array functions.
Dustin Martin
Analyzing PostgreSQL Logs with pgBadger
pgBadger is one tool to help you parse Postgres logs and get insights into your database. Here’s a great primer to get up and running.
garage-coding.​com
New Versions of Postgres Migration Toolkit Released
Intelligent Converters   #news 
Stop wasting time - know what you'll earn before the interview
On Hired, sign up in 10 minutes and get offers from top companies like GitHub, Uber, & Stripe. Engineers get an average of 5 offers on the platform in 1 week
Hired.​com    #job 
« Prev
Next »
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.