pirsch-analytics / pirsch

Pirsch is a drop-in, server-side, no-cookie, and privacy-focused analytics solution for Go.
https://pirsch.io
GNU Affero General Public License v3.0
928 stars 43 forks source link

Filter bots using IP lists #264

Closed Kugelschieber closed 2 years ago

Kugelschieber commented 2 years ago

https://github.com/jhassine/server-ip-addresses https://github.com/Umkus/ip-index https://github.com/firehol/blocklist-ipsets Udger (paid but looks nice, Support hasn't responded yet)

Also, remove the page visit limit afterward.

select ip
from udger_ip_list l
join udger_ip_class c on l.class_id = c.id
where c.id != 100
;

select *
from udger_datacenter_range r
join udger_datacenter_list l on r.datacenter_id = l.id
;

select *
from udger_datacenter_range6 r
join udger_datacenter_list l on r.datacenter_id = l.id
;