supavisor

What's Changed

• chore: update runtime.exs path in hot_upgrade by @abc3 in https://github.com/supabase/supavisor/pull/322

Full Changelog: https://github.com/supabase/supavisor/compare/v1.1.44...v1.1.45

What's Changed

• fix: set Logger level otherwise Phoenix plug exceptions are not thrown by @chasers in https://github.com/supabase/supavisor/pull/312
• fix: async calls for all ready_for_query messages by @abc3 in https://github.com/supabase/supavisor/pull/318
• fix: stop pool connection if credentials fail by @abc3 in https://github.com/supabase/supavisor/pull/321

Full Changelog: https://github.com/supabase/supavisor/compare/v1.1.40...v1.1.44

What's Changed

• fix: sync sending after reaching the threshold by @abc3 in https://github.com/supabase/supavisor/pull/313

Full Changelog: https://github.com/supabase/supavisor/compare/v1.1.39...v1.1.40

What's Changed

• fix: enable connection to custom database name other than 'postgres' by @w3b6x9 in https://github.com/supabase/supavisor/pull/254
• fix: tenant id handling in manager by @abc3 in https://github.com/supabase/supavisor/pull/271
• feat: add new metrics by @abc3 in https://github.com/supabase/supavisor/pull/270
• feat: pick node to spin up a pool by tenant id by @abc3 in https://github.com/supabase/supavisor/pull/269
• fix: metrics tenant by @abc3 in https://github.com/supabase/supavisor/pull/272
• fix: start_dist in client_handler by @abc3 in https://github.com/supabase/supavisor/pull/275
• fix: kill the linked handler in session mode by @abc3 in https://github.com/supabase/supavisor/pull/277
• feat: add more logs by @abc3 in https://github.com/supabase/supavisor/pull/278
• chore: set max heap size for handlers by @abc3 in https://github.com/supabase/supavisor/pull/280
• fix: setting a mode on transaction port by @abc3 in https://github.com/supabase/supavisor/pull/283
• feat: setting log level per tenant via options by @abc3 in https://github.com/supabase/supavisor/pull/286
• feat: update hostname by @abc3 in https://github.com/supabase/supavisor/pull/288
• chore(deps): bump shlex from 1.2.0 to 1.3.0 in /native/pgparser by @dependabot in https://github.com/supabase/supavisor/pull/281
• chore: improve logging by @abc3 in https://github.com/supabase/supavisor/pull/292
• chore: set number of ets tables and processes by @abc3 in https://github.com/supabase/supavisor/pull/293
• fix: add [active: once] on receiving a response by @abc3 in https://github.com/supabase/supavisor/pull/295
• feat: reset the check timer after the client's disconnection by @abc3 in https://github.com/supabase/supavisor/pull/291
• fix: handle client termination in db handler by @abc3 in https://github.com/supabase/supavisor/pull/296
• fix: add an error case for get_payload() by @abc3 in https://github.com/supabase/supavisor/pull/297
• fix: stop db handler before client by @abc3 in https://github.com/supabase/supavisor/pull/298
• feat: local or remote pool checkout duration metric by @abc3 in https://github.com/supabase/supavisor/pull/299
• feat: recheck auth secrets on connection error by @abc3 in https://github.com/supabase/supavisor/pull/304
• feat: idle workers in pool by @abc3 in https://github.com/supabase/supavisor/pull/285
• chore: ecto pool_size 25 by @abc3 in https://github.com/supabase/supavisor/pull/305
• chore: update options for the get secrets by @abc3 in https://github.com/supabase/supavisor/pull/306
• feat: clear tenant's cache on update or delete by @abc3 in https://github.com/supabase/supavisor/pull/309

New Contributors

• @w3b6x9 made their first contribution in https://github.com/supabase/supavisor/pull/254

Full Changelog: https://github.com/supabase/supavisor/compare/v1.1.13...v1.1.39

Notable

• Fixes "expected SASL response, got message type" which can appear in Postgres logs
• Don't attempt to check database availability during tenant CRUD operations
• Fixes metrics per tenant endpoint
• Fixes edge cases during scram auth

What's Changed

