this post was submitted on 19 Feb 2024
32 points (100.0% liked)

PostgreSQL

652 readers
15 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
32
Request for SQL experts: Lemmy PR to combine action tables (github.com)
submitted 9 months ago by dessalines@lemmy.ml to c/postgresql@programming.dev
13 comments fedilink hide all child comments
 

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?

you are viewing a single comment's thread
view the rest of the comments
[–] morrowind@lemmy.ml 9 points 9 months ago

I'm pretty sure the developers have better than chatgpt level knowledge. There's a reason they're asking for experts