Summary
Throughout this chapter, we touched upon the basics of querying three very different database systems.
The MySQL database has been around for a very long time, and is likely the number one database for most PHP applications. Its ACID compliance makes it irreplaceable for applications dealing with financial or other sensitive data where atomicity, consistency, isolation, and durability are key factors.
Mongo, on the other hand, tackles data storage through a schema-less approach. This makes it much easier for developers to pace up application development, although the lack of ACID compliance across documents limits its use in certain types of applications.
Finally, the Redis data store serves as a great caching, or even a session-storing ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access