Practical Guides

boringSQL Guides is where the theory meets practices. Explaining fundamentals while covering practical use cases that align well with the concept of boringSQL.


Mastering Logical Replication in PostgreSQL

Practical guide covering everything from setup to advanced usage of PostgreSQL's logical replication. Learn how to replicate selected tables, manage schema changes, handle conflicts, and build scalable, fault-tolerant architectures using the publish-subscribe model.

PostgREST Tutorial: APIs made easy

Practical guide that deep dives into the world of building APIs with PostgREST, a tool that leverages your existing PostgreSQL database. Step-by-step instructions and building a sample Time Off Manager application, you'll learn how to expose database tables, implement business logic with stored procedures, handle authentication, and fine-tune permissions. This guide is perfect for those seeking a straightforward, no-nonsense approach to API development without the need for extensive custom code.