Tag: database

MySQL 5.7 introduced some awkward changes for older codebases and tends to break apps. Here's how to temporarily (or permanently) lower the strictness level

Firdaus Zahari walks us through the most important class when dealing with databases in WordPress - wpdb, using a series of examples with explanations.

Ryan Irelan introduces Craft, a flexible, database-driven, design-friendly CMS providing an elegant and simple authoring experience for clients.

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.

Here's the vital guide to working out a developer's knowledge of web development, including client-side, server-side, transport, and database related topics.

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!

I explain how to connect and extract data from a database using PHP, PHP Data Objects (PDO), preventing SQL injection, and finally extracting your data.

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.

There are many ways of scaling your website. In this article we focus on database tweaks and optimizations that can improve WordPress performance.

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

In this article, we briefly introduced the basic functionality of PINQ and how to use it in a web app.

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.

0xDBE is a new tool by JetBrains made to solve all our database management problems. Soon, we'll be able to leave Workbench behind and work without crashes!

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)

Learn about ChromeMyAdmin - a packaged app that lets you manage your MySQL/MariaDB database directly from any instance of your Google Chrome browser

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