• feat: track duration from tcp connection to greeting clients by @abc3 in https://github.com/supabase/supavisor/pull/258
• fix: don't block the connection during the scram dance by @abc3 in https://github.com/supabase/supavisor/pull/256
• fix: add a new line in tenant metrics by @abc3 in https://github.com/supabase/supavisor/pull/261
• fix: new line in tenant metrics by @abc3 in https://github.com/supabase/supavisor/pull/262
• feat: bump Rustler and pg_query to resolve security warning by @J0 in https://github.com/supabase/supavisor/pull/255
• fix: add proto guards by @abc3 in https://github.com/supabase/supavisor/pull/267
• feat: don't check db creds on update by @abc3 in https://github.com/supabase/supavisor/pull/265

Full Changelog: https://github.com/supabase/supavisor/compare/v1.1.6...v1.1.13

Notable

• Fixes a bug which caused prepared statements to fail in session mode

What's Changed

• fix: linking db pid in session mode by @abc3 in https://github.com/supabase/supavisor/pull/249

Full Changelog: https://github.com/supabase/supavisor/compare/v1.1.5...v1.1.6

Notable

• Pools now start with only 10 connections and create new ones up to tenant default_pool_size or user pool_size
• Logs correct tenant id
• API endpoints accept PATCH requests

What's Changed

• fix: DbHandler Logger metadata by @abc3 in https://github.com/supabase/supavisor/pull/245
• fix: update api by @abc3 in https://github.com/supabase/supavisor/pull/247
• feat: set initial pool size to 10, enable other via max_overflow by @abc3 in https://github.com/supabase/supavisor/pull/225

Full Changelog: https://github.com/supabase/supavisor/compare/v1.1.2...v1.1.5

Notable

• allow_list field on the tenant to support network restrictions
• More docs
• client_heartbeat_interval on the tenant to detect zombie client connections
• Bug fixes
• Observability improvements

What's Changed

• feat: reduce logging by @J0 in https://github.com/supabase/supavisor/pull/216
• Update pgbouncer.md (fix typo) by @zorbash in https://github.com/supabase/supavisor/pull/224
• fix: return proper error on undefined tenant by @J0 in https://github.com/supabase/supavisor/pull/220
• chore(deps): bump rustix from 0.38.10 to 0.38.28 in /native/pgparser by @dependabot in https://github.com/supabase/supavisor/pull/217
• chore: upgrade gh runner by @abc3 in https://github.com/supabase/supavisor/pull/226
• feat: add heartbeat interval to client handler by @abc3 in https://github.com/supabase/supavisor/pull/223
• fix: remove stub in heartbeat_interval by @abc3 in https://github.com/supabase/supavisor/pull/229
• fix: catch errors from decode_payload by @abc3 in https://github.com/supabase/supavisor/pull/231
• feat: update the Dockerfile and install Rust so build goes through by @J0 in https://github.com/supabase/supavisor/pull/237
• fix: higher res buckets for pool checkout duration metric by @chasers in https://github.com/supabase/supavisor/pull/241
• fix: config compile_time_purge_matching for prod by @chasers in https://github.com/supabase/supavisor/pull/242
• feat: check ip against allow list by @chasers in https://github.com/supabase/supavisor/pull/240
• fix: adds a FAQ by @chasers in https://github.com/supabase/supavisor/pull/235
• chore(deps): bump tj-actions/changed-files from 35 to 41 in /.github/workflows by @dependabot in https://github.com/supabase/supavisor/pull/243
• feat: update dockerfile and add docker-compose file by @J0 in https://github.com/supabase/supavisor/pull/215
• feat: add additional clause for Telem.client_join by @J0 in https://github.com/supabase/supavisor/pull/219

New Contributors

• @dependabot made their first contribution in https://github.com/supabase/supavisor/pull/217

Full Changelog: https://github.com/supabase/supavisor/compare/v1.0.0...v1.1.2

Notable

• Added support for named prepared statements
• Added support for read replicas and query load balancing
• Added a client_idle_timeout option
• New docs build process and website (Github hosted)
• Docs for migrating from PgBouncer
• auth_query with md5 support
• native pool_mode to proxy direct connections to Postgres
• New metric for unique connected tenants
• Cache metadata database queries for faster tenant info lookups
• Bug fixes

What's Changed

