PostgreSQL

618 readers
1 users here now

The world's most advanced open source relational database

Project
Events
Podcasts
Related Fediverse communities

founded 1 year ago
MODERATORS
[email protected]
[email protected]
[email protected]
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 [email protected] to c/[email protected]
0 comments fedilink
2
12
Adding a Primary Key To An Existing Table [via RoR] (www.stevenan.com)
submitted 2 weeks ago* (last edited 2 weeks ago) by [email protected] to c/[email protected]
1 comments fedilink
 
 

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

3
14
GitHub - supabase/pg_jsonschema: PostgreSQL extension providing JSON Schema validation (github.com)
submitted 3 months ago by [email protected] to c/[email protected]
0 comments fedilink
4
5
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 3 months ago by [email protected] to c/[email protected]
0 comments fedilink
5
18
PostgreSQL Lands Support For Incremental Backups (www.phoronix.com)
submitted 4 months ago by [email protected] to c/[email protected]
1 comments fedilink
 
 

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

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

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

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

14
10
What’s new in the Postgres 16 query planner / optimizer (www.citusdata.com)
submitted 6 months ago by [email protected] to c/[email protected]
0 comments fedilink
15
5
Is it possible to upgrade PostreSQL from 14 to 16 directly when using containers? (social.touha.me)
submitted 6 months ago* (last edited 6 months ago) by [email protected] to c/[email protected]
1 comments fedilink
 
 

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

16
9
UUID Benchmark War (ardentperf.com)
submitted 6 months ago by [email protected] to c/[email protected]
0 comments fedilink
17
8
The performance cost of pl/pgsql exception block in Postgres (dev.to)
submitted 6 months ago by [email protected] to c/[email protected]
0 comments fedilink
18
27
“But how much does a PostgreSQL license actually cost?” A Frequently Asked Question from Oracle users considering PostgreSQL (stormatics.tech)
submitted 6 months ago by [email protected] to c/[email protected]
3 comments fedilink
19
7
One PID to Lock Them All: Finding the Source of the Lock in Postgres (www.crunchydata.com)
submitted 7 months ago by [email protected] to c/[email protected]
0 comments fedilink
20
9
Prague PostgreSQL Developer Day 2024 / Call for Papers & Sponsors (www.postgresql.org)
submitted 7 months ago by [email protected] to c/[email protected]
0 comments fedilink
21
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 [email protected] to c/[email protected]
2 comments fedilink
 
 

GDS is leading the digital transformation of the UK government.

22
5
Waiting for Postgres 17: Incremental base backups (pganalyze.com)
submitted 7 months ago by [email protected] to c/[email protected]
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.

23
29
Don't Do This - PostgreSQL wiki (wiki.postgresql.org)
submitted 7 months ago by [email protected] to c/[email protected]
1 comments fedilink
24
15
Nine ways to shoot yourself in the foot with PostgreSQL (philbooth.me)
submitted 7 months ago by [email protected] to c/[email protected]
1 comments fedilink
25
4
Query Exercise: Find Posts with the Wrong CommentCount (smartpostgres.com)
submitted 7 months ago by [email protected] to c/[email protected]
0 comments fedilink
 
 

Via https://mstdn.social/@michristofides/111738621686733546

There's a fun looking new weekly #PostgreSQL newsletter from Brent Ozar (one of my favourite authors from the SQL Server community).

From this week's post: "But… I’m a DBA, and you know what DBA stands for: Doesn’t Believe Anyone"

view more: next ›