BIGINT type parser configured

NUMERIC type parser configured

Type parsers before pool creation

SSL configured for production

Pool with production settings

keepAlive enabled

Parameterized queries throughout

ANY for multi-status filter

pool.query for single queries

Pool error handler

Graceful shutdown

Pool with production settings

Parameterized queries throughout

Bulk import uses unnest or multi-row VALUES

ANY or overlap for tag search

ANY for multi-status filter

Foreign key violation handling

RETURNING clause on INSERT/UPDATE

pool.query for single queries

Pool error handler and shutdown

TIMESTAMPTZ in migration

CHECK constraint on status

Index on foreign key

Unique constraint on author email

No individual Client instances

Transaction with BEGIN/COMMIT

ROLLBACK on error

client.release() in finally

pool.connect() for transactions

Pool with production settings

keepAlive enabled

Parameterized queries throughout

RETURNING clause on INSERT

Foreign key constraint handling

Pool error handler

Graceful shutdown

TIMESTAMPTZ in migration

FK index in migration

Pool with production settings

Parameterized queries throughout

Bulk import uses unnest or multi-row VALUES

No loop of individual INSERTs for batch

Typed array casts on unnest or parameters

ANY for tag filtering

ANY for multi-category filter

RETURNING clause on INSERT

pool.query for single queries

Pool error handler

Graceful shutdown

Pool with max connections

Pool timeout settings

keepAlive enabled

Pool error handler

Graceful shutdown

Parameterized queries throughout

pool.query for single queries

RETURNING clause on INSERT/UPDATE

Unique violation handling for email

BIGINT type parser configured

TIMESTAMPTZ in migration

CHECK constraint on role

Index on email column