uf-valence-backend-postgres 0.1.2

Postgres DatabaseBackend adapter for Valence
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49

# valence-backend-postgres

Postgres wire [`DatabaseBackend`](../valence-core/src/backend/port.rs) adapter. Enable via the public `valence` feature `postgres` and wire remote Postgres at boot using the builder's `from_env_defaults` pattern.

```rust
pub const ENGINE_ID: &str = "postgres";
```

## Environment

| Variable | Meaning |
|----------|---------|
| `DATABASE_URL` | Postgres connection URL (required unless `.url()` is set) |

## Wiring

```rust
use std::sync::Arc;
use valence::{PostgresBackend, Valence};

// Explicit:
let backend = PostgresBackend::connect("postgres://localhost/valence").await?;
// Or env:
let backend = PostgresBackend::from_env().await?;

let valence = Valence::builder()
    .add_backend("default", Arc::new(backend))
    .build()?;
```

Builder: `PostgresBackend::builder().url(...).from_env_defaults().build().await?`

## Docker

```bash
docker run --rm -d --name valence-postgres -p 5432:5432 -e POSTGRES_PASSWORD=postgres postgres:16
export DATABASE_URL=postgres://postgres:postgres@127.0.0.1:5432/postgres
```

Runnable (skips when unset):

```bash
DATABASE_URL=postgres://postgres:postgres@127.0.0.1:5432/postgres \
  cargo run -p uf-valence --example quickstart_postgres --features postgres
```

Live multi-remote routing alongside Redis: [`examples/remote-multi-backend-host`](../examples/remote-multi-backend-host/).

See `DatabaseBackend` rustdoc (`cargo doc -p uf-valence-core --open`).