nathanl

Deadlocks Demo

For a basic discussion and demo, see https://www.postgresql.org/docs/current/explicit-locking.html#id-1.5.12.6.8.2

My own demo follows.

Setup

Create two tables with unique indexes:

cpursley

Postgres Full Text Search

Do you really nead Elastic Search?

• https://www.postgresql.org/docs/current/pgtrgm.html
• https://scoutapm.com/blog/how-to-make-text-searches-in-postgresql-faster-with-trigram-similarity
• https://about.gitlab.com/blog/2016/03/18/fast-search-using-postgresql-trigram-indexes/
• https://mazeez.dev/posts/pg-trgm-similarity-search-and-fast-like
• https://alexklibisz.com/2022/02/18/optimizing-postgres-trigram-search.html
• https://www.freecodecamp.org/news/fuzzy-string-matching-with-postgresql/

erikig

ProGM

Arel Cheatsheet on Steroids

A (more) complete cheatsheet for Arel, including NamedFunction functions, raw SQL and window functions.

Tables

posts = Arel::Table.new(:posts)
posts = Post.arel_table # ActiveRecord

Table alias

olivierlemoal

Moved to https://github.com/olivierlemoal/i3-swap-focus

DoomHammer

## Prefix like in screen
set -g prefix 'C-a'

## Use xterm keys (makes eg. Ctrl+Arrow navigate words)
set-window-option -g xterm-keys on

## List of plugins
# For this to work you need to install https://github.com/tmux-plugins/tpm
set -g @plugin 'tmux-plugins/tpm'
set -g @plugin 'tmux-plugins/tmux-sensible'

Gorcenski

import numpy as np
from functools import reduce

class Buzzer:
    def __init__(self, **kwargs):
        values = [v for k, v in kwargs.items()]

        self.kwargs = kwargs
        self.lcm = np.lcm.reduce(values)
        self.eps = 1e-7

superjose

# Reference: https://www.exclamationlabs.com/blog/continuous-deployment-to-npm-using-gitlab-ci/

# GitLab uses docker in the background, so we need to specify the 
# image versions. This is useful because we're freely to use
# multiple node versions to work with it. They come from the docker
# repo.
# Uses NodeJS V 9.4.0
image: node:9.4.0

# And to cache them as well.

eltonvs

Arch Linux Installation Guide

This guide will show step-by-step how to Install Arch Linux on UEFI mode.

Table of Contents

• Bootable Flash Drive
• BIOS
• Pre installation
  • Set Keyboard Layout
  • Check boot mode
• Update System Clock

zargony

version: 2

jobs:
  test:
    docker:
      - image: rust:1
    steps:
      - checkout
      - run:
          name: Version information