Olap

Developer rebuilds stock analytics tool, migrating from InnoDB OLTP to Iceberg OLAP stack

A developer who originally built a stock analysis repository on MySQL's InnoDB storage engine rewrote it to run on an OLAP lakehouse stack built around Apache Iceberg. The author explains that the switch was driven by a single optimization available in the OLAP approach, but required learning the internals of lakehouse architecture to actually exploit it. The piece breaks down InnoDB's core mechanics—row storage layout, indexing tradeoffs, and MVCC via undo logs—as the baseline being replaced.