Working with Databases

Working with Databases Yii 2

Content of the «Working with Databases» section:

Database Access Objects: Connecting to a database, basic queries, transactions, and schema manipulation
Query Builder: Querying the database using a simple abstraction layer
Active Record: The Active Record ORM, retrieving and manipulating records, and defining relations
Migrations: Apply version control to your databases in a team development environment
Sphinx
Redis
MongoDB
ElasticSearch

Articles section «Working with Databases»:

Details: Parent Category: The Definitive Guide to Yii 2.0; Category: Working with Databases

Elasticsearch Extension provides the elasticsearch integration for the Yii2 framework. It includes basic querying/search support and also implements the ActiveRecord pattern that allows you to store active records in elasticsearch.

Table of contents Read more

Details: Parent Category: The Definitive Guide to Yii 2.0; Category: Working with Databases

MongoDB extension provides the MongoDB integration for the Yii2 framework. Usage MongoDB Extension for Yii 2.

Table of contents Read more

Details: Parent Category: The Definitive Guide to Yii 2.0; Category: Working with Databases

Redis Cache, Session and ActiveRecord for Yii 2

Redis extension Yii2 provides the redis key-value store support for the framework. Redis includes a Cache and Session storage handler and implements the ActiveRecord pattern that allows you to store active records in redis.

Table of contents Read more

Details: Parent Category: The Definitive Guide to Yii 2.0; Category: Working with Databases

Sphinx Extension for Yii 2 adds Sphinx full text search engine extension for the Yii 2 framework. It supports all Sphinx features including Real-time Indexes.

Table of contents Read more

Details: Parent Category: The Definitive Guide to Yii 2.0; Category: Working with Databases

During the course of developing and maintaining a database-driven Yii 2 application, the structure of the database being used evolves just like the source code does. Steps show how database migration can be used by a team during development Yii 2 application.

Table of contents Read more

Table of contents

Database Migration

During the course of developing and maintaining a database-driven application, the structure of the database being used evolves just like the source code does. For example, during the development of an application, a new table may be found necessary; after the application is deployed to production, it may be discovered that an index should be created to improve the query performance; and so on. Because a database structure change often requires some source code changes, Yii supports the so-called database migration feature that allows you to keep track of database changes in terms of database migrations which are version-controlled together with the source code.

Details: Parent Category: The Definitive Guide to Yii 2.0; Category: Working with Databases

Active Record provides in Yii 2 an object-oriented interface for accessing and manipulating data stored in databases. An Active Record class Yii is associated with a database table, an Active Record instance corresponds to a row of that table, and an attribute of an Active Record instance represents the value of a particular column in that row.

Table of contents Read more

Table of contents

Active Record

Active Record provides an object-oriented interface for accessing and manipulating data stored in databases. An Active Record class is associated with a database table, an Active Record instance corresponds to a row of that table, and an attribute of an Active Record instance represents the value of a particular column in that row. Instead of writing raw SQL statements, you would access Active Record attributes and call Active Record methods to access and manipulate the data stored in database tables.

Details: Parent Category: The Definitive Guide to Yii 2.0; Category: Working with Databases

Built on top of Database Access Objects, Yii 2 query builder allows you to construct a SQL query in a programmatic and DBMS-agnostic way. Compared to writing raw SQL statements, using Yii query builder will help you write more readable SQL-related code and generate more secure SQL statements.

Table of contents Read more

Details: Parent Category: The Definitive Guide to Yii 2.0; Category: Working with Databases

Built on top of PDO, Yii DAO (Database Access Objects) provides an object-oriented API for accessing relational databases. When using Yii DAO, you mainly need to deal with plain SQLs and PHP arrays.

Table of contents Read more

Table of contents

Database Access Objects

Built on top of PDO, Yii DAO (Database Access Objects) provides an object-oriented API for accessing relational databases. It is the foundation for other more advanced database access methods, including query builder and active record.

When using Yii DAO, you mainly need to deal with plain SQLs and PHP arrays. As a result, it is the most efficient way to access databases. However, because SQL syntax may vary for different databases, using Yii DAO also means you have to take extra effort to create a database-agnostic application.