Insights, tutorials, and updates from the QCK team about URL shortening, analytics, and digital marketing.
170 million rows. 2.71 GiB on disk. We dropped one column and changed some types. Same data, same queries — 166 MiB. Here's what we learned about ClickHouse compression the hard way.
Beyond simple link shortening—how to use custom aliases, UTM tracking, and link organization to build a professional URL strategy.
PostgreSQL is great until you need to count a billion clicks. Here's why we added ClickHouse to our stack and what we learned about OLAP databases.
Discover the power of QCK - the fastest URL shortener with advanced analytics and team collaboration.