pgdogdev/pgdog v0.1.17 on GitHub

Support search_path for schema-based sharding. Now you can SET search_path TO schema_a, public and all subsequent queries will be sent to shard matching schema_a.
Support generating globally unique BIGINT identifiers using the Snowflake-like time-based algorithm. Usable with SHOW pgdog.unique_id currently. pgdog.unique_id() function will be added in the next release.
Automatic role detection by fetching pg_is_in_recovery() from each database. Enable it by setting lsn_check_delay = 0 and role = "auto".
Track idle in transaction clients and report the metric in OpenMetrics and SHOW POOLS (sv_idle_xact).

Client connections weren't updating their status to active correctly inside transactions.
Schema detection wasn't always working for SELECT queries with multiple schemas.
Schema sync was ignoring IDENTITY column constraint.
Aggregate column count was incorrect. @mijoharas
PREPARE/EXECUTE not working correctly when prepared_statements = "full".
REAL/DOUBLE PRECISION columns were dropped in rewritten INSERT and UPDATE statements used in cross-shard writes. @phillipvanheerden
NULL values weren't correctly routed to all shards.

New Contributors

Full Changelog: v0.1.16...v0.1.17