definiteIymaybe

addEventListener('scheduled', event => {
  event.waitUntil(handleSchedule(event.scheduledTime))
})

async function handleSchedule(scheduledDate) {
  const url = `https://api.github.com/repos/${OWNER}/${REPO}/actions/workflows/${WORKFLOW_ID}/dispatches`
  await fetch(url, {
    method: 'POST',
    headers: {
      'Accept': 'application/vnd.github+json',

definiteIymaybe

# pip3 install openai

import openai
import time


OPENAI_API_KEY = "your_api_key_here"
openai.api_key = OPENAI_API_KEY

prompt = """French: La semaine dernière, quelqu’un m’a fait part de sa gratitude envers notre travail.

definiteIymaybe

// Variables used by Scriptable.
// These must be at the very top of the file. Do not edit.
// icon-color: orange; icon-glyph: quote-right;

// Change these to your usernames!
const user = "spencer"

const jike = "4DDA0425-FB41-4188-89E4-952CA15E3C5E"
const telegram = "realSpencerWoo"
const github = "spencerwooo"

definiteIymaybe

import revHash from 'rev-hash'
import { readFileSync, statSync } from 'fs'
import { resolve } from 'path'

/**
 * Calculate the rev hash for a file
 *
 * @param {string} file The path to the file to hash
 * @returns {string}
 */

definiteIymaybe

Using PostgreSQL's COPY to import & export CSV files

COPY can read/write data not only from/to CSV, but also from/to binary files. For the import, the table must exist along with its columns matching CSV columns.

Export table to CSV

COPY <table> TO 'file.csv' DELIMITER ',' CSV HEADER; 

definiteIymaybe

Routing tips for VPNs on OS X

When VPNs Just Work™, they're a fantastic way of allowing access to a private network from remote locations. When they don't work it can be an experience in frustration. I've had situations where I can connect to a VPN from my Mac, but various networking situations cause routing conflicts. Here are a couple of cases and how I've been able to get around them.

Specific cases

Case 1: conflicting additional routes.

In this example the VPN we are connecting to has a subnet that does not conflict with our local IP, but has additional routes that conflict in some way with our local network's routing. In my example the remote subnet is 10.0.x.0/24, my local subnet is 10.0.y.0/24, and the conflicting route is 10.0.0.0/8. Without the later route, I can't access all hosts on the VPN without manually adding the route after connecting to the VPN:

definiteIymaybe

launchctl unload /Library/LaunchAgents/com.tuxera.ntfs.agent.plist
sudo trash -Fv /Applications/Tuxera\ Disk\ Manager.app
sudo trash -Fv /Library/Application\ Support/Tuxera\ NTFS
sudo trash -Fv /Library/Filesystems/fusefs_txantfs.fs
sudo trash -Fv /Library/LaunchAgents/com.tuxera.ntfs.agent.plist
sudo trash -Fv /Library/PreferencePanes/Tuxera\ NTFS.prefPane
sudo trash -Fv /Library/Preferences/com.tuxera.NTFS.plist

definiteIymaybe

# POST a JSON file and redirect output to stdout
wget -q -O - --header="Content-Type:application/json" --post-file=foo.json http://127.0.0.1

# Download a complete website
wget -m -r -linf -k -p -q -E -e robots=off http://127.0.0.1

# But it may be sufficient
wget -mpk http://127.0.0.1

# Download all images of a website

definiteIymaybe

Custom format for displaying bytes as kb, mb, gb or tb.

Response to a few places on the internet: https://productforums.google.com/forum/#!topic/docs/x_T_N-yRUYg And here: https://stackoverflow.com/questions/1533811/how-can-i-format-bytes-a-cell-in-excel-as-kb-mb-gb-etc

Here is one that I have been using:

[<1000000]0.00," KB";[<1000000000]0.00,," MB";0.00,,," GB"

definiteIymaybe

Processing JSON using jq

jq is useful to slice, filter, map and transform structured json data.

Installing jq

On Mac OS

brew install jq