To help out everyone else, this is designed for those working on PostgreSQL development. For anyone who is just using PostGres as part of their application, use normal PostGreSQL container.
Honest question. Do you recommend a "devcontainer" for this? Like a Docker image that maybe has both postgres and your development environment preinstalled inside? Or do you generally like to use and reference an external docker container instance (with postgres installed) and connect to it from your devcontainer instance?
So if I'm building Python application with Prometheus/RabbitMQ/PostGres that's used as part of my application, My docker compose has network, those 3 services + Python Dev Container and I just reference the hostname of the service in my Python application config (ENV VARS).
pg-dev-container is a ready-to-run VS Code development container that includes:
- PostgreSQL source code and build tools
- A debug build of PostgreSQL
- A pre-configured debugger for step-through debugging
- Sample extensions
- A brief guide on how to compile, install, and debug a simple extension
It's an interesting idea but it seems like a lot of resources will get tied up on my dev box.
To help out everyone else, this is designed for those working on PostgreSQL development. For anyone who is just using PostGres as part of their application, use normal PostGreSQL container.
Honest question. Do you recommend a "devcontainer" for this? Like a Docker image that maybe has both postgres and your development environment preinstalled inside? Or do you generally like to use and reference an external docker container instance (with postgres installed) and connect to it from your devcontainer instance?
I tend to use dev containers with docker compose.
So if I'm building Python application with Prometheus/RabbitMQ/PostGres that's used as part of my application, My docker compose has network, those 3 services + Python Dev Container and I just reference the hostname of the service in my Python application config (ENV VARS).
You can set it up with docker compose and put the container on the same network of your dev env, and you are good to go.
What I'd really like is an image that mirrors extensions available on AWS Aurora. Supabase's is the only that has some parity as far as I know
pg-dev-container is a ready-to-run VS Code development container that includes:
- PostgreSQL source code and build tools - A debug build of PostgreSQL - A pre-configured debugger for step-through debugging - Sample extensions - A brief guide on how to compile, install, and debug a simple extension
Via
https://www.linkedin.com/feed/update/urn:li:activity:7417691...