The other day a customer wanted to integrate binary data from MySQL to Snowflake and the pipeline was returning an error on our platform. I did some further digging and found out that Snowflake binary only supports the following binary format as per their documentation. 1. hex 2. base64 3. UTF-8 We can use MySQL's HEX() or TO_BASE64() ...

Yesterday I got an inquiry from a teammate asking if it's possible to automatically update a value of the column whenever it gets updated. Instantly thought of Postgres or MySQL capability to have this column that is updated automatically on a trigger (say when it gets updated) -- like an updated_at or some sort. As it turns out Redshi...

Have you ever sat down on your chair and debugged a really complex issue which took you hours and hours (even up to midnight) but you never really noticed the time? Well sure, technically not noticing the time is not realistic but let's just say time just flew. This is probably what they call as The Zone. For the past couple days I've ...

These past few weeks, I've been thinking of starting a personal dev blog using some headless CMS and deployed to Heroku, looks like I no longer have to due to this functionality! In a nutshell, Hey.com lets its users send an email to world@hey.com and it automatically serves it as a blog post on https://world.hey.com/makoto -- Pretty a...