TOOLS

PgWire Server

Connect to Teide using any PostgreSQL-compatible client via the wire protocol server.

Starting the Server

cargo run --release --features server

# Or use the built binary
teide-server

Default: listens on 127.0.0.1:5433.

Server Arguments

Argument Default Description
--host HOST 127.0.0.1 Listen address
--port PORT 5433 Listen port
--load NAME=PATH Load CSV as named table (repeatable)
--init PATH Execute SQL init script at startup
--verbose false Enable verbose logging

Loading Data at Startup

teide-server \
  --load trades=data/trades.csv \
  --load users=data/users.csv \
  --init setup.sql

Connecting with psql

psql -h 127.0.0.1 -p 5433

Then run SQL queries as normal:

SELECT * FROM trades ORDER BY price DESC LIMIT 10;

Connecting with DBeaver

  1. Create a new PostgreSQL connection
  2. Host: 127.0.0.1, Port: 5433
  3. No username/password required
  4. Test connection and browse tables

JDBC Connection

jdbc:postgresql://127.0.0.1:5433/

Architecture