The Chartio Blog

Expert advice on business intelligence to help drive data at your company.
Sign up to get the latest data tips delivered to your inbox.

SQL

Eliminating Duplicate Queries using Distributed Locking

With our customers relying on over 100,000 dashboards and 2,000,000 charts in Chartio to run their business, query performance is something our engineering team is very serious about. Find out one of the ways we are reducing database load by eliminating duplicate queries.

Why I Wrote Yet Another SQL Tutorial

If you haven’t yet learned SQL, know someone who’s learning, or want to brush up in our practice areas, check out the new SQL Tutorial.

Pivoting a Table with Amazon Redshift or PostgreSQL

A pivot table reorganizes or summarizes data in a relational table. Learn how to pivot a table with Amazon Redshift or PostgreSQL.

How to Optimize Amazon Redshift Performance

This post will take you through the most common issues Amazon Redshift users come across, and will give you advice on how to address each of those issues in relation to performance.