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

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

• https://spectrum.chat/statecharts/general/when-to-use-react-state-and-when-to-use-xstate-context~e32d06e2-3389-4228-9fa9-e5df745871e6
• https://twitter.com/mpocock1/status/1345083512173555712
• https://twitter.com/tannerlinsley/status/1345085887026106368
• https://css-tricks.com/using-react-and-xstate-to-build-a-sign-in-form/
• In the wild! Where are you using XState
• Elm: How do we feel about state machines?
• [Things I wish I knew about state management when I started writing React apps](https://news.ycombinator.

jbranchaud

results = `git log HEAD@{'7 days ago'}..HEAD --oneline | sed 's/^\([[:alnum:]]*\) .*$/\1/'`

commit_list = results.split(/\n/).map do |item|
  item.split(' ', 2)
end.filter do |sha, commit_message|
  commit_message.start_with?('Add ')
end

commit_data = commit_list.map do |sha, commit_message|
  diff_tree_result = `git diff-tree --no-commit-id --name-only -r #{sha}`

jbranchaud

def sometimes_fails
  puts "Beginning of sometimes_fails"
  
  begin
    retries ||= 0
    puts "About to do a thing (#{retries})"

    raise StandardError if rand(5) != 4

    puts "Success!"