This is a sample app how to use the Firebolt JDBC driver within Java to write a web application. The application is using JDBI.
See this animated gif how it works when up and running:
This app assumes a running Firebolt database with GitHub events data.
The following environment variables are needed:
FIREBOLT_DATABASE
: Name of the Firebolt DatabaseFIREBOLT_USER
: Firebolt username (can be a read only user)FIREBOLT_PASSWORD
: Firebolt passowrdFIREBOLT_ENGINE
: Name of the Firebolt engineGITHUB_OAUTH_KEY
: GitHub OAuth keyGITHUB_OAUTH_SECRET
: GitHub OAuth secretGITHUB_CALLBACK_URL
: GitHub OAuth callback URL. Should be your endpoint ending withauth/login/github
, for examplehttp://localhost:7000/auth/login/github
for local testing
Feel free to take a look at the source, and if you have questions, please open an issue in the Firebolt Help Center.
- peity vanilla: Vanila JS Sparklines library inspired by peity.js
- Javalin: web framework
- JDBI: data abstraction layer
- Firebolt JDBC driver: JDBC connector
- pac4j: authorization against GitHub
- caffeine: caching