---
title: "This Week's PostgreSQL News (#76)"
publication: "Postgres Weekly"
issue: 76
published_at: "2014-10-08"
canonical_url: "https://postgresweekly.com/issues/76"
---

Postgres Weekly Issue 76 - October 8, 2014

[Archives](http://postgresweekly.com/issues) [Read this issue on the Web](http://postgresweekly.com/issues/76)**Postgres Weekly****Issue 76**
October 8, 2014[Postgres 9.5 Feature Highlight: Row-Level Security and Policies](http://michael.otacoo.com/postgresql-2/postgres-9-5-feature-highlight-row-level-security/?utm_source=postgresweekly&utm_medium=email)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](http://www.openscg.com/2014/10/postgresql-dollar-quoting/?utm_source=postgresweekly&utm_medium=email)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](http://www.craigkerstiens.com/2013/08/02/use-dollar-quoting-anywhere/)._Jim Mlodgenski_[Vectorized Executor to Speed Up PostgreSQL](https://github.com/citusdata/postgres_vectorization_test?utm_source=postgresweekly&utm_medium=email)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](https://raygun.io/error-tracking-software?utm_source=email-october=newsletter=postgres-newsletter?utm_source=postgresweekly&utm_medium=email)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._RaygunSponsored_[![\](http://s3.amazonaws.com/nlga/uploads/item/image/28108/125.png)](https://raygun.io/error-tracking-software?utm_source=email-october=newsletter=postgres-newsletter?utm_source=postgresweekly&utm_medium=email)[Vitesse Data](http://vitessedata.com/?utm_source=postgresweekly&utm_medium=email)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](http://sequelizejs.com/?utm_source=postgresweekly&utm_medium=email)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](http://blog.arkency.com/2014/10/how-to-start-using-uuid-in-activerecord-with-postgresql/?utm_source=postgresweekly&utm_medium=email)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](https://github.com/brianc/node-pg-native?utm_source=postgresweekly&utm_medium=email)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](http://stonecolddev.in/posts/quick-and-dirty-how-to-trees-in-sql-postgres-rails-4?utm_source=postgresweekly&utm_medium=email)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_Curated by [Craig Kerstiens](http://craigkerstiens.com/) and published by [Cooper Press](https://cooperpress.com/).
Want to sponsor an issue? See our [media kit.](https://cooperpress.com/mediakit2014q2.pdf)

 © 2017 Cooper Press Ltd. [Email policy](https://cooperpress.com/spam.html) [Privacy policy](https://cooperpress.com/privacy.html)
Office 30, Fairfield Enterprise Centre, Louth, LN11 0LS, UK[Update your email address](*|UPDATE_PROFILE|*)
or [unsubscribe here](*|UNSUB|*)