PostgreSQL Store
Production-grade PostgreSQL store with automatic migrations.
The store/postgres package implements Shield's store.Store interface using the grove ORM with the PostgreSQL driver. It provides full support for all 11 Shield subsystems with automatic schema migrations managed by the grove orchestrator.
Usage
import (
"context"
"log"
"github.com/xraph/grove"
"github.com/xraph/grove/drivers/pgdriver"
"github.com/xraph/shield/store/postgres"
)
db, err := grove.Open(pgdriver.Open("postgres://user:pass@localhost:5432/shield"))
if err != nil {
log.Fatal(err)
}
s := postgres.New(db)
if err := s.Migrate(context.Background()); err != nil {
log.Fatal(err)
}Tables
| Table | Subsystem | Purpose |
|---|---|---|
shield_instincts | instinct | Built-in safety rules and threat patterns |
shield_awareness | awareness | Context-aware detection configurations |
shield_boundaries | boundary | Input/output boundary enforcement rules |
shield_values | values | Value-alignment rule definitions |
shield_judgments | judgment | Content evaluation and scoring rules |
shield_reflexes | reflex | Automatic response and action triggers |
shield_profiles | profile | Composite safety profile configurations |
shield_scans | scan | Content scan results and audit log |
shield_policies | policy | Organizational safety policy definitions |
shield_policy_tenants | policy | Policy-to-tenant assignment mappings |
shield_pii_tokens | pii | Tokenized PII storage for redaction/recovery |
shield_compliance_reports | compliance | Generated compliance audit reports |
Internals
| Aspect | Detail |
|---|---|
| Driver | grove ORM + pgdriver |
| Migrations | grove orchestrator with programmatic migrations |
| Transactions | PostgreSQL-level transactions |
| Concurrency | Full MVCC with concurrent readers and writers |
When to use
- Production deployments requiring ACID guarantees and high concurrency.
- Multi-tenant environments with complex query patterns.
- Teams already running PostgreSQL in their infrastructure.