Indexing is a must-have part of performance optimization from the database side. However, sometimes, many of us create indexes that might not be best and could have other side effects instead. From the last few days of my work, I did get a chance to dig a little deeper into this area and found that there are some common techniques which we should all remember while … [Read more...] about 9 Useful Mysql Indexing Tips You Should Know About
As we are using Doctrine ORM to ease our database layer programming, it's very important to understand how to establish the doctrine relationship between entities and do it in the proper way to build a robust relational database design. Here, by the term 'relationship,' I meant the x-to-x relations, which can take the form of one-to-one, one-to-many (many-to-one) or … [Read more...] about Doctrine Relationship Management Between Entities
If you have started using doctrine ORM, you should know how tightly the database and doctrine entity are bonded together. Any change must be reflected in the doctrine entity and database itself. That can become a tedious task if you start doing the changes on both sides manually. So, it's worth to figure out a way to migrate from one to another.Entity To DB Or DB To … [Read more...] about Transformation Between Doctrine Entity And MySQL Database
So, it seems like you are in big trouble. Otherwise, why would you want to execute a doctrine native SQL query? In this tutorial, I will describe and show how you can perform such operations. But that doesn't necessarily mean I am encouraging you to use it all the time. I still strongly recommend finding your way within the doctrine's ORM, DBAL, and DQL implementation as much … [Read more...] about How To Execute Native SQL Query With Doctrine
In an earlier tutorial, I showed how we could easily perform the CRUD operations using Doctrine ORM. However, as a lot of developers use doctrine ORM as part of their favourite Codeigniter framework, I came to feel that it will be very useful if we can use some wrapper model for these base CRUD operations in Codeigniter that will use doctrine implementation. This should … [Read more...] about Doctrine Model Plugin For Codeigniter
