May 5, 2010 Managing big data sets with MySQL I'm currently working on a database which stores, literally, a million of new data registers every day. They come from several hundred weather stations spread along the world, and need… READ MORE
February 25, 2009 Creating Triggers in MySQL from PHP On my last project, I needed to create tables periodically on a database, to partition data in several identical tables, named according to the year quarter. Instead of using MySQL… READ MORE
February 9, 2009 Avoid deletions with triggers and MySQL Some times, we store valuable data that we would never want to lose. This is a particular fact when working with data for scientific, statistical purposes, like environmental analysis. In… READ MORE
May 24, 2007 PHP class dbhandler to deal with databases Notice: Article only available in Spanish! Hemos visto en publicaciones anteriores cómo conectar a una base de datos mysql desde php, y cómo usar la función mysql_query para consultar datos.… READ MORE
May 19, 2007 Reading data from a MySQL database with PHP Notice: article only available in Spanish! Ya he explicado en otro post cómo conectar a una base de datos mysql desde php. Ahora voy a explicar cómo trabajar con esta… READ MORE