Notes on computers, programming and all the stuff

Here is a simple PostgreSQL type: CREATE TYPE foo_t AS ( id integer, total bigint );   and a simple query wrapped in stored procedu...

Secret Hackers Rule #11: Hackers read manuals. Recently I've discovered that PostgreSQL supports setting NULL on column referenced to...

Recently I did some experminets with n-grams indexes used to speed-up full text search in a plain SQL database. The results are really promi...

Suppose that database stores some kind of dictionary and user picks some items, but wants to keep order. For example dictionary has entries ...