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.
By Rowan Rodrik, 6 years ago, on April 15, 2009, at 22:04 |
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...
By halfgaar, 6 years ago, on August 28, 2008, at 16:08 |
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.
By Rowan Rodrik, 7 years ago, on July 16, 2007, at 14:07 |
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.
By Rowan Rodrik, 8 years ago, on February 02, 2007, at 23:02 |