migrations – Page 22 – Türker Yıldırım

A TIMESTAMP column has a default you did not ask for

NoteFebruary 27, 20142 min read

shipped_at TIMESTAMP in a migration and the column that ends up in the database are not the same column. MySQL applies two implicit rules to the first TIMESTAMP…

The 5.6 ALTERs that still copy the whole table

NoteJanuary 29, 20142 min read

5.6’s online DDL gets summarised as “ALTER TABLE no longer locks”, and adding an index really is online now. Several other alterations are not, they are the ones…

Artisan migrate:rollback only undoes the last batch

NoteNovember 28, 20132 min read

The migrations table records a batch number rather than a position, and migrate:rollback unwinds the highest batch — which is every migration that ran in the last migrate…

Rebuilding an internal admin panel on Laravel 4

Deep diveSeptember 29, 20139 min read

A framework four months old, an admin panel five years old, and one small section of it rebuilt to find out what Laravel 4 is like to live…

Add an index to a large MySQL table

SnippetJune 12, 20131 min read

MySQL 5.6 adds an index without copying the table

NoteMay 8, 20132 min read

Adding an index to a large InnoDB table on 5.5 rebuilds it into a copy and blocks writes for the whole operation, which is why the index that…

WooCommerce 2.0 renamed the order meta you were reading

NoteApril 25, 20132 min read

WooCommerce 2.0 moved order line items out of a serialised _order_items post meta value and into two dedicated tables. Anything that read that key directly — a sales…

Read a CSV file into an array in PHP

SnippetApril 3, 20131 min read

Indexing a report query that reads the whole orders table

Deep diveMarch 7, 20139 min read

A daily report scanning 1.2 million rows to return two hundred. Why neither obvious index helped, what the composite one costs, and the two answers I turned down.

Import a JSON file into MongoDB

SnippetFebruary 19, 20131 min read