55

Note that unless you're a Lemmy instance admin, this doesn't have much use to you.

Until this package came along, if you wanted a bot that responds to events, you had to manually traverse all comments/posts/whatever at a fixed interval. With this package you can actually react to events directly from the database. It's implemented in a very efficient way by connecting the package directly to the Lemmy database and using native Postgres features to get the events (LISTEN/NOTIFY if you want to get technical).

The webhooks themselves are inserted into a separate SQLite database (API is coming) and allow for both simple and complex filtering of the incoming data. The system is already in use by two of my bots, @ChatGPT@lemmings.world and @DallE@lemmings.world who now both receive the information about being tagged in a comment in seconds (the actual reply takes a little longer, but that's because of the nature of the bot).

Currently you can be notified about a post or a comment, other types are trivial to include as well.

Let me know what you think!

top 21 comments
sorted by: hot top controversial new old
[-] Asudox@lemmy.world 6 points 10 months ago

This is awesome. I really like that. Hope it becomes an official optional setting you can turn on or off in the instance config.

[-] originalucifer@moist.catsweat.com 2 points 10 months ago

what are the resource use implications of something like this? will it scale well with a large instance?

[-] rikudou@lemmings.world 3 points 10 months ago

Yep, it uses pushing from the postgres to the webhook processor instead of polling for data periodically by an app. So after every insert, an event is pushed using the native postgres listen/notify mechanism and then the webhook processor doesn't interact with the database at all.

[-] originalucifer@moist.catsweat.com 2 points 10 months ago

yeah, but im seeing a reference to the doubling of my standing-processing as now i have an insert-after-event that didnt exist before... is that right?

i mean i get that youre pushing the processing to a different, functional mechanism, but its still additive processing on the server that needs accounting... and seems expanded.

[-] rikudou@lemmings.world 1 points 10 months ago

Yeah, everything you do takes processing power. This is done in a way that minimises the impact. There's no insert-after-event that I'm aware of. Also I'm not sure what you mean by expanded.

[-] originalucifer@moist.catsweat.com 1 points 10 months ago

Yeah, everything you do takes processing power. So after every insert, an event is pushed using the native postgres listen/notify mechanism

right, i was just curious how much processing this is. it gets expensive quick on a large instance, efficiency matters. might be negligible, but i watch my services like a hawk.

[-] rikudou@lemmings.world 3 points 10 months ago

This feels like a moot point. I promise you this is much more efficient than the rest of Lemmy is.

[-] Nerd02@lemmy.basedcount.com 1 points 10 months ago

Hey this is pretty cool! I wanted something similar for my instance, with a webhook notifying me of any application request, so I can get a notification and react as soon as possible. Well, I ended up having to implement that from scratch within my @AutoMod@lemmy.basedcount.com bot. A solution like this would probably be WAY more efficient than my current setup (with a client continuously polling for new applications). Good stuff!

[-] rikudou@lemmings.world 2 points 10 months ago

Should be simple to rewrite the bot to accept input from this! If you plan on doing so, let me know, I'll add support for the applications table.

[-] Nerd02@lemmy.basedcount.com 1 points 10 months ago

I have a bit too much stuff going on in my life right now to focus on changing my Lemmy stack, I'll have to stick to my current setup for the time being.

But I am very much interested in the package. Gonna leave a star on its repo and hopefully I'll remember to come back to this once my hands are a bit less full than they are now.

[-] solrize@lemmy.world 1 points 10 months ago

I'd rather have fewer bots on Lemmy, but from an implementation pov I wonder whether a pub-sub interface could keep up better with fast updates. Do webhooks make a new outgoing tls connection on every event?

[-] rikudou@lemmings.world 2 points 10 months ago

Pub-sub might work for some use cases, but it wouldn't work at all for mine. I host my bots on AWS Lambda so I don't pay for anything, unless the code is actually running. So the webhook essentially wakes the virtual machine up and after processing is done, it goes back to sleep.

Yeah, they make a new ongoing tls connection on every https webhook. Which doesn't necessarily mean all db events, there's quite powerful filtering available and everyone should use it, sending a ping for db events you don't need to seems quite wasteful.

[-] solrize@lemmy.world 2 points 10 months ago* (last edited 10 months ago)

If we maintain the fantasy (and we may as well) of Lemmy someday overtaking Reddit, that can mean 100s of new posts per second that bots might want to inspect. So that's quite a lot of vm restarts as well as load on the side sending out the webhook queries. I guess this stuff will have been redesigned a few more times by then though, so it is ok. Lemmy at the moment isn't ready for such volume for many other reasons too.

[-] rikudou@lemmings.world 3 points 10 months ago

Well, it stays warmed up some 15 seconds or so, but the important part is you don't pay for that uptime. And if my bots ever get to 100s of requests per second, I'm gonna have to shut them down, I'm not that rich.

[-] solrize@lemmy.world 1 points 10 months ago* (last edited 10 months ago)

It shouldn't be hard to handle 100s of requests per sec on a small vm. Where does your server side (the part listening to postgres events) run anyway?

I'm thinking of e.g. that stupid reddit bot that responds if all the words in someone's else's post are in alphabetical order. That isn't the type of filter you'd normally offer in a webhook API, so the bot has to listen to the "fire hose". But its outbound traffic won't be too large.

From a privacy standpoint I'd also consider a firehose feed preferable to a filtered one. Like if I want to count how many posts per day mention Taylor Swift, I might not want to reveal that interest. So I have to take in an unfiltered feed and do the counting in my own client.

There is a whole CS topic called Private Information Retrieval (PIR) that revolves around this idea, fwiw. The Wikipedia article about it is ok.

[-] rikudou@lemmings.world 2 points 10 months ago

It needs direct access to the db, so in my case it's on the same vm as my instance.

It theoretically could be done in the webhook filter, it's a full (but limited) language, I'd just need to add support for some functions.

Those are not really webhooks for public use but for the instance admins, so filtering by posts mentioning Taylor Swift should be more than enough. But yeah, you can just send everything to your bot if it can handle that.

[-] solrize@lemmy.world 1 points 10 months ago

Oh I see, thanks. I was imagining this being used by bot authors who don't want to run actual lemmy instances. This makes sense now, given that you want to run your bots on Lambda. I'd just run them on a VM but that's just me. Cloudflare Workers seems like another possibility.

[-] rikudou@lemmings.world 2 points 10 months ago

It's not only for the Lambda use case, my main motivation was AutoMods - they are very resource intensive currently and need to run very often. What you needed to do until this package, was traversing all new posts and all comments in there to check whether they're newer than the last post / comment you've moderated. Which is a lot of api requests every minute or two, you're essentially DDOSing yourself. With this, your AutoMod receives the information that a new comment was created and you can fetch the comment in a single (relatively inexpensive) api request, instead of plethora of requests which are all fairly expensive.

Whether the webhooks feature is then exposed to other users is really up to each instance admins, I'm thinking of exposing the functionality for my instance's users when I finish implementing all I have envisioned.

Of course bot authors can add support for webhook triggering which means the admins can then use it more effectively.

[-] solrize@lemmy.world 1 points 10 months ago

I see, that is a good application. How did Reddit deal with this issue? Lemmy does lots of dumb things by comparison it seems to me. I'd be surprised if reddit required constant polling from automods.

[-] rikudou@lemmings.world 1 points 10 months ago

No idea, I didn't do any api development with Reddit, it felt way too oversaturated already. But event subscriptions are a common thing for such use-cases, so my guess would be actually very similar to what I have created here with this package.

[-] solrize@lemmy.world 2 points 10 months ago

Fair enough, but it sounds like the subscription feature should really be built into Lemmy's API. That is, your package is a useful workaround for a shortcoming in Lemmy. It's probably worth fixing Lemmy directly

this post was submitted on 08 Jan 2024
55 points (96.6% liked)

Fediverse

28340 readers
175 users here now

A community to talk about the Fediverse and all it's related services using ActivityPub (Mastodon, Lemmy, KBin, etc).

If you wanted to get help with moderating your own community then head over to !moderators@lemmy.world!

Rules

Learn more at these websites: Join The Fediverse Wiki, Fediverse.info, Wikipedia Page, The Federation Info (Stats), FediDB (Stats), Sub Rehab (Reddit Migration), Search Lemmy

founded 1 year ago
MODERATORS