The world's most advanced open source relational database
Project
- About (history)
- Docs
- Donate to PostgreSQL
- Wiki
- Planet PostgreSQL
- IRC
- Mailing lists:
- pgsql-announce
- pgsql-hackers (developers)
- pgsql-general
- pgsql-jobs
- User Groups
-
PostgreSQL @programming.dev Nemeski @lemm.ee www.postgresql.org openHalo Project is now Released!openHalo provides the capability to migrate MySQL to PostgreSQL with ZERO code change and provides much more better performance than …
-
PostgreSQL @programming.dev Nemeski @lemm.ee www.postgresql.org pgAdmin 4 v9.2 ReleasedThe pgAdmin Development Team is pleased to announce pgAdmin 4 version 9.2. This release of pgAdmin 4 includes 24 bug …
-
PostgreSQL @programming.dev fhoekstra @programming.dev Blog: fixing a broken CNPG cluster
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.
-
PostgreSQL @programming.dev Serpent7776 @programming.dev pg_worker_pool: extension creating a pool of background workers
github.com GitHub - serpent7776/pg_worker_pool: Postgres extension creating a pool of background workersPostgres extension creating a pool of background workers - serpent7776/pg_worker_pool
I'm doing an extension that creates a pool of named background workers. Happy to hear any feedback on this.
undefined
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,
fooandbar.foowill create an indices on tablemy_big_tableandbaron tableother_big_table.fooandbarwill run independently of each other, but all indices submitted to the same worker will be created in order. -
PostgreSQL @programming.dev Arnold Franke @chaos.social What are your experiences with jsonb columns as document store?
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 @programming.dev Jason Novinger @programming.dev notso.boringsql.com How not to change PostgreSQL column type | boringSQLLearn practical SQL & PostgreSQL techniques. Build rock-solid data systems with 'boring' database solutions that deliver reliability without the drama.
-
PostgreSQL @programming.dev daamien @lemmy.world 
www.postgresql.org PostgreSQL 17 Released!The [PostgreSQL Global Development Group](https://www.postgresql.org) today announced the release of [PostgreSQL 17](https://www.postgresql.org/docs/17/release-17.html), the latest version of the world's most advanced …
-
PostgreSQL @programming.dev lysdexic @programming.dev github.com GitHub - supabase/pg_jsonschema: PostgreSQL extension providing JSON Schema validationPostgreSQL extension providing JSON Schema validation - supabase/pg_jsonschema
-
PostgreSQL @programming.dev ericjmorey @programming.dev POSETTE: An Event for Postgres 2024 | 3rd annual virtual event organized by the Postgres team at Microsoft | 48 Hours of Virtual Presentations and Meetings Starting Tue, June 11 @ 3:00 PM UTC
www.citusdata.com POSETTE: An Event for Postgres 2024POSETTE 2024 is a wrap, but you can still watch all the talks! POSETTE: An Event for Postgres is a virtual and free developer event that happened on June 11-13 in 2024. Watch any or all of the 42 talks to learn what you can do with the world’s most advanced open source relational database—from the n...
-
PostgreSQL @programming.dev BrikoX @lemmy.zip github.com GitHub - tatut/pgprolog: PostgreSQL Prolog language handlerPostgreSQL Prolog language handler. Contribute to tatut/pgprolog development by creating an account on GitHub.
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.
-
PostgreSQL @programming.dev BrikoX @lemmy.zip PostgreSQL maintainer Simon Riggs has died in a small airplane crash
m6n.io Berkubernetus (@fuzzychef@m6n.io)PostgreSQL maintainer Simon Riggs has died in a small airplane crash, on Tuesday. For those who didn't know Simon, he's responsible for PostgreSQL Binary Replication and many big data features. He and I worked together at Greenplum 2006-2008. Postgres would not be the world-leading DB it is tod...
PostgreSQL maintainer Simon Riggs has died in a small airplane crash, on Tuesday.
For those who didn't know Simon, he's responsible for PostgreSQL Binary Replication and many big data features. He and I worked together at Greenplum 2006-2008. Postgres would not be the world-leading DB it is today if it weren't for him.
-
PostgreSQL @programming.dev Mac @programming.dev 
www.cybertec-postgresql.com Recovering Deleted Data From PostgreSQL TablesFour options in recovering deleted data. In this article we will show you four options how to restore your data.
-
PostgreSQL @programming.dev Mac @programming.dev 
xata.io Introducing pgzx: create PostgreSQL extensions using ZigWe are excited to introduce pgzx, a framework for creating Postgres extensions using the Zig programming language.
