Building a Production-Ready Postgres Kubernetes Operator in Java with Quarkus and GraalVM

An airhacks.fm conversation with Alvaro Hernandez (@ahachete (twitter.com/ahachete)) about:
discussion about LLMs generating Java (java.com/en) code with BCE (youtube.com/watch?v=grJC6RFiB58) patterns and architectural rules,
Java being 20-30% better for LLM code generation than python.org and typescriptlang.org,
embedding business knowledge in Java source code for LLM context,
stackgres.io as a curated opinionated stack for running Postgres (coreos.com/blog/introducing-operators.html) on kubernetes.io,
Postgres requiring external tools for connection pooling and high availability and backup and monitoring,
StackGres as a Helm package and Kubernetes operator,
comparison with oxide.computer hardware for on-premise cloud environments,
experimenting with Incus for system containers and en.wikipedia.org/wiki/OpenVMS,
limitations of Ansible (ansible.com) for infrastructure automation and code reuse,
Kubernetes as an API-driven architecture abstracting compute and storage,
Custom Resource Definitions (CRDs) for declarative Postgres cluster management,
StackGres supporting sharding with automated multi-cluster deployment,
13 lines of YAML (yaml.org) to create 60-node sharded clusters,
three interfaces for StackGres including CRDs and web console and REST API,
operator written in Java with quarkus.io unlike typical Go-based operators,
Google study showing Java faster than Go,
GraalVM (graalvm.org) native compilation for 80MB container images versus 400-500MB JVM images,
fabric8.io Kubernetes client for API communication,
reconciliation cycle running every 10 seconds to maintain desired state,
pod local controller as Quarkus sidecar for local Postgres operations,
dynamic extension installation without rebuilding container images,
grpc.io bi-directional communication between control plane and control nodes,
inverse connection pattern where nodes initiate connections to control plane,
comparison with Jini (river.apache.org) and en.wikipedia.org/wiki/Tuple_space#JavaSpaces leasing (river.apache.org/release-doc/3.0.0/specs/html/…) concepts from Sun Microsystems (en.wikipedia.org/wiki/Sun_Microsystems),
quarter million lines of Java code in the operator mostly POJOs predating records,
PostgreSQL (postgresql.org) configuration validation with 300+ parameters,
automated tuning applied by default in StackGres,
potential for LLM-driven optimization with clone clusters for testing,
Framework Computer (en.wikipedia.org/wiki/Framework_Computer) laptop automation with Ubuntu auto-install and Ansible and en.wikipedia.org/wiki/Nix_(package_manager),
five to ten minute full system reinstall including BIOS updates

Alvaro Hernandez on twitter: @ahachete (twitter.com/ahachete)