jbranchaud

[
  {
    "Plan": {
      "Node Type": "Sort",
      "Parallel Aware": false,
      "Async Capable": false,
      "Startup Cost": 25.77,
      "Total Cost": 25.78,
      "Plan Rows": 1,
      "Plan Width": 164,

jbranchaud

package main

import (
	"flag"
	"fmt"
	"os"
	"path/filepath"
	"regexp"
	"strings"
	"time"

jbranchaud

# Send More Money
#
# Verbal Arithmetic https://en.wikipedia.org/wiki/Verbal_arithmetic

letters = %i[s e n d m o r y]

check = ->(vals) do
  # leading zeros are not allowed
  return false if vals[:s] == 0 || vals[:m] == 0

jbranchaud

/** @type {import("@johnlindquist/kit")} */

// Name: Get Email for Newsletter
// Description: Create email address with current domain interpolated

const createEmailWithDomain = (baseEmail, { url }) => {
  const [emailUser, emailDomain] = baseEmail.split("@");

  const urlObj = new URL(url);
  let domain = urlObj.host.split(".");

jbranchaud

-- from the People, Postgres, Data Discord https://discord.com/channels/710918545906597938/710918545906597941/1214677867431206932

CREATE TABLE todo_list (
  id          INT NOT NULL PRIMARY KEY GENERATED ALWAYS AS IDENTITY,
  list_name   TEXT NOT NULL,
  item_order  INT[] NULL
);

CREATE TABLE todo_list_item (
  id          INT NOT NULL PRIMARY KEY GENERATED ALWAYS AS IDENTITY,

jbranchaud

PostgreSQL: Migrating from int to bigint

Resources

PostgreSQL zero-downtime migration of a primary key from int to bigint (with Ruby on Rails specific notes)

• This approach requires setting up a PostgreSQL trigger to keep the mirrored bigint column in sync with the existing int column until it is time to swap them out.

The Integer at the End of the Universe: Integer Overflow in Postgres

jbranchaud

Platforms that support running Playwright + Chromium

• AWS Lambda -- Running End-to-End Tests with Playwright on AWS Lambda
• Cloudflare Workers -- Automate an isolated browser instance with just a few lines of code
• Google Cloud -- Creating an automatic monitoring application with Node.js, Playwright, and Google Sheets on Google Cloud Platform
• Digital Ocean -- How To Run End-to-End Tests Using Playwright and Docker
• BrowserStack -- Run your first Playwright test on BrowserStack
• GitHub Actions -- [Playwright CLI with GitHub Actions CI](https://github.com/mic

jbranchaud

/** @type {import("@johnlindquist/kit")} */

// Shortcut: control option v

const turnTitleAndUrlIntoMarkdownLink = ({title: _title, url}) => {
  // in case the title is blank, use the URL as the title
  const titleIsPresent = _title && _title.trim !== '';
  const title = titleIsPresent ? _title : url;

  // combine the title and URL into a markdown link

jbranchaud

let jxa = await npm("@jxa/run")

let result = await jxa.run(() => {
  let app = Application("com.google.Chrome")
  let windows = app.windows()
  let frontWindow = windows[0]
  let tab = frontWindow.activeTab()

  let closedTabData = {
    id: tab.id(),

jbranchaud

/** @type {import("@johnlindquist/kit")} */

// Exclude: false
// Shortcut: control option v

const getChromeTabs = await npm("get-chrome-tabs")

// grab all tabs for all windows
const tabs = await getChromeTabs()