Postgres Container Apps (beta) • Hacker News Board

Re: Postgres Container Apps (beta)

#21

Post by paxys » Fri, Apr 01, 2022, 1:10 AM UTC

> Start a container with SELECT run_container('');

> Stop a container SELECT stop_container('');

This physically hurts me.

Heck being able to run a Docker container alongside your DB on the same server is probably useful, but why make it so gimmicky?

Re: Postgres Container Apps (beta)

#22

Post by throwthere » Fri, Apr 01, 2022, 1:16 AM UTC

plaur782 wrote: post #19

throwthere wrote: post #18

Aside— I can’t get your pricing page to work. Every aws config just says contact sales. Maybe it’s just a mobile thing.

I appreciate the heads up. You are trying this page ( https://www.crunchydata.com/products/crunchy-bridge/pricing/ ) and it isnt working for you?

Yes. I just dug deeper now and saw that you can get to the prices if you scroll to the right on mobile. It wasn’t obvious to me that there was more content to the right

Re: Postgres Container Apps (beta)

#23

Post by spacemanmatt » Fri, Apr 01, 2022, 1:31 AM UTC

CuriouslyC wrote: post #17

yetanother-1 wrote: post #14

Earlier quoted context omitted.

I love Postgresql, but I don't want it to end up like oracle, where it is the center of thr focus. That being said, I like the idea of Postgres as a platform for more than data tables storage and database engine. It proved quite powerful and useful.

The killer reason for "Postgres as a platform" is that Postgres has a robust* security model (there are edge cases, but for a subset of statements, it works well)

That is true, and most DBAs are fully aware that the security model is only as good as the extensions they load and docker integration is very likely low on the list of necessities.

Re: Postgres Container Apps (beta)

#24

Post by koolba » Fri, Apr 01, 2022, 2:07 AM UTC

Does this run the containers on the DB host itself? How’s that work with replication?

And what’s an actual end user application / use case for this? The post lists some examples but I don’t understand what it means to run them in a container on the DB.

Re: Postgres Container Apps (beta)

#25

Post by ChanderG » Fri, Apr 01, 2022, 3:18 AM UTC

Aside - this is a great example that shows how bad Google search has become. Seeing only the comments here, I tried to search for "pgpodman" not realizing that it's from this very article. Google only returns stuff about podman. Searching for "postgres pgpodman" only gets articles about pgAdmin.

DuckDuckGo gets this article as the first hit - top 4-5 links are all relevant.

Re: Postgres Container Apps (beta)

#26

Post by kkirsche » Sat, Apr 02, 2022, 11:19 AM UTC

pramsey wrote: post #9

The fact that PostgreSQL is pigeon-holed as a "database" blinds folks to the fact that it is also a full-fledged integration environment. It's a place where you can bind together multiple kinds of data and multiple kinds of application. * Use FDW connections to pull in data from all kinds of sources! Multiple databases, file formats, HTTP buckets, you name it! * Custom behaviours in multiple languages! PL/Python, PL/…

To help others who also don’t know all of the terms: 1. FDW: foreign data wrappers

https://wiki.postgresql.org/wiki/Foreign_data_wrappers

2. PL/Python: language-specific procedural language

https://www.postgresql.org/docs/10/plpython.html

Essentially, this (as I understand it) is highlighting the ways that Postgres can expose data from outside of its default table structure context via these types of functions.