Despite all the implications of using LIKE in MySQL, sometimes it’s quite useful for a proof-of-concept to be able to use it.

Even though this is a rather trivial example, I hope it will be of help to whoever is wondering how to use a LIKE in a where using a Zend_Db_Select::where() or Zend_Db_Select::orWhere() and did not manage to find decent documentation about it.

(more…)

1

SELECT tasty FROM beers WHERE cold="very" AND price="free" GROUP BY nerds;

A few weeks ago I was talking to Mark Baker from MySQL AB about getting a MySQL meetup happening in Dublin. Meetups currently happen in London, San Fran, etc., and are an opportunity for local MySQL users to meet socially. Mark was very helpful, up to the point that he’s offered to fly himself and Ivan Zoratti for the inaugural meetup. They’ll give us a brief talk on MySQL 5.4, MySQL Cluster v7 and what the future holds for MySQL.

This event is a chance for you to engage in your community by meeting other Dublin web / MySQL developers, learn from shared experiences and to make some nerdy contacts.

The good people in the South William Bar have given us the use of their top floor for this informal event, which kicks off at 18:30 on Wednesday 24th June. Places are limited to 25 people. You can reserve your spot on eventbrite for free.

To help with the “community” part of it, we’re going to put some money behind the bar for some nice beers.

UPDATE (3rd June 2009) : This happy bunch of MySQL developers have registered to come along. We’ll be releasing a few more tickets a few days before the meetup.

Barry Alistair, Richard Bowden, Declan Boylan, Rory Browne, Paul Campbell, David Coallier, Ray Cregan, Barry Cronin, Darragh Curran, Stephen Curran, Laura Czajkowski, Bill de hÓra, Andrew Duffy, Ross Duggan, J.D. Fitz.Gerald, Eoghan Gaffney, David Gillen, Daniel Hunt, Piotr Jankowski, Eamon Leonard, Conor McDermottroe, John Moylan, Tomasz Muras, Shane O’Grady, Paul Phillips, Eduard Raos, Karen Thompson, Neil Turner

According to wikipedia, the Dragon’s Den is:

a venture-capitalist television programme that originated in Japan where the format is owned by Sony. The format, which now airs internationally, consists of entrepreneurs pitching their ideas in order to secure investment finance from business experts — the “Dragons”.

As some may already know, in 2009 the television show began in Ireland on RTÉ ONE. This post covers the technical considerations encountered when a web site / application appears on national television. (more…)