Blazer Quickstart

This page contains a quickstart to help you get blazer up and running with Container Apps on Crunchy Bridge. We recommend you start with the quickstart to get an understanding of container apps. Additional documentation for the Blazer Docker image can be found on the Blazer Docker GitHub page.

About Blazer

From the original project:

Explore your data with SQL. Easily create charts and dashboards, and share them with your team.

Blazer with Container Apps Quickstart

First ensure you have Container Apps enabled with CREATE EXTENSION pgpodman;. Once enabled you’ll need your DATABASE_URL from Crunchy Bridge to include in the command.

Next, tables used by Blazer must be initialized

SELECT run_container('-dt -e DATABASE_URL="<DATABASE_URL>" docker.io/ankane/blazer rails db:migrate');

The initialization will run and its container will exit. To start your Blazer app, run:

SELECT run_container('-dt -p 5433:8080/tcp -e DATABASE_URL="<DATABASE_URL>" docker.io/ankane/blazer');

Now you can visit your running Blazer app at your hostname:5433.

Blazer configuration

By default the above setup is a public app that anyone who knows the URL can access. It is recommended that you setup authentication. You can setup basic auth by configuring the BLAZER_USERNAME and BLAZER_PASSWORD values when you initiate the Container App:

SELECT run_container('-dt -p 5433:8080/tcp -e DATABASE_URL="<DATABASE_URL>" -e BLAZER_USERNAME="<USERNAME>" -e BLAZER_PASSWORD="<PASSWORD>" docker.io/ankane/blazer');