oura 2.2.0

The tail of Cardano
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

# SQLite sink

Split blocks into transactions and persist their raw CBOR into a local SQLite database using
templated SQL statements.

## Pipeline

```mermaid
flowchart LR
  src[N2N source] --> f1[SplitBlock] --> sink[SqlDb sink]
```

- **Source** — `N2N`: mainnet relay, starting from the `Point` in `[intersect]`.
- **Filters** — `SplitBlock`: breaks each block into individual transactions.
- **Sink** — `SqlDb`: runs the `apply_template` / `undo_template` / `reset_template`
  statements against `sqlite:./mydatabase.db`, storing each transaction's slot and CBOR.
  Rollbacks and resets are handled by the undo/reset templates.

## Companion files

- `init.sql` — creates the `txs` table (and slot index) the templates write to.
- `Makefile` — `make create_db` runs `init.sql` against `mydatabase.db`.

```sh
make create_db          # or: sqlite3 mydatabase.db < init.sql
```

## Prerequisites

- Built with the `sql` feature.

## Run

```sh
cd examples/sqlite
cargo run --features sql --bin oura -- daemon --config daemon.toml
```

(or `oura daemon --config daemon.toml` with a binary built with the `sql` feature.)

The database is written to `./mydatabase.db` in the working directory.