Archive for August, 2009

SugarCRM data generator

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

Multiple field index vs external primary key calculation

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

Update on mysql-query-browser “affected rows”

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

Compiling mysql-gui-tools

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

Percorrer uma tabela MyISAM de forma controlada

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

VARCHAR index size in InnoDB

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

The bigger smaller than the smaller one

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

A importância da Wikipédia enquanto fonte de dados e não [tanto] de informação

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

Google Translator Toolkit

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