-
Categories
-
Tags/Keywords
VIM MediaWiki T61 Linux zimbra blog.bigsmoke.us RuG CSS postfix Subversion Windows Firefox Screen WLB07051 plugin WordPress xen shell bash X WWW samba DNS van der Molen PHP smb RAID CLI HTTP Javascript Family HTML nutrition SSH Ruby svn metabolism Gentoo ssl Debian MySQL Ubuntu Apache mod_rewrite XTerm -
Recent Posts
-
Recent Comments
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 »
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 »
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 »
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 »
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 »