search

toddsundsted / ktistec

Single user ActivityPub (https://www.w3.org/TR/activitypub/) server.
GNU Affero General Public License v3.0
350 stars 21 forks source link

Question: Mass- and auto-deleting posts #89

Closed JayVii closed 6 months ago

JayVii commented 6 months ago

Is there a way to delete old posts by a SQL-query? Are they gone, when they are deleted from the database or are more steps necessary?

Unfortunately I do not quite get what the deletion class in ktistec actually does.

toddsundsted commented 6 months ago

@JayVii i'd like to consolidate this into https://github.com/toddsundsted/ktistec/issues/77

i think they cover the same concern. generally you could just use SQL to delete a bunch of old posts, and the server should just work correctly (and if it doesn't i'm happy to fix that). however, i think there's a more graceful solution to trimming the database that preserves the things you might want preserved (posts with a hashtag you're particularly interested in, for example).

toddsundsted commented 6 months ago

(the Delete class just represents the ActivityPub Delete activity, which transmits actor and object deletions between federated instances. it doesn't do any deleting.)

JayVii commented 6 months ago

@JayVii i'd like to consolidate this into #77

Yes, absolutely! Thanks a lot