Postgres Container Apps (beta)

#1

Post by mattrighetti » Thu, Mar 31, 2022, 2:32 PM UTC

Postgres Container Apps (beta)
blog.crunchydata.com

Re: Postgres Container Apps (beta)

#2

Post by jbverschoor » Thu, Mar 31, 2022, 4:14 PM UTC

Is it April 1st yet? Or simply technology creating a problem, because it really couldn't find the problem for itself?

Re: Postgres Container Apps (beta)

#3

Post by craigkerstiens » Thu, Mar 31, 2022, 4:16 PM UTC

jbverschoor wrote: post #2

Is it April 1st yet? Or simply technology creating a problem, because it really couldn't find the problem for itself?

My biggest regret of this launch is actually not launching it on April 1. The best April fools jokes turn out to be real things.

Re: Postgres Container Apps (beta)

#4

Post by adlpz » Thu, Mar 31, 2022, 4:33 PM UTC

I feel like the whole programmer community is literally running out of things to try. And this is the result.

And somehow I find it really intriguing.

Next PaaS prediction: hosted Postgres with PL/v8, pgpodman, pg_graphql and PostgREST. Run everything inside your DB!

Re: Postgres Container Apps (beta)

#5

Post by jasonpbecker » Thu, Mar 31, 2022, 4:40 PM UTC

I think the use cases in this announcement are well-laid out. There's not _a ton_ that I think fits well for these container apps, but pganalyze or New Relic monitoring etc are great examples. Some of this stuff being just _a little bit easier_ to maintain and manage is a big help to smaller teams.

Re: Postgres Container Apps (beta)

#6

Post by craigkerstiens » Thu, Mar 31, 2022, 4:44 PM UTC

jasonpbecker wrote: post #5

I think the use cases in this announcement are well-laid out. There's not _a ton_ that I think fits well for these container apps, but pganalyze or New Relic monitoring etc are great examples. Some of this stuff being just _a little bit easier_ to maintain and manage is a big help to smaller teams.

Thanks! There is definitely a full range, from being a "science project" running things like varnish or Redis from inside PG. The turnkey apps are maybe really easy and useful in certain cases. But you nailed it with some that are really just simple but practical like pganalyze. For us it's a lot of fun because you have practical, but then can do the absolute crazy things because sometimes software engineering should be fun.

Re: Postgres Container Apps (beta)

#7

Post by zinclozenge » Thu, Mar 31, 2022, 4:50 PM UTC

adlpz wrote: post #4

I feel like the whole programmer community is literally running out of things to try. And this is the result. And somehow I find it really intriguing. Next PaaS prediction: hosted Postgres with PL/v8, pgpodman, pg_graphql and PostgREST. Run everything inside your DB!

that's basically supabase.io

Re: Postgres Container Apps (beta)

#8

Post by ramses0 » Thu, Mar 31, 2022, 5:24 PM UTC

craigkerstiens wrote: post #6

jasonpbecker wrote: post #5

I think the use cases in this announcement are well-laid out. There's not _a ton_ that I think fits well for these container apps, but pganalyze or New Relic monitoring etc are great examples. Some of this stuff being just _a little bit easier_ to maintain and manage is a big help to smaller teams.

Thanks! There is definitely a full range, from being a "science project" running things like varnish or Redis from inside PG. The turnkey apps are maybe really easy and useful in certain cases. But you nailed it with some that are really just simple but practical like pganalyze. For us it's a lot of fun because you have practical, but then can do the absolute crazy things because sometimes software engineering should…

vis: https://couchapp.readthedocs.io/en/latest/intro/what-is-couc...

CouchDB supports "select index.html && index.js from my_couchdb.some_app" so you can have a UI bundled with your DB Blob. Additionally, since the UI is "just some documents", technically they can update + sync to other distributed DB's.

It's a very interesting concept to make apps more cohesive by including (not just HTML+JS), but also a full docker container that could talk to the datastore w/o any intermediaries.

We're finally coming full circle with PHP5's bundling of SQLite, and are instead having Postgres effectively bundling PHP. :-P

Re: Postgres Container Apps (beta)

#9

Post by pramsey » Thu, Mar 31, 2022, 5:34 PM UTC

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/Perl, PL/R!

* Read and write to web services! (PL/Python, pgsql-http)

* And now string together arbitrary containers! (pgpodman)

The way the extension system and the type system play together, it really is a very generic place to build weird integrated systems.

Re: Postgres Container Apps (beta)

#10

Post by plaur782 » Thu, Mar 31, 2022, 5:54 PM UTC

adlpz wrote: post #4

I feel like the whole programmer community is literally running out of things to try. And this is the result. And somehow I find it really intriguing. Next PaaS prediction: hosted Postgres with PL/v8, pgpodman, pg_graphql and PostgREST. Run everything inside your DB!

Evidently it is smooshing:

https://redmonk.com/jgovernor/2022/03/31/on-postgres-contain...