How do I shrink my ktistec database?

[vrthra]

At this point, my Ktistec database is over 1 GB. I would like to shrink this database by removing older information except for my followers and followed, the posts I liked and the posts I posted. Is this possible?

[toddsundsted]

@vrthra it's definitely possible but it would take some careful work on the database right now. there are no triggers, for example, that delete associated rows in other tables if you delete an object you don't want, for example.

how set are you on keeping only those specific things? my database is up around 1GB, and while i'm fine with that, i can see a day coming where i might want to trim it down—however, i would want to keep my posts/shares/likes, as well as the objects i shared/liked and replied to. i'd also want to keep full threads (replies to my posts), and any objects that have hashtags/mentions that i've followed in the past. and probably the last 30-60 of posts, generally.

[vrthra]

Hi @toddsundsted, I am happy to keep all the objects you mentioned too.

[toddsundsted]

the next major release is going to focus on server/database maintenance, and i'll tackle this then. i have the same problem, and while a huge database has stress tested things like my queries, it's not handy. no ETA yet, however.