I came across this blog and thought it was a nice demonstration of the backup, recovery and migration options in CNPG, and the cloud-native way of working in a tough situation: treat your servers as cattle, not as pets. Spin up a new container and kill the problematic old one.

I'm doing an extension that creates a pool of named background workers. Happy to hear any feedback on this.

CREATE EXTENSION pg_worker_pool;
CALL worker_pool.submit('foo', 'create index myindex_1 on my_big_table (id)');
CALL worker_pool.submit('foo', 'create index myindex_1 on my_big_table (name)');
CALL worker_pool.submit('bar', 'create index otherindex_2 on other_big_table (author)');
CALL worker_pool.submit('bar', 'create index otherindex_2 on other_big_table (title)');

This will start two background workers, foo and bar. foo will create an indices on table my_big_table and bar on table other_big_table. foo and bar will run independently of each other, but all indices submitted to the same worker will be created in order.

What are your experiences with @postgresql jsonb columns as document store?

Is it easy to use from a Spring App? How fast is it? What are its limitations?

#postgresql #json #databases

Via https://fosstodon.org/@hunleyd/113205392466307810

Via https://fosstodon.org/@hunleyd/113080821469886930

Via https://mastodon.social/@stevenan/112899205276153700

Via https://mastodon.social/@hunleyd@fosstodon.org/112220150255942506

Prolog language for PostgreSQL

This is a PostgreSQL extension that allows writing stored procedures in Prolog.

This embeds Scryer Prolog into a PostgreSQL extension.

Proof of concept! Not ready for any actual use.