Rex Bytes

pgmonkey (8/8) — Production Patterns Summary: Put pgmonkey into production — transaction management, GUC session settings, connection caching, Flask and FastAPI integration patterns, error handling, and a production readiness checklist.…

pgmonkey (7/8) — CSV Import and Export Summary: Use pgmonkey's pgexport and pgimport commands to move data between PostgreSQL tables and CSV files — with auto-detection of delimiters, encoding, and…

pgmonkey (6/8) — The CLI Toolbox Summary: pgmonkey's CLI goes well beyond basic connectivity — it generates config files, tests connections across all four types, writes working Python code, recommends…

pgmonkey (5/8) — Environment Variables and Secrets Summary: Keep credentials out of your config files using pgmonkey's environment variable interpolation — inline ${VAR} substitution, structured from_env and from_file references, and…

pgmonkey (4/8) — Connection Pooling Summary: Configure and tune pgmonkey's connection pools — sync and async — with the right pool size, health checks, lifecycle limits, and concurrent access patterns…

pgmonkey (3/8) — Securing Connections with SSL/TLS Summary: Configure SSL/TLS encryption for your PostgreSQL connections — from basic encryption with require through full certificate verification with verify-full and client certificate…

pgmonkey (2/8) — Connection Types Summary: pgmonkey supports four connection types — normal, pool, async, and async_pool — all driven by the same YAML config file. Learn when to use…

pgmonkey (1/8) — Getting Started Summary: Install pgmonkey, generate a YAML configuration file, and run your first PostgreSQL query — all in under five minutes. KeyValueOS targetUbuntu 24.04 LTSPython version3.12pgmonkey…

pgmonkey: One Config File to Rule All Your PostgreSQL Connections Summary: pgmonkey is a Python library that unifies PostgreSQL connection management -- normal, pooled, async, and async-pooled -- behind a…

Advanced Make - Libraries, Linking, and Mixed Builds Summary: Build static and shared libraries with Make, link against external libraries using pkg-config, create mixed-language projects, and understand the debian/rules Makefile…