How can I organize traffic filtering on Cisco?

Question

Cisco

It is necessary to organize traffic filtering according to white and black lists.
CISCO2911-SEC/K9 router Postgresql
list database running with python on the site there will be an admin panel for adding sites to the list I think to organize on squid that works with http and with additional https settings.
Guys, please help, what do you think about this?

Answer 1

You can simply and directly - unload the database by cron and change the necessary acl on the tsiska. And you can, if you want to be smarter, cheat with the radius and av-pairs

Answer 2

The clumsy method had to be done somehow: resolve the IP by DNS name with a script, form a list, use expect, connect to Cisco via telnet and apply it to the interface.
Although you have Squid - it can filter without Cisco.