[openstreetmap/openstreetmap-website] Add the ability to rate limit edits (PR #4319)

Roland Olbricht notifications at github.com
Mon Oct 30 10:39:09 UTC 2023


> Talking about the API is irrelevant anyway because the server code doesn't use the API or parse XML to do things like this, it would just execute `current_user.changesets.sum(:num_changes)` but that will turn into something like:
> 
> ```sql
> SELECT SUM("changesets"."num_changes") FROM "changesets" WHERE "changesets"."user_id" = $1
> ```

Can we take advantage of `changesets_user_id_created_at_idx` and look only into the last hour or last 24 hours or so?

-- 
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/openstreetmap-website/pull/4319#issuecomment-1784912382
You are receiving this because you are subscribed to this thread.

Message ID: <openstreetmap/openstreetmap-website/pull/4319/c1784912382 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/rails-dev/attachments/20231030/1bf8f168/attachment-0001.htm>


More information about the rails-dev mailing list