Dossy Shiobara dossy

Trying to unnest `SUPER` data in Amazon Redshift

Working in Amazon Redshift, I got the following error:

ERROR:  Query unsupported due to an internal error.
DETAIL:  Unsupported PartiQL correlated subquery
CONTEXT:  nested_decorrelate_validate|

How to install `jdbc_fdw` into PostgreSQL 15 on Amazon Linux 2023

These instructions were written and tested on 2024-02-17, using Amazon Linux 2023 AMI 2023.3.20240205.2 arm64 HVM kernel-6.1 (ami-0bbebc09f0a12d4d9) on a t4g.medium (2 vCPU, 4 GiB RAM) instance.

Instructions

Step 1. Install prerequisite packages

Using GNU enscript to simulate 132x66 output to PDF

Prerequisites

Command

This command will produce an out.pdf file containing two full pages of X characters, with each page fitting 132x66 characters on Legal (8.5"x14") paper in landscape orientation using fixed-width Courier font.

How to apply transitions to the current scene behind a Ren'Py choice menu

Here is example code to apply the blur transform to the master layer when a choice menu is displayed, along with applying a fade-in and fade-out effect of the choice items.

This was tested on Ren'Py 7.4.0.1167.

Keybase proof

I hereby claim:

I am dossy on github.
I am dossy (https://keybase.io/dossy) on keybase.
I have a public key whose fingerprint is C535 6302 1171 987D 738E BFD8 2B1A B2E1 8D97 40AA

To claim this, I am signing this object:

	/**
	* Sleeps for `ms` milliseconds.
	*
	* @param {number} ms - Sleep duration in milliseconds.
	* @returns {Promise<void>}
	*
	* @example
	* // Sleep for 250ms.
	* await sleep(250);
	*/

	// from: https://github.com/facebook/react/issues/10135#issuecomment-314441175

	// fatfisz <https://github.com/fatfisz> commented on Jul 11, 2017

	// Just leaving a solution for future reference (checked in Edge 15, IE 11, FF 53, Chrome 59):

	function setNativeValue(element, value) {
	const valueSetter = Object.getOwnPropertyDescriptor(element, 'value').set;
	const prototype = Object.getPrototypeOf(element);
	const prototypeValueSetter = Object.getOwnPropertyDescriptor(prototype, 'value').set;

	function toJSON(node) {
	let propFix = { for: 'htmlFor', class: 'className' };
	let specialGetters = {
	style: (node) => node.style.cssText,
	};
	let attrDefaultValues = { style: '' };
	let obj = {
	nodeType: node.nodeType,
	};
	if (node.tagName) {

	// for: https://stackoverflow.com/questions/65272176/how-to-solve-type-listdynamic-is-not-a-subtype-of-type-string

	import 'package:flutter/material.dart';
	import 'package:flutter/painting.dart';

	final Color darkBlue = Color.fromARGB(255, 18, 32, 47);

	void main() {
	runApp(MyApp());
	}

	<script type="text/javascript">
	// don't forget to add a style for:
	// `input[type="submit"].disabled, input[type="submit"].button-disabled, input[type="submit"]:disabled`
	jQuery(function ($) {
	$('form[id^="gform_"]').on('change', function (e) {
	var $reqd = $(this).find('.gfield_contains_required.gfield_visibility_visible').filter(function (i, c) {
	return []
	.concat($(c).find('input[type="text"], textarea').filter(function (i, fl) { return $(fl).val().length == 0; }).get())
	.concat($(c).find('input[type="checkbox"]').not(':checked').get())
	.length;