RSSDs: Portability of Excel, Power of SQL

Resource Surveillance State Databases (RSSDs) represent surveilr's core storage format, combining the best of both worlds: Excel's portability and SQL's power.

The Excel Problem

Spreadsheets are ubiquitous because they're: - Easy to share - Self-contained - Universally readable

But they lack: - Query capabilities - Data integrity - Scalability

The SQL Solution

SQLite-based RSSDs provide: - Full SQL query support - ACID compliance - Unlimited scalability

While maintaining: - Single-file portability - No server requirements - Universal tooling support

RSSD Features

Schema Flexibility Adapt to any data structure without migrations.

Query Power Full SQL including joins, aggregations, and window functions.

Portability Share files like spreadsheets, query like databases.

Migration Path

Moving from Excel to RSSD is straightforward with surveilr's import capabilities.