Quick Tip: How to Permanently Change SQL Mode in MySQL
PHP
By Bruno Skvorc,
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
database
Working with Databases in WordPress
WordPress
By Firdaus Zahari,
Firdaus Zahari walks us through the most important class when dealing with databases in WordPress - wpdb, using a series of examples with explanations.
Introduction to Craft CMS
Web
By Ryan Irelan,
Ryan Irelan introduces Craft, a flexible, database-driven, design-friendly CMS providing an elegant and simple authoring experience for clients.
How to Use RethinkDB with Node.js Applications
JavaScript
By Jay Raj,
Jay Ray shows how to use RethinkDB, an open source JSON database, with Node.js applications.
Shifting Your Development Environment from Ubuntu to OS X
Web
By Shaumik Daityari,
Shaumik Daityari looks at the subtle differences you might face when shifting your development environment from Ubuntu to OS X, and vice versa.
The Vital Guide to Interviewing Web Developers
Web
By Demir Selmanovic,
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.
Building Database-free Websites with Statamic CMS
Web
By Gareth Redfern,
Gareth Redfern introduces Statamic, a full-featured, flat-file CMS for creating sophisticated, fully version-controlled websites without a database.
Caching a MongoDB Database with Redis
JavaScript
By Iddo Gino,
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
SQL vs NoSQL: How to Choose
Web
By Craig Buckler,
In the continuing SQL vs NoSQL debate, Craig discusses example project scenarios to determine which type of database offers the most benefit.
SQL vs NoSQL: The Differences
Web
By Craig Buckler,
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.
Re-introducing PDO – the Right Way to Access Databases in PHP
PHP
By Parham Doustdar,
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!
Video: Database Access with PHP
PHP
By Lami Adabonyan,
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.
SQLite 3 Beyond the Basics
PHP
By Shivam Mamgain,
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.
Getting Started with SQLite3 – Basic Commands
PHP
By Shivam Mamgain,
Shivam Mamgain introduces the basic commands of SQLite3, explaining how to use it from the command line.
Getting Started with Medoo – Examples of Use
PHP
By Wern Ancheta,
Wern Ancheta introduces Medoo, a small database abstraction library that aims to make your database related codebase lighter.
Yii 2.0 ActiveRecord Explained
PHP
By Arno Slatius,
Arno Slatius explains Yii 2.0's ActiveRecord, listing the features, novelties, upgrades and usage examples.
Database Changes to Improve WordPress Performance
WordPress
By Shaumik Daityari,
There are many ways of scaling your website. In this article we focus on database tweaks and optimizations that can improve WordPress performance.
Essentials of LDAP with PHP
PHP
By Matthew Setter,
Matthew Setter explains the basics of LDAP and how you can use it with PHP to store structured contact data
5 of the Best Android ORMs
Mobile
By Aldo Ziflaj,
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.
PINQ – Querify Your Datasets – Faceted Search
PHP
By Taylor Ren,
Taylor Ren introduces PINQ - a PHP library based on LINQ for providing a unified API for querying arrays, iterators and external data sources
PINQ – querify your datasets – introduction
PHP
By Taylor Ren,
In this article, we briefly introduced the basic functionality of PINQ and how to use it in a web app.
The WordPress Database Demystified
WordPress
By Shaumik Daityari,
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.
Fractal: a Practical Walkthrough
PHP
By SitePoint Sponsors,
Alex explains what Fractal is and how you can use it to keep your JSON output consistent, even after database schema changes
Getting Started with FluentPDO
PHP
By Francesco Malatesta,
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: A First Look
PHP
By Bruno Skvorc,
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!
Enable PhpMyAdmin’s Extra Features
PHP
By Peter Nijssen,
Peter Nijssen activates and demonstrates PhpMyAdmin's additional features - from SQL bookmarking to visual relationships
Exposing Tables to Views in Drupal 7
PHP
By Daniel Sipos,
Danny Sipos explains how (and why) to expose your custom database tables to Views in Drupal 7 (applies also to Drupal 8)
MySQL Management with Packaged Apps
JavaScript
By Bruno Skvorc,
Learn about ChromeMyAdmin - a packaged app that lets you manage your MySQL/MariaDB database directly from any instance of your Google Chrome browser
Database Versioning with Ladder Migrations
PHP
By Lukas White,
Lukas White introduces you to Ladder - a database versioning tool which lets you version control your database changes through migration files
Understanding Drupal’s EntityFieldQuery
PHP
By Abbas Suterwala,
Abbas Suterwala explains and demonstrates the EntityFieldQuery class in Drupal, showing how to use it to fetch custom nodes and node content