Author image

Huy Nguyen

Helping companies have better access to data at Holistics.io

Splitting array/string into rows in Amazon Redshift or MySQL

We've worked with a lot of customers who writes SQL on a regular basis. And from time to time they come to us with SQL question - that we thought would be interesting to share with others! Today, one of our customers came to us with a question - They were having problems unnesting a string/array into rows in Amazon Redshift. Question - Splitting… Read More

Reusing Your SQLs with Query Templates

As engineers we refactor and abstract our code regularly, this is part of process to improve our code quality and scale up our codebase. In my previous job, we refactor our code religiously - "Leave the codebase a better place than you found it" so we said, that was the main reason to help us build big, complex system with just a handful of engineers!… Read More

How ShopBack Deliver Faster Better Data Reports with Holistics

ShopBack is a well-known online consumer cashbacks store in Singapore. In this case study, we explain what were the manual data extraction challenges they had, and how Holistics has helped them solved this problem and built a better data-informed culture. ShopBack, the online Cashback shopping website, is a treat for all shoppers in Southeast Asia. The 2 year-old Singapore startup strikes deals with over 1,… Read More

Why You Should Use Postgres Over MySQL For Analytics Purpose

Being an analytics/reporting product company, we’ve worked with a fair amount of customers who run Postgres/Redshift for their analytics, and the same fair amount who uses MySQL. And from our experience with both, I’d prefer our new customers to use Postgres all the time. For reporting/analytics/data-warehouse purpose, Postgres wins over MySQL hands-down. In this post I lay down a… Read More