Choose how you want to continue.
Migrating from Fathom Lite to Umami
Summary
The blog post discusses the technical process of migrating 6 years of analytics data from Fathom Lite, which uses SQLite, to Umami v3, which utilizes PostgreSQL. It details the creation of a Python script to transform hourly aggregate data into individual event rows, making it a practical guide for developers involved in data migration.
MORE POSTS LIKE THIS
syntaqlite 0.6: SQLite dot commands and pyodide
Lalit Maganti ·
Jun 17, 2026
Row vs Columnar Storage for Analytics: Why PostgreSQL Scans Are Slower Than They Should Be
Timescale ·
Jun 5, 2026
How to Work with the ORC File Format in Python – A Guide with Examples
freeCodeCamp.org ·
Jan 14, 2026
AUTHOR
Sponsored
Organized team chat for people who take work seriously. Topic-based
threading keeps conversations focused.
Try Zulip