MySQL replication in PHP - on the same machine
Wednesday, September 14th, 2011I just realized I needed to replicate some data from one database to another, but only certain tables.... Read More
Posts Tagged ‘Database’
MySQL / InnoDB performance optimization
Wednesday, September 14th, 2011I’ve recently gotten some help and done some research into optimizing a MySQL database. The following applies if you have a powerful box at your disposal, I have 32GB RAM and 32 cores. If you are very limited hardware wise then not much of the following will apply.... Read More
CRUD with PHP Doctrine
Sunday, August 24th, 2008Table of Contents for Working with Doctrine
- PHP Doctrine introduction for dummies
- Smarty and Doctrine combination
- Extending PHP Doctrine Record - Check Box Groups
- CRUD with PHP Doctrine
- File Uploads with PHP Doctrine
- Pagination with PHP Doctrine
- DQL recipes
- PHP Doctrine - adding automatic, simple CRUD
- Smarty + Doctrine = Smoc
- Extending Smoc - Check Box Groups, Search and Pagination
- Cleaning up and wrapping up
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, 2008Table of Contents for Working with Doctrine
- PHP Doctrine introduction for dummies
- Smarty and Doctrine combination
- Extending PHP Doctrine Record - Check Box Groups
- CRUD with PHP Doctrine
- File Uploads with PHP Doctrine
- Pagination with PHP Doctrine
- DQL recipes
- PHP Doctrine - adding automatic, simple CRUD
- Smarty + Doctrine = Smoc
- Extending Smoc - Check Box Groups, Search and Pagination
- Cleaning up and wrapping up
It was long overdue but finally I’ve taken a look at Doctrine. And I’m blown away, bye bye Zend DB.... Read More