[HN Gopher] Postgres Container Apps (beta)
___________________________________________________________________
Postgres Container Apps (beta)
Author : mattrighetti
Score : 45 points
Date : 2022-03-31 14:32 UTC (8 hours ago)
(HTM) web link (blog.crunchydata.com)
(TXT) w3m dump (blog.crunchydata.com)
| jasonpbecker wrote:
| 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.
| craigkerstiens wrote:
| 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.
| ramses0 wrote:
| 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
| jbverschoor wrote:
| Is it April 1st yet? Or simply technology creating a problem,
| because it really couldn't find the problem for itself?
| craigkerstiens wrote:
| 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.
| spousty wrote:
| Is there is a Github repo for this?
| adlpz wrote:
| 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!
| eatonphil wrote:
| Forth-like VM inside PL/pgSQL.
|
| https://notes.eatonphil.com/exploring-plpgsql-forth-like.htm...
| zinclozenge wrote:
| that's basically supabase.io
| pramsey wrote:
| or https://crunchybridge.com
| plaur782 wrote:
| Evidently it is smooshing:
|
| https://redmonk.com/jgovernor/2022/03/31/on-postgres-contain...
| pramsey wrote:
| 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.
| yetanother-1 wrote:
| 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.
| layer8 wrote:
| Sounds like the Emacs of database systems.
___________________________________________________________________
(page generated 2022-03-31 23:00 UTC)