Category: Database

How to Use RethinkDB with Node.js Applications

One of the most common task for a web application is to save data. Without the ability to store data, users would not be able to customize their preferences for an application, organize their data, or achieve similar tasks. For a long time, the web has relied on relational database to save information. For example, on ...

Watch: Fetch Remote Data Using Guzzle

Fetching data from a remote server has become a very common task these days. Unless you are very new to web programming, you must have, at some point, written code to fetch something from a remote server, be it JSON, XML, text or even an image. Most PHP developers are used to using cURL to perform such tasks. However, ...

Modeling an Aggregate with Eloquent

The Aggregate pattern is an important part of Domain Driven Design. It prevents inconsistencies and is responsible for enforcing business rules within a collection of objects. For these reasons alone, it is clear to see why it is a key component of a domain model. Architectural advice recommends that the layer containi...

Building Database-free Websites with Statamic CMS

A content management system (CMS) is a package of code around which you build a dynamic website—with components that change, adapt and update automatically, in contrast to a hard-coded, static site. In this article, Gareth Redfern presents a relatively new type of CMS that’s challenging the more established da...

Caching a MongoDB Database with Redis

Today, performance is one of the most important metrics you need to evaluate when developing a web service. Keeping customers engaged is critical to any company, especially startups, and for this reason it is extremely important to improve the performances and reduce page load times. When running a web server that inte...

SQL vs NoSQL: How to Choose

In the previous article we discussed the primary differences between SQL and NoSQL databases. In this follow-up, we’ll apply our knowledge to specific scenarios and determine the best option. To recap: SQL databases:store related data in tables require a schema which defines tables prior to use encourage normal...

First Look at Yahoo’s MySQL Performance Analyzer

When you deploy an app to production servers, you may experience some database problems as your data grows. Some tools can help you debug and solve your problems, like MysqlTuner, Percona, etc. In this article, we’re going to explore the Yahoo MySql performance analyzer and see what the main features are.Installati...

Re-introducing PDO – the Right Way to Access Databases in PHP

PDO is the acronym of PHP Data Objects. As the name implies, this extension gives you the ability to interact with your database through objects.Why not mysql and mysqli? The very valid question people ask when confronted by a new technology is simply, why should they upgrade? What does this new technology give them ...

Video: Database Access with PHP

In this screencast I explain how to connect and extract data from a database using PHP, touching on topics like, PHP Data Objects (PDO), preventing SQL injection, and finally extracting your data in variety of different formats (as arrays, classes, or objects).Loading the player…jwplayer("video-5667").setup...

Speeding up Existing Apps with a Redis Cache

We’ve gone through the basics of Redis in PHP before, but it’s time to cover a real life use case. In this tutorial, we’ll add it to an already deployed application to give the app the appearance of speed.You can easily follow along by cloning the 0.6 release of the app. The Problem Before applying a solution, ...