Search Results

Homepage https://github.com/MyIntervals/PHP-CSS-Parser What is it? A PHP module for parsing CSS files. Why did we choose it? It does what we need it to do, is open source, and is highly performant. What do we use it for? Dynamically generating CSS files...

VPC Endpoints Not all AWS services can communicate with each other, as some are in a VPC and some are not, i.e. have public Internet access. VPC Endpoints allow you to connect a service that's in a VPC with another service outside the VPC. This is useful for...

If you have an error in one of your email templates, or any code that uses them, you may end up with a "Rendering Failure" - SES will return a status code 200 as if it had sent the email, but will not actually have sent the email. The only way to know these o...

Normally when you use Lightsail, you can't connect to other AWS resources from your Lightsail servers (e.g: you won't be able to connect to an RDS database). This is because your Lightsail resources are inside their own special VPC, and thus they can't see you...

Homepage https://aws.amazon.com/dynamodb/ What is it? A cloud NoSQL database (very different from normal SQL databases; it's more like a key-value store than a relational database). Why did we choose it? It's useful for storing information we need for som...

Homepage https://www.npmjs.com/package/archiver What is it? A Node.js library for simplifying the creation of compressed archives (i.e. zip files and the like). Why did we choose it? It has good documentation, performs well, and is actively maintained. W...

Hi all, hope you're doing well! I'm still ill, and other than the sinus infection from last time I seem to have picked up something else, though I'm not sure what. Anyhow, updates are below ^^ Profile settings: social options cleaned up I've tidied up the o...

SQL Using the GetGalleryForDisplay stored procedure CALL usp_galleries_GetGalleryForDisplay( 'N', -- Exclude images from result: Y or N 'N', -- Exclude videos from result: Y or N NULL, -- Include artworks matching given categories from resu...

EventBridge scheduler role An example IAM role for EventBridge schedules is below. The main points to note are: The role needs permission to use any resource it has set as a target, such as Lambda function execution. If you specify an SQS dead letter queu...

If for whatever reason you need to restore a snapshot of an RDS database, there are a few possible pitfalls and things to be aware of. IAM Role requirements The IAM role to perform the export needs a bunch of permissions: s3:GetBucketLocation, and various...

The flexible timeframes feature on EventBridge is there to help avoid having e.g. a bunch of tasks all executing at the same time (which could, for instance, cause heavy load on a user's database servers). It's not there to balance out load on AWS resources, ...

To save on repetitive code in your Lambda functions, you can define a custom Lambda Layer to add to functions where you need to use the same code. You can do this in the same manner as creating a normal Node.js project, however: Your own code needs to be in...

If you fail to clean up connections properly, you can end up with functions taking a lot longer than they otherwise should. For example, serverless code functions will have to wait until the connections become inactive (the default is around ~10 seconds, but d...

This is a list of libraries Deserted Chateau uses, and their respective license terms (accurate as of the time of writing). MIT License info: https://opensource.org/license/mit archiver BookStack flowjs & flow-php-server jQuery, jQueryUI, ImagesLoaded,...

Homepage https://www.npmjs.com/package/unzipper What is it? A Node.js library for unzipping compressed archives (.zip files and the like). Why did we choose it? It's simple and lightweight, which is good for our use case. What do we use it for? Packagin...

Refresh webserver configuration values The values kept in the configuration database table are cached in Redis indefinitely. To make the webservers receive new changes, you must unlink the Redis key, which will cause the webservers to go back to the database ...

Hi all, hope you're doing well ^^ Dealing with ADHD medication problems here, so everything's a bit chaotic, but updates are below. Gallery non-infinite scroll option implemented I've created a system for the gallery layout, in which users can choose betwee...

Concatenate two videos, fading to a second of black between them ffmpeg \ -i "yourvideo1.mp4" \ -f lavfi -t 1 -i "color=black:s=1920x1080:r=60" \ -f lavfi -t 1 -i "anullsrc=r=48000:cl=2" \ -i "yourvideo2.mp4" \ -filter_complex "[1:v] null [1v]; [2:a] an...

Hi all, hope you're doing well. My health has been getting worse this month due to medication issues, which is why I didn't publish this update near the end of May, but still chipping away at things nonetheless. CSS name refactoring completed I've finished r...

Test Environments All servers use IPv4. Live Environments Documentation and articles server have IPv4 addresses. Webservers have IPv6 addresses only, to reduce cost. Since they are behind a load balancer, they do not need IPv4 addresses, as the load balanc...