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 121 — September 2, 2015
10 Beginner's PostgreSQL Tasks You Should Know
You may already be pretty knowledgable about Postgres, but if you’re still relatively new, here’s a good run down of 10 basic steps to help you get up and running.
Jorge Raze
SQL vs NoSQL KO: Postgres vs Mongo
A thorough comparison of Postgres to Mongo (one of the predominant NoSQL databases). Instead of just performance benchmark fodder, this post does a great job helping educate about many of the differences along the way.
Abraham Polishchuk
Efficient Storage Of Large IDs In Postgres
A look at using different column types to store large IDs (such as long hex string identifiers) more efficiently.
Gary Sieling   #tutorial 
Unleash Real-Time Big Data on PostgreSQL
CitusDB delivers real-time end user insights into your big data while reducing the cost and complexity of your database infrastructure and leveraging your existing PostgreSQL knowledge and applications. Supports structured or unstructured data and elastically scales.
Citus Data    #sponsored 
PostgreSQL Document API Part 4: Complex Queries
Continuing with his series on using Postgres as a document store, Rob Conery now looks at how to create complex queries on documents, far beyond basic string matching.
Rob Conery
Review of Operators in Postgres
JSONB and Array are two very awesome and powerful datatypes in Postgres, but querying in to them may not be the most natural thing. Here’s the overview of key operators for working with each, a great handy guide if you’re already or looking to use those datatypes.
Bernardo Chaves   #code 
Replication and Load Balancing with pgpool-ii
Postgres has come along way with its replication story in recent years, but load balancing still requires a bit extra in terms of tooling. pgpool is one option - take a look at how to set it up here.
Philip Hallstrom
pg-migrator: PostgreSQL Migration Tool
A complete and easy to use command-line migration tool for PostgreSQL.
Aphel Bilişim Hizmetleri   #code 
wal-e: Simple Continuous Archiving for Postgres
The most important task for your database is keeping your data safe, so continuous archiving is one of the tools every database should have. Wal-e is a simple tool for helping with that, and it powers continuous archiving for all of Heroku Postgres too.
GitHub   #code 
postgres-backup-s3: Docker Container for PostgreSQL to S3 Backups
Johannes Schickling   #tools 
OSCON EU 2015: Amsterdam, October 26-28
O'Reilly's OSCON open source conference is coming to Europe this October, featuring speakers like Douglas Crockford of PayPal and Leslie Hawthron of Elastic. There's a whole data track too.
oscon.​com
« Prev
Next »
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.