I thought that whitelisting Azure DevOps IP Addresses for the hosted agents to execute against my firewalled applications on AWS would be as simple as adding a range of permanent IP addresses and forget about it. Turns out that it’s much more complicated than that. …

Since you found this article, you should already know that these operations are not supported in MySQL. Stop short of migrating entirely over to another database, what can we do to achieve the same results we want? Here are some tricks. How to do Intersect in MySQL Say we wanted to do INTERSECT in MySQL for…

Recently at work, I have to implement a quick search that searches across multiple models and return a unified list of results. I thought I needed a third-party package to achieve that. Turns out that it’s really easy to do it ourselves using UNION. So here’s a simple guide on…

In an app that I’m currently working on, I need to copy some large files from local disk over to DigitalOcean Spaces everyday after processing. Because the files are quite large, I need to do it via streaming instead or I will exhaust my VPS’s memory. Following Laravel’s documentation, I…

I love how easy it is to plug in Laravel Scout and Meilisearch and instantly I get a search engine for my app. Searching by keywords is easy and well-documented. Assuming a Movie model, we could just do this and get a list of results. Movie::search('Star Wars')->get(); Amazing! But what…

If you have recently updated to Sublime Text 4, and that you are using SublimePHPCompanion, you may have already noticed how many features such as Find User, Expand Fully Qualified Class Name, Import Namespace etc stopped working. At first I thought maybe the package needed updating before it can support…

AlpineJS is great as a jQuery replacement when you need to perform some simple Javascript operation like opening and closing a dropdown menu. Dropdown menu is now increasingly popular as a UI choice and here we’ll learn how to create the menu easily with AlpineJS and TailwindCSS. Step 1. Include all necessary assets on our page We’ll need both…

I just spent the whole day trying to figure out why isn’t my Wireguard working. The client seems to be able to connect but it’s not sending or receiving any data. Doing a wg show doesn’t show that the client is connected. It’s weird! I was using this script from…

If you have created an Elixir Phoenix project without the --no-ecto flag, you will see a lot of warnings and errors regarding databases and ecto down the line. Here’s how you can disable it. Go to lib/myapp/application.ex, comment out the following lines: children = [ # Start the Ecto…