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 210 — June 7, 2017
Scaling Out Complex SQL Transactions in Multi-Tenant Apps
Citus is an open source database built on top of Postgres–helping scale out your data. Here they walk through how you can have complex SQL transactions in Citus distributed setup.
citusdata
The Postgres Vacuum
Malis continues his series on all things Postgres. First with this post on 'vacuum' and following it up with some details about transaction wraparound.
Michael Malis
check_pgactivity 2.2: A Postgres Plugin for Nagios
A Nagios-compatible checker to monitor key features of a Postgres cluster such as database size, slow queries, dumps, bloated indexes, and more.
PostgreSQL   #tools 
Why waste time managing your own developer services
Especially when you have many services on different platforms. Manifold helps you manage all your services with a single account. We have awesome partners like JawsDB, LogDNA and Mailgun. Start building your stack today.
Manifold    #sponsored 
Another Way to Optimize PostgreSQL
How to deal with data entry, slow selection, and possible collisions.
JetRuby
Postgres Operations That You Can't 'Explain'
Felix Geisendörfer
Using Sequelize ORM to Manage Relationships in A Postgres
Sequelize is one of many options in Node for working with Postgres. Here's a primer of what it is and how you can use it for your next Node app.
Zachary Bergmann
Joining Two Tables by a Foreign Key Relationship
Need to join two tables that aren’t explicitly related by some key? This post walks through the use case and how you can accomplish it.
Olga Berezovsky
Writing a Firebase Clone with Postgres and Node.js (Part 1)
Patrick Ackerman
PGObserver: A Postgres Monitoring Tool
An open source tool to help you monitor a Postgres database and get insights on stored procedures, IO stats, index usage, and more.
Zalando   #tools 
Linux cloud hosting starting at 1GB of RAM for $5/mo.
Get a Linode server up and running in seconds. Use promo code POSTGRES20 for a $20 credit on a new account.
linode    #sponsored 
ora2pg: Migrate an Oracle Database to a Postgres Schema
Darold   #code 
« Prev
Next »
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.