Simples Possible Time Series System

Setup local environment

We stand on the shoulders of giants, so you'll need:

• Rust - use standard rustup to install your toolchain.
• Diesel as an ORM layer - see below.
• docker-compose and Docker for running external services (Postgres and Grafana). Install as per your preferred method.

For Diesel, follow their getting started guide to install the CLI tool. In this case, we just need Postgres, so you can use:

sudo apt-get install libpq-dev
cargo install diesel_cli --no-default-features --features postgres

For docker-compose, you can fire this up as usual:

$ docker compose up postgres -d
$ psql postgres://test:test@localhost:5432/test
psql# CREATE DATABASE grafana;
psql# \q
$ docker compose up grafana -d

Copy over the env file, which is configured for docker-compose.yml, but adjust for your environment:

cp .env.example .env

And then run the migrations to get your database set up:

diesel migration run

Finally, run the test-data-generator to insert some sample data to work with:

cargo run --bin test-data-generator

Grafana

With docker-compose, Grafana is available via http://localhost:3000/, default login is admin/admin.

You then need to add a Postgres Data source to connect to itself, but the test database:

• Connections > Data sources > Add new Data Source
• Type: Postgres
• Credentials:
  • Host: postgres:5432
  • Database: test
  • Username: test
  • Password: test
• Be sure to set TLS/SSL mode to "disable" for the docker-compose setup.
• Be sure to set the Version to match your running version (13 in my test, because this matched my legacy deployment version)

The default dashboard uses the custom views, and a JSON transformer to extract fields. A very simple example dashboard is checked in.

In Grafana, create a new dashboard, and add a new panel. Then go back to the dashboard, and for that panel, in the three dots menu, go to Inspect > Panel JSON. Then you can replace the JSON with views/grafana-panel-code-binary-size.json for an example. If it gives you an error, edit the panel and run the query the first time. Then it should work ok!