Tag: mariaDB

By Bruno Skvorc, May 28, 2014

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

Cursors in MySQL Stored Procedures

PHP

By Taylor Ren, February 05, 2014

Taylor Ren explains and demonstrates the use of Cursors in MySQL's Stored Procedures

Horizontal Scaling of PHP Apps, Part 2

PHP

By Bruno Skvorc, January 25, 2014

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

Stored Procedures in MySQL and PHP

PHP

By Taylor Ren, January 03, 2014

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

Unique Index and its Rationale

PHP

By Taylor Ren, December 30, 2013

Learn about unique index and the way they can increase performance when built correctly

How to Explain Your SQL EXPLAIN Queries

Blogs

By Craig Buckler, September 25, 2013

Read How to Explain Your SQL EXPLAIN Queries and learn with SitePoint. Our web development and design tutorials, courses, and books will teach you HTML, CSS, JavaScript, PHP, Python, and more.

We’re Putting the (MySQL) Band Back Together

Programming

By Craig Buckler, April 29, 2013

Read We're Putting the (MySQL) Band Back Together and learn with SitePoint. Our web development and design tutorials, courses, and books will teach you HTML, CSS, JavaScript, PHP, Python, and more.