I’ve been tinkering around with PostgreSQL off-late while working on a project, using Laravel as my framework of choice. Its been many years since I looked into PostgreSQL, enough to say that I might as well be starting fresh. The …
Laravel is great at good many things and its inbuilt ORM & query builder makes working with multiple databases a breeze. But while working yesterday, I came across a curious issue – running artisan migrate:fresh command breaks if your tables …
Fixing messed up data encoding and charset in a database can be a challenge. Here's how I fixed it on 100+ tables in a few minutes using a quick PHP script that I wrote.