The Database Cloud

An airhacks.fm conversation with Alvaro Hernandez (@ahachete)
about: discussion about stackgres as a complete database cloud
solution for PostgreSQL, kubernetes as an abstraction layer over
infrastructure providing a programmable API, Stackgres offering
high availability with primary and replica nodes using patroni,
integrated connection pooling with PgBouncer, kubernetes operators
and Custom Resource Definitions (CRDs) as a powerful way to extend
Kubernetes, day two operations automated through CRDs including
benchmarks and version upgrades, Stackgres supporting sharding with
Citus for horizontal scaling similar to DynamoDB, Change Data
Capture capabilities using embedded debezium, failover mechanisms
taking typically 30 seconds with DNS updates, synchronous vs
asynchronous replication options affecting data loss during
failover, Stackgres being implemented in Java using quarkus,
ContainerD as a programmable container runtime that can be used
without Kubernetes, Stackgres offering multiple interfaces
including CRDs, REST API, and a web console, considerations for
running databases on Kubernetes vs cloud-managed services, the
advantages of containerization for infrastructure, the challenges
of multi-leader setups in PostgreSQL requiring conflict resolution,
the value of Kubernetes for on-premises deployments vs cloud
environments

Alvaro Hernandez on twitter: @ahachete