Perl, MySQL, Money and Food
Posted by robbiebow on 29 October, 2009 under geek | 
Be the First to Comment
The ReCAPTCHA project has a neat facility called Mailhide which will give you a chunk of HTML to add to your page. Users then get the familiar ReCAPTCHA challenge in a new window to complete in order to see your email address, thus limiting the ability of harvesters to get your address.
You can see this at work on my home page
Posted by robbiebow on 26 October, 2009 under geek, stuff | Be the First to Comment
After having my cheap Nokia phone stolen in Barcelona last weekend I went out and bought an even cheaper Sony Ericsson the day I arrived home. That turned out to be unsatisfying, so I opted to get an HTC Hero and join the smart-phone nation.
It’s a nice gadget. I love the ease with which I could integrate my Gmail contacts and link them with Facebook profiles. It’s taken a couple of hours, but this prompted me to tidy up my contacts. Now I have emails and phone numbers together. Changes I make in Gmail synchronize with the phone and vice versa. This is good. I haven’t found a music app that compares to iTunes ( not that I’ve looked properly yet ), so any tips on a suitable candidate most welcome.
Comparing the Hero with my iPod Touch, I find the iPod a more polished product. The Hero freezes occasionally for small amounts of time. It feels like – as other reviewers have said – the hardware is the weak spot. The UI is good; the potential for uses, great, but that freezing experience is a bit disappointing. Not to say I am disappointed: overall I am very pleased, but there is room for some improvement. Value for money, compared to the iPhone, the Hero wins.
If HTC heed the reviews, I hope to see a more robust box that gives the software the processing and memory it deserves in the not too distant future.
Posted by robbiebow on 13 October, 2009 under geek | Be the First to Comment
SQLite doesn’t support DROP COLUMN. This means you need to do something slightly more complex to drop a column:
BEGIN TRANSACTION; CREATE TABLE t1_new ( foo TEXT PRIMARY KEY, bar TEXT, baz INTEGER, ); INSERT INTO t1_new SELECT foo, bar, baz FROM t1; DROP TABLE t1; ALTER TABLE t1_new RENAME TO t1; COMMIT;
The quick way to get the SQL to create your new table would be to use the .schema command when connected to the database using the command line client.
