CodeIgniter also offers a good pack of database utilities, ranging from ease of database configuration, to using configuration files, to Active Record features such as query structures and transactions.
It lacks some of the powerful Active Record utilities and table relationships that exist on other frameworks by default, but you can also have those with some coding. At first you may find it more difficult to use the Active Record functions than plain queries, but with the help of the profiler and some time, you can learn to write Active Record queries that are easy to read.
Note
Benefits are:
Wide range of possibilities and tools that make our coding experience more productive, when working with databases, with a gradual learning curve. Enhanced security when using Active Record, as data is escaped automatically. Some powerful tools such as query caching and transactions. Active Record, gives us the possibility to switch databases as and when needed, from MySQL to Postgres,...