It’s pretty typical of most lib “solutions” - which essentially are non-solutions - of funding do-nothing programs with someone else’s money, and growing the size of gov’t and any bureaucracy they can.
The solution is to kill the shooter before he can do any damage: zero recidivism. People who are that far gone into madness and the desire for slaughter, probably should just be dispatched from this world. JMO.
That doesn’t prevent it from starting, only possibly from getting worse.
The best way to prevent such things is to stop pussy-footing around jackasses and psychos, and punish them as appropriate. Being serious about jailing and treating crooks as the scum they are, and psychos treated in asylums set aside just for them.