The Database Cloud

An airhacks.fm conversation with Alvaro Hernandez (@ahachete (twitter.com/ahachete)) about:
discussion about stackgres.io as a complete database cloud solution for PostgreSQL (postgresql.org),
kubernetes.io as an abstraction layer over infrastructure providing a programmable API,
Stackgres offering high availability with primary and replica nodes using github.com/patroni/patroni,
integrated connection pooling with PgBouncer (pgbouncer.org),
kubernetes operators (kubernetes.io/docs/concepts/extend-kubernetes/…) 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 (citusdata.com) for horizontal scaling similar to DynamoDB (aws.amazon.com/dynamodb),
Change Data Capture (en.wikipedia.org/wiki/Change_data_capture) capabilities using embedded debezium.io,
failover mechanisms taking typically 30 seconds with DNS updates,
synchronous vs asynchronous replication options affecting data loss during failover,
Stackgres being implemented in Java (java.com/en) using quarkus.io,
ContainerD (containerd.io) as a programmable container runtime that can be used without Kubernetes,
Stackgres offering multiple interfaces including CRDs,
REST (keycloak.org/docs-api/5.0/rest-api/index.html) 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 (twitter.com/ahachete)