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

Change work_mem configuration for PostgreSQL Database

Let's say you are experiencing a Postgres error that reads like this: "Postgres running out of temp space".

A potential fix to this is adjusting the work_mem value for the database. This will require some tuning to optimize the database for the particular query load that it experiences. So, some trial and error.

Before getting started, you'll want to take note of the specs of your Postgres instance where these errors occur. You'll be interested in both the available RAM and the number of supported connections.

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

Working With Buffers

Me

• I'm Josh Branchaud
• I work at Hashrocket
• Twitter: @jbrancha
• Github: @jbranchaud

Why talk about buffers?

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

jbranchaud

function switch_pg {
  local version_to_run=$1
  local currently_running_version=$(psql --no-psqlrc -t -c 'show server_version;' postgres | xargs)

  # check if you're erroneously switching to the same version
  if [ "$version_to_run" = "$currently_running_version" ]; then
    echo "Postgres $version_to_run is already running."
    return 1
  fi

jbranchaud

Testable JavaScript Resources

Testing JavaScript isn't just a thing you can read about in children's fairy tales.

This is just a scratch pad of everything I find. As the really good resources start to float to the top, I'll transition them to a more permanent GitHub repo.

General

• Test-Driven JavaScript Development [book]
• JavaScript Testing Recipes [book]