PostgreSQL

627 readers
6 users here now

The world's most advanced open source relational database

Project
Events
Podcasts
Related Fediverse communities

founded 1 year ago
MODERATORS
Ategon
starman
jnovinger
listing: all - local
1
23
PostgreSQL 16.3, 15.7, 14.12, 13.15, and 12.19 Released! (www.postgresql.org)
submitted 3 months ago by mac to c/postgresql
0 comments fedilink
2
5
Improved query cancellation in PostgreSQL 17 and Psycopg 3.2 (blog.dalibo.com)
submitted 3 days ago by jnovinger to c/postgresql
1 comments fedilink
 
 

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

3
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 to c/postgresql
1 comments fedilink
 
 

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

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

Via https://mastodon.social/@[email protected]/112220150255942506

7
6
GitHub - tatut/pgprolog: PostgreSQL Prolog language handler (github.com)
submitted 5 months ago by [email protected] to c/postgresql
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.

8
76
PostgreSQL maintainer Simon Riggs has died in a small airplane crash (m6n.io)
submitted 5 months ago by [email protected] to c/postgresql
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

9
11
Recovering Deleted Data From PostgreSQL Tables (www.cybertec-postgresql.com)
submitted 5 months ago by mac to c/postgresql
0 comments fedilink
10
7
Introducing pgzx: create PostgreSQL extensions using Zig (xata.io)
submitted 5 months ago by mac to c/postgresql
0 comments fedilink
11
6
Will PostgreSQL ever change its license? | Jonathan Katz (jkatz05.com)
submitted 5 months ago by mac to c/postgresql
0 comments fedilink
12
8
PGConf NYC 2024 - Call for Presentations (CFP) and Sponsors! (www.postgresql.org)
submitted 5 months ago by mac to c/postgresql
0 comments fedilink
13
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 5 months ago by mac to c/postgresql
0 comments fedilink
14
32
Request for SQL experts: Lemmy PR to combine action tables (github.com)
submitted 6 months ago by [email protected] to c/postgresql
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?

15
11
What’s new in the Postgres 16 query planner / optimizer (www.citusdata.com)
submitted 7 months ago by mac to c/postgresql
0 comments fedilink
16
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 [email protected] to c/postgresql
1 comments fedilink
 
 

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

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

24
31
Don't Do This - PostgreSQL wiki (wiki.postgresql.org)
submitted 8 months ago by jnovinger to c/postgresql
1 comments fedilink
25
15
Nine ways to shoot yourself in the foot with PostgreSQL (philbooth.me)
submitted 8 months ago by jnovinger to c/postgresql
1 comments fedilink
view more: next ›