Skip to main content

Recently Updated Pages

May 16

Development Updates, pre-launch 2024

Hi all, hope you're doing well ^^ Dealing with ADHD medication problems here, so everything's a ...

Updated 8 months ago by Ant

April 27

Development Updates, pre-launch 2024

Hi all, hope you're doing well! I'm still ill, and other than the sinus infection from last time...

Updated 8 months ago by Ant

April 13

Development Updates, pre-launch 2024

Hi all, hope you're doing well. The illness I had in the last update has persisted; I went to the...

Updated 8 months ago by Ant

March 29

Development Updates, pre-launch 2024

Hi all, hope you're doing well. Been ill with some weird cold/flu-like infection the last week or...

Updated 8 months ago by Ant

March 14

Development Updates, pre-launch 2024

Hi all, hope you're doing well ^^ updates below! I'm still having a rough time atm, but trying t...

Updated 8 months ago by Ant

February 28

Development Updates, pre-launch 2024

Hi all, hope you're doing well. I've had a very rough month, so I didn't feel up to writing two u...

Updated 8 months ago by Ant

January 30

Development Updates, pre-launch 2024

Hi all, hope you're doing well ^^ updates below! HTML / JS / CSS improvements, continued Fixed ...

Updated 8 months ago by Ant

January 15

Development Updates, pre-launch 2024

Hi everyone, hope you're well. Had a pretty rough two weeks, but I got a decent amount done, none...

Updated 8 months ago by Ant

Misc

Useful Commands Reference

SQL Using the GetGalleryForDisplay stored procedure CALL usp_galleries_GetGalleryFo...

Updated 10 months ago by Ant

Caching dangers (user safety)

Implementing Searches / Galleries Efficiency: SQL and caching

Because retrieving data specific to the requesting user is a huge caching inefficiency, we need t...

Updated 11 months ago by Ant

Caching results

Implementing Searches / Galleries Efficiency: SQL and caching

If your gallery SQL query is run every time a user performs a search or loads a gallery, it's goi...

Updated 11 months ago by Ant

Optimising the SQL query

Implementing Searches / Galleries Efficiency: SQL and caching

Optimising a query of this size can seem a very daunting task. In reality, there are a handful of...

Updated 11 months ago by Ant

Query explanation

Implementing Searches / Galleries Deserted Chateau's Gallery SQL

Updated 11 months ago by Ant

Overview

Implementing Searches / Galleries Introduction

Updated 11 months ago by Ant

Database Structure

Implementing Searches / Galleries Introduction

The tables, etc involved.

Updated 11 months ago by Ant

Tooltip Shells

Code Standards: Backend Pre-page loading

To standardise how tooltip elements are rendered on Deserted Chateau, and avoid janky page loadin...

Updated 11 months ago by Ant

Choosing a CDN provider

Introduction Choosing your Infrastructure and Softwa...

There are a lot more CDN providers than there are cloud service providers (though most of the clo...

Updated 11 months ago by Ant

Infrastructure Overview

Introduction Basic Overview

Before thinking about code of any sort, creating a website bigger than "Hello World!" requires a ...

Updated 11 months ago by Ant

Tech stack and managerial considerations (non-developers)

Introduction Basic Overview

If you're a developer, then choosing a tech stack to use is probably going to come down to what y...

Updated 11 months ago by Ant

Configuring iptables

Webserver Documentation

You can configure IPTables to restrict access to a particular server by IP address. Unless you s...

Updated 11 months ago by Ant