Tag: database

Jay Ray shows how to use RethinkDB, an open source JSON database, with Node.js applications.

Shaumik Daityari looks at the subtle differences you might face when shifting your development environment from Ubuntu to OS X, and vice versa.

Gareth Redfern introduces Statamic, a full-featured, flat-file CMS for creating sophisticated, fully version-controlled websites without a database.

Iddo Gino teaches you how to improve the performance of your Node.js web service with Redis to store the results of the query executed on a MongoDB database

In the continuing SQL vs NoSQL debate, Craig discusses example project scenarios to determine which type of database offers the most benefit.

Are you puzzled by SQL and NoSQL? Are you unsure what to use in your next project? Craig discusses the primary differences in on handy summary.

Parham re-introduces PDO ahead of the PHP 7 launch, preparing you for a transition from the soon-to-be removed insecure and deprecated mysql extension!

Shivam dives deeper into SQLite after introducing you to the basics the last time around. This time, we look at transactions, queries, aliases and more.

Shivam Mamgain introduces the basic commands of SQLite3, explaining how to use it from the command line.

Wern Ancheta introduces Medoo, a small database abstraction library that aims to make your database related codebase lighter.

Arno Slatius explains Yii 2.0's ActiveRecord, listing the features, novelties, upgrades and usage examples.

Matthew Setter explains the basics of LDAP and how you can use it with PHP to store structured contact data

If you are developing an Android application, you will likely need to store data somewhere and ORMs, Aldo Ziflaj looks at five of the best to consider.

Taylor Ren introduces PINQ - a PHP library based on LINQ for providing a unified API for querying arrays, iterators and external data sources

This article explores the WordPress database and how things work in the background. It will also help you gain an understanding of the database structure.

Alex explains what Fractal is and how you can use it to keep your JSON output consistent, even after database schema changes

Francesco Malatesta introduces you to FluentPDO - a small and simple PDO library built to solve your data manipulation needs. See what it can do.

Peter Nijssen activates and demonstrates PhpMyAdmin's additional features - from SQL bookmarking to visual relationships

Danny Sipos explains how (and why) to expose your custom database tables to Views in Drupal 7 (applies also to Drupal 8)

Lukas White introduces you to Ladder - a database versioning tool which lets you version control your database changes through migration files

Abbas Suterwala explains and demonstrates the EntityFieldQuery class in Drupal, showing how to use it to fetch custom nodes and node content

Learn to deploy your first Laravel application on Nitrous.io - the cloud development environment

Horizontal scaling of databases in PHP applications - the how and why of master-slave replication

Learn about Graph Databases like Neo4j and prepare for the continuation of this series - a real world example of PHP+Neo4j use.

Revisit the long forgotten topic of Stored Procedures in MySQL and PHP

Read How to Use Unique Indexes in MySQL and Other Databases and learn with SitePoint. Our web development and design tutorials, courses, and books will teach you HTML, CSS, JavaScript, PHP, Python, and more.

Oracle Cloud is a late entrant in Cloud Market but it enters with a end to end offerings.

In the last of a three-part database series, this tutorial explains how to create scheduled events in MySQL which run automatically at during pre-defined intervals.

In the second of a three-part database series, this tutorial explains how to create triggers in MySQL which run automatically when records are added, changed or deleted.

A short tutorial of two powerful database features: triggers and events. When should and shouldn't they be used?