DeflateAwning

#!/usr/bin/env python3

import urllib.request
import xml.etree.ElementTree as ET

import time, random, math

import smtplib
from email.message import EmailMessage

DeflateAwning

# Unix/Max
ping www.google.com -i 1 | while read pong; do echo "$(date +%Y-%m-%d_%H:%M:%S): $pong"; done | grep --line-buffered timeout

# Windows (through cygwin or Git Bash)
ping www.google.com -n 500000 | while read pong; do echo "$(date +%Y-%m-%d_%H:%M:%S): $pong"; done | grep --line-buffered timed

DeflateAwning

Option Explicit

Sub ButterflyButton()

    Dim tbl As ListObject
    Dim csvFilePath As String
    Dim fNum As Integer
    Dim i As Long
    Dim tblArr
    Dim rowArr

DeflateAwning

import pandas as pd
import BOE_SQLAccess as boesql

sqlEngine = boesql.createSQLAlchemyEngine() # or equivalent SQLEngine object

tableName = 'petrinex_ab_well_licence'
pk = 'Licence Number' # target column to check for duplicates as the primary key

df_in = pd.read_sql(tableName, con=sqlEngine)
df = df_in.copy() # make a copy for safety, because downloads can be expensive

DeflateAwning

DBeaver Properties Changes

Allow line breaks in queries

1. File > Properties > Editors > SQL Editor > SQL Processing
2. Uncheck "Blank line is statement delimeter" in Delimeters section.

DeflateAwning

= Table.AddColumn(#"Changed Type", "SQL", each "INSERT INTO TableName (" & Text.Combine(Table.ColumnNames(#"Changed Type"), ", ") & ") VALUES (" & Text.Combine(List.Transform(Record.FieldValues(_), each "'" & Text.From(_) & "'") , ", ") & ")")

DeflateAwning

Option Explicit ' require strict variable 'dim' statements to avoid typos

Public Sub LookupClosestLatLong()
    ' Runs a procedure that prompts the user a few times, and takes them to the row of a pipe tally closest to some input coords.
    ' @since 2021-04-15
    
    ' Note to self: Range.Cells(row number, col number) is 0-index. Cells(2,1) = B3. Good luck.
    
    Dim LatColNum As Long
    Dim LonColNum As Long

DeflateAwning

Random Color = 
VAR minColorVal = 128

VAR cR =
    RANDBETWEEN ( minColorVal, 255 )
VAR cG =
    RANDBETWEEN ( minColorVal, 255 )
VAR cB =
    RANDBETWEEN ( minColorVal, 255 )
VAR RedP0 =

DeflateAwning

Setup copyq

This guide details how to setup copyq on Ubuntu/Debian systems to behave at least as well as Windows+V on Windows.

Setup Instructions

1. Install with sudo apt update && sudo apt install copyq.
2. Launch copyq from the start menu or with copyq.
3. Go File > Settings > Check "Autostart".
4. Go File > Commands/Global Shortcuts > Add > Show/hide main window > Ok > Click the plus button next to "Global Shortcut" > Press Windows+V (aka Super+V).

Step 3: Profit

DeflateAwning

Google Home Complaints

• In Spotify, it doesn't cache enough music. Intermitent network outages (<15 seconds) are noticable with pauses in the music.
• Sometimes randomly plays on other households' devices. The number of times I've wanted it to play on another household's device is 0.
  • Not on my IP subnet? Don't control that device!