Search Results for "sql query builder"

SPQR is a sharding proxy for PostgreSQL that enables horizontal scalability by distributing queries across multiple PostgreSQL instances. Designed for large-scale, multi-tenant architectures, SPQR routes, rewrites, and manages SQL queries to ensure they are executed efficiently across shards. It provides a PostgreSQL-compatible interface so applications can scale transparently without code changes.

dbtpl is a Go-based tool that brings templated SQL into your codebase in a clean and structured way. It allows developers to define raw SQL queries in .tpl.sql files and compile them into Go code with strong typing and minimal overhead. By combining SQL’s power with Go’s safety and performance, dbtpl is ideal for teams that want full SQL control without sacrificing maintainability.

noisia is a PostgreSQL workload generator designed for testing and benchmarking query performance. It simulates real-world SQL traffic by replaying or generating workloads based on defined query profiles. noisia is useful for stress testing databases, tuning configurations, and validating changes in performance-sensitive environments.