Archive | Databases RSS feed for this section

Introdução ao PostgreSQL e HTML 5 (WTH!?)

1 Sep

MySQL is a SGBD very well know, and many people know how ‘use’ it. The PostgreSQL SGBD isn’t so well know as MySQL, and many people just heard about :). With this fact,  a little ago, I started to develop some introductory slides targeting people at Lightcomm, company where I live 8 hours/day. The slides is […]

Migrando bases de dados LATIN1 para UTF-8 com o PostgreSQL

6 Feb

Nowadays it is a standard that all web sites and servers run at least with UTF-8 encoding as default, however you can find cases where it is LATIN1 or even ASCII. The case we are dealing with today is a Debian server, version 5.0.3 (etch), which used encode LATIN1 as default encoding when installed and […]

Pensamento rápido – “ilike” SQL

4 Sep

Today I saw a post at one of the blogs I often watch, where a guy said he got 1000% of speed boost in a aplication by changing: uma aplicação trocando um: SELECT * FROM table WHERE fieldname ILIKE ‘abc%'; For SELECT * FROM table WHERE lower(fieldname) LIKE ‘abc%'; (changed ilike to lower … like) […]