Archive for the ‘mysql’ Category

How to Search on Securely Encrypted Database Fields

Posted on: No Comments
We [ParagonIE] get asked the same question a lot (or some remix of it). This question shows up from time to time in open source encryption libraries' bug trackers. This was one of the "weird problems" covered in my talk at B-Sides Orlando (titled Build...

How to Synchronize WordPress Live and Development Databases

Posted on: No Comments
Developing WordPress themes is considerably easier with real content. Unexpected situations begin to arise when people add pages, posts, media and comments. Your beautiful template can break when: editors use assets which are too big or small for your...

Beaver in Action: Practical MySQL Optimization

Posted on: No Comments
Clients with an existing application sometimes ask me to fix bugs, improve efficiency by speeding up the application, or add a new feature to some existing software. The first stage of this is researching the original code – so-called reverse enginee...

Phinx – the Migration Library You Never Knew You Needed

You're building an application, and you need to share the database's structure with your team. After all, you want everyone to be up and running as soon as possible. What do you do? SQL dumps of table structures? You could... but that's so very primiti...

3 More Joins You Should Be Familiar With

Posted on: No Comments
There are many ways to JOIN data from two database tables and filter the information you require. Craig Buckler wrote a popular piece on understanding JOINs; namely INNER, LEFT, RIGHT, and FULL OUTER. This article is an extension of that one. Let’s r...

Quick Tip: How to Permanently Change SQL Mode in MySQL

Posted on: No Comments
I was working on a legacy project recently and needed to import some data from MySQL 5.5. All the queries in the code worked perfectly in MySQL 5.5, so I assumed an upgrade to 5.7 would be seamless. Not so. First I got errors due to DateTime columns b...

Learn SQL In 20 Minutes

Posted on: No Comments
Every web developer should know SQL. Although it has been around since the 70s, it is still widely used, and you can’t build a serious application without it. Most full-stack frameworks have libraries for dealing with the SQL complexity –...

First Look at Yahoo’s MySQL Performance Analyzer

Posted on: No Comments
When you deploy an app to production servers, you may experience some database problems as your data grows. Some tools can help you debug and solve your problems, like MysqlTuner, Percona, etc. In this article, we’re going to explore the Yahoo MySql ...

Re-introducing PDO – the Right Way to Access Databases in PHP

Posted on: No Comments
PDO is the acronym of PHP Data Objects. As the name implies, this extension gives you the ability to interact with your database through objects. Why not mysql and mysqli? The very valid question people ask when confronted by a new technology is simpl...

Caching Hat-trick: Zend Opcache, Etags and Query Caching

Posted on: No Comments
In this article, we will be looking at some of the common caching techniques in PHP: Opcache, Expires Headers and Query Caching in MySQL. We’ll look at additional approaches in part 2. PHP’s Request Lifecycle Before we move on, it’s important to...