Postgres Weekly Issue 76
October 8, 2014
Postgres 9.5 Feature Highlight: Row-Level Security and Policies
Want even finer access control on your data such as hiding specific rows in certain tables from people? Well you have it available with row level security in about a year as it’s now been committed to Postgres 9.5.
Michael Paquier
PostgreSQL Dollar Quoting
Dollar quoting provides a cleaner way of escaping every single quoted item in Postgres if you’ve got a long string that needs escaping, but it can also provide much more.
Jim Mlodgenski
Vectorized Executor to Speed Up PostgreSQL
While definitely in a proof of concept stage, this vectorized executor from Citus data shows a 3-4x speed up on basic selects, and is open source for all to check out.
Citus Data
Find software errors before your users do
Raygun gives you a complete overview of software bugs and crashes that are happening in your applications. Just add a few lines of code to your application and start fixing bugs before your users are affected.
Raygun  Sponsored
Vitesse Data
I was lucky enough to meet with Vitesse Data a few months ago, who have done some interesting work to make Postgres perform much faster on certain OLAP query workloads. While still in early beta, you can sign up to get a preview and follow along.
Sequelize - Node.js ORM for Postgres, MySQL, SQLite
Here’s yet another ORM for relational databases and Node, give this one a try and blog about your experience with it.
Sascha Depold
How to Start using UUID in ActiveRecord with PostgreSQL
UUIDs are just simply a better primary key than integers, there’s not much debate about that, yet most frameworks don’t use them out of the box. Here’s a great walkthrough getting them setup with Rails.
Kamil Lelonek
Node js PostgreSQL Sync library
Just in case you wanted something different from the other Node ORM this week, here’s a library that makes it easier to write synchronous raw SQL easily with Node.
Brian C
Quick and Dirty How To - Trees in SQL + Postgres + Rails 4
Threading whether for email or comments or anything else isn’t the easiest thing to build into your relational database, but it also isn’t the hardest. Here’s a great walkthrough of doing it with Rails.
Devin Austin