Why PostgreSQL?
For me the reasons are
- a lower memory footprint
- more convenient functions, e.g. ILIKE for case insensitive search which is a mess in MariaDB, i.e. queries becomes way more complex instead of just using
ILIKE
instead ofLIKE
as you can with Postgres. - PostgreSQL just feels more rounded, is more standard compliant and creates less hassle. MariaDB (to me personally) feels too āhackyā compared to Postgres. Another example is that to make MariaDB queries secure with PDO in PHP you need to make sure the right charset is used. In Postgres āit just worksā.
Why no virus scan implementation?
Because virus scanners are mostly snake oil, i.e. give you a wrong sense of security while detecting few viruses that really matter. This might be even more true for desktop solutions but I just decided that its not worth the effort for the little to no gain.
Whatās about redis?
I actually state in the tutorial that you should use Redis for larger user bases and provide links to instructions on how to set up Redis. I did not include it merely because at some point I had to make a cut (you can always explain more and do more but time is limited) and for my use case I donāt need it (relatively few users). But if you do, just follow the links.