Trino - Cross DB Reporting
Introduction Managing multiple data sources was a big challenge I was facing on my NAS environment. I have various applications running on my NAS, and each application utilizes different databases to store the data. This diverse ecosystem of databases includes MySQL, PostgreSQL, SQLite, MS SQL, and others, each serving its specific purpose. My main applications are: Immich, a photo and video backup system A WordPress blog Some of my personal projects Each of these applications has its own database, and I wanted to generate a daily report that requires data from multiple databases. Manually joining tables across these different databases was not only time-consuming but also prone to errors and inefficiencies. I was looking for a solution that could seamlessly integrate and query data from these disparate sources to generate accurate and timely reports. ...