Wern Ancheta, Apr 19
Database Versioning with DBV
Wern Ancheta explains what DBV is and how one can use it to version control a database
Taylor Ren, Apr 18
A Look at Valentina
Taylor Ren looks at a relatively new suite of DB tools - Valentina - and gives you his opinion on it.
Peter Nijssen, Apr 04
Optimizing MySQL Bottlenecks
Peter Nijssen covers using Percona to optimize MySQL bottlenecks
Peter Nijssen, Apr 03
Optimizing MySQL Configuration
Peter Nijssen covers using the Percona Toolkit to optimize your MySQL configuration
Peter Nijssen, Apr 02
Optimizing MySQL Indexes
Peter Nijssen covers optimizing MySQL indexes with Percona
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
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
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.
Taylor Ren, Feb 05
Cursors in MySQL Stored Procedures
Taylor Ren explains and demonstrates the use of Cursors in MySQL's Stored Procedures
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.
Taylor Ren, Jan 03
Stored Procedures in MySQL and PHP
Revisit the long forgotten topic of Stored Procedures in MySQL and PHP
Taylor Ren, Dec 30
Unique Index and its Rationale
Learn about unique index and the way they can increase performance when built correctly
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.
Khurram Aziz, Nov 25
MySQL Tweaks to Streamline Magento
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.
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!
Glenn Goodrich, Aug 19
A Look at OrientDB: The Graph-Document NoSQL
Craig Buckler, 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.
Richard Kotze, Apr 22
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.