Posts on Data and Open Source https://siftrss.com/f/JzZZ3q9xxnM Recent content in Posts on Data and Open Source Hugo en-us Mon, 12 Aug 2024 09:41:51 +0200 How to CONCAT in MySQL https://ftisiot.net/posts/mysql-concat/ Mon, 12 Feb 2024 14:43:29 +0100 https://ftisiot.net/posts/mysql-concat/ <p>One of the most common tasks with strings is concatenation! This blog post showcases several techniques to perform it with MySQL.</p> 1 billion rows challenge in MySQL https://ftisiot.net/posts/1browsmysql/ Fri, 26 Jan 2024 14:43:29 +0100 https://ftisiot.net/posts/1browsmysql/ <p>Earlier this month I wrote a piece on solving <a href="https://www.linkedin.com/in/gunnar-morling-2b44b7229/">Gunnar Morling</a> interesting <a href="https://www.morling.dev/blog/one-billion-row-challenge/">1 billion rows challenge</a> in <a href="https://ftisiot.net/posts/1brows">PostgreSQL and ClickHouse</a>. Since <a href="http://aiven.io">Aiven</a> provides also MySQL, I wanted to give it a try. TLDR; The results are much slower than PG and ClickHouse, do you have any suggestion on how to improve?</p>