PostgreSQL

637 readers
4 users here now

The world's most advanced open source relational database

Project
Events
Podcasts
Related Fediverse communities

founded 1 year ago
MODERATORS
Ategon@programming.dev
starman@programming.dev
jnovinger@programming.dev
listing: all - local
1
23
PostgreSQL 16.3, 15.7, 14.12, 13.15, and 12.19 Released! (www.postgresql.org)
submitted 4 months ago by mac@programming.dev to c/postgresql@programming.dev
0 comments fedilink
2
15
PostgreSQL 17 Released! (www.postgresql.org)
submitted 3 days ago by daamien@lemmy.world to c/postgresql@programming.dev
0 comments fedilink
3
3
How not to change PostgreSQL column type | boringSQL (notso.boringsql.com)
submitted 3 days ago by jnovinger@programming.dev to c/postgresql@programming.dev
0 comments fedilink
 
 

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

4
5
Improved query cancellation in PostgreSQL 17 and Psycopg 3.2 (blog.dalibo.com)
submitted 3 weeks ago by jnovinger@programming.dev to c/postgresql@programming.dev
1 comments fedilink
 
 

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

5
12
Adding a Primary Key To An Existing Table [via RoR] (www.stevenan.com)
submitted 1 month ago* (last edited 1 month ago) by jnovinger@programming.dev to c/postgresql@programming.dev
1 comments fedilink
 
 

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

6
14
GitHub - supabase/pg_jsonschema: PostgreSQL extension providing JSON Schema validation (github.com)
submitted 5 months ago by lysdexic@programming.dev to c/postgresql@programming.dev
0 comments fedilink
7
6
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)
submitted 5 months ago by ericjmorey@programming.dev to c/postgresql@programming.dev
0 comments fedilink
8
18
PostgreSQL Lands Support For Incremental Backups (www.phoronix.com)
submitted 5 months ago by jnovinger@programming.dev to c/postgresql@programming.dev
1 comments fedilink
 
 

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

9
6
GitHub - tatut/pgprolog: PostgreSQL Prolog language handler (github.com)
submitted 6 months ago by BrikoX@lemmy.zip to c/postgresql@programming.dev
0 comments fedilink
 
 

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.

10
76
PostgreSQL maintainer Simon Riggs has died in a small airplane crash (m6n.io)
submitted 6 months ago by BrikoX@lemmy.zip to c/postgresql@programming.dev
1 comments fedilink
 
 

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.

https://www.bbc.com/news/articles/cjex992z0wlo

11
11
Recovering Deleted Data From PostgreSQL Tables (www.cybertec-postgresql.com)
submitted 6 months ago by mac@programming.dev to c/postgresql@programming.dev
0 comments fedilink
12
7
Introducing pgzx: create PostgreSQL extensions using Zig (xata.io)
submitted 6 months ago by mac@programming.dev to c/postgresql@programming.dev
0 comments fedilink
13
6
Will PostgreSQL ever change its license? | Jonathan Katz (jkatz05.com)
submitted 6 months ago by mac@programming.dev to c/postgresql@programming.dev
0 comments fedilink
14
8
PGConf NYC 2024 - Call for Presentations (CFP) and Sponsors! (www.postgresql.org)
submitted 6 months ago by mac@programming.dev to c/postgresql@programming.dev
0 comments fedilink
15
11
PostgreSQL JDBC 42.7.3, 42.6.2, 42.5.6, 42.4.5, 42.3.10, 42.2.29 Released (www.postgresql.org)
submitted 6 months ago by mac@programming.dev to c/postgresql@programming.dev
0 comments fedilink
16
32
Request for SQL experts: Lemmy PR to combine action tables (github.com)
submitted 7 months ago by dessalines@lemmy.ml to c/postgresql@programming.dev
13 comments fedilink
 
 

Lemmy currently uses distinct tables like post_like: (post_id, person_id, score) and post_saved. Unfortunately this causes performance issues when we have to join many of these tables to create views.

One suggestion in this PR, is to combine these into a single post_action table, with a lot of optional columns depending on the action. This solution scares me a little, because I'm afraid we might lose data integrity, and many of our constraints with so many optional columns.

Is there a better way of doing this in SQL?

17
11
What’s new in the Postgres 16 query planner / optimizer (www.citusdata.com)
submitted 7 months ago by mac@programming.dev to c/postgresql@programming.dev
0 comments fedilink
18
4
Is it possible to upgrade PostreSQL from 14 to 16 directly when using containers? (social.touha.me)
submitted 7 months ago* (last edited 7 months ago) by dragnucs@social.touha.me to c/postgresql@programming.dev
1 comments fedilink
 
 

Is it possible to upgrade PostreSQL from 14 to 16 directly when using containers?
@postgresql

19
9
UUID Benchmark War (ardentperf.com)
submitted 7 months ago by agilob@programming.dev to c/postgresql@programming.dev
0 comments fedilink
20
8
The performance cost of pl/pgsql exception block in Postgres (dev.to)
submitted 8 months ago by Serpent7776@programming.dev to c/postgresql@programming.dev
0 comments fedilink
21
27
“But how much does a PostgreSQL license actually cost?” A Frequently Asked Question from Oracle users considering PostgreSQL (stormatics.tech)
submitted 8 months ago by jnovinger@programming.dev to c/postgresql@programming.dev
3 comments fedilink
22
2
One PID to Lock Them All: Finding the Source of the Lock in Postgres (www.crunchydata.com)
submitted 8 months ago by mac@programming.dev to c/postgresql@programming.dev
0 comments fedilink
23
2
Prague PostgreSQL Developer Day 2024 / Call for Papers & Sponsors (www.postgresql.org)
submitted 8 months ago by mac@programming.dev to c/postgresql@programming.dev
0 comments fedilink
24
3
How we migrated our PostgreSQL database with 11 seconds downtime - Government Digital Service (gds.blog.gov.uk)
submitted 8 months ago* (last edited 8 months ago) by starman@programming.dev to c/postgresql@programming.dev
0 comments fedilink
25
2
Waiting for Postgres 17: Incremental base backups (pganalyze.com)
submitted 8 months ago by starman@programming.dev to c/postgresql@programming.dev
0 comments fedilink
 
 

We walk through the incremental backup feature committed to the Postgres 17 development branch by Robert Haas. We show an example on our local machine.

view more: next ›