# SPQR

## Docs

- [Auth settings](https://docs.pg-sharding.tech/configuration/auth.md): auth, tls, frontend_tls, etc.
- [Balancer](https://docs.pg-sharding.tech/configuration/balancer.md)
- [Coordinator](https://docs.pg-sharding.tech/configuration/coordinator.md)
- [Roles settings](https://docs.pg-sharding.tech/configuration/roles.md): Specify readers, writes, admins
- [Router](https://docs.pg-sharding.tech/configuration/router.md)
- [Router with Init SQL](https://docs.pg-sharding.tech/deployment/bare_router.md): Simple SPQR deployment using init_sql for static sharding configuration
- [Overview](https://docs.pg-sharding.tech/deployment/overview.md): Understanding SPQR deployment modes and choosing the right one for your use case
- [Router + Coordinator](https://docs.pg-sharding.tech/deployment/router_coordinator.md): Production-ready SPQR deployment with dynamic configuration management
- [SPQR Infra Mode](https://docs.pg-sharding.tech/deployment/spqrinfra.md): Combined router and coordinator deployment for resource efficiency
- [Various authentication types](https://docs.pg-sharding.tech/features/authentication.md)
- [Live configuration reloading](https://docs.pg-sharding.tech/features/config_reloading.md)
- [Cross-shard queries](https://docs.pg-sharding.tech/features/cross_shard_queries.md)
- [Data Balancing](https://docs.pg-sharding.tech/features/data_balancing.md)
- [Default shard](https://docs.pg-sharding.tech/features/default_shard.md)
- [Distributed Transactions](https://docs.pg-sharding.tech/features/distributed_transactions.md)
- [Fault Tolerance](https://docs.pg-sharding.tech/features/fault_tolerance.md)
- [Multiple servers and failover](https://docs.pg-sharding.tech/features/multiple_servers_and_failover.md)
- [Performance](https://docs.pg-sharding.tech/features/performance.md)
- [Transaction and session pooling](https://docs.pg-sharding.tech/features/pooling.md)
- [Works over PostgreSQL protocol](https://docs.pg-sharding.tech/features/protocol.md)
- [Dedicated read-only mode](https://docs.pg-sharding.tech/features/read_only.md)
- [Reference tables](https://docs.pg-sharding.tech/features/reference_tables.md)
- [Sharding](https://docs.pg-sharding.tech/features/sharding.md)
- [Statistics](https://docs.pg-sharding.tech/features/statistics.md)
- [Routing hints](https://docs.pg-sharding.tech/routing/hints.md)
- [Details](https://docs.pg-sharding.tech/sharding/balancing/details.md)
- [Overview](https://docs.pg-sharding.tech/sharding/balancing/overview.md)
- [Bulk Operations](https://docs.pg-sharding.tech/sharding/bulk.md): Efficiently load data across multiple shards using COPY and batch INSERT
- [Coordinator](https://docs.pg-sharding.tech/sharding/cluster_components/coordinator.md)
- [Overview](https://docs.pg-sharding.tech/sharding/cluster_components/overview.md)
- [Router](https://docs.pg-sharding.tech/sharding/cluster_components/router.md)
- [Shard](https://docs.pg-sharding.tech/sharding/cluster_components/shard.md)
- [Composite Sharding Keys](https://docs.pg-sharding.tech/sharding/composite_keys.md): Learn how to use multiple columns as sharding keys in SPQR
- [Concepts](https://docs.pg-sharding.tech/sharding/console/concepts.md): Some SPQR Admin Console terms
- [How to connect](https://docs.pg-sharding.tech/sharding/console/how_to_connect.md): SPQR router and coordinator admin console
- [SQL commands](https://docs.pg-sharding.tech/sharding/console/sql_commands.md): Create distributions, key ranges and tables and see cluster info
- [Default shard](https://docs.pg-sharding.tech/sharding/default_shard.md)
- [Distributed Transactions](https://docs.pg-sharding.tech/sharding/distributed_transactions.md): How to use two-phase commit and understand transaction commit strategies
- [Hash-based sharding](https://docs.pg-sharding.tech/sharding/hashed.md)
- [Direct key sharding](https://docs.pg-sharding.tech/sharding/ranged.md)
- [Reference Tables](https://docs.pg-sharding.tech/sharding/reference_tables.md)
- [Sharded Tables](https://docs.pg-sharding.tech/sharding/sharded_tables.md)
- [Design Goals](https://docs.pg-sharding.tech/welcome/design.md)
- [FAQ](https://docs.pg-sharding.tech/welcome/faq.md): Frequently Asked Questions
- [Get Started](https://docs.pg-sharding.tech/welcome/get_started.md): Start sharding your PostgreSQL cluster in 5 minutes
- [Welcome to SPQR](https://docs.pg-sharding.tech/welcome/index.md)
- [Talks](https://docs.pg-sharding.tech/welcome/talks.md): Public Talks About SPQR

## OpenAPI Specs

- [openapi](https://docs.pg-sharding.tech/api-reference/openapi.json)

## Optional

- [Community](https://t.me/+jMGhyjwicpI3ZWQy)
- [Releases](https://github.com/pg-sharding/spqr/releases)