Recently Updated Pages
February 28
Hi all, hope you're doing well. I've had a very rough month, so I didn't feel up to writing two u...
January 30
Hi all, hope you're doing well ^^ updates below! HTML / JS / CSS improvements, continued Fixed ...
January 15
Hi everyone, hope you're well. Had a pretty rough two weeks, but I got a decent amount done, none...
Caching dangers (user safety)
Because retrieving data specific to the requesting user is a huge caching inefficiency, we need t...
Caching results
If your gallery SQL query is run every time a user performs a search or loads a gallery, it's goi...
Optimising the SQL query
Optimising a query of this size can seem a very daunting task. In reality, there are a handful of...
Query explanation
Overview
Database Structure
The tables, etc involved.
Tooltip Shells
To standardise how tooltip elements are rendered on Deserted Chateau, and avoid janky page loadin...
Choosing a CDN provider
There are a lot more CDN providers than there are cloud service providers (though most of the clo...
Infrastructure Overview
Before thinking about code of any sort, creating a website bigger than "Hello World!" requires a ...
Tech stack and managerial considerations (non-developers)
If you're a developer, then choosing a tech stack to use is probably going to come down to what y...
Configuring iptables
You can configure IPTables to restrict access to a particular server by IP address. Unless you s...
Logrotate
Main configuration Although running the command "logrotate somefile" runs that file, it does NOT...
Apache httpd.conf settings
Modifying the Bitnami instance httpd.conf files bitnami.conf (/opt/bitnami/apache/conf/bitnami/b...
Understanding how to configure Apache properly
For the most part, there are two important things we need to consider when configuring Apache, bu...
Head HTML
Head HTML for every page is loaded in two places: The core HeadHtml.php file, which loads the ...
Requesting SSL certificates with more than one domain
When requesting an ACM certificate, AWS will ask you to add some CNAME records in Route 53 (or yo...
WAF pricing: rules and rule groups
The free managed rule groups still incur a charge Be aware that, although the AWS managed rule g...