Writing Portable PostgreSQL - backed network applications for the open cloud
summary
Claims that a PostgreSQL app can be shifted from GitHub into OpenShift are backed by the actual commands and limits shown: use rhc app create with a cartridge list to provision python plus postgres92, HAProxy handles load, auto‑scale triggers on network connections, and PostGIS 2.0/2.1 is available soon. Demos include a scalable to‑do app, a parks map that partially works, and an adopt‑a‑hydrant reuse story. Concrete constraints matter: free tier three apps, 512 MB RAM, 1 GB persistent disk, ~20 connections, and plugins must be installed in the base image by ops.
AI-written summary · about
chapters (28)
- 0:00Intro
- 1:24What is an open cloud
- 3:37Installing PostgreSQL
- 6:23Why use open platforms
- 8:47Public cloud solutions
- 9:45Open source solutions
- 12:16Hosting your own
- 13:33Running on Openshift
- 14:26Appt Create
- 17:10Output
- 18:06AppShow
- 18:52Red Hat Terminology
- 19:46Cartridge
- 20:39Gears
- 27:06Openshift versions
- 28:05Todo application
- 28:52Scaling
- 31:20Min and Max
- 31:44Web UI
- 34:40Parks
- 38:13PostGIS
- 42:28Adopt a Hydrant
- 43:41Hydrant App
- 45:33Hydrant Secret Token
- 48:33Help
- 51:35Environment variables
- 52:48Community involvement
- 54:55Questions
related talks
41mCloud-Native Databases in Kubernetes with OpenShift and Postgres
35mContainerizing PostgreSQL and Making it Cloud Native Ready
54mPostgres: From Cloud to Hybrid and On Prem Again
51mPostgres on OpenStack
08mUsing PostgreSQL in real life
28mRun PostgreSQL in Warp Speed Using NVMe/TCP in the Cloud
33mPostgreSQL Service in Oracle OCI
13mBuilding reliable infrastructure with Postgres