Archiwizowane January, 2008

z dosyć losowego powodu wszedłem dziś na google trends i coś sprawdziłem (trzeba kliknąć dalej, nie chciałem dawać wulgaryzmów na pierwszej stronie)...

January 21st, 2008 by depesz | Tags: | 7 comments »

some time ago i wrote about potential (or not potential, depending on your situation) problem with updates which do not update anything. now, andrew dunstan wrote c version of trigger which skips such updates. so, let's test how well it works.

we use orm yes, and? and we have a problem with it... you already said that now, imagine a simple scenario: objects table (let's name it "topics"), which contains column: posts_count sub-objects table (posts), with foreign key to topics triggers which update posts_count on insert/update/delete on posts simple? ...

January 16th, 2008 by depesz | Tags: | No comments »

Changes: represent percentage as 99.99, and not 0.99 (better precision, easier to read) treat queries: "select a,b from c" and "select b,a from c" as the same type. SVN repo at: http://svn.depesz.com/svn/pgsql-tools/trunk

January 13th, 2008 by depesz | Tags: | 7 comments »

i needed a way to generate ed2k urls based on existing files on my harddrive. ed2k link looks like this: ed2k://|file|FILENAME|FILESIZE|CHECKSUM|/ filename and filesize are of course known, but what about checksum? i tried to find some ready program to calculate them, but ...