How to remove API key rate limit?

[devrsi0n]

Thanks for your hard work, really appreciate it! 👍

I would like to use API keys to access the stats API, but the doc says it has a rate limit, I want to know how to remove it on self-hosted version. Tried to search it in this repo, but didn't find the luck.

Thank you for your time.

[ukutaht]

There's no way to do it through the UI but you can directly change the request limits in the database.

1. Access the postgres database: How to access the postgres and clickhouse database in self hosted version #621 (comment)
2. UPDATE api_keys set hourly_request_limit=99999999

[devrsi0n]

@ukutaht Thank you so much for your help, I also figured it out by searching the keyword 600 in the source code.

Here are my commands to fix it:

Run psql via docker

docker exec -it plausible_plausible_db_1 psql -U postgres

Run psql

# list databases
\l

# Switching Databases
\c api_keys

# Expanded display
\x

# List the data
SELECT * FROM public.api_keys;

# Update the field with max value of integer
UPDATE public.api_keys SET hourly_request_limit = 2147483647;