Ever heard of OLAP? If you want to handle millions of rows and run analytics on these data, you might want to look into ClickHouse. I wrote over on hashnode about it: https://picostitch.hashnode.dev/getting-started-with-clickhouse
If you see no entries in MariaDB's time_zone table, then you have no timezone support.
Continue reading →
A long time ago, I used to know all MySQL commands by heart. Now I am re-learning them, but this time with MariaDB, and I learn best by writing things down. So here is the cheatsheet to have a way of looking up commands quickly.
Continue reading →
RethinkDB is a topic that I had been investing some time into, because I tried to figure out which DB to use for cosmowiki. What convinced me about: it is a DB which offers the best of both worlds, the NoSQL world (schema "freedom") and SQL DB's relational data. RethinkDB has joins built-in as one of the core features. Besides built-in joins it claims to have a very simple scale out mechanism and almost magic, transparent fail-over since version 2.1.
Continue reading →