Tag: PostgreSQL

Some new (upcoming) PostgreSQL features

These are some random new PostgreSQL features that I'm interested in: The EXECUTE USING feature in PostgreSQL 8.4 will allow the use of more secure dynamic SQL in PL/PgSQL. Read More »
By Rowan Rodrik, 3 years ago, on April 15, 2009, at 22:04 | No comments

PostgreSQL back-end for Ruby on Rails confusion

I just need to add a quick summary of what postgres back-end tool our Ruby on Rails application uses, and how we've configured it, because it's quite confusing... Read More »
By halfgaar, 3 years ago, on August 28, 2008, at 16:08 | 5 comments

Native PostgreSQL authentication in Rails with rails-psql-auth

A while ago, I wrote a PostgreSQL auth plugin for Rails. The plugin basically defers all authentication and authorization worries to the database layer where they are supposed to be taken care of anyway. Read More »
By Rowan Rodrik, 5 years ago, on July 16, 2007, at 14:07 | No comments

Unique constraints and indexes in PostgreSQL

This afternoon, I had to add a unique index for some table in the Sicirec PostgreSQL database. I had already assumed that I needed to use CREATE UNIQUE INDEX to create my new unique index until I noticed, thanks to pgAdmin's clear GUI, that some tables clearly had unique constraints and unique indexes while one table lacked a unique constraint and only had an unique index defined. Read More »
By Rowan Rodrik, 5 years ago, on February 02, 2007, at 23:02 | 2 comments