Recently Updated Pages
May 16
Hi all, hope you're doing well ^^ Dealing with ADHD medication problems here, so everything's a ...
April 27
Hi all, hope you're doing well! I'm still ill, and other than the sinus infection from last time...
April 13
Hi all, hope you're doing well. The illness I had in the last update has persisted; I went to the...
March 29
Hi all, hope you're doing well. Been ill with some weird cold/flu-like infection the last week or...
March 14
Hi all, hope you're doing well ^^ updates below! I'm still having a rough time atm, but trying t...
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...
Misc
SQL Using the GetGalleryForDisplay stored procedure CALL usp_galleries_GetGalleryFo...
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...