Laravel: Specified key was too long error on migration
When you install a new Laravel project with 'laravel new' and run the migration that comes with it you might get the following error: #php artisan migrate Migration table created successfully. SQLSTATE: Syntax error or access violation: 1071 Spe ...
Setup Laravel with Docker containers
Docker Docker has captured my attention lately and has been growing exponentially for last few years. Docker has revolutionized the virtualization space and has given DevOps engineers and developers a new set of tools that can ease their development ...
INSERT new rows from a result of SELECT query
There were numerous times when I needed to insert records in the table from a result of another SELECT query, or copy data from one table to another. And every time I forgot the syntax of insert...select query. So I thought I should write it somewher ...
MySQL Installation and Configuration
A step by step guide on how to install and configure MySQL on the Windows Operating System.
MySQL Query Cache
MySQL query cache is good to cache select queries and their results and improve some performance of your database applications. So, enable query cache in just one step.
Multiple MySQL on single host
Sometimes we need to run multiple MySQL servers on single machine. That is mostly required in testing environments to test different aspects with different configurations. In this way one can test server without affecting others. So, if you want to r ...
Database indexes and locks
It is important to create good indexes so that your queries do not unnecessarily need to scan many rows, that can result in lock on those rows and due to which deadlocks can occur, performance can be degraded, or anything bad can happen.