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.
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.
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
Expand Fully Qualified Class Name,
Import Namespace etc stopped working.
At first I thought maybe the package needed updating before it can support…
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.
lib/myapp/application.ex, comment out the following lines:
children = [
# Start the Ecto…
Screen is a very powerful tool to keep a process running in the background while retaining the ability to log out and log back in anytime to check on the output.
Annoyingly I keep forgetting the commands to use
screen effectively so here’s a quick reference guide of commands and…
Say you have a few thousand files that you need to upload to DigitalOcean Spaces totalling up to a few gigabytes from either another Space, your local, or your VPS. And you are wondering what’s the fastest and easiest way to do so.
Previously, I would mount DigitalOcean Spaces using…