I faced a small challenge this weekend in migrating a database from MySQL to SQLite. All instructions for exporting from MySQL and importing into SQLite seemed to fail. Of course, this begs the question, why migrate from MySQL to SQLite in the first place? Let me explain.
Category: note
bookmark_borderUsing ssh keys with Github and Bitbucket with multiple accounts
Both Github and Bitbucket recently changed the way developers must access their repositories when cloning, pushing or pulling. If you’ve got multiple accounts at either service, this solution should help.
bookmark_borderScheduling tasks in Laravel
On a recent client project I needed to schedule a task so that the site would sync its data with two APIs every day. In the past I would simply have created a CRON job to execute a shell script to execute the update. Laravel makes it so much easier!
bookmark_borderMarathon Laravel Update from 5.6 to 9.0
I recently bit the bullet and decided to update a Laravel app that has been running on Laravel 5.6 since early 2018. Laravel 9 was released a week ago, and I started to feel left behind.
bookmark_borderInstalling XDebug for XAMPP on Mac (Intel or M1) with a little help from Homebrew
How to install XDebug for XAMPP on a Mac (Intel or M1), without HomeBrew. While it’s not as easy as it is on WIndows (a simple download), it’s still pretty straightforward. Just follow these steps.
bookmark_borderSetting up XDebug 3 on a Docker Container with Visual Studio Code
Using and configuring XDebug since the release of version 3 has been a breeze. Similarly, getting XDebug to work when using a Docker Container as a dev environment is equally easy.
bookmark_borderUnexpected Type Issue in a PHP Model
While using Psalm, Vimeo’s static type analysis tool for PHP, I ran into an unexpected type issue on a couple of model files. What I had always assumed to be an integer (the return value from PDO::lastInsertId(), turned out, in fact, to be a string.
bookmark_borderInstalling MySQL client without server on Mac
How to install the MySQL monitor shell on a Mac, without installing the Community Server. It’s not available as a standalone download. But this works.
bookmark_borderSimple Docker LAMP stack
My lovely Vagrant setup on my Intel Mac Mini was broken last month when I upgraded to a Mac Mini with Apple Silicon. No more seamless switching workflows between my Mac and my Windows laptop! Luckily, Docker containers came to the rescue.