Practical Guides

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.

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.