Oh man, I accidently deleted production data from the database

The probable outcome of a software engineer or database administrator deleting data he didn’t mean to from production database, is immediate heart attack. Hospitals are full of programmers leaving out the ‘where’ clause by mistake. If you’re reading this post, I assume you would like to know one of two things: How to restore data… Continue reading Oh man, I accidently deleted production data from the database

Facebook releases a new OnlineSchemaChange tool written in Python

This post's contentIt’s a tool, not an engineCan be integrated with the user’s Python appTestableReliableUsage Example Facebook’s online schema change tool’s goal is to alters a table's structure without blocking reads or writes to the database during execution. The first version of Facebook OSC (OnlineSchemaChange) was released back at 2010 and was written in PHP.… Continue reading Facebook releases a new OnlineSchemaChange tool written in Python

Mysqli vs Mysql vs PDO Performance Benchmark Results – PHP & MySQL

1 Comment

This post's contentExperiment Setup & ProcessResults with PHP 5.2Results with PHP 7.1.3SummaryCode Reference The technology world is all about options, so when looking into the different ways you have to connect to a MySQL database when working with PHP, it’s no different. There are three major ways to connect to MySQL databases with PHP -… Continue reading Mysqli vs Mysql vs PDO Performance Benchmark Results – PHP & MySQL

MySQL Datetime vs Timestamp column types – which one I should use?

This post's contentDATETIME and TIMESTAMPHow are they different?Practical uses DATETIME and TIMESTAMP Some MySQL data types are a bit confusing at first sight. Without reading through the documentation (and sometimes even after reading it), it’s hard to figure out which data type is the right one for your current needs. That’s why we’re here. So… Continue reading MySQL Datetime vs Timestamp column types – which one I should use?