Tag: PostgreSQL

Recent posts on the YTEC blog

Ytec, where I work since July 31 2015, is an IT company specializing in customer-specific custom software ("klantspecifieke maatwerk software"). Somewhere in late 2015, YTEC deployed a fancy new website based on React, which, to my surprise, is actually indexed somewhat decently by Google. Still, I want to be able to find my own posts on the YTEC blog when I filter by “site:blog.bigsmoke.us”, which is why I'm listing my posts there here: Read More »
By Rowan Rodrik, 3 years ago, on June 27, 2016, at 18:06 | 1 comment

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, 10 years ago, on April 15, 2009, at 22:04 | Comments closed

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, 1 decade 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, 1 decade ago, on July 16, 2007, at 14:07 | Comments closed

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, 1 decade ago, on February 02, 2007, at 23:02 | 2 comments