Archive for August, 2009
Monday, August 31st, 2009 Posted in performance, pt_PT, sugarcrm | No Comments »
O SugarCRM dispõe de um gerador de dados para popular a DB com accounts, contacts, etc de exemplo. No entanto, pode ser utilizado para gerar DB's para testes, nomeadamente para ... Read more..
Saturday, August 29th, 2009 Posted in en_US, mysql, performance | No Comments »
I bumped over a client which was using a VARCHAR(200) as a MyISAM PRIMARY KEY key for detecting colisions which was externally (by the app) calculated and fed into MySQL. ... Read more..
Thursday, August 27th, 2009 Posted in en_US, mysql | No Comments »
Yesterday I tried massaging mysql-gui-tools a bit to see if I could make affected rows show up on modification DMLs, sucha as INSERT, DELETE and UPDATE. Here is a briefing ... Read more..
Thursday, August 27th, 2009 Posted in en_US, mysql | 1 Comment »
Me and a colleague were missing some features in mysql-query-browser and am trying to have a look at them, since no one at MySQL AB is very interested in supporting ... Read more..
Wednesday, August 26th, 2009 Posted in mysql, pt_PT | No Comments »
Lembrei-me de partilhar um teste que fiz há tempos. O que se pretendia era demonstrar que podemos percorrer uma tabela MyISAM (e só neste caso específico) de forma controlada (ie, ... Read more..
Saturday, August 22nd, 2009 Posted in en_US, mysql, performance | No Comments »
Although my previous conclusions about VARCHAR influence on index size could be quite storage engine specific, I'd like to see if we can extend them to InnoDB, so I took ... Read more..
Thursday, August 20th, 2009 Posted in en_US, mysql, performance | 4 Comments »
I was trying to determine if the storage size of a VARCHAR field in MySQL had any fixed influence in the key size. I've created a few tables, but an ... Read more..
Monday, August 10th, 2009 Posted in pt_PT, wikipedia | 3 Comments »
Tão cedo comecei a ganhar destreza na Wikipédia, não pude evitar lamentar-me com o desperdício, em termos de esforço, da criação de artigos em texto corrido a partir de dados ... Read more..
Friday, August 7th, 2009 Posted in programming, pt_PT, wikipedia | No Comments »
Traduzir artigos de outras Wikipédias para a Wikipédia da Língua Portuguesa é uma forma corrente de, pelo menos, dar um arranque aos artigos com conteúdo. Tomei agora conhecimento do Google ... Read more..