15 COMMENTs
PHP
Peter Nijssen, Apr 04

Optimizing MySQL Bottlenecks

Peter Nijssen covers using Percona to optimize MySQL bottlenecks
PHP
Peter Nijssen, Apr 03

Optimizing MySQL Configuration

Peter Nijssen covers using the Percona Toolkit to optimize your MySQL configuration
7 COMMENTs
PHP
Peter Nijssen, Apr 02

Optimizing MySQL Indexes

Peter Nijssen covers optimizing MySQL indexes with Percona
3 COMMENTs
PHP
Abbas Suterwala, Mar 12

Understanding Drupal's EntityFieldQuery

Abbas Suterwala explains and demonstrates the EntityFieldQuery class in Drupal, showing how to use it to fetch custom nodes and node content
10 COMMENTs
PHP
Taylor Ren, Feb 24

Data Fixtures in Symfony2

Learn how to use Doctrine's Data Fixtures in Symfony2 to provide your app with sample data
6 COMMENTs
Programming
Bruno Skvorc, Feb 20

A Client-Server Dart App From Scratch: Getting Started

An introduction to creating a client-server dart app: setting up the environment, making sure we have the latest SDK, and going over some Dart basics.
13 COMMENTs
PHP
Taylor Ren, Feb 05

Cursors in MySQL Stored Procedures

Taylor Ren explains and demonstrates the use of Cursors in MySQL's Stored Procedures
18 COMMENTs
PHP
Mehul Jain, Jan 10

PHP and Neo4j: Introduction to Graph Databases

Learn about Graph Databases like Neo4j and prepare for the continuation of this series - a real world example of PHP+Neo4j use.
30 COMMENTs
PHP
Taylor Ren, Jan 03

Stored Procedures in MySQL and PHP

Revisit the long forgotten topic of Stored Procedures in MySQL and PHP
3 COMMENTs
PHP
Taylor Ren, Dec 30

Unique Index and its Rationale

Learn about unique index and the way they can increase performance when built correctly
11 COMMENTs
Programming
Craig Buckler, Dec 09

How to Use Unique Indexes in MySQL and Other Databases

Craig describes what unique indexes are, when you should use them, and a little-known issue with a certain popular database system.
Programming
Khurram Aziz, Nov 25

MySQL Tweaks to Streamline Magento

JavaScript
Shameer C, Oct 30

Working with jQuery DataTables

In this article we’ll go through the basics of the jQuery DataTable and how to use some of the advanced features.
HTML & CSS
David Rousset, Oct 09

Using IndexedDB to Manage 3D WebGL Assets

David Rousset shares some tips and tricks for using IndexedDB, gleaned while working on a 3D WebGL Babylon.JS game engine.
HTML & CSS
Craig Buckler, Oct 09

HTML5 Browser Storage: the Past, Present and Future

A round up of all browser storage options available to client-side HTML5 developers.
Programming
Craig Buckler, Sep 25

How to Explain Your SQL EXPLAIN Queries

Could you explain the output of a MySQL or MariaDB EXPLAIN statement? Craig describes how to use the Explain Analyzer and become a SQL god!
Ruby
Glenn Goodrich, Aug 19

A Look at OrientDB: The Graph-Document NoSQL

8 COMMENTs
Programming
Lukas White, Apr 29

We're Putting the (MySQL) Band Back Together

The original MySQL developers are back together to work on a rival to Oracle's open source database.
4 COMMENTs
Programming
Lukas White, Apr 22

MySQL Views

MySQL Views
36 COMMENTs
Programming
Craig Buckler, May 19

Understanding JOINs in MySQL and Other Relational Databases

SQL JOINs are often misunderstood and one of the biggest causes of database optimization problems. This brief tutorial explains JOINs and their use in MySQL and other relational databases.