Storage Backends¶

router-hosts supports three storage backends. SQLite is the default and recommended for most deployments.

Comparison¶

Feature	SQLite	PostgreSQL	DuckDB
Setup complexity	Low	Medium	Low
Concurrent connections	Limited	High	Limited
Embedded	Yes	No	Yes
Production ready	Yes	Yes	Experimental

Best for single-server deployments. Zero configuration required.

[storage]
database_url = "sqlite:///var/lib/router-hosts/hosts.db"

Default location (if no URL specified): ~/.local/share/router-hosts/hosts.db

Best for high-availability deployments with multiple server instances.

[storage]
database_url = "postgres://user:password@localhost:5432/router_hosts"

Requires PostgreSQL 14+.

Experimental backend. Requires the router-hosts-duckdb binary variant.

[storage]
database_url = "duckdb:///var/lib/router-hosts/hosts.duckdb"

Warning

DuckDB support is experimental. Use SQLite or PostgreSQL for production.