PostgreSQL

662 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
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 6 months ago by mac to c/postgresql
0 comments fedilink
2
10
What are your experiences with jsonb columns as document store? (chaos.social)
submitted 2 weeks ago by [email protected] to c/postgresql
4 comments fedilink
 
 

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

3
4
How not to change PostgreSQL column type | boringSQL (notso.boringsql.com)
submitted 1 month ago by jnovinger to c/postgresql
0 comments fedilink
 
 

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

4
15
PostgreSQL 17 Released! (www.postgresql.org)
submitted 1 month ago by [email protected] to c/postgresql
0 comments fedilink
5
5
Improved query cancellation in PostgreSQL 17 and Psycopg 3.2 (blog.dalibo.com)
submitted 2 months ago by jnovinger to c/postgresql
1 comments fedilink
 
 

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

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

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

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

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

10
6
GitHub - tatut/pgprolog: PostgreSQL Prolog language handler (github.com)
submitted 7 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.

11
76
PostgreSQL maintainer Simon Riggs has died in a small airplane crash (m6n.io)
submitted 7 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

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

18
11
What’s new in the Postgres 16 query planner / optimizer (www.citusdata.com)
submitted 9 months ago by mac to c/postgresql
0 comments fedilink
19
4
Is it possible to upgrade PostreSQL from 14 to 16 directly when using containers? (social.touha.me)
submitted 9 months ago* (last edited 9 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

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