postgresql
3 series · 3 posts
Series
Jenkins CI/CD
Unlock the power of Jenkins CI/CD in your development workflow! This introduction covers essential prerequisites, including understanding the contrasting roles of the controller and agent, and highlights the groundbreaking concept of "Pipeline as Code." With a verified build agent equipped with Python, Docker, and Git, you’ll elevate your automation process, ensuring reproducibility and efficiency while embracing best practices for a robust development environment.
- 1Jenkins CI/CD (1/11): Prerequisites and Mental Model
- 2Jenkins CI/CD (2/11): Create the Minimal Repo and Prove Local Tests Run
- 3Jenkins CI/CD (3/11): First Jenkins Job With a Jenkinsfile
- 4Jenkins CI/CD (4/11): Test Reporting With JUnit Results in Jenkins
- 5Jenkins CI/CD (5/11): Fast-Fail Static Checks With a Lint Stage
- 6Jenkins CI/CD (6/11): Integration Tests With Docker Compose
- 7Jenkins CI/CD (7/11): Artifacts and Debugging Failed Builds
- 8Jenkins CI/CD (8/11): Workspace Cleanup, Timeouts, and Retries
- 9Jenkins CI/CD (9/11): Concurrency and Port Conflicts
- 10Jenkins CI/CD (10/11): Release Pipeline — Build Artifacts on Tags
- 11Jenkins CI/CD (11/11): Publish to PyPI Securely
GitHub Actions CI/CD
In this exhilarating first part of a ten-part series on GitHub Actions CI/CD, you embark on creating the "helloci" Python package. It features a simple yet powerful greeting function and a user-friendly CLI entry point. The journey begins with project setup, encapsulating best practices in Python packaging and laying the groundwork for automated tests. Get ready to transform your coding experience!
- 1GitHub Actions CI/CD (1/10): Make It a Package You Can Test
- 2GitHub Actions CI/CD (2/10): Unit Tests — Fast Feedback
- 3GitHub Actions CI/CD (3/10): Quality Gate Before Tests — Lint and Formatting
- 4GitHub Actions CI/CD (4/10): Your First CI Workflow — Run on Every PR
- 5GitHub Actions CI/CD (5/10): Matrix Testing — Multiple Python Versions
- 6GitHub Actions CI/CD (6/10): Integration Tests — Real Dependencies in CI
- 7GitHub Actions CI/CD (7/10): Branch Protection — Make CI a Merge Gate
- 8GitHub Actions CI/CD (8/10): Artifacts — Keep Evidence From a Run
- 9GitHub Actions CI/CD (9/10): Release Workflow — Tag, Build, Publish
- 10GitHub Actions CI/CD (10/10): Going Professional — Split Jobs, Caching, and Nightly Builds
pgmonkey
Alright, so here's the gist: You can get started with pgmonkey in under five minutes. Just set up your project folder, install pgmonkey, and create a YAML config file. After tweaking it for your database, test your connection and run a simple Python query. Easy peasy!
- 1pgmonkey (1/8) — Getting Started
- 2pgmonkey (2/8) — Connection Types
- 3pgmonkey (3/8) — Securing Connections with SSL/TLS
- 4pgmonkey (4/8) — Connection Pooling
- 5pgmonkey (5/8) — Environment Variables and Secrets
- 6pgmonkey (6/8) — The CLI Toolbox
- 7pgmonkey (7/8) — CSV Import and Export
- 8pgmonkey (8/8) — Production Patterns
Posts
pgmonkey: One Config File to Rule All Your PostgreSQL Connections
pgmonkey is a handy Python library that simplifies PostgreSQL connection management with just one YAML config file. It supports multiple connection types—like sync, async, and pooled—while handling caching and lifecycle tasks seamlessly. Ideal for projects with mixed connection needs, it saves developers from configuration chaos. Worth checking out!
Feb 17, 2026QNAP Container Station Docker Setup (Postgres with SSL Certificate)
2023 - How to run postgres as a docker container in QNAP using Container Station and have data persist on a local share directory using bind mounts.
Dec 11, 2023Ubuntu: Install PostgreSQL With pgAdmin4
A quickstart guide that includes the part how to connect pgAdmin4 to your local postgresql install by registering your server after installing PostgreSQL and pgAdmin4.
Oct 22, 2022
You must be logged in to post a comment.