postgres

Overview ¶

Package postgres runs Nectar's storage on PostgreSQL.

It is the backend for deployments that need real concurrency: SQLite allows one writer at a time, which is a documented limit rather than a bug, and this one does not.

Everything but this file lives in internal/storage/sqlstore, shared with SQLite. What is here is the whole of the difference -- placeholder syntax, how an insert reports its surrogate key, full-text search, and the DDL. That the list is this short is the point: the schema was built portable from the first migration, and this port is a translation rather than a rewrite.