link

joined 2 years ago
MODERATOR OF
yesyesyesno
sorted by: new top controversial old
Today is Romania's national day! in c/europe@feddit.de
[–] link@lemy.lol 3 points 2 years ago

🎉 🎉

Discuit just went open source, could federation be next? in c/fediverse@lemmy.world
[–] link@lemy.lol 11 points 2 years ago (6 children)

Its website is looking good.

Average Lemmy Active Users by Month in c/fediverse@lemmy.world
[–] link@lemy.lol 9 points 2 years ago* (last edited 2 years ago) (4 children)

Users who posts or comments. I’m not sure about votes tho 🤔

Edit: its posts or comments. No lurkers. I think they should include voters to get an actual number.

[ NEW BETA RELEASE ] Mlem for Lemmy 1.1.1 RC 0: Lemmy 0.19 Support in c/mlemapp@lemmy.ml
[–] link@lemy.lol 3 points 2 years ago (1 children)

0.19 RC.4 was working with Mlem but RC.5 broke it.

I’m getting ‘incorrect login’ and ‘Unable to decode’ errors on previously logged accounts.

I wish I could provide more info but I don’t have 🫤

Is this instance NSFW friendly? in c/meta@lemy.lol
Ways to remove child when parent deleted in 1:1 relation in c/postgresql@programming.dev
[–] link@lemy.lol 1 points 2 years ago

Yep, I guess I should control it from software side.

Ways to remove child when parent deleted in 1:1 relation in c/postgresql@programming.dev
[–] link@lemy.lol 1 points 2 years ago (2 children)

What do you suggest for not using an image more than once? It bothers me too that image table is in non-standard use.

The thing is, image table used on 4 other tables and if I want to put FK on image table I have to:

  • Add 4 optional foreign keys to the image table and use only one
  • Create 4 different image table that each of them related to the related 4 tables

Neither of these looking ideal to me.

Ways to remove child when parent deleted in 1:1 relation in c/postgresql@programming.dev
[–] link@lemy.lol 2 points 2 years ago (4 children)

But image is used more than once, so its ideal to keep image independent from other tables.

Ways to remove child when parent deleted in 1:1 relation in c/postgresql@programming.dev
[–] link@lemy.lol 1 points 2 years ago

I've been avoiding triggers, but I guess there's no better alternative. Thanks.

25
Ways to remove child when parent deleted in 1:1 relation (lemy.lol)
submitted 2 years ago* (last edited 2 years ago) by link@lemy.lol to c/postgresql@programming.dev
8 comments fedilink
 

Example flow is on the image. Here I want to accomplish if playlist removed, make it delete image too.

I know I should've put FK on image table but Image is generic and its used more than once.

What are my options? Triggers and application-side comes to mind, but I'm not sure. Maybe there is a better way.

UPDATE: I guess I've found what I was looking for, rules:

CREATE RULE playlist_delete AS ON DELETE TO playlist WHERE (SELECT id FROM image WHERE image.id = OLD.image_id) IS NOT NULL DO INSTEAD NOTHING;

Changes to Germany's skilled immigration rules take effect in c/europe@feddit.de
[–] link@lemy.lol 1 points 2 years ago

I need a sponsor uWu 👉 👈

Lemmy 0.19.0-rc.5 and Development Update 2023-11-17 in c/lemmy@lemmy.ml
Love the new icon! in c/mlemapp@lemmy.ml
[–] link@lemy.lol 6 points 2 years ago

Yeah I’m on original icon gang too 😅

6
corner flag sad edit (lemy.lol)
3
meanwhile in turkish tv shows (lemy.lol)
 

cross-posted from: https://lemy.lol/post/14401384

via /user/Glad-Internet-7894

2
betrayal (lemy.lol)
13
Notification support? (lemy.lol)
 

Currently, as far as I understand, there is no notification support. May I ask, is it on roadmap?

view more: ‹ prev next ›