

Are you using postgresql 18? I tried upgrading yesterday from 17.6 and got an identical error message.


Are you using postgresql 18? I tried upgrading yesterday from 17.6 and got an identical error message.


Welp, the fourth one can’t happen. Posts or comments by users won’t be stored in the database, so you can’t calculate “karma” for users.
The others are left to the community mods’ implementations.


Unfortunately there is also a need for automatic moderation.
Humans can’t catch everything.
By the way, mind telling me what was the most infuriating thing about Reddit’s automod to you?


All can be made except that “r9k” mode. I don’t plan on storing posts OR comments at all. I DO plan on giving each community a small key-value database so they can store some stuff, but I am not sure how many hashes of posts it could hold.
I wouldn’t define “stat tracking” as appropriate for an automod, but the implementation will be left to mods so I don’t really have any say in that. It can be made.


All dependent on the implementation. As said in other comments, the design I have in mind is letting community mods define the automod’s behaviour in their community by writing scripts in a language like Lua in a sandboxed environment.
So you can make the bot do pretty much anything within the boundaries of the community.


yeah sure


The kind of automod I am building is not only for Lemmy. It also does not depend on any API. It’s a completely new ActivityPub platform just for automoderation. Any platform that mainly uses Group actors and supports moderation on them can be made compatible with it, with full integration of the platform’s moderation features.


All of them are possible with my current design plan, which is allowing mods to write the functionality themselves (instead of predefining them like in some other automods) in sandboxed Lua (might change).
I might still predefine some myself for performance.


Of course. Reddit’s automod is very simple.
My current design plan is leaving the implementation to community mods by embedding sandboxed Lua (might change).


For automated ones, sure. But if you just want to schedule some post you made, that functionality is already available in Piefed and will be available in Lemmy in the next 1.0.0 release as well.
Why is the source cose in privatebin?