These last days of 2020 I have spent hours patching the "soon-to-be" FusionPBX 4.6. One of the things I don't like is the way the cache engine is designed. Since FusionPBX 4.4, there are two ways of doing cache:
I will first talk about how they are now (Dec 30th, 2020) and what my published pull request will fix and enhance.
This is a quick reminder for me and for any developer. When using an SVN, and we want to publish a tarball, usually the name of the SVN is 1.0.0/ and the working directory of the tarball should be project-1.0.0/.
So I have decided to make public the most useful SQL queries I have developed while dealing with FusionPBX. Please note that I am a MariaDB user, I have no intention to translate to PostgreSQL for free. Remember to change them to fit your specific needs.