Skip to content

Instantly share code, notes, and snippets.

@roydejong
roydejong / mysql-backup-to-s3
Last active August 13, 2021 07:29
Cron script: MySQL Nightly Backups to S3
#!/bin/bash
# /etc/cron.daily/mysql-s3-backup
# Before use, install AWS CLI and use "aws configure" to set up credentials with write access to your s3 bucket
# See https://docs.aws.amazon.com/cli/latest/userguide/install-cliv2-linux.html#cliv2-linux-install
DB_USER=XXX
DB_NAME=XXX
DB_PASS=XXX
@roydejong
roydejong / commit_convention.md
Last active January 22, 2021 14:04
Commit message conventions

Goals

Consistent commit messages that are easily readable & searchable.

Syntax

commit_type(project_component): [issue_reference] short_message 

optional_extended_message
@roydejong
roydejong / progrids-install.md
Last active September 12, 2024 10:35
Installing ProGrids v3 in Unity 2018.3

The problem

ProGrids seems to have disappeared from the Unity Package Manager as of Unity 2018.3.

It is possible to install ProGrids v2 via the Asset Store, but it's an old and incompatible version.

The solution (new)

Per Sayama3:

In 2021, you still can use it but it's different :

  • Go to the Package Manager
@roydejong
roydejong / is_touch_device.js
Created January 7, 2019 03:16
JavaScript: Detect touch device (react compatible)
function is_touch_device() {
try {
let prefixes = ' -webkit- -moz- -o- -ms- '.split(' ');
let mq = function (query) {
return window.matchMedia(query).matches;
};
if (('ontouchstart' in window) || (typeof window.DocumentTouch !== "undefined" && document instanceof window.DocumentTouch)) {
return true;
@roydejong
roydejong / UnityDiscordRPCDebugLogger.cs
Last active January 7, 2019 05:47
Unity: Debug logger class for the DiscordRPC C# Wrapper Library
using DiscordRPC.Logging;
using System;
using UnityEngine;
public class DiscordDebugLogger : DiscordRPC.Logging.ILogger
{
/// <summary>
/// The level of logging to apply to this logger.
/// </summary>
public LogLevel Level { get; set; }
@roydejong
roydejong / NativeWinAlert.cs
Last active June 4, 2024 09:03
Unity: NativeWinAlert (Windows MessageBox / Alert Dialog for Unity games)
using System;
using System.Runtime.InteropServices;
/// <see>https://docs.microsoft.com/en-us/windows/desktop/api/winuser/nf-winuser-messagebox</see>
public static class NativeWinAlert
{
[System.Runtime.InteropServices.DllImport("user32.dll")]
private static extern System.IntPtr GetActiveWindow();
public static System.IntPtr GetWindowHandle()
@roydejong
roydejong / floatval-locale-guess.php
Last active May 1, 2022 19:38
PHP: Parse raw input as a float, with best guess for the decimal character (dot or comma). Useful if you do not know original locale or when you are processing user input.
<?php
function parseFloatGuess($rawValue) {
if (!$rawValue) {
return 0;
}
$lastCommaPosition = strrpos($rawValue, ',');
$lastDotPosition = strrpos($rawValue, '.');
@roydejong
roydejong / wkhtmltopdf-setup-with-xvfb-and-php.md
Last active October 28, 2024 15:16
Set up wkhtmltopdf on Ubuntu server

Important

wkhtmltopdf has been abandoned and is not being updated anymore. Avoid using it for new projects.

Tip

Consider using Chrome in headless mode and just DIY-ing it instead of wkhtmltopdf:

google-chrome --headless --disable-gpu --run-all-compositor-stages-before-draw --print-to-pdf={$tempPath} --no-pdf-header-footer {$renderUrl}

Install wkhtmltopdf

@roydejong
roydejong / pouchdb-create-or-update-merge.js
Last active July 4, 2017 14:02
PouchDB: Add or update record (sync / merge)
static addOrUpdate(id, document) {
return new Promise(function (resolve, reject) {
let doStore = function (originalDocument) {
// Merge the document: First, set the ID. Then apply the existing doc on top if possible. Finally, apply the changed doc.
let mergedDoc = {
_id: id
};
if (originalDocument) {
for (let key in originalDocument) {
@roydejong
roydejong / map_country_to_continent.php
Created May 23, 2017 13:14
PHP: Array mapping country ISO codes to continent codes
$mapCountryToContinent = array(
"AF" => "AS",
"AX" => "EU",
"AL" => "EU",
"DZ" => "AF",
"AS" => "OC",
"AD" => "EU",
"AO" => "AF",
"AI" => "NA",
"AQ" => "AN",