Justintime50

SELECT 
    table_name AS `Table`,
    table_rows AS `Records`,
    ROUND((data_length + index_length) / 1024 / 1024, 2) AS `Size (MB)`
FROM 
    information_schema.tables
WHERE 
    table_schema = 'your_db_table'
ORDER BY 
    `Size (MB)` DESC;

Justintime50

// Bootstrap 5 Color Palette
// Docs: https://getbootstrap.com/docs/5.3/customize/color

// Theme colors
$primary: #0d6efd;
$secondary: #6c757d;
$success: #198754;
$info: #0dcaf0;
$warning: #ffc107;
$danger: #dc3545;

Justintime50

#!/bin/bash

# Start from the current directory or specify the root directory as an argument
start_dir="${1:-.}"

process_config() {
    local config_file="$1"
    echo "Processing $config_file"
    sed -i.bak 's|https://github.com/|git@github.com:|g' "$config_file"
}

Justintime50

Print a ZPL from the CLI on macOS

1. Install the ZPL printer

# 2. Get the list of printers
lpstat -p -d

# 3. Print to the ZPL
lpr -P NAME_OF_PRINTER -o raw path/to/file.zpl

Justintime50

Clean Docker Container Logs on macOS

I searched high and low for a command that worked in 2024 to clean all the Docker container logs on macOS and finally found one that worked:

docker run -it --rm --privileged --pid=host justincormack/nsenter1
truncate -s 0 /var/lib/docker/containers/*/*-json.log

Justintime50

function resetForm() {
  deleteAllFormResponses()
  resetFormResponseDestination()
}

function resetFormResponseDestination() {
  var form = FormApp.getActiveForm();
  var formResponsesSheetId = form.getDestinationId();
  var spreadsheet = SpreadsheetApp.openById(formResponsesSheetId);
  

Justintime50

Diagnose Docker on macOS

/Applications/Docker.app/Contents/MacOS/com.docker.diagnose check

Justintime50

import random

n = 36

random.randint(pow(10, n - 1), pow(10, n) - 1)

Justintime50

#!/bin/bash

# shellcheck disable=SC2104

# The following script will setup the project for the first time for local dev
# To run the project after setup, use `docker compose up -d`

set -e

REPO_NAME="$1"

Justintime50

Debugging with LLDB

LLDB is a debugger you can attach to a program to do things like capturing stacktraces. Here is some basic usage:

# Attach to a program (waits for future execution in another terminal)
lldb -n php -w

# continue execution
c