Notes on computers, programming and all the stuff

Size of integer in PHP depends on machine , it has 32 bits on 32-bit architectures, and 64 on 64-bit architectures. On 32-bit machines PDO...

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...

PostgreSQL wiki has entry about sprintf - is is quite simple approach (and isn't marked as immutable ), the main drawback is iterating ...

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