Archive for the ‘Database’ Category

MySQL tips and tricks

Tuesday, May 26th, 2009

Update: This stuff has its own MySQL page now where we continue :)... Read More

CRUD with PHP Doctrine

Sunday, August 24th, 2008

This piece is building on the prior tutorial, we now have Retrieve, Update and Delete in addition to the Create stuff. The prior tutorial has also been updated since the fromArrayExt method needed some adjustments to manage updating.... Read More

PHP Doctrine introduction for dummies

Tuesday, August 5th, 2008

It was long overdue but finally I’ve taken a look at Doctrine. And I’m blown away, bye bye Zend DB.... Read More

PHP import and export

Wednesday, May 21st, 2008

God how I hate Webmin. No wonder everyone is using phpMyAdmin, everyone except my admin of course.... Read More

Making BigDump like mysqldump

Friday, February 22nd, 2008

Update: See Alexey’s comment at the bottom, it seems like I missed reading some important info at the top of the bigdump file.... Read More

Registration form with Merb and Datamapper

Tuesday, February 19th, 2008

This tutorial is an example of a typical registration form with Datamapper and Merb, we have:
– Unique username and email.
– Password confirm check.
– Terms and conditions agreement.
– And some more custom stuff implemented such as birthdate from year, month and day dropdowns.... Read More

PostgreSQL on Ubuntu with phpPgAdmin

Thursday, January 24th, 2008

Setting up default installations of Apache, PHP and PostgreSQL is really easy, I’m using a Gutsy setup and writing this in a terminal:... Read More

MySQL user setup in Webmin

Tuesday, December 18th, 2007

I recently had to setup a new database user in Webmin for a project using Joomla 1.0.13. ... Read More