• feat: added a metric for the number of connected tenants by @abc3 in https://github.com/supabase/supavisor/pull/154
• fix: scram channel binding by @abc3 in https://github.com/supabase/supavisor/pull/157
• fix: the total count of connected clients for a tenant by @abc3 in https://github.com/supabase/supavisor/pull/155
• fix: display 0 in the supavisor_connections field after the last disconnection by @abc3 in https://github.com/supabase/supavisor/pull/158
• feat: add a mode type to the pool id by @abc3 in https://github.com/supabase/supavisor/pull/160
• chore: publish a tarball to prod by @abc3 in https://github.com/supabase/supavisor/pull/161
• feat: add client_idle_timeout option by @abc3 in https://github.com/supabase/supavisor/pull/165
• chore: update GH actions dependencies by @delgado3d in https://github.com/supabase/supavisor/pull/166
• chore: bump ecto_sql and logflare_logger_backend by @abc3 in https://github.com/supabase/supavisor/pull/170
• feat: add an option to set the pool's strategy, default is fifo by @abc3 in https://github.com/supabase/supavisor/pull/173
• feat: support auth_query with md5 by @abc3 in https://github.com/supabase/supavisor/pull/175
• fix: error message during md5 auth by @abc3 in https://github.com/supabase/supavisor/pull/177
• fix: cache for user query, server_name_indication, change log level by @abc3 in https://github.com/supabase/supavisor/pull/179
• fix: add sni in get_secrets by @abc3 in https://github.com/supabase/supavisor/pull/181
• fix: host in db_handler is already a charlist by @abc3 in https://github.com/supabase/supavisor/pull/182
• chore: move docs to mkdocs by @chasers in https://github.com/supabase/supavisor/pull/186
• docs: auto publish docs on main by @chasers in https://github.com/supabase/supavisor/pull/189
• fix: install mkdocs-material by @chasers in https://github.com/supabase/supavisor/pull/192
• docs: more docs by @chasers in https://github.com/supabase/supavisor/pull/190
• feat: add gh workflow by @J0 in https://github.com/supabase/supavisor/pull/180
• feat: add native mode by @abc3 in https://github.com/supabase/supavisor/pull/188
• fix: handle http request in the native mode by @abc3 in https://github.com/supabase/supavisor/pull/193
• feat: handle cancelling requests by @abc3 in https://github.com/supabase/supavisor/pull/194
• fix: prevent client <-> db locking by @abc3 in https://github.com/supabase/supavisor/pull/195
• fix: update doc links by @abc3 in https://github.com/supabase/supavisor/pull/198
• fix: docs set defaults on tenant for example by @chasers in https://github.com/supabase/supavisor/pull/199
• fix: docs enumerate tenant and user configs with auth_query by @chasers in https://github.com/supabase/supavisor/pull/201
• feat: add metrics for connection success/failure and improve error handling by @abc3 in https://github.com/supabase/supavisor/pull/200
• fix: add docs for migrating from pgbouncer by @chasers in https://github.com/supabase/supavisor/pull/205
• chore: change from native mode to session mode by @abc3 in https://github.com/supabase/supavisor/pull/210
• feat: handling of named prepared statements by @abc3 https://github.com/supabase/supavisor/pull/207
• feat: add support for read replicas by @abc3 in https://github.com/supabase/supavisor/pull/162

New Contributors

• @delgado3d made their first contribution in https://github.com/supabase/supavisor/pull/166

Full Changelog: https://github.com/supabase/supavisor/compare/v0.9.0...v1.0.0

Notable

• SSL support upstream and downstream - clients can connect with SSL and SCRAM-SHA-256 authentication
• Optionally enforce SSL connections - set enforce_ssl to true on the tenant to force clients to connect with SSL
• Authentication query support like PgBouncer - define an auth_query on the tenant to authenticate users dynamically
• Metrics endpoint per tenant - /metrics/:external_id will respond with metrics filtered for a single tenant by external_id
• Region and instance id metadata in logs - filter your logs easily by region or instance_id
• Optionally limit client connections per tenant - set default_max_clients on the tenant and optionally max_clients on the user to limit inbound connections per tenant

What's Changed

