Go to file
GroovieGermanikus 78d1250842
fix index name
2024-11-07 11:46:42 +01:00
.github/workflows cleanup: do not count rows unless enabled by argument "--count-rows" (#63) 2024-03-11 20:40:49 +01:00
.idea
src disable amt writing 2024-10-02 23:22:29 +02:00
.dockerignore
.gitignore
Cargo.lock remove .clones and use fd_bs58 2024-04-25 12:45:11 +02:00
Cargo.toml remove .clones and use fd_bs58 2024-04-25 12:45:11 +02:00
DBA.md
Dockerfile
README.md
alts.txt
fly-hetzner-migration.toml
fly.toml
init-database.sql
migration.sql fix index name 2024-11-07 11:46:42 +01:00
run-service-and-cleanup.sh cleanup: do not count rows unless enabled by argument "--count-rows" (#63) 2024-03-11 20:40:49 +01:00

README.md

BankingStage Sidecar

This is a sidecar application for the BankingStage project. It is responsible for importing data from the Solana blockchain into the PostgreSQL database. Data is retrieved via Solana RPC and Geysers gRPC API.

Database Configuration

Database Roles

  • bankingstage_sidecar - write access to the database for the sidecar importer
  • bankingstage_dashboard - read-only access to the database for the dashboard web application
  • query_user - group for read-only access to the database intended for human user interaction with database
CREATE USER some_user_in_group_query_user PASSWORD 'test';
GRANT query_user TO some_user_in_group_query_user;

Configure sidecar PostgreSQL connection

export PG_CONFIG="host=localhost dbname=the_banking_stage_db user=some_user_in_group_query_user password=test sslmode=disable"

Database Schema

The database schema is defined in the migration.sql file. For new database installations start with the init-database.sql file. Required is a PostgreSQL database (tested version 15).