Case Insensitive Columns Postgres

Unsuccessful with the making columns case-insensitive framework level, I had to go deeper. Here’s how I changed my Postgres columns to be case-insensitive, and ultimately solve my model relationship problems. CITEXT Extension for Postgres You needs to provision the extension to the database. If you use Heroku (like me here’s a simple step). The citext module provides … Read more

Suspend Terminal Process

I was running a lengthy terminal process when my laptop was about to die. And what do you know? You can suspend terminal processes and resume them later. Suspend There are many ways to go about it. The simplest way is to press ctrl + z in the terminal that’s running the process. Shortcut “ctrl” … Read more

Laravel Chunk vs. Cursor

I’ve been fighting memory limits more often than I thought I would have to. Giving me the thought that perhaps I’m building my query wrong. But there are a few helpful helpers that can keep the memory low. Two of them being chunk() and cursor(). This speed test is brought to you by @ryo511. His … Read more

Redis Cheatsheet for Mac

Credit goes to @tommysmile. type below: To have launchd start redis now and restart at login: Or, if you don’t want/need a background service you can just run: Test if Redis server is running. If it replies “PONG”, then it’s good to go! Location of Redis configuration file. Uninstall Redis and its files.

Git : How to remove a big file wrongly committed

This article saved my ass. How to remove a big file wrongly committed. TL;DR If you get this remote: error: GH001: Large files detected. You may want to try Git Large File Storage – remote: error: Trace: 7d51855d4f834a90c5a5a526e93d2668 remote: error: See for more information. remote: error: File coverage/sensitivity/simulated.bed is 102.00 MB; this exceeds … Read more