![](https://igeek.info/wp-attach/2024/06/jitxebe_ps4-394x263.jpg)
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 …
![](https://igeek.info/wp-attach/2024/06/6641731-368x263.jpg)
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 …
![Re-arranging scrambled data](https://igeek.info/wp-attach/2022/04/bmybtsv7rfy-468x263.jpg)
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.