PostgreSQL

670 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
1
2
 
 

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
15
PostgreSQL 17 Released! (www.postgresql.org)
submitted 2 months ago by [email protected] to c/postgresql
5
6
12
submitted 4 months ago* (last edited 4 months ago) by jnovinger to c/postgresql
7
8
9
10
 
 

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
 
 

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
submitted 8 months ago by mac to c/postgresql
13
14
15
16
17
 
 

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
19
 
 

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

20
9
UUID Benchmark War (ardentperf.com)
submitted 10 months ago by agilob to c/postgresql
21
22
23
24
25
view more: next ›