• docs(openapi): match tenant update implementation by @ChristianAlexander in https://github.com/supabase/supavisor/pull/65
• New logo 🔥 by @chasers in https://github.com/supabase/supavisor/pull/71
• Implement multiple pools per tenant by @abc3 in https://github.com/supabase/supavisor/pull/73
• fix the 'list tenants' endpoint by @abc3 in https://github.com/supabase/supavisor/pull/84
• Implement session mode functionality by @abc3 in https://github.com/supabase/supavisor/pull/79
• Implement Websocket proxy by @abc3 in https://github.com/supabase/supavisor/pull/82
• feat: handle MD5 authentication by @altjohndev in https://github.com/supabase/supavisor/pull/89
• feat: add version check to CI via VERSION file by @J0 in https://github.com/supabase/supavisor/pull/78
• Add logflare support by @abc3 in https://github.com/supabase/supavisor/pull/96
• Systemd service by @abc3 in https://github.com/supabase/supavisor/pull/95
• Handle http request by @abc3 in https://github.com/supabase/supavisor/pull/98
• Add prefix to migration AddTimeoutToUsers by @acco in https://github.com/supabase/supavisor/pull/99
• Add credo config by @abc3 in https://github.com/supabase/supavisor/pull/108
• Prevent linking to the db process on startup when transaction mode by @abc3 in https://github.com/supabase/supavisor/pull/107
• Check creds before adding to db and wait timeout for cold start by @abc3 in https://github.com/supabase/supavisor/pull/101
• Add Postgres strategy for libcluster by @abc3 in https://github.com/supabase/supavisor/pull/110
• chore: set min/max values for inet_dist_listen by @abc3 in https://github.com/supabase/supavisor/pull/113
• Add connection pool stop on db credential change by @abc3 in https://github.com/supabase/supavisor/pull/114
• chore: add prefix to osmon metrics by @abc3 in https://github.com/supabase/supavisor/pull/117
• chore: support ipv4 and ipv6 for tenant's db by @abc3 in https://github.com/supabase/supavisor/pull/115
• fix: pg version without platform by @abc3 in https://github.com/supabase/supavisor/pull/118
• feat: add mix tasks for generating release artifacts by @abc3 in https://github.com/supabase/supavisor/pull/119
• SSL support for upstream connections by @abc3 in https://github.com/supabase/supavisor/pull/124
• SSL support for downstream connections by @abc3 in https://github.com/supabase/supavisor/pull/129
• Option to allow only SSL connection by @abc3 in https://github.com/supabase/supavisor/pull/130
• feat: auth_query support by @abc3 in https://github.com/supabase/supavisor/pull/132
• fix: start proxy on two ports by @abc3 in https://github.com/supabase/supavisor/pull/136
• fix: update the query for retrieving user creds by @abc3 in https://github.com/supabase/supavisor/pull/137
• fix: use username from the connection in process names by @abc3 in https://github.com/supabase/supavisor/pull/141
• feat: add region and instance id to logger by @abc3 in https://github.com/supabase/supavisor/pull/142
• feat: limit client connections by @abc3 in https://github.com/supabase/supavisor/pull/144
• feat: api endpoint to terminate tenancy tree connection by @abc3 in https://github.com/supabase/supavisor/pull/145
• fix: query count and network usage metrics by @abc3 in https://github.com/supabase/supavisor/pull/149
• feat: metric endpoint per tenant by @abc3 in https://github.com/supabase/supavisor/pull/147

New Contributors

• @kiwicopple made their first contribution in https://github.com/supabase/supavisor/pull/53
• @MildTomato made their first contribution in https://github.com/supabase/supavisor/pull/62
• @zorbash made their first contribution in https://github.com/supabase/supavisor/pull/64
• @ChristianAlexander made their first contribution in https://github.com/supabase/supavisor/pull/66
• @altjohndev made their first contribution in https://github.com/supabase/supavisor/pull/89
• @J0 made their first contribution in https://github.com/supabase/supavisor/pull/78

• Connect to multiple different Postgres instances/clusters
• Transaction pooling
• Cluster-able
• Resilient during cluster resizing
• Supports rolling and blue/green deployment strategies
• NOT run in a serverless environment
• NOT dependent on Kubernetes
• Easily understand throughput by a tenant, tenant database or individual connection
• Prometheus /metrics endpoint
• OpenAPI spec at /api/openapi
• SwaggarUI at /swaggerui
• When deployed as a Supavisor cluster and a node dies connection pools should be quickly spun up or already available on other nodes when clients reconnect
• Connection buffering
• Brief connection buffering for transparent database restarts or failovers