Issues » 76

Archives   Read this issue on the Web
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
Curated by Craig Kerstiens and published by Cooper Press.
Want to sponsor an issue? See our media kit.

© 2014 Cooper Press Ltd. Email policy Privacy policy
Office 30, Fairfield Enterprise Centre, Louth, LN11 0LS, UK
Update your email address
or unsubscribe here

ONE e-mail each Wednesday. Easy to unsubscribe. No spam — your e-mail address is safe
Published by Cooper Press and curated by Craig Kerstiens