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|

dossy

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

dossy

Using GNU enscript to simulate 132x66 output to PDF

Prerequisites

• GNU enscript
• Ghostscript

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.

dossy

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

dossy

// 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;

dossy

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) {

dossy

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.

dossy

// 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());
}

dossy

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:

dossy

<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;