Documentation Index
Fetch the complete documentation index at: https://docs.memwal.ai/llms.txt
Use this file to discover all available pages before exploring further.
The indexer syncs account data into PostgreSQL so the relayer can resolve ownership quickly without hitting the blockchain on every request.
Database
Both the relayer and the indexer connect to the same PostgreSQL instance (with the pgvector extension enabled). Migrations run automatically on boot.
Tables
vector_entries
The primary search table — stores vector embeddings linked to encrypted Walrus blobs.
| Column | Type | Description |
|---|
id | TEXT (PK) | UUID for this entry |
owner | TEXT | Owner’s Sui address |
namespace | TEXT | Namespace label (default: "default") |
blob_id | TEXT | Walrus blob ID pointing to the encrypted payload |
embedding | vector(1536) | 1536-dimensional vector embedding (pgvector) |
created_at | TIMESTAMPTZ | Insertion timestamp |
idx_vector_entries_owner — B-tree on owneridx_vector_entries_blob_id — B-tree on blob_ididx_vector_entries_owner_ns — composite B-tree on (owner, namespace) for scoped queriesidx_vector_entries_embedding — HNSW on embedding using vector_cosine_ops for fast similarity search
delegate_key_cache
Auth optimization — caches the mapping from delegate public key to account, so the relayer doesn’t need to scan the onchain registry on every request.
| Column | Type | Description |
|---|
public_key | TEXT (PK) | Hex-encoded Ed25519 public key |
account_id | TEXT | MemWalAccount object ID |
owner | TEXT | Owner’s Sui address |
cached_at | TIMESTAMPTZ | When this mapping was cached |
accounts
Populated by the indexer — maps owner addresses to their MemWalAccount object IDs.
| Column | Type | Description |
|---|
account_id | TEXT (PK) | MemWalAccount object ID |
owner | TEXT (unique) | Owner’s Sui address |
created_at | TIMESTAMPTZ | When this row was indexed |
indexer_state
Tracks the indexer’s cursor position so it can resume from where it left off after restarts.
| Column | Type | Description |
|---|
key | TEXT (PK) | State key (e.g., "event_cursor") |
value | TEXT | JSON-serialized cursor (txDigest + eventSeq) |
How It Helps
- Constant-time account lookup — the relayer checks
delegate_key_cache and accounts instead of scanning the onchain registry
- Resumable event polling — the indexer stores its cursor in
indexer_state, so it picks up where it left off after restarts without re-processing old events
- Reactive cleanup — when Walrus returns 404 for an expired blob during recall, the relayer deletes the corresponding
vector_entries rows automatically
Similarity Search
Recall queries use pgvector’s cosine distance operator (<=>) against the HNSW index:
SELECT blob_id, (embedding <=> $1)::float8 AS distance
FROM vector_entries
WHERE owner = $2 AND namespace = $3
ORDER BY embedding <=> $1
LIMIT $4
