Metabase - The Easy Way

After trying a ton of different options, I ended up sticking with the PSQL database mentioned in the other post, but this time, I installed Metabase on the LXC to provide a nice web interface that gave me some quick charts and tables with zero effort. 

• Website: https://www.metabase.com/
• Docs: https://www.metabase.com/docs/latest/
• Installation: https://www.metabase.com/docs/latest/installation-and-operation/installing-metabase

1. Install JDK: apt install -y openjdk-17-jre (use whatever version you want)
2. Get Metabase: wget https://downloads.metabase.com/v0.46.6/metabase.jar -P /opt/metabase/

The interface will be accessed at port 3000, so whatever IP or domain is used to connect to the LXC, use that. For example: http://192.168.0.100:3000

To complete the installation, use the web interface and connect the database - boom done.