Email or username:

Password:

Forgot your password?
dansup's posts Post Back to profile
dansup

I'm starting to notice some bad decisions I made regarding @pixelfed database structure

In 2018 when I first started Pixelfed, I took a lot of inspiration from Mastodon, and while their DB structure makes sense for them, I'm realizing that it's starting to limit us

Storing posts, replies, and shares in a single table doesn't make sense for us

Fixing this will be fun, I love challenges and look forward to blogging about it after a seamless deployment.

The goal is to make this unnoticeable 😎

11 September at 11:34 | Open on mastodon.social
8 comments
Captain Steph
dansup

@sirber @pixelfed [statuses] [status_replies] [status_shares] basically moving the replies (in_reply_to_id) and reblogs (reblog_of_id) into their own tables

11 September at 11:37 | Open on mastodon.social
Captain Steph

@dansup @pixelfed smaller tables is generally good, index wise

11 September at 11:42 | Open on fosstodon.org
wikiyu

@dansup @pixelfed

Years ago when i was younger i would suggest "procedure" approach -> move all DB stuff to as encapsulated procedures as possible (crud)

then making a migration BUT with stay on application side to procedures that are changed with migration.

Now? I dont know, i didnt thought about stuff like that for at least 4? 5? years as i am doing a bit different part of it development now then then.

11 September at 11:37 | Open on infosec.exchange
dansup

@wikiyu @pixelfed Well, we do use Laravel, so we can make versioned migrations but this is a bit more complex than a simple migration.

Data needs to be slowly synced to prevent downtime

11 September at 11:39 | Open on mastodon.social
wikiyu

@dansup @pixelfed

Do you really need "no downtime"?

I think that stuff like that doesnt have to be done seamless...

More important is stability and being sure of doing it right, then "no downtime"

11 September at 11:41 | Open on infosec.exchange
Henri

@dansup I think this is just copying the Twitter concept of a tweet?

11 September at 11:46 | Open on mdon.ee
kcarruthers

@dansup data architecture is often a gotcha. Good luck.

11 September at 23:45 | Open on mastodon.social
Go Up