base on :memo: Today I Learned # TIL > Today I Learned A collection of concise write-ups on small things I learn day to day across a variety of languages and technologies. These are things that don't really warrant a full blog post. These are things I've picked up by [Learning In Public™](https://dev.to/jbranchaud/how-i-built-a-learning-machine-45k9) and pairing with smart people at Hashrocket. For a steady stream of TILs, [sign up for my newsletter](https://crafty-builder-6996.ck.page/e169c61186). _1544 TILs and counting..._ --- ### Categories * [Ack](#ack) * [Amplify](#amplify) * [Ansible](#ansible) * [Astro](#astro) * [Brew](#brew) * [Chrome](#chrome) * [Clojure](#clojure) * [CSS](#css) * [Deno](#deno) * [Devops](#devops) * [Docker](#docker) * [Drizzle](#drizzle) * [Elixir](#elixir) * [Gatsby](#gatsby) * [Git](#git) * [GitHub Actions](#github-actions) * [Go](#go) * [GROQ](#groq) * [Heroku](#heroku) * [HTML](#html) * [HTTP](#http) * [Inngest](#inngest) * [Internet](#internet) * [Java](#java) * [JavaScript](#javascript) * [jj](#jj) * [jq](#jq) * [Kitty](#kitty) * [Linux](#linux) * [LLM](#llm) * [Mac](#mac) * [MongoDB](#mongodb) * [MySQL](#mysql) * [Neovim](#neovim) * [Netlify](#netlify) * [NextAuth.js](#next-auth) * [Next.js](#nextjs) * [Phoenix](#phoenix) * [Planetscale](#planetscale) * [pnpm](#pnpm) * [PostgreSQL](#postgresql) * [Prisma](#prisma) * [Python](#python) * [Rails](#rails) * [React](#react) * [React Native](#react-native) * [React Testing Library](#react-testing-library) * [ReasonML](#reasonml) * [Remix](#remix) * [RSpec](#rspec) * [Ruby](#ruby) * [sed](#sed) * [Shell](#shell) * [SQLite](#sqlite) * [Streaming](#streaming) * [Tailwind CSS](#tailwind-css) * [tmux](#tmux) * [TypeScript](#typescript) * [Unix](#unix) * [Vercel](#vercel) * [Vim](#vim) * [VSCode](#vscode) * [Webpack](#webpack) * [Workflow](#workflow) * [XState](#xstate) * [YAML](#yaml) * [Zod](#zod) * [Zsh](#zsh) --- ### Ack - [ack --bar](ack/ack-bar.md) - [Case-Insensitive Search](ack/case-insensitive-search.md) - [List Available File Types](ack/list-available-file-types.md) ### Amplify - [Sign Up User With Email And Password](amplify/sign-up-user-with-email-and-password.md) ### Ansible - [Loop Over A List Of Dictionaries](ansible/loop-over-a-list-of-dictionaries.md) ### Astro - [Generate Types For A Content Collection](astro/generate-types-for-a-content-collection.md) - [Markdown Files Are Of Type MarkdownInstance](astro/markdown-files-are-of-type-markdown-instance.md) ### Brew - [Configure Brew Environment Variables](brew/configure-brew-environment-variables.md) - [Export List Of Everything Installed By Brew](brew/export-list-of-everything-installed-by-brew.md) - [List All Services Managed By Brew](brew/list-all-services-managed-by-brew.md) ### Chrome - [Access A Value Logged To The Console](chrome/access-a-value-logged-to-the-console.md) - [Chrome Supports Many Unix Keyboard Shortcuts](chrome/chrome-supports-many-unix-keyboard-shortcuts.md) - [Copy Some Data From The Console](chrome/copy-some-data-from-the-console.md) - [Duplicate The Current Tab](chrome/duplicate-the-current-tab.md) - [Easier Access To Network Throttling Controls](chrome/easier-access-to-network-throttling-controls.md) - [Keybinding To Focus The Address Bar](chrome/keybinding-to-focus-the-address-bar.md) - [Pause JavaScript From The Source DevTools Panel](chrome/pause-javascript-from-the-source-devtools-panel.md) - [Navigate The Browser History With Vimium](chrome/navigate-the-browser-history-with-vimium.md) - [Pretty Print Tabular Data](chrome/pretty-print-tabular-data.md) - [Reference The Selected Node](chrome/reference-the-selected-node.md) - [Selecting DOM Elements Faster Than Ever](chrome/selecting-dom-elements-faster-than-ever.md) - [Simulating Various Connection Speeds](chrome/simulating-various-connection-speeds.md) - [Toggle Device Mode](chrome/toggle-device-mode.md) - [Toggle Open The Console Drawer](chrome/toggle-open-the-console-drawer.md) - [Trigger Commands From The Devtools Command Palette](chrome/trigger-commands-from-the-devtools-command-palette.md) - [View Network Traffic For New Tabs](chrome/view-network-traffic-for-new-tabs.md) ### Clojure - [Aggregation Using merge-with](clojure/aggregation-using-merge-with.md) - [Argument Requirements For A Function](clojure/argument-requirements-for-a-function.md) - [Combinations Of Items From A Sequence](clojure/combinations-of-items-from-a-sequence.md) - [Define Something Only Once](clojure/define-something-only-once.md) - [Evaluate One Liners With lein-exec](clojure/evaluate-one-liners-with-lein-exec.md) - [Expanding Macros](clojure/expanding-macros.md) - [Get The Value Of An Environment Variable](clojure/get-the-value-of-an-environment-variable.md) - [List Functions For A Namespace](clojure/list-functions-for-a-namespace.md) - [Load A File Into The REPL](clojure/load-a-file-into-the-repl.md) - [Mapping With An Index](clojure/mapping-with-an-index.md) - [Open JavaDocs](clojure/open-javadocs.md) - [Pretty Print The Last Thing](clojure/pretty-print-the-last-thing.md) - [Quick Clojure Docs](clojure/quick-clojure-docs.md) - [Reductions](clojure/reductions.md) - [Set Max Heap Size](clojure/set-max-heap-size.md) - [Specify the Directory of a Shell Command](clojure/specify-the-directory-of-a-shell-command.md) - [Splitting On Whitespace](clojure/splitting-on-whitespace.md) - [Swap Two Items in a Vector](clojure/swap-two-items-in-a-vector.md) - [Try A Clojure Project In The REPL](clojure/try-a-clojure-project-in-the-repl.md) - [Type of Anything](clojure/type-of-anything.md) - [When Overflow Is Desired](clojure/when-overflow-is-desired.md) ### CSS - [Add Fab Icons To Your Site With FontAwesome 5](css/add-fab-icons-to-your-site-with-fontawesome-5.md) - [Add Line Numbers To A Code Block With Counter](css/add-line-numbers-to-a-code-block-with-counter.md) - [Animate Smoothly Between Two Background Colors](css/animate-smoothly-between-two-background-colors.md) - [Apply Multiple Box Shadows To Single Element](css/apply-multiple-box-shadows-to-single-element.md) - [Apply Styles Based On Dark-Mode Preferences](css/apply-styles-based-on-dark-mode-preferences.md) - [Apply Styles To The Last Child Of A Specific Type](css/apply-styles-to-the-last-child-of-a-specific-type.md) - [Change The Orientation Of An Image](css/change-the-orientation-of-an-image.md) - [Circular Icons With A Massive Border Radius](css/circular-icons-with-a-massive-border-radius.md) - [Clean Up Repetition With :is() Pseudo-Class](css/clean-up-repetition-with-is-pseudo-class.md) - [Conditional Styling For Unsupported CSS Features](css/conditional-styling-for-unsupported-css-features.md) - [Create A Pulsing Background With CSS Animation](css/create-a-pulsing-background-with-css-animation.md) - [Define CSS Custom Properties With CSS Variables](css/define-css-custom-properties-with-scss-variables.md) - [Define HSL Colors With Alpha Values](css/define-hsl-colors-with-alpha-values.md) - [Display Responsive iframe Maintaining Aspect Ratio](css/display-responsive-iframe-maintaining-aspect-ratio.md) - [Dry Up SCSS With Mixins](css/dry-up-scss-with-mixins.md) - [Give Elements The Same Width With Flexbox](css/give-elements-the-same-width-with-flexbox.md) - [Let Pointer Events Pass Through An Element](css/let-pointer-events-pass-through-an-element.md) - [Lighten And Darken With CSS Brightness Filter](css/lighten-and-darken-with-css-brightness-filter.md) - [Lighten And Darken With SCSS](css/lighten-and-darken-with-scss.md) - [Make A Block Of Text Respect New Lines](css/make-a-block-of-text-respect-new-lines.md) - [Parameterized SCSS Mixins](css/parameterized-scss-mixins.md) - [:root Has Higher Specificity Than html](css/root-has-higher-specificity-than-html.md) - [Style A Background With A Linear Gradient](css/style-a-background-with-a-linear-gradient.md) - [Using Maps In SCSS](css/using-maps-in-scss.md) ### Deno - [Read In The Contents Of A File](deno/read-in-the-contents-of-a-file.md) ### Devops - [Aliasing An Ansible Host](devops/aliasing-an-ansible-host.md) - [Allow Cross-Origin Requests To Include Cookies](devops/allow-cross-origin-requests-to-include-cookies.md) - [Allow HTTPS Through Your UFW Firewall](devops/allow-https-through-your-ufw-firewall.md) - [Check For Cached Site Assocation File For iOS](devops/check-for-cached-site-association-file-for-ios.md) - [Check The Status of All Services](devops/check-the-status-of-all-services.md) - [Check The Syntax Of nginx Files](devops/check-the-syntax-of-nginx-files.md) - [Connect To An RDS PostgreSQL Database](devops/connect-to-an-rds-postgresql-database.md) - [Determine The IP Address Of A Domain](devops/determine-the-ip-address-of-a-domain.md) - [Path Of The Packets](devops/path-of-the-packets.md) - [Push Non-master Branch To Heroku](devops/push-non-master-branch-to-heroku.md) - [Reload The nginx Configuration](devops/reload-the-nginx-configuration.md) - [Resolve The Public IP Of A URL](devops/resolve-the-public-ip-of-a-url.md) - [Running Out Of inode Space](devops/running-out-of-inode-space.md) - [SSH Into A Docker Container](devops/ssh-into-a-docker-container.md) - [SSL Certificates Can Cover Multiple Domains](devops/ssl-certificates-can-cover-multiple-domains.md) - [Wipe A Heroku Postgres Database](devops/wipe-a-heroku-postgres-database.md) ### Docker - [Configure Different Host And Container Ports](docker/configure-different-host-and-container-ports.md) - [List Running Docker Containers](docker/list-running-docker-containers.md) - [Run A Basic PostgreSQL Server In Docker](docker/run-a-basic-postgresql-server-in-docker.md) ### Drizzle - [Create bigint Identity Column For Primary Key](drizzle/create-bigint-identity-column-for-primary-key.md) - [Drizzle Tracks Migrations In A Log Table](drizzle/drizzle-tracks-migrations-in-a-log-table.md) - [Get Fields For Inserted Row](drizzle/get-fields-for-inserted-row.md) ### Elixir - [All Values For A Key In A Keyword List](elixir/all-values-for-a-key-in-a-keyword-list.md) - [Append To A Keyword List](elixir/append-to-a-keyword-list.md) - [Assert An Exception Is Raised](elixir/assert-an-exception-is-raised.md) - [Binary Representation Of A String](elixir/binary-representation-of-a-string.md) - [Check For A Substring Match](elixir/check-for-a-substring-match.md) - [Check List Membership](elixir/check-list-membership.md) - [Comparing DateTime Structs](elixir/comparing-datetime-structs.md) - [Compute Intermediate Values In A With Construct](elixir/compute-intermediate-values-in-a-with-construct.md) - [Compute md5 Digest Of A String](elixir/compute-md5-digest-of-a-string.md) - [Counting Records With Ecto](elixir/counting-records-with-ecto.md) - [Create A Date With The Date Sigil](elixir/create-a-date-with-the-date-sigil.md) - [Create A List Of Atoms](elixir/create-a-list-of-atoms.md) - [Creating A PID](elixir/creating-a-pid.md) - [Creating Indexes With Ecto](elixir/creating-indexes-with-ecto.md) - [Defining Multiple Clauses In An Anonymous Function](elixir/defining-multiple-clauses-in-an-anonymous-function.md) - [Determine The Latest Release Of A Hex Package](elixir/determine-the-latest-release-of-a-hex-package.md) - [Do You Have The Time?](elixir/do-you-have-the-time.md) - [Do You Have The Time? - Part 2](elixir/do-you-have-the-time-part-2.md) - [Documentation Lookup With Vim And Alchemist](elixir/documentation-lookup-with-vim-and-alchemist.md) - [Dynamically Generating Atoms](elixir/dynamically-generating-atoms.md) - [Execute Raw SQL In An Ecto Migration](elixir/execute-raw-sql-in-an-ecto-migration.md) - [Expose Internal Representation](elixir/expose-internal-representation.md) - [Include Captures With String.split](elixir/include-captures-with-string-split.md) - [Inspecting The Process Message Queue](elixir/inspecting-the-process-message-queue.md) - [List Functions For A Module](elixir/list-functions-for-a-module.md) - [Listing Files In IEx](elixir/listing-files-in-iex.md) - [Match On A Map In A With Construct](elixir/match-on-a-map-in-a-with-construct.md) - [Passing Around And Using Modules](elixir/passing-around-and-using-modules.md) - [Pattern Matching In Anonymous Functions](elixir/pattern-matching-in-anonymous-functions.md) - [Pipe Into A Case Statement](elixir/pipe-into-a-case-statement.md) - [Quitting IEx](elixir/quitting-iex.md) - [Range Into List Using Comprehensions](elixir/range-into-list-using-comprehensions.md) - [Refer To A Module Within Itself](elixir/refer-to-a-module-within-itself.md) - [Referencing Values In IEx's History](elixir/referencing-values-in-iexs-history.md) - [Remove One List From Another](elixir/remove-one-list-from-another.md) - [Replace Duplicates In A Keyword List](elixir/replace-duplicates-in-a-keyword-list.md) - [Requiring Keys For Structs](elixir/requiring-keys-for-structs.md) - [Reversing A List](elixir/reversing-a-list.md) - [Reversing A List - Part 2](elixir/reversing-a-list-part-2.md) - [Root Directory Of A Project](elixir/root-directory-of-a-project.md) - [Round Floats To Integers](elixir/round-floats-to-integers.md) - [Run ExUnit Tests In A Deterministic Order](elixir/run-exunit-tests-in-a-deterministic-order.md) - [Run The Test At A Specific Line Number](elixir/run-the-test-at-a-specific-line-number.md) - [Same Functions Should Be Grouped Together](elixir/same-functions-should-be-grouped-together.md) - [Skip A Specific Test](elixir/skip-a-specific-test.md) - [String Interpolation With Just About Anything](elixir/string-interpolation-with-just-about-anything.md) - [Unique Indexes With Ecto](elixir/unique-indexes-with-ecto.md) - [Updating Values In A Map](elixir/updating-values-in-a-map.md) - [Using When Clauses In A With Construct](elixir/using-when-clauses-in-a-with-construct.md) - [Virtual Fields With Ecto Schemas](elixir/virtual-fields-with-ecto-schemas.md) - [When Things Don't Match The With Statements](elixir/when-things-dont-match-the-with-statements.md) - [Word Lists For Atoms](elixir/word-lists-for-atoms.md) ### Gatsby - [Add JavaScript To Body Of The Document](gatsby/add-javascript-to-body-of-the-document.md) ### Git - [Accessing a Lost Commit](git/accessing-a-lost-commit.md) - [Add A Range Of Filename To gitignore](git/add-a-range-of-filenames-to-gitignore.md) - [Add Only Tracked Files From A Directory](git/add-only-tracked-files-from-a-directory.md) - [Amend Author Of Previous Commit](git/amend-author-of-previous-commit.md) - [Auto-Squash Those Fixup Commits](git/auto-squash-those-fixup-commits.md) - [Better Diffs With Delta](git/better-diffs-with-delta.md) - [Caching Credentials](git/caching-credentials.md) - [Change The Start Point Of A Branch](git/change-the-start-point-of-a-branch.md) - [Check How A File Is Being Ignored](git/check-how-a-file-is-being-ignored.md) - [Checking Commit Ancestry](git/checking-commit-ancestry.md) - [Checkout Old Version Of A File](git/checkout-old-version-of-a-file.md) - [Checkout Previous Branch](git/checkout-previous-branch.md) - [Cherry Pick A Range Of Commits](git/cherry-pick-a-range-of-commits.md) - [Clean Out All Local Branches](git/clean-out-all-local-branches.md) - [Clean Out Working Copy With Patched Restore](git/clean-out-working-copy-with-patched-restore.md) - [Clean Up Old Remote Tracking References](git/clean-up-old-remote-tracking-references.md) - [Clone A Repo Just For The Files, Without History](git/clone-a-repo-just-for-the-files-without-history.md) - [Clone A Repo Locally From .git](git/clone-a-repo-locally-from-git.md) - [Configure Global gitignore File](git/configure-global-gitignore-file.md) - [Configuring The Pager](git/configuring-the-pager.md) - [Copy A File From Another Branch](git/copy-a-file-from-another-branch.md) - [Count All Files Of Specific Type Tracked By Git](git/count-all-files-of-specific-type-tracked-by-git.md) - [Create A New Branch With Git Switch](git/create-a-new-branch-with-git-switch.md) - [Delete All Untracked Files](git/delete-all-untracked-files.md) - [Determine The Hash Id For A Blob](git/determine-the-hash-id-for-a-blob.md) - [Diffing With Patience](git/diffing-with-patience.md) - [Dropping Commits With Git Rebase](git/dropping-commits-with-git-rebase.md) - [Dry Runs in Git](git/dry-runs-in-git.md) - [Exclude A File From A Diff Output](git/exclude-a-file-from-a-diff-output.md) - [Excluding Files Locally](git/excluding-files-locally.md) - [Extend Git With Custom Commands](git/extend-git-with-custom-commands.md) - [Find And Remove Files That Match A Name](git/find-and-remove-files-that-match-a-name.md) - [Find The Date That A File Was Added To The Repo](git/find-the-date-that-a-file-was-added-to-the-repo.md) - [Find The Initial Commit](git/find-the-initial-commit.md) - [Fix Whitespace Errors Throughout Branch Commits](git/fix-whitespace-errors-throughout-branch-commits.md) - [Get Latest Commit Timestamp For A File](git/get-latest-commit-timestamp-for-a-file.md) - [Get The Name Of The Current Branch](git/get-the-name-of-the-current-branch.md) - [Get The Short Version Of The Latest Commit](git/get-the-short-version-of-the-latest-commit.md) - [Grab A Single File From A Stash](git/grab-a-single-file-from-a-stash.md) - [Grep For A Pattern On Another Branch](git/grep-for-a-pattern-on-another-branch.md) - [Grep Over Commit Messages](git/grep-over-commit-messages.md) - [Highlight Extra Whitespace In Diff Output](git/highlight-extra-whitespace-in-diff-output.md) - [Ignore Changes To A Tracked File](git/ignore-changes-to-a-tracked-file.md) - [Ignore Files Specific To Your Workflow](git/ignore-files-specific-to-your-workflow.md) - [Include A Message With Your Stashed Changes](git/include-a-message-with-your-stashed-changes.md) - [Include Or Exclude Remaining Patch Changes](git/include-or-exclude-remaining-patch-changes.md) - [Include Some Stats In Your Git Log](git/include-some-stats-in-your-git-log.md) - [Intent To Add](git/intent-to-add.md) - [Interactively Checkout Specific Files From A Stash](git/interactively-checkout-specific-files-from-a-stash.md) - [Interactively Unstage Changes](git/interactively-unstage-changes.md) - [Keep File Locally With `git rm`](git/keep-file-locally-with-git-rm.md) - [Last Commit A File Appeared In](git/last-commit-a-file-appeared-in.md) - [List All Files Changed Between Two Branches](git/list-all-files-changed-between-two-branches.md) - [List Branches That Contain A Commit](git/list-branches-that-contain-a-commit.md) - [List Commits On A Branch](git/list-commits-on-a-branch.md) - [List Different Commits Between Two Branches](git/list-different-commits-between-two-branches.md) - [List Filenames Without The Diffs](git/list-filenames-without-the-diffs.md) - [List Just The Files Involved In A Commit](git/list-just-the-files-involved-in-a-commit.md) - [List Most Git Commands](git/list-most-git-commands.md) - [List Untracked Files](git/list-untracked-files.md) - [List Untracked Files For Scripting](git/list-untracked-files-for-scripting.md) - [Move The Latest Commit To A New Branch](git/move-the-latest-commit-to-a-new-branch.md) - [Override The Global Git Ignore File](git/override-the-global-git-ignore-file.md) - [Pick Specific Changes To Stash](git/pick-specific-changes-to-stash.md) - [Pulling In Changes During An Interactive Rebase](git/pulling-in-changes-during-an-interactive-rebase.md) - [Push To A Branch On Another Remote](git/push-to-a-branch-on-another-remote.md) - [Quicker Commit Fixes With The Fixup Flag](git/quicker-commit-fixes-with-the-fixup-flag.md) - [Rebase Commits With An Arbitrary Command](git/rebase-commits-with-an-arbitrary-command.md) - [Reference A Commit Via Commit Message Pattern Matching](git/reference-a-commit-via-commit-message-pattern-matching.md) - [Remove Untracked Files From A Directory](git/remove-untracked-files-from-a-directory.md) - [Rename A Remote](git/rename-a-remote.md) - [Renaming A Branch](git/renaming-a-branch.md) - [Resetting A Reset](git/resetting-a-reset.md) - [Resolve A Merge Conflict From Stash Pop](git/resolve-a-merge-conflict-from-stash-pop.md) - [Review Commits From Before A Certain Date](git/review-commits-from-before-a-certain-date.md) - [Run A Git Command From Outside The Repo](git/run-a-git-command-from-outside-the-repo.md) - [Set A Custom Pager For A Specific Command](git/set-a-custom-pager-for-a-specific-command.md) - [Set Default Branch Name For New Repos](git/set-default-branch-name-for-new-repos.md) - [Shorthand To Force Push A Branch](git/shorthand-to-force-push-a-branch.md) - [Show All Commits For A File Beyond Renaming](git/show-all-commits-for-a-file-beyond-renaming.md) - [Show Changes For Files That Match A Pattern](git/show-changes-for-files-that-match-a-pattern.md) - [Show Changes In The Compose Commit Message View](git/show-changes-in-the-compose-commit-message-view.md) - [Show File Diffs When Viewing Git Log](git/show-file-diffs-when-viewing-git-log.md) - [Show List Of Most Recently Committed Branches](git/show-list-of-most-recently-committed-branches.md) - [Show Only Commits That Touch Specific Lines](git/show-only-commits-that-touch-specific-lines.md) - [Show The diffstat Summary Of A Commit](git/show-the-diffstat-summary-of-a-commit.md) - [Show The Good And The Bad With Git Bisect](git/show-the-good-and-the-bad-with-git-bisect.md) - [Show What Is In A Stash](git/show-what-is-in-a-stash.md) - [Single Key Presses in Interactive Mode](git/single-key-presses-in-interactive-mode.md) - [Skip A Bad Commit When Bisecting](git/skip-a-bad-commit-when-bisecting.md) - [Skip Pre-Commit Hooks](git/skip-pre-commit-hooks.md) - [Staging Changes Within Vim](git/staging-changes-within-vim.md) - [Staging Stashes Interactively](git/staging-stashes-interactively.md) - [Stash A Single Untracked File](git/stash-a-single-untracked-file.md) - [Stash Everything](git/stash-everything.md) - [Stashing Only Unstaged Changes](git/stashing-only-unstaged-changes.md) - [Stashing Untracked Files](git/stashing-untracked-files.md) - [Switch To A Recent Branch With FZF](git/switch-to-a-recent-branch-with-fzf.md) - [Transition A Branch From One Base To Another](git/transition-a-branch-from-one-base-to-another.md) - [Turn Off The Output Pager For One Command](git/turn-off-the-output-pager-for-one-command.md) - [Two Kinds Of Dotted Range Notation](git/two-kinds-of-dotted-range-notation.md) - [Unstage Changes Wih Git Restore](git/unstage-changes-with-git-restore.md) - [Untrack A Directory Of Files Without Deleting](git/untrack-a-directory-of-files-without-deleting.md) - [Untrack A File Without Deleting It](git/untrack-a-file-without-deleting-it.md) - [Update The URL Of A Remote](git/update-the-url-of-a-remote.md) - [Using Commands With A Relative Date Format](git/using-commands-with-a-relative-date-format.md) - [Verbose Commit Message](git/verbose-commit-message.md) - [Viewing A File On Another Branch](git/viewing-a-file-on-another-branch.md) - [What Changed?](git/what-changed.md) - [What Is The Current Branch?](git/what-is-the-current-branch.md) - [Whitespace Warnings](git/whitespace-warnings.md) ### GitHub Actions - [Cache Playwright Dependencies Across Workflows](github-actions/cache-playwright-dependencies-across-workflows.md) - [Capture An Output Value For Use In A Later Step](github-actions/capture-an-output-value-for-use-in-a-later-step.md) - [Disable A Workflow With The gh CLI](github-actions/disable-a-workflow-with-the-gh-cli.md) - [Reference An Encrypted Secret In An Action](github-actions/reference-an-encrypted-secret-in-an-action.md) - [Trigger A Workflow Via An API Call](github-actions/trigger-a-workflow-via-an-api-call.md) ### Go - [Access Go Docs Offline](go/access-go-docs-offline.md) - [Add A Method To A Struct](go/add-a-method-to-a-struct.md) - [Build For A Specific OS And Architecture](go/build-for-a-specific-os-and-architecture.md) - [Check If Cobra Flag Was Set](go/check-if-cobra-flag-was-set.md) - [Combine Two Slices](go/combine-two-slices.md) - [Detect If Stdin Comes From A Redirect](go/detect-if-stdin-comes-from-a-redirect.md) - [Do Something N Times](go/do-something-n-times.md) - [Find Executables Installed By Go](go/find-executables-installed-by-go.md) - [Format Date And Time With Time Constants](go/format-date-and-time-with-time-constants.md) - [Not So Random](go/not-so-random.md) - [Parse A String Into Individual Fields](go/parse-a-string-into-individual-fields.md) - [Parse Flags From CLI Arguments](go/parse-flags-from-cli-arguments.md) - [Produce The Zero Value Of A Generic Type](go/produce-the-zero-value-of-a-generic-type.md) - [Redirect File To Stdin During Delve Debug](go/redirect-file-to-stdin-during-delve-debug.md) - [Replace The Current Process With An External Command](go/replace-the-current-process-with-an-external-command.md) - [Sleep For A Duration](go/sleep-for-a-duration.md) - [Sort Slice In Ascending Or Descending Order](go/sort-slice-in-ascending-or-descending-order.md) - [Upgrading From An Older Version On Mac](go/upgrading-from-an-older-version-on-mac.md) ### GROQ - [Grab Multiple Values From A Reference](groq/grab-multiple-values-from-a-reference.md) - [Grab Values From An Array Of References](groq/grab-values-from-an-array-of-references.md) - [Include Attributes When Conditional Check Passes](groq/include-attributes-when-conditional-check-passes.md) - [Include Type Of Operation In Webhook Response](groq/include-type-of-operation-in-webhook-response.md) ### Heroku - [Connect To A Database By Color](heroku/connect-to-a-database-by-color.md) - [Deploy A Review App To A Different Stack](heroku/deploy-a-review-app-to-a-different-stack.md) - [Diagnose Problems In A Heroku Postgres Database](heroku/diagnose-problems-in-a-heroku-postgres-database.md) - [Open Dashboard For Specific Add-On](heroku/open-dashboard-for-specific-add-on.md) - [Run SQL Against Remote Postgres Database](heroku/run-sql-against-remote-postgres-database.md) - [Set And Show Heroku Env Variables](heroku/set-and-show-heroku-env-variables.md) - [SSH Into Heroku Server Hosting App](heroku/ssh-into-heroku-server-hosting-app.md) ### HTML - [Adding Alt Text To An Image](html/adding-alt-text-to-an-image.md) - [Determine Which Button Submitted The Form](html/determine-which-button-submitted-the-form.md) - [Disable Auto-Completion For A Form Input](html/disable-auto-completion-for-a-form-input.md) - [Make Elements Non-Interactive With Inert](html/make-elements-non-interactive-with-inert.md) - [Prevent Search Engines From Indexing A Page](html/prevent-search-engines-from-indexing-a-page.md) - [Render Text As Superscript](html/render-text-as-superscript.md) - [Submit A Form With A Button Outside The Form](html/submit-a-form-with-a-button-outside-the-form.md) ### HTTP - [What Counts As Cross-Origin With CORS?](http/what-counts-as-cross-origin-with-cors.md) ### Inngest - [Ensure Lookup Can Be Retried](inngest/ensure-lookup-can-be-retried.md) - [Exit Function Early Without Retries](inngest/exit-function-early-without-retries.md) ### Internet - [Add Emoji To GitHub Repository Description](internet/add-emoji-to-github-repository-description.md) - [Add Styled Alerts To GitHub Markdown Documents](internet/add-styled-alerts-to-github-markdown-documents.md) - [Analyze Your Website Performance](internet/analyze-your-website-performance.md) - [Check Your Public IP Address](internet/check-your-public-ip-address.md) - [Digraph Unicode Characters Have A Titlecase](internet/digraph-unicode-characters-have-a-titlecase.md) - [Enable Keyboard Shortcuts In Gmail](internet/enable-keyboard-shortcuts-in-gmail.md) - [Exclude AI Overview From Google Search](internet/exclude-ai-overview-from-google-search.md) - [Exclude Whitespace Changes From GitHub Diffs](internet/exclude-whitespace-changes-from-github-diffs.md) - [Figure Out Your Public IP Address](internet/figure-out-your-public-ip-address.md) - [Focus The URL Bar](internet/focus-the-url-bar.md) - [Get Random Images From Unsplash](internet/get-random-images-from-unsplash.md) - [Search Tweets By Author](internet/search-tweets-by-author.md) - [Show All Pivotal Stories With Blockers](internet/show-all-pivotal-stories-with-blockers.md) - [Verify Site Ownership With DNS Record](internet/verify-site-ownership-with-dns-record.md) ### Java - [Ensure Resources Always Get Closed](java/ensure-resources-always-get-closed.md) - [Install Java On Mac With Brew](java/install-java-on-mac-with-brew.md) - [Run A Hello World Program In Eclipse](java/run-a-hello-world-program-in-eclipse.md) ### JavaScript - [Accessing Arguments To A Function](javascript/accessing-arguments-to-a-function.md) - [Add Item To An Array Of References In Sanity](javascript/add-item-to-an-array-of-references-in-sanity.md) - [Basic Date Formatting Without A Library](javascript/basic-date-formatting-without-a-library.md) - [Character Codes from Keyboard Listeners](javascript/character-codes-from-keyboard-listeners.md) - [Check Classes On A DOM Element](javascript/check-classes-on-a-dom-element.md) - [Check If A Number Is Positive Or Negative](javascript/check-if-a-number-is-positive-or-negative.md) - [Check If File Exists Before Reading It](javascript/check-if-file-exists-before-reading-it.md) - [Check If Something Is An Array](javascript/check-if-something-is-an-array.md) - [Check Media Queries From JavaScript](javascript/check-media-queries-from-javascript.md) - [Check The Password Confirmation With Yup](javascript/check-the-password-confirmation-with-yup.md) - [Compare The Equality Of Two Date Objects](javascript/compare-the-equality-of-two-date-objects.md) - [Computed Property Names In ES6](javascript/computed-property-names-in-es6.md) - [Conditionally Include Pairs In An Object](javascript/conditionally-include-pairs-in-an-object.md) - [Configure Jest To Run A Test Setup File](javascript/configure-jest-to-run-a-test-setup-file.md) - [Convert Seconds To Date Object](javascript/convert-seconds-to-date-object.md) - [Create A Cancelable Promise With PCancelable](javascript/create-a-cancelable-promise-with-pcancelable.md) - [Create An Array Containing 1 To N](javascript/create-an-array-containing-1-to-n.md) - [Create An Object With No Properties](javascript/create-an-object-with-no-properties.md) - [Create Bootstrapped Apps With Yarn](javascript/create-bootstrapped-apps-with-yarn.md) - [Create Future And Past Dates From Today](javascript/create-future-and-past-dates-from-today.md) - [Custom Type Checking Error Messages With Yup](javascript/custom-type-checking-error-messages-with-yup.md) - [Default And Named Exports From The Same Module](javascript/default-and-named-exports-from-the-same-module.md) - [Define A Custom Jest Matcher](javascript/define-a-custom-jest-matcher.md) - [Destructure With Access To Nested Value And Parent Value](javascript/destructure-with-access-to-nested-value-and-parent-value.md); - [Destructuring The Rest Of An Array](javascript/destructuring-the-rest-of-an-array.md) - [Enable ES7 Transforms With react-rails](javascript/enable-es7-transforms-with-react-rails.md) - [Ensure Shell Can Find Global npm Binaries](javascript/ensure-shell-can-find-global-npm-binaries.md) - [Easy Date Comparison With DayJS](javascript/easy-date-comparison-with-dayjs.md) - [Expand Emojis With The Spread Operator](javascript/expand-emojis-with-the-spread-operator.md) - [Fill An Input With A Ton Of Text](javascript/fill-an-input-with-a-ton-of-text.md) - [Find The Version Of An Installed Dependency](javascript/find-the-version-of-an-installed-dependency.md) - [Find Where Yarn Is Installing Binaries](javascript/find-where-yarn-is-installing-binaries.md) - [for...in Iterates Over Object Properties](javascript/for-in-iterates-over-object-properties.md) - [Format A Decimal To A Fixed Number Of Digits](javascript/format-a-decimal-to-a-fixed-number-of-digits.md) - [Format Time Zone Identifier](javascript/format-time-zone-identifier.md) - [Formatting Values With Units For Display](javascript/formatting-values-with-units-for-display.md) - [Freeze An Object, Sorta](javascript/freeze-an-object-sorta.md) - [Generate A V4 UUID In The Browser](javascript/generate-a-v4-uuid-in-the-browser.md) - [Generate Random Integers](javascript/generate-random-integers.md) - [Get The Location And Size Of An Element](javascript/get-the-location-and-size-of-an-element.md) - [Get The Response Status From An Axios Error](javascript/get-the-response-status-from-an-axios-error.md) - [Get The Time Components Of A Date](javascript/get-the-time-components-of-a-date.md) - [Get The Time Zone Of The Client Computer](javascript/get-the-time-zone-of-the-client-computer.md) - [Globally Install A Package With Yarn](javascript/globally-install-a-package-with-yarn.md) - [Globally Install Specific Version Of PNPM](javascript/globally-install-specific-version-of-pnpm.md) - [Immutable Remove With The Spread Operator](javascript/immutable-remove-with-the-spread-operator.md) - [Initialize A New JavaScript Project With Yarn](javascript/initialize-a-new-javascript-project-with-yarn.md) - [Install The Latest Version Of Node With Nvm](javascript/install-the-latest-version-of-node-with-nvm.md) - [Interpolate A String Into A Regex](javascript/interpolate-a-string-into-a-regex.md) - [ISO-8601 Formatted Dates Are Interpreted As UTC](javascript/iso-8601-formatted-dates-are-interpreted-as-utc.md) - [Link A JavaScript Package Locally](javascript/link-a-javascript-package-locally.md) - [List Top-Level NPM Dependencies](javascript/list-top-level-npm-dependencies.md) - [Load And Use Env Var In Node Script](javascript/load-and-use-env-var-in-node-script.md) - [Make The Browser Editable With Design Mode](javascript/make-the-browser-editable-with-design-mode.md) - [Make Truly Deep Clone With Structured Clone](javascript/make-truly-deep-clone-with-structured-clone.md) - [Matching A Computed Property In Function Args](javascript/matching-a-computed-property-in-function-args.md) - [Matching Multiple Values In A Switch Statement](javascript/matching-multiple-values-in-a-switch-statement.md) - [Mock A Function With Return Values Using Jest](javascript/mock-a-function-with-return-values-using-jest.md) - [New Dates Can Take Out Of Bounds Values](javascript/new-dates-can-take-out-of-bounds-values.md) - [Numbers Are Empty](javascript/numbers-are-empty.md) - [Object Initialization With Shorthand Property Names](javascript/object-initialization-with-shorthand-property-names.md) - [Obtain Undefined Value With The Void Operator](javascript/obtain-undefined-value-with-the-void-operator.md) - [Open Global npm Config File](javascript/open-global-npm-config-file.md) - [Parse A Date From A Timestamp](javascript/parse-a-date-from-a-timestamp.md) - [Pre And Post Hooks For Yarn Scripts](javascript/pre-and-post-hooks-for-yarn-scripts.md) - [Prevent Hidden Element From Flickering On Load](javascript/prevent-hidden-element-from-flickering-on-load.md) - [Purge Null And Undefined Values From Object](javascript/purge-null-and-undefined-values-from-object.md) - [Random Cannot Be Seeded](javascript/random-cannot-be-seeded.md) - [Reach Into An Object For Nested Data With Get](javascript/reach-into-an-object-for-nested-data-with-get.md) - [Render An Array Of Elements With React 16](javascript/render-an-array-of-elements-with-react-16.md) - [Resolve And Pass Multiple Values From A Then](javascript/resolve-and-pass-multiple-values-from-a-then.md) - [Run A Bash Script From A Node Script](javascript/run-a-bash-script-from-a-node-script.md) - [Run Multiple Node Scripts Concurrently](javascript/run-multiple-node-scripts-concurrently.md) - [Running ES6 Specs With Mocha](javascript/running-es6-specs-with-mocha.md) - [Scoping Variables With A Block Statement](javascript/scoping-variables-with-a-block-statement.md) - [Short Circuit Concurrently When Process Fails](javascript/short-circuit-concurrently-when-process-fails.md) - [Show Description Of All npm Config Options](javascript/show-description-of-all-npm-config-options.md) - [Sleep For A Bit In Async Code](javascript/sleep-for-a-bit-in-async-code.md) - [Sorting Arrays Of Objects With Lodash](javascript/sorting-arrays-of-objects-with-lodash.md) - [Splat Arguments To A Function](javascript/splat-arguments-to-a-function.md) - [Spread Merging Objects Includes Nil Values](javascript/spread-merging-objects-includes-nil-values.md) - [Spread The Rest With ES6](javascript/spread-the-rest-with-es6.md) - [Start Node Process In Specific Timezone](javascript/start-node-process-in-specific-timezone.md) - [String Interpolation With Template Literals](javascript/string-interpolation-with-template-literals.md) - [Support Nested Matching In Custom Jest Matchers](javascript/support-nested-matching-in-custom-jest-matchers.md) - [Tell Jest To Focus On Running Only One Test](javascript/tell-jest-to-focus-on-running-only-one-test.md) - [Tell Node To Treat JS Files As ESM](javascript/tell-node-to-treat-js-files-as-esm.md) - [Tell Prettier To Not Format A Statement](javascript/tell-prettier-to-not-format-a-statement.md) - [Test Coverage Stats With Jest](javascript/test-coverage-stats-with-jest.md) - [Test Timing-Based Code With Jest Fake Timers](javascript/test-timing-based-code-with-jest-fake-timers.md) - [The Comma Operator](javascript/the-comma-operator.md) - [Throttling A Function Call](javascript/throttling-a-function-call.md) - [Timing Processes](javascript/timing-processes.md) - [Transforming ES6 and JSX With Babel 6](javascript/transforming-es6-and-jsx-with-babel-6.md) - [Truthiness of Integer Arrays](javascript/truthiness-of-integer-arrays.md) - [Turn An HTMLCollection Into An Array](javascript/turn-an-html-collection-into-an-array.md) - [Turn Off Console Error Messages In A Test](javascript/turn-off-console-error-messages-in-a-test.md) - [Turn Off npm Funding Message](javascript/turn-off-npm-funding-message.md) - [Waiting On Multiple Promises](javascript/waiting-on-multiple-promises.md) - [Who Am I: NPM Edition](javascript/who-am-i-npm-edition.md) - [Write A JavaScript Object To A JSON File](javascript/write-a-javascript-object-to-a-json-file.md) - [Yarn Commands Without The Emojis](javascript/yarn-commands-without-the-emojis.md) - [Yup Schemas Are Validated Asynchronously](javascript/yup-schemas-are-validated-asynchronously.md) ### jj - [Colocate jj And git Directories For Project](jj/colocate-jj-and-git-directories-for-project.md) - [Find System-wide Config File For User](jj/find-system-wide-config-file-for-user.md) ### jq - [Combine An Array Of Objects Into A Single Object](jq/combine-an-array-of-objects-into-a-single-object.md) - [Count Each Collection In A JSON Object](jq/count-each-collection-in-a-json-object.md) - [Count The Number Of Things In A JSON File](jq/count-the-number-of-things-in-a-json-file.md) - [Extract A List Of Values](jq/extract-a-list-of-values.md) - [Filter Out Results Based On List Of Values](jq/filter-out-results-based-on-list-of-values.md) - [Find All Objects In An Array Where Key Is Set](jq/find-all-objects-in-an-array-where-key-is-set.md) - [Find All Objects With A Matching Key Value Pair](jq/find-all-objects-with-a-matching-key-value-pair.md) - [Get A Slice Of The Ends Of An Array](jq/get-a-slice-of-the-ends-of-an-array.md) - [Get The First Item For Every Top-Level Key](jq/get-the-first-item-for-every-top-level-key.md) - [Get The Last Item From An Array](jq/get-the-last-item-from-an-array.md) - [Reduce Object To Just Entries Of A Specific Type](jq/reduce-object-to-just-entries-of-a-specific-type.md) - [Turn A List From A Command Into JSON](jq/turn-a-list-from-a-command-into-json.md) - [Zip Two JSON Files Together Based On Shared ID](jq/zip-two-json-files-together-based-on-shared-id.md) ### Kitty - [Set The Title Of A Window](kitty/set-the-title-of-a-window.md) - [Use The Built-In Emoji Picker](kitty/use-the-built-in-emoji-picker.md) ### Linux - [Check Ubuntu Version](linux/check-ubuntu-version.md) - [Configure Your Server Timezone](linux/configure-your-server-timezone.md) - [List The Statuses Of All Upstart Jobs](linux/list-the-statuses-of-all-upstart-jobs.md) - [Show Current System Time And Settings](linux/show-current-system-time-and-settings.md) - [Show Used And Available System Memory](linux/show-used-and-available-system-memory.md) - [Upgrading Ubuntu](linux/upgrading-ubuntu.md) ### LLM - [Send cURL To Claude Text Completion API](llm/send-curl-to-claude-text-completion-api.md) - [Use The llm CLI With Claude Models](llm/use-the-llm-cli-with-claude-models.md) ### Mac - [Access All Screen And Video Capture Options](mac/access-all-screen-and-video-capture-options.md) - [Access System Information On OS X](mac/access-system-information-on-osx.md) - [Access Unsupported Screen Resolutions With RDM](mac/access-unsupported-screen-resolutions-with-rdm.md) - [Check Network Quality Stats From The Command Line](mac/check-network-quality-stats-from-the-command-line.md) - [Clean Up Old Homebrew Files](mac/clean-up-old-homebrew-files.md) - [Convert An HEIC Image File To JPG](mac/convert-an-heic-image-file-to-jpg.md) - [Default Screenshot Location](mac/default-screenshot-location.md) - [Disable Swipe Navigation For A Specific App](mac/disable-swipe-navigation-for-a-specific-app.md) - [Display A Message With Alfred](mac/display-a-message-with-alfred.md) - [Find The Process Using A Specific Port](mac/find-the-process-using-a-specific-port.md) - [Gesture For Viewing All Windows Of Current App](mac/gesture-for-viewing-all-windows-of-current-app.md) - [Insert A Non-Breaking Space Character](mac/insert-a-non-breaking-space-character.md) - [Keyboard Shortcuts For Interesting With Text Areas](mac/keyboard-shortcuts-for-interacting-with-text-areas.md) - [List All The Say Voices](mac/list-all-the-say-voices.md) - [Open Finder.app To Specific Directory](mac/open-finder-app-to-specific-directory.md) - [Quickly Type En Dashes And Em Dashes](mac/quickly-type-en-dashes-and-em-dashes.md) - [Require Additional JS Libraries In Postman](mac/require-additional-js-libraries-in-postman.md) - [Resize App Windows With AppleScript](mac/resize-app-windows-with-applescript.md) - [Resizing Both Corners Of A Window](mac/resizing-both-corners-of-a-window.md) - [Run A Hardware Check](mac/run-a-hardware-check.md) - [Run AppleScript Commands Inline In The Terminal](mac/run-applescript-commands-inline-in-the-terminal.md) - [Set A Window To Its Default Zoom Level](mac/set-a-window-to-its-default-zoom-level.md) - [Specify App When Opening From Command Line](mac/specify-app-when-opening-from-command-line.md) - [Use Default Screenshot Shortcuts With CleanShot X](mac/use-default-screenshot-shortcuts-with-cleanshot-x.md) - [View All Windows Of The Current App](mac/view-all-windows-of-the-current-app.md) - [Write System Clipboard To A File](mac/write-system-clipboard-to-a-file.md) ### MongoDB - [Determine The Database Version](mongodb/determine-the-database-version.md) - [Dump A Remote Database](mongodb/dump-a-remote-database.md) - [Dump And Restore With A Single gzip File](mongodb/dump-and-restore-with-a-single-gzip-file.md) - [Get Size Stats For A Collection](mongodb/get-size-stats-for-a-collection.md) - [List Size Stats For All Collections](mongodb/list-size-stats-for-all-collections.md) ### MySQL - [Change Existing Column To Not Null](mysql/change-existing-column-to-not-null.md) - [Connect To A Database In Safe Update Mode](mysql/connect-to-a-database-in-safe-update-mode.md) - [Default Username And Password For New Instance](mysql/default-username-and-password-for-new-instance.md) - [Display Output In A Vertical Format](mysql/display-output-in-a-vertical-format.md) - [Doing Date Math](mysql/doing-date-math.md) - [Dump A Database To A File](mysql/dump-a-database-to-a-file.md) - [Echo A Message From A SQL File](mysql/echo-a-message-from-a-sql-file.md) - [Ignore Duplicates When Inserting Records](mysql/ignore-duplicates-when-inserting-records.md) - [List Databases And Tables](mysql/list-databases-and-tables.md) - [Run Statements In A Transaction](mysql/run-statements-in-a-transaction.md) - [Select Rows After An Offset](mysql/select-rows-after-an-offset.md) - [Set Value On Null JSON Column](mysql/set-value-on-null-json-column.md) - [Show Create Statement For A Table](mysql/show-create-statement-for-a-table.md) - [Show Tables That Match A Pattern](mysql/show-tables-that-match-a-pattern.md) - [Show Indexes For A Table](mysql/show-indexes-for-a-table.md) ### Neovim - [Allow Neovim To Copy/Paste With System Clipboard](neovim/allow-neovim-to-copy-paste-with-system-clipboard.md) - [Create User Command To Open Init Config](neovim/create-user-command-to-open-init-config.md) - [Run A Lua Statement From The Command Prompt](neovim/run-a-lua-statement-from-the-command-prompt.md) - [Set Up Vim-Plug With Neovim](neovim/set-up-vim-plug-with-neovim.md) ### Netlify - [Override The Default Yarn Version](netlify/override-the-default-yarn-version.md) ### NextAuth.js - [Adjust The Shape Of The User Type](next-auth/adjust-the-shape-of-the-user-type.md) ### Next.js - [Avoid Conflicting Files](nextjs/avoid-conflicting-files.md) - [Create Files And Directories For Dynamic Routes](nextjs/create-files-and-directories-for-dynamic-routes.md) - [Define URL Redirects In The Next Config](nextjs/define-url-redirects-in-the-next-config.md) - [Fetch Does Not Work In API Serverless Function](nextjs/fetch-does-not-work-in-api-serverless-function.md) - [Make Environment Variable Publicly Available](nextjs/make-environment-variable-publicly-available.md) - [Match Middleware On Groups Of Paths](nextjs/match-middleware-on-groups-of-paths.md) - [Organize Pages In Route Groups](nextjs/organize-pages-in-route-groups.md) - [Precedence Of Dot Env Files](nextjs/precedence-of-dot-env-files.md) - [Push A Route With A URL Object](nextjs/push-a-route-with-a-url-object.md) - [Redirect An Unauthorized User](nextjs/redirect-an-unauthorized-user.md) - [Remove A Query Param From The URL](nextjs/remove-a-query-param-from-the-url.md) - [Ship Public Assets With A Next.js App](nextjs/ship-public-assets-with-a-nextjs-app.md) ### Phoenix - [Bypass Template Rendering](phoenix/bypass-template-rendering.md) - [Check The Installed Version](phoenix/check-the-installed-version.md) - [Generate New App Without Brunch](phoenix/generate-new-app-without-brunch.md) - [Render A Template To A String](phoenix/render-a-template-to-a-string.md) - [Serve Static Assets From Custom Directory](phoenix/serve-static-assets-from-custom-directory.md) - [Specifying The Digest Directory](phoenix/specifying-the-digest-directory.md) - [Specifying The Server Port](phoenix/specifying-the-server-port.md) ### Planetscale - [Seed Production Data Into Another Branch](planetscale/seed-production-data-into-another-branch.md) ### pnpm - [Execute A Command From The Workspace Root](pnpm/execute-a-command-from-the-workspace-root.md) - [Install Command Runs For Entire Workspace](pnpm/install-command-runs-for-entire-workspace.md) - [List The Installed Version Of A Specific Package](pnpm/list-the-installed-version-of-a-specific-package.md) ### PostgreSQL - [A Better Null Display Character](postgres/a-better-null-display-character.md) - [Add Foreign Key Constraint Without A Full Lock](postgres/add-foreign-key-constraint-without-a-full-lock.md) - [Add ON DELETE CASCADE To Foreign Key Constraint](postgres/add-on-delete-cascade-to-foreign-key-constraint.md) - [Add Unique Constraint Using Existing Index](postgres/add-unique-constraint-using-existing-index.md) - [Adding Composite Uniqueness Constraints](postgres/adding-composite-uniqueness-constraints.md) - [Aggregate A Column Into An Array](postgres/aggregate-a-column-into-an-array.md) - [Assumed Radius Of The Earth](postgres/assumed-radius-of-the-earth.md) - [Auto Expanded Display](postgres/auto-expanded-display.md) - [Between Symmetric](postgres/between-symmetric.md) - [Capitalize All The Words](postgres/capitalize-all-the-words.md) - [Change The Current Directory For psql](postgres/change-the-current-directory-for-psql.md) - [Change The Owner Of A Sequence](postgres/change-the-owner-of-a-sequence.md) - [Check If Clusters Are Upgrade Compatible](postgres/check-if-clusters-are-upgrade-compatible.md) - [Check If The Local Server Is Running](postgres/check-if-the-local-server-is-running.md) - [Check If User Role Exists For Database](postgres/check-if-user-role-exists-for-database.md) - [Check Table For Any Oprhaned Records](postgres/check-table-for-any-orphaned-records.md) - [Checking Inequality](postgres/checking-inequality.md) - [Checking The Type Of A Value](postgres/checking-the-type-of-a-value.md) - [Clear The Screen In psql](postgres/clear-the-screen-in-psql.md) - [Clear The Screen In psql (2)](postgres/clear-the-screen-in-psql-2.md) - [Compute Hashes With pgcrypto](postgres/compute-hashes-with-pgcrypto.md) - [Compute The Levenshtein Distance Of Two Strings](postgres/compute-the-levenshtein-distance-of-two-strings.md) - [Compute The md5 Hash Of A String](postgres/compute-the-md5-hash-of-a-string.md) - [Concatenate Strings With A Separator](postgres/concatenate-strings-with-a-separator.md) - [Configure The Timezone](postgres/configure-the-timezone.md) - [Constructing A Range Of Dates](postgres/constructing-a-range-of-dates.md) - [Convert A String To A Timestamp](postgres/convert-a-string-to-a-timestamp.md) - [Count How Many Records There Are Of Each Type](postgres/count-how-many-records-there-are-of-each-type.md) - [Count Records By Type](postgres/count-records-by-type.md) - [Count The Number Of Trues In An Aggregate Query](postgres/count-the-number-of-trues-in-an-aggregate-query.md) - [Create A Cluster In A Specific Data Directory](postgres/create-a-cluster-in-a-specific-data-directory.md) - [Create A Composite Primary Key](postgres/create-a-composite-primary-key.md) - [Create A Table From The Structure Of Another](postgres/create-a-table-from-the-structure-of-another.md) - [Create An Index Across Two Columns](postgres/create-an-index-across-two-columns.md) - [Create An Index Without Locking The Table](postgres/create-an-index-without-locking-the-table.md) - [Create Database Uses Template1](postgres/create-database-uses-template1.md) - [Create hstore From Two Arrays](postgres/create-hstore-from-two-arrays.md) - [Create Table Adds A Data Type](postgres/create-table-adds-a-data-type.md) - [Creating Conditional Constraints](postgres/creating-conditional-constraints.md) - [Creating Custom Types](postgres/creating-custom-types.md) - [Day Of Week By Name For A Date](postgres/day-of-week-by-name-for-a-date.md) - [Day Of Week For A Date](postgres/day-of-week-for-a-date.md) - [Default Schema](postgres/default-schema.md) - [Defining Arrays](postgres/defining-arrays.md) - [Determine Types Of JSONB Records](postgres/determine-types-of-jsonb-records.md) - [Determining The Age Of Things](postgres/determining-the-age-of-things.md) - [Difference Between Explain And Explain Analyze](postgres/difference-between-explain-and-explain-analyze.md) - [Different Ways To Define An Interval](postgres/different-ways-to-define-an-interval.md) - [Dump All Databases To A SQL File](postgres/dump-all-databases-to-a-sql-file.md) - [Dump And Restore A Database](postgres/dump-and-restore-a-database.md) - [Dump The SQL Needed To Recreate A Table](postgres/dump-the-sql-needed-recreate-a-table.md) - [Duplicate A Local Database](postgres/duplicate-a-local-database.md) - [Edit Existing Functions](postgres/edit-existing-functions.md) - [Enable Logging Of Database Activity](postgres/enable-logging-of-database-activity.md) - [Enforce Uniqueness On Column Expression](postgres/enforce-uniqueness-on-column-expression.md) - [Escaping A Quote In A String](postgres/escaping-a-quote-in-a-string.md) - [Escaping String Literals With Dollar Quoting](postgres/escaping-string-literals-with-dollar-quoting.md) - [Export Query Results To A CSV](postgres/export-query-results-to-a-csv.md) - [Extracting Nested JSON Data](postgres/extracting-nested-json-data.md) - [Fetch Specific Number Of Results](postgres/fetch-specific-number-of-results.md) - [Find Duplicate Records In Table Without Unique Id](postgres/find-duplicate-records-in-table-without-unique-id.md) - [Find Records That Contain Duplicate Values](postgres/find-records-that-contain-duplicate-values.md) - [Find Records That Have Multiple Associated Records](postgres/find-records-that-have-multiple-associated-records.md) - [Find The Data Directory](postgres/find-the-data-directory.md) - [Find The Location Of Postgres Config Files](postgres/find-the-location-of-postgres-config-files.md) - [Fizzbuzz With Common Table Expressions](postgres/fizzbuzz-with-common-table-expressions.md) - [Force SSL When Making A psql Connection](postgres/force-ssl-when-making-a-psql-connection.md) - [Generate A UUID](postgres/generate-a-uuid.md) - [Generate Modern Primary Key Columns](postgres/generate-modern-primary-key-columns.md) - [Generate Random Alphanumeric Identifier](postgres/generate-random-alphanumeric-identifier.md) - [Generate Random UUIDs Without An Extension](postgres/generate-random-uuids-without-an-extension.md) - [Generate Series Of Numbers](postgres/generate-series-of-numbers.md) - [Generating UUIDs With pgcrypto](postgres/generating-uuids-with-pgcrypto.md) - [Get A Quick Approximate Count Of A Table](postgres/get-a-quick-approximate-count-of-a-table.md) - [Get Row Count For Most Recent Query](postgres/get-row-count-for-most-recent-query.md) - [Get The Size On Disk of An Index](postgres/get-the-size-on-disk-of-an-index.md) - [Get The Size Of A Database](postgres/get-the-size-of-a-database.md) - [Get The Size Of A Table](postgres/get-the-size-of-a-table.md) - [Get The Size Of An Index](postgres/get-the-size-of-an-index.md) - [Getting A Slice Of An Array](postgres/getting-a-slice-of-an-array.md) - [Group By The Result Of A Function Call](postgres/group-by-the-result-of-a-function-call.md) - [Idempotent Inserts](postgres/idempotent-inserts.md) - [Include All Queries In The Log File](postgres/include-all-queries-in-the-log-file.md) - [Include Columns In A Covering Index](postgres/include-columns-in-a-covering-index.md) - [Include Multiple Tables In A pg_dump](postgres/include-multiple-tables-in-a-pg-dump.md) - [Insert A Bunch Of Records With Generate Series](postgres/insert-a-bunch-of-records-with-generate-series.md) - [Insert Just The Defaults](postgres/insert-just-the-defaults.md) - [Inspect Progress Of Long-Running Create Index](postgres/inspect-progress-of-long-running-create-index.md) - [Install Postgres With uuid-ossp Using asdf](postgres/install-postgres-with-uuid-ossp-using-asdf.md) - [Integers In Postgres](postgres/integers-in-postgres.md) - [Intervals Of Time By Week](postgres/intervals-of-time-by-week.md) - [Is It Null Or Not Null?](postgres/is-it-null-or-not-null.md) - [Label Dollar-Quoted Strings With A Tag](postgres/label-dollar-quoted-strings-with-a-tag.md) - [Limit Execution Time Of Statements](postgres/limit-execution-time-of-statements.md) - [List All Columns Of A Specific Type](postgres/list-all-columns-of-a-specific-type.md) - [List All Rows In A Table](postgres/list-all-rows-in-a-table.md) - [List All The Databases](postgres/list-all-the-databases.md) - [List All Versions Of A Function](postgres/list-all-versions-of-a-function.md) - [List Available Schemas](postgres/list-available-schemas.md) - [List Connections To A Database](postgres/list-connections-to-a-database.md) - [List Databases Available For Connecting](postgres/list-databases-available-for-connecting.md) - [List Database Objects With Disk Usage](postgres/list-database-objects-with-disk-usage.md) - [List Database Users](postgres/list-database-users.md) - [List Various Kinds Of Objects](postgres/list-various-kinds-of-objects.md) - [Lower Is Faster Than ilike](postgres/lower-is-faster-than-ilike.md) - [Manage Major Versions With Brew And Direnv](postgres/manage-major-versions-with-brew-and-direnv.md) - [Max Identifier Length Is 63 Bytes](postgres/max-identifier-length-is-63-bytes.md) - [Open Heroku Database In Postico From Terminal](postgres/open-heroku-database-in-postico-from-terminal.md) - [Output Explain Query Plan In Different Formats](postgres/output-explain-query-plan-in-different-formats.md) - [pg Prefix Is Reserved For System Schemas](postgres/pg-prefix-is-reserved-for-system-schemas.md) - [Postgres Does Not Support Unsigned Integers](postgres/postgres-does-not-support-unsigned-integers.md) - [Prepare, Execute, And Deallocate Statements](postgres/prepare-execute-and-deallocate-statements.md) - [Pretty Print Data Sizes](postgres/pretty-print-data-sizes.md) - [Pretty Printing JSONB Rows](postgres/pretty-printing-jsonb-rows.md) - [Prevent A Query From Running Too Long](postgres/prevent-a-query-from-running-too-long.md) - [Print The Query Buffer In psql](postgres/print-the-query-buffer-in-psql.md) - [Put Unique Constraint On Generated Column](postgres/put-unique-constraint-on-generated-column.md) - [Remove Not Null Constraint From A Column](postgres/remove-not-null-constraint-from-a-column.md) - [Renaming A Sequence](postgres/renaming-a-sequence.md) - [Renaming A Table](postgres/renaming-a-table.md) - [Restart A Sequence](postgres/restart-a-sequence.md) - [Restarting Sequences When Truncating Tables](postgres/restarting-sequences-when-truncating-tables.md) - [Salt And Hash A Password With pgcrypto](postgres/salt-and-hash-a-password-with-pgcrypto.md) - [Send A Command To psql](postgres/send-a-command-to-psql.md) - [Set Inclusion With hstore](postgres/set-inclusion-with-hstore.md) - [Set A Seed For The Random Number Generator](postgres/set-a-seed-for-the-random-number-generator.md) - [Set A Statement Timeout Threshold For A Session](postgres/set-a-statement-timeout-threshold-for-a-session.md) - [Sets With The Values Command](postgres/sets-with-the-values-command.md) - [Shorthand Absolute Value Operator](postgres/shorthand-absolute-value-operator.md) - [Show All Versions Of An Operator](postgres/show-all-versions-of-an-operator.md) - [Show The Hidden Queries Behind Backslash Commands](postgres/show-the-hidden-queries-behind-backslash-commands.md) - [Sleeping](postgres/sleeping.md) - [Special Math Operators](postgres/special-math-operators.md) - [Storing Emails With citext](postgres/storing-emails-with-citext.md) - [String Contains Another String](postgres/string-contains-another-string.md) - [Survey Of User-Defined Ordering Of Records](postgres/survey-of-user-defined-ordering-of-records.md) - [Switch Non-Castable Column Type With Using Clause](postgres/switch-non-castable-column-type-with-using-clause.md) - [Switch The Running Postgres Server Version](postgres/switch-the-running-postgres-server-version.md) - [Table Names Are Treated As Lower-Case By Default](postgres/table-names-are-treated-as-lower-case-by-default.md) - [Temporarily Disable Triggers](postgres/temporarily-disable-triggers.md) - [Temporary Tables](postgres/temporary-tables.md) - [Terminating A Connection](postgres/terminating-a-connection.md) - [The nullif Function](postgres/the-nullif-function.md) - [Timestamp Functions](postgres/timestamp-functions.md) - [Toggling The Pager In PSQL](postgres/toggling-the-pager-in-psql.md) - [Track psql History Separately Per Database](postgres/track-psql-history-separately-per-database.md) - [Truncate All Rows](postgres/truncate-all-rows.md) - [Truncate Tables With Dependents](postgres/truncate-tables-with-dependents.md) - [Turning Timing On](postgres/turn-timing-on.md) - [Two Ways To Compute Factorial](postgres/two-ways-to-compute-factorial.md) - [Two Ways To Escape A Quote In A String](postgres/two-ways-to-escape-a-quote-in-a-string.md) - [Types By Category](postgres/types-by-category.md) - [Union All Rows Including Duplicates](postgres/union-all-rows-including-duplicates.md) - [Use A psqlrc File For Common Settings](postgres/use-a-psqlrc-file-for-common-settings.md) - [Use A Trigger To Mirror Inserts To Another Table](postgres/use-a-trigger-to-mirror-inserts-to-another-table.md) - [Use Argument Indexes](postgres/use-argument-indexes.md) - [Use Not Valid To Immediately Enforce A Constraint](postgres/use-not-valid-to-immediately-enforce-a-constraint.md) - [Use Rename To Hot Swap Two Tables](postgres/use-rename-to-hot-swap-two-tables.md) - [Use Variables In An Anonymous Function](postgres/use-variables-in-an-anonymous-function.md) - [Using Expressions In Indexes](postgres/using-expressions-in-indexes.md) - [Using Intervals To Offset Time](postgres/using-intervals-to-offset-time.md) - [Who Is The Current User](postgres/who-is-the-current-user.md) - [Word Count for a Column](postgres/word-count-for-a-column.md) - [Write A Query Result To File](postgres/write-a-query-result-to-file.md) ### Prisma - [Apply Separate Formatting With A Blank Line](prisma/apply-separate-formatting-with-a-blank-line.md) - [Batch Insert Records With createMany](prisma/batch-insert-records-with-create-many.md) - [Check If Database And Schema Are Not In Sync](prisma/check-if-database-and-schema-are-not-in-sync.md) - [Configure Client To Log SQL Queries](prisma/configure-client-to-log-sql-queries.md) - [Execute A Raw SQL Query](prisma/execute-a-raw-sql-query.md) - [Grab A Limited Set Of Records](prisma/grab-a-limited-set-of-records.md) - [Open Connections To Multiple Databases](prisma/open-connections-to-multiple-databases.md) - [Override Table Name For Prisma Model](prisma/override-table-name-for-prisma-model.md) - [Specify Alternate Location For Prisma Schema](prisma/specify-alternate-location-for-prisma-schema.md) ### Python - [Access Instance Variables](python/access-instance-variables.md) - [Create A Dummy DataFrame In Pandas](python/create-a-dummy-dataframe-in-pandas.md) - [Dunder Methods](python/dunder-methods.md) - [Override The Boolean Context Of A Class](python/override-the-boolean-context-of-a-class.md) - [Store And Access Immutable Data In A Tuple](python/store-and-access-immutable-data-in-a-tuple.md) - [Test A Function With Pytest](python/test-a-function-with-pytest.md) - [Use pipx To Install End User Apps](python/use-pipx-to-install-end-user-apps.md) ### Rails - [Add A Check Constraint To A Table](rails/add-a-check-constraint-to-a-table.md) - [Add A Database Index If It Does Not Already Exist](rails/add-a-database-index-if-it-does-not-already-exist.md) - [Add A Foreign Key Reference To A Table](rails/add-a-foreign-key-reference-to-a-table.md) - [Add A Reference Column With An Index](rails/add-a-reference-column-with-an-index.md) - [Add ActiveRecord Error Not Tied To Any Attribute](rails/add-activerecord-error-not-tied-to-any-attribute.md) - [Add React With Webpacker To A New Rails App](rails/add-react-with-webpacker-to-a-new-rails-app.md) - [Add timestamptz Columns With The Migration DSL](rails/add-timestamptz-columns-with-the-migration-dsl.md) - [Access Secrets In A Rails 5.2 App](rails/access-secrets-in-a-rails-5-2-app.md) - [ActiveRecord Query For This Or That](rails/active-record-query-for-this-or-that.md) - [Advance The Date](rails/advance-the-date.md) - [Allow Associations To Be Optional](rails/allow-associations-to-be-optional.md) - [Allow List Params Anywhere With Strong Params](rails/allow-list-params-anywhere-with-strong-params.md) - [All or Nothing Database Transactions](rails/all-or-nothing-database-transactions.md) - [Alphabetize Schema Columns To Keep Them Consistent](rails/alphabetize-schema-columns-to-keep-them-consistent.md) - [Alter The Rails Setup Script](rails/alter-the-rails-setup-script.md) - [Assert Two Arrays Have The Same Items With RSpec](rails/assert-two-arrays-have-the-same-items-with-rspec.md) - [Attach A File With Capybara](rails/attach-a-file-with-capybara.md) - [Attribute Getter without the Recursion](rails/attribute-getter-without-the-recursion.md) - [Attribute Was](rails/attribute-was.md) - [Autosave False On ActiveRecord Associations](rails/autosave-false-on-activerecord-associations.md) - [Bind Parameters To ActiveRecord SQL Query](rails/bind-parameters-to-activerecord-sql-query.md) - [Build A Hash Of Model Attributes](rails/build-a-hash-of-model-attributes.md) - [Capture Development Emails With Mailhog](rails/capture-development-emails-with-mailhog.md) - [Capybara Page Status Code](rails/capybara-page-status-code.md) - [Cast Common Boolean-Like Values To Booleans](rails/cast-common-boolean-like-values-to-booleans.md) - [Change The Nullability Of A Column](rails/change-the-nullability-of-a-column.md) - [Change The Time Zone Offset Of A DateTime Object](rails/change-the-time-zone-offset-of-a-datetime-object.md) - [Check If ActiveRecord Update Fails](rails/check-if-activerecord-update-fails.md) - [Check If Any Records Have A Null Value](rails/check-if-any-records-have-a-null-value.md) - [Check Specific Attributes On ActiveRecord Array](rails/check-specific-attributes-on-activerecord-array.md) - [Code Statistics For An Application](rails/code-statistics-for-an-application.md) - [Columns With Default Values Are Nil On Create](rails/columns-with-default-values-are-nil-on-create.md) - [Comparing DateTimes Down To Second Precision](rails/comparing-datetimes-down-to-second-precision.md) - [Conditional Class Selectors in Haml](rails/conditional-class-selectors-in-haml.md) - [Convert A Symbol To A Constant](rails/convert-a-symbol-to-a-constant.md) - [Count The Number Of Records By Attribute](rails/count-the-number-of-records-by-attribute.md) - [Create A Custom Named References Column](rails/create-a-custom-named-references-column.md) - [Create A Join Table With The Migration DSL](rails/create-a-join-table-with-the-migration-dsl.md) - [Create Table With bigint Id As Primary Key](rails/create-table-with-bigint-id-as-primary-key.md) - [Creating Records of Has_One Associations](rails/creating-records-of-has-one-associations.md) - [Custom Validation Message](rails/custom-validation-message.md) - [Customize Paths And Helpers For Devise Routes](rails/customize-paths-and-helpers-for-devise-routes.md) - [Customize The Path Of A Resource Route](rails/customize-the-path-of-a-resource-route.md) - [Define The Root Path For The App](rails/define-the-root-path-for-the-app.md) - [Delete Paranoid Records](rails/delete-paranoid-records.md) - [Demodulize A Class Name](rails/demodulize-a-class-name.md) - [Different Ways To Add A Foreign Key Reference](rails/different-ways-to-add-a-foreign-key-reference.md) - [Disambiguate Where In A Joined Relation](rails/disambiguate-where-in-a-joined-relation.md) - [Empty find_by Returns First Record](rails/empty-find-by-returns-first-record.md) - [Ensure A Rake Task Cannot Write Data](rails/ensure-a-rake-task-cannot-write-data.md) - [Ensure Migrations Use The Latest Schema](rails/ensure-migrations-use-the-latest-schema.md) - [Ensure Record Saved With after_commit Callback](rails/ensure-record-saved-with-after-commit-callback.md) - [Find Or Create A Record With FactoryBot](rails/find-or-create-a-record-with-factory-bot.md) - [Find Records With Multiple Associated Records](rails/find-records-with-multiple-associated-records.md) - [Force All Users To Sign Out](rails/force-all-users-to-sign-out.md) - [Generate A Model](rails/generate-a-model.md) - [Generate A Rails App From The Main Branch](rails/generate-a-rails-app-from-the-main-branch.md) - [Generating And Executing SQL](rails/generating-and-executing-sql.md) - [Get A Quick Approximate Count Of A Large Table](rails/get-a-quick-approximate-count-of-a-large-table.md) - [Get ActiveRecord Attribute Directly From Database](rails/get-active-record-attribute-directly-from-database.md) - [Get An Array Of Values From The Database](rails/get-an-array-of-values-from-the-database.md) - [Get An Empty ActiveRecord Relation](rails/get-an-empty-activerecord-relation.md) - [Get Formatted UTC Offset Value](rails/get-formatted-utc-offset-value.md) - [Get Help With A Rails App Update](rails/get-help-with-a-rails-app-update.md) - [Get The Column Names For A Model](rails/get-the-column-names-for-a-model.md) - [Get The Current Time](rails/get-the-current-time.md) - [Grab A Random Record From The Database](rails/grab-a-random-record-from-the-database.md) - [Handle Named Arguments In A Rake Task](rails/handle-named-arguments-in-a-rake-task.md) - [Hash Slicing](rails/hash-slicing.md) - [Ignore Poltergeist JavaScript Errors](rails/ignore-poltergeist-javascript-errors.md) - [Include Devise Helpers In Your Controller Tests](rails/include-devise-helpers-in-your-controller-tests.md) - [Inspect Previous Changes To ActiveRecord Object](rails/inspect-previous-changes-to-activerecord-object.md) - [Link To The Current Page With Query Params](rails/link-to-the-current-page-with-query-params.md) - [List All Installable Rails Versions](rails/list-all-installable-rails-versions.md) - [List The Enqueued Jobs](rails/list-the-enqueued-jobs.md) - [Load A File When Starting Rails Console](rails/load-a-file-when-starting-rails-console.md) - [Load Records In Batches With find_each](rails/load-records-in-batches-with-find-each.md) - [Log SQL Queries Executed By ActiveRecord](rails/log-sql-queries-executed-by-activerecord.md) - [Look Up Time Zone Info For Identifier](rails/look-up-time-zone-info-for-identifier.md) - [Mark A Migration As Irreversible](rails/mark-a-migration-as-irreversible.md) - [Make A String Attribute Easy To Inquire About](rails/make-a-string-attribute-easy-to-inquire-about.md) - [Make ActionMailer Synchronous In Test](rails/make-action-mailer-synchronous-in-test.md) - [Make Remove Column Migration Reversible](rails/make-remove-column-migration-reversible.md) - [Manually Run A Migration From Rails Console](rails/manually-run-a-migration-from-rails-console.md) - [Mark For Destruction](rails/mark-for-destruction.md) - [Mask An ActiveRecord Attribute](rails/mask-an-activerecord-attribute.md) - [Merge A Scope Into An ActiveRecord Query](rails/merge-a-scope-into-an-activerecord-query.md) - [Migrating Up Down Up](rails/migrating-up-down-up.md) - [Mock Rails Environment With An Inquiry Instance](rails/mock-rails-environment-with-an-inquiry-instance.md) - [Order Matters For `rescue_from` Blocks](rails/order-matters-for-rescue-from-blocks.md) - [Params Includes Submission Button Info](rails/params-includes-submission-button-info.md) - [Params Is A Hash With Indifferent Access](rails/params-is-a-hash-with-indifferent-access.md) - [Parse Query Params From A URL](rails/parse-query-params-from-a-url.md) - [Parse Request Params In Rack::Attack Block](rails/parse-request-params-in-rack-attack-block.md) - [Perform SQL Explain With ActiveRecord](rails/perform-sql-explain-with-activerecord.md) - [Polymorphic Path Helpers](rails/polymorphic-path-helpers.md) - [Prefer select_all Over execute For Read Queries](rails/prefer-select-all-over-execute-for-read-queries.md) - [Pretend Generations](rails/pretend-generations.md) - [Prevent Writes With A Sandboxed Rails Console](rails/prevent-writes-with-a-sandboxed-rails-console.md) - [Query A Single Value From The Database](rails/query-a-single-value-from-the-database.md) - [Read In Environment-Specific Config Values](rails/read-in-environment-specific-config-values.md) - [Read-Only Models](rails/read-only-models.md) - [Remove A Database Column From A Table](rails/remove-a-database-column-from-a-table.md) - [Remove The Default Value On A Column](rails/remove-the-default-value-on-a-column.md) - [Render An Alternative ActionMailer Template](rails/render-an-alternative-action-mailer-template.md) - [Render The Response Body In Controller Specs](rails/render-the-response-body-in-controller-specs.md) - [Replace An Index With A Unique Index](rails/replace-an-index-with-a-unique-index.md) - [Rescue From](rails/rescue-from.md) - [Rescue From With A Separate Method](rails/rescue-from-with-a-separate-method.md) - [Respond With JSON Regardless of Content Type](rails/respond-with-json-regardless-of-content-type.md) - [Retrieve An Object If It Exists](rails/retrieve-an-object-if-it-exists.md) - [Rollback A Couple Migrations](rails/rollback-a-couple-migrations.md) - [Rollback A Specific Migration Out Of Order](rails/rollback-a-specific-migration-out-of-order.md) - [Rounding Numbers With Precision](rails/rounding-numbers-with-precision.md) - [Run A Rake Task Programmatically](rails/run-a-rake-task-programmatically.md) - [Run Commands With Specific Rails Version](rails/run-commands-with-specific-rails-version.md) - [Run Some Code Whenever Rails Console Starts](rails/run-some-code-whenever-rails-console-starts.md) - [Schedule Sidekiq Jobs Out Into The Future](rails/schedule-sidekiq-jobs-out-into-the-future.md) - [Secure Passwords With Rails And Bcrypt](rails/secure-passwords-with-rails-and-bcrypt.md) - [Select A Select By Selector](rails/select-a-select-by-selector.md) - [Select A Specific Rails Version To Install](rails/select-a-specific-rails-version-to-install.md) - [Select Value For SQL Counts](rails/select-value-for-sql-counts.md) - [Serialize With fast_jsonapi In A Rails App](rails/serialize-with-fast-jsonapi-in-a-rails-app.md) - [Set A Timestamp Field To The Current Time](rails/set-a-timestamp-field-to-the-current-time.md) - [Set DateTime To Include Time Zone In Migrations](rails/set-datetime-to-include-time-zone-in-migrations.md) - [Set Default As SQL Function In Migration](rails/set-default-as-sql-function-in-migration.md) - [Set default_url_options For Entire Application](rails/set-default-url-options-for-entire-application.md) - [Set Schema Search Path](rails/set-schema-search-path.md) - [Set Statement Timeout For All Postgres Connections](rails/set-statement-timeout-for-all-postgres-connections.md) - [Set The Default Development Port](rails/set-the-default-development-port.md) - [Show Pending Migrations](rails/show-pending-migrations.md) - [Show Rails Models With Pry](rails/show-rails-models-with-pry.md) - [Show Rails Routes With Pry](rails/show-rails-routes-with-pry.md) - [Skip Validations When Creating A Record](rails/skip-validations-when-creating-a-record.md) - [Specify New Attributes For #find_or_create_by](rails/specify-new-attributes-for-find-or-create-by.md) - [Temporarily Disable strong_params](rails/temporarily-disable-strong-params.md) - [Temporarily Turn Off Pending Migrations Error](rails/temporarily-turn-off-pending-migrations-error.md) - [Test For A Subset Of Attributes On A Model](rails/test-for-a-subset-of-attributes-on-a-model.md) - [Test If An Instance Variable Was Assigned](rails/test-if-an-instance-variable-was-assigned.md) - [Test If deliver_later Is Called For A Mailer](rails/test-if-deliver-later-is-called-for-a-mailer.md) - [Test Out URL And Path Helpers In The Console](rails/test-out-url-and-path-helpers-in-the-console.md) - [Truncate Almost All Tables](rails/truncate-almost-all-tables.md) - [Update Column Versus Update Attribute](rails/update-column-versus-update-attribute.md) - [Upgrading Your Manifest For Sprocket's 4](rails/upgrading-your-manifest-for-sprockets-4.md) - [Use IRB And Ruby Flags With Rails Console](rails/use-irb-and-ruby-flags-with-rails-console.md) - [Useful ActiveSupport Constants For Durations](rails/useful-active-support-constants-for-durations.md) - [Validate Column Data With Check Constraints](rails/validate-column-data-with-check-constraints.md) - [Verify And Read A Signed Cookie Value](rails/verify-and-read-a-signed-cookie-value.md) - [Where Am I In The Partial Iteration?](rails/where-am-i-in-the-partial-iteration.md) - [Why Redirect And Return In Controllers](rails/why-redirect-and-return-in-controllers.md) - [Wipe Out All Precompiled Assets](rails/wipe-out-all-precompiled-assets.md) - [Write Reversible Migration To Set Default](rails/write-reversible-migration-to-set-default.md) - [Write Safer Where Clauses With Placeholders](rails/write-safer-where-clauses-with-placeholders.md) ### React - [A Component Is Just A Bag Of Data](react/a-component-is-just-a-bag-of-data.md) - [Access The Latest Lifecycle Methods In An Old App](react/access-the-latest-lifecycle-methods-in-an-old-app.md) - [Accessing Env Vars In create-react-app](react/accessing-env-vars-in-create-react-app.md) - [Accessing Location Within @reach/router](react/accessing-location-within-reach-router.md) - [Allow md As An Extension With gatsby-mdx](react/allow-md-as-an-extension-with-gatsby-mdx.md) - [Alter The Display Name Of A Component](react/alter-the-display-name-of-a-component.md) - [Building A React App In The Browser](react/building-a-react-app-in-the-browser.md) - [Check The Type Of A Child Component](react/check-the-type-of-a-child-component.md) - [Conditionally Including Event Handler Functions](react/conditionally-including-event-handler-functions.md) - [Create A Snowpack-Bundled React App](react/create-a-snowpack-bundled-react-app.md) - [Create Dynamically Named Custom React Components](react/create-dynamically-named-custom-react-components.md) - [create-react-app Comes With Lodash](react/create-react-app-comes-with-lodash.md) - [create-react-app Has A Default Test Setup File](react/create-react-app-has-a-default-test-setup-file.md) - [CSS !important Is Not Supported By Inline Styles](react/css-important-is-not-supported-by-inline-styles.md) - [Debug Jest Tests In create-react-app](react/debug-jest-tests-in-create-react-app.md) - [Defining State In A Simple Class Component](react/defining-state-in-a-simple-class-component.md) - [Destructure Variables As Props To A Component](react/destructure-variables-as-props-to-a-component.md) - [Details Tags Are A Controllable Component](react/details-tags-are-a-controllable-component.md) - [Dispatch Anywhere With Redux](react/dispatch-anywhere-with-redux.md) - [Dynamically Add Props To A Child Component](react/dynamically-add-props-to-a-child-component.md) - [Dynamically Create HTML Elements](react/dynamically-create-html-elements.md) - [Enforce Specific Values With PropTypes](react/enforce-specific-values-with-proptypes.md) - [Focus An Input With useRef Hook](react/focus-an-input-with-useref-hook.md) - [Force A Component To Only Have One Child](react/force-a-component-to-only-have-one-child.md) - [Forcing A Child Remount With The Key Prop](react/forcing-a-child-remount-with-the-key-prop.md) - [Formik Connected Components](react/formik-connected-components.md) - [Formik's Validation Schema As A Function](react/formiks-validation-schema-as-a-function.md) - [Inactive And Active Component Styles With Radium](react/inactive-and-active-component-styles-with-radium.md) - [Inline Style Attributes Should Be Camel Cased](react/inline-style-attributes-should-be-camel-cased.md) - [Manage State In A Functional Component](react/manage-state-in-a-functional-component.md) - [Mapping Over One Or Many Children](react/mapping-over-one-or-many-children.md) - [Mock A Function That A Component Imports](react/mock-a-function-that-a-component-imports.md) - [Navigate With State Via @reach/router](react/navigate-with-state-via-reach-router.md) - [Pairing A Callback With A useState Hook](react/pairing-a-callback-with-a-usestate-hook.md) - [Pass A Function To A useState Updater](react/pass-a-function-to-a-usestate-updater.md) - [Passing Props Down To React-Router Route](react/passing-props-down-to-react-router-route.md) - [Prevent reach/router Redirect Error Screen In Dev](react/prevent-reach-router-redirect-error-screen-in-dev.md) - [Proxy To An API Server In Development With CRA](react/proxy-to-an-api-server-in-development-with-cra.md) - [Quickly Search For A Component With React DevTools](react/quickly-search-for-a-component-with-react-devtools.md) - [@reach/router Renders To A Div](react/reach-router-renders-to-a-div.md) - [Read Only Input Elements](react/read-only-input-elements.md) - [Rendering Multiple Nodes With Fragments](react/rendering-multiple-nodes-with-fragments.md) - [Set The Type For A useState Hook](react/set-the-type-for-a-usestate-hook.md) - [Specifying Dependencies Of A useEffect Hook](react/specifying-dependencies-of-a-useeffect-hook.md) - [Spelunking Through Components With Enzyme's Dive](react/spelunking-through-components-with-enzymes-dive.md) - [Sync Your react-router State With Redux](react/sync-your-react-router-state-with-redux.md) - [Test Files In create-react-app](react/test-files-in-create-react-app.md) - [Test That Element Does Not Render In The Component](react/test-that-element-does-not-render-in-the-component.md) - [Trigger Effect Only When The Component Mounts](react/trigger-effect-only-when-the-component-mounts.md) - [Update Formik Initial Values When Props Change](react/update-formik-initial-values-when-props-change.md) - [Upgrading To The Latest React In CodeSandbox](react/upgrading-to-the-latest-react-in-codesandbox.md) - [Use A Ref To Autofocus An Input](react/use-a-ref-to-autofocus-an-input.md) - [Use React 16 With Gatsby](react/use-react-16-with-gatsby.md) - [Use withRouter To Pass Down React-Router History](react/use-withrouter-to-pass-down-react-router-history.md) - [Visually Select A React Element For Inspection](react/visually-select-a-react-element-for-inspection.md) - [Who Is Your Favorite Child?](react/who-is-your-favorite-child.md) - [Wrap The Root Of A Gatsby App In A Component](react/wrap-the-root-of-a-gatsby-app-in-a-component.md) ### React Native - [Avoid The Notch With SafeAreaView](react_native/avoid-the-notch-with-safeareaview.md) ### React Testing Library - [Check That A Component Renders As Null](react-testing-library/check-that-a-component-renders-as-null.md) - [findBy\* Queries Have Async Built In](react-testing-library/find-by-queries-have-async-built-in.md) - [Pretty Print Some DOM To Debug A Test](react-testing-library/pretty-print-some-dom-to-debug-a-test.md) - [Test A Component That Uses React Portals](react-testing-library/test-a-component-that-uses-react-portals.md) ### ReasonML - [Break Out Of A While Loop](reason/break-out-of-a-while-loop.md) - [Compile Reason To Native With Dune](reason/compile-reason-to-native-with-dune.md) - [Compile Reason With An OCaml Package Using Dune](reason/compile-reason-with-an-ocaml-package-using-dune.md) - [Create A Map Of Strings](reason/create-a-map-of-strings.md) - [Create A Stream From An Array](reason/create-a-stream-from-an-array.md) - [Creating A 2D Array](reason/creating-a-2d-array.md) - [Data Structures With Self-Referential Types](reason/data-structures-with-self-referential-types.md) - [Defining Variants With Constructor Arguments](reason/defining-variants-with-constructor-arguments.md) - [Dynamically Create A Printf String Format](reason/dynamically-create-a-printf-string-format.md) - [Exhaustive Pattern Matching Of List Variants](reason/exhaustive-pattern-matching-of-list-variants.md) - [Format The Current File Within Vim](reason/format-the-current-file-within-vim.md) - [Generate A Native ReasonML Project With Pesy](reason/generate-a-native-reasonml-project-with-pesy.md) - [Generate Starter Reason Projects](reason/generate-starter-reason-projects.md) - [Helping The Compiler Help Us With Variants](reason/helping-the-compiler-help-us-with-variants.md) - [Inline Component Styles With Reason React](reason/inline-component-styles-with-reason-react.md) - [Is This A Directory Or A File?](reason/is-this-a-directory-or-a-file.md) - [Making Things Mutable](reason/making-things-mutable.md) - [Modifying A String With blit_string](reason/modifying-a-string-with-blit-string.md) - [Multi-Argument Functions As Syntactic Sugar](reason/multi-argument-functions-as-syntactic-sugar.md) - [Pattern Match On Exceptions](reason/pattern-match-on-exceptions.md) - [Quickly Bootstrap A React App Using Reason](reason/quickly-bootstrap-a-react-app-using-reason.md) - [Seeding And Generating Random Integers](reason/seeding-and-generating-random-integers.md) - [Stream A File Line By Line](reason/stream-a-file-line-by-line.md) - [String Interpolation With Integers And Sprintf](reason/string-interpolation-with-integers-and-sprintf.md) - [String Interpolation With Quoted Strings](reason/string-interpolation-with-quoted-strings.md) - [Trying Out ReasonML In CodeSandbox](reason/trying-out-reasonml-in-codesandbox.md) - [Two Ways To Find An Item In A List](reason/two-ways-to-find-an-item-in-a-list.md) - [Using Optional Labeled Function Arguments](reason/using-optional-labeled-function-arguments.md) - [Wrapping A Component For Use In JavaScript](reason/wrapping-a-component-for-use-in-javascript.md) ### Remix - [Get Query Params From The Request URL](remix/get-query-params-from-the-request-url.md) - [Markdown And MDX Files Are Rendered To Routes](remix/markdown-and-mdx-files-are-rendered-to-routes.md) - [Relative And Absolute Paths In Links](remix/relative-and-absolute-paths-in-links.md) - [Run The Development Server From Another Port](remix/run-the-development-server-from-another-port.md) - [Set The Title Of A Page](remix/set-the-title-of-a-page.md) ### RSpec - [Avoid Accidentally Disabling Pry](rspec/avoid-accidentally-disabling-pry.md) - [Check Specific Arguments To Received Method](rspec/check-specific-arguments-to-received-method.md) - [Configure Tests To Run In Random Order](rspec/configure-tests-to-run-in-random-order.md) - [Find Minimal Set Of Tests Causing A Flicker](rspec/find-minimal-set-of-tests-causing-a-flicker.md) - [Format Test Results As A JSON File](rspec/format-test-results-as-a-json-file.md) - [Run Tests With Documentation Formatting](rspec/run-tests-with-documentation-formatting.md) - [Use Specific Cache Store In A Single Test](rspec/use-specific-cache-store-in-a-single-test.md) ### Ruby - [A Basic Case Statement](ruby/a-basic-case-statement.md) - [A Shorthand For Rerunning Failed Tests With RSpec](ruby/a-shorthand-for-rerunning-failed-tests-with-rspec.md) - [Add Comments To Regex With Free-Spacing](ruby/add-comments-to-regex-with-free-spacing.md) - [Add Linux As A Bundler Platform](ruby/add-linux-as-a-bundler-platform.md) - [Add Progress Reporting To Long-Running Script](ruby/add-progress-reporting-to-long-running-script.md) - [Are They All True?](ruby/are-they-all-true.md) - [Assert About An Object's Attributes With RSpec](ruby/assert-about-an-objects-attributes-with-rspec.md) - [Audit Your Ruby Project For Any CVEs](ruby/audit-your-ruby-project-for-any-cves.md) - [Assoc For Hashes](ruby/assoc-for-hashes.md) - [Block Comments](ruby/block-comments.md) - [Block Syntaxes Have Different Precedence](ruby/block-syntaxes-have-different-precedence.md) - [Build HTTP And HTTPS URLs](ruby/build-http-and-https-urls.md) - [Chaining Multiple RSpec Change Matchers](ruby/chaining-multiple-rspec-change-matchers.md) - [Check For Any Overlaps In List Of Ranges](ruby/check-for-any-overlaps-in-list-of-ranges.md) - [Check If A URL Resolves To 200](ruby/check-if-a-url-resolves-to-200.md) - [Check If An Object Includes A Module](ruby/check-if-an-object-includes-a-module.md) - [Check Return Status Of Running A Shell Command](ruby/check-return-status-of-running-a-shell-command.md) - [Click On Text With Capybara](ruby/click-on-text-with-capybara.md) - [Colorful Output With MiniTest](ruby/colorful-output-with-minitest.md) - [Comparing Class Hierarchy Relationships](ruby/comparing-class-hierarchy-relationships.md) - [Comparing Arrays In RSpec](ruby/comparing-arrays-in-rspec.md) - [Construct A Constant From A String](ruby/construct-a-constant-from-a-string.md) - [Convert A Unix Epoch Timestamp To A Time Object](ruby/convert-a-unix-epoch-timestamp-to-a-time-object.md) - [Create an Array of Stringed Numbers](ruby/create-an-array-of-stringed-numbers.md) - [Create a CSV::Table Object](ruby/create-a-csv-table-object.md) - [Create A Hash From An Array Of Arrays](ruby/create-a-hash-from-an-array-of-arrays.md) - [Create Listing Of All Middleman Pages](ruby/create-listing-of-all-middleman-pages.md) - [Create Named Structs With Struct.new](ruby/create-named-structs-with-struct-new.md) - [Create Thumbnail Image For A PDF](ruby/create-thumbnail-image-for-a-pdf.md) - [Defaulting To Frozen String Literals](ruby/defaulting-to-frozen-string-literals.md) - [Define A Custom RSpec Matcher](ruby/define-a-custom-rspec-matcher.md) - [Define A Method On A Struct](ruby/define-a-method-on-a-struct.md) - [Define Multiline Strings With Heredocs](ruby/define-multiline-strings-with-heredocs.md) - [Destructure The First Item From An Array](ruby/destructure-the-first-item-from-an-array.md) - [Destructuring Arrays In Blocks](ruby/destructuring-arrays-in-blocks.md) - [Disable Interpolation For A Heredoc String](ruby/disable-interpolation-for-a-heredoc-string.md) - [Disassemble Some Codes](ruby/disassemble-some-codes.md) - [Double Splat To Merge Hashes](ruby/double-splat-to-merge-hashes.md) - [Edit Previous Parts Of The Pry Buffer History](ruby/edit-previous-parts-of-the-pry-buffer-history.md) - [Editing Code In Pry](ruby/editing-code-in-pry.md) - [Encode A String As URL-Safe Base64](ruby/encode-a-string-as-url-safe-base64.md) - [Enumerate A Pairing Of Every Two Sequential Items](ruby/enumerate-a-pairing-of-every-two-sequential-items.md) - [Evaluating One-Off Commands](ruby/evaluating-one-off-commands.md) - [Exclude Values From An Array](ruby/exclude-values-from-an-array.md) - [Execute Several Commands With Backtick Heredoc](ruby/execute-several-commands-with-backtick-heredoc.md) - [Exit A Process With An Error Message](ruby/exit-a-process-with-an-error-message.md) - [Expect A Method To Be Called And Actually Call It](ruby/expect-a-method-to-be-called-and-actually-call-it.md) - [Extract A Column Of Data From A CSV File](ruby/extract-a-column-of-data-from-a-csv-file.md) - [FactoryGirl Sequences](ruby/factory-girl-sequences.md) - [Fail](ruby/fail.md) - [Fetch Warns About Superseding Block Argument](ruby/fetch-warns-about-superseding-block-argument.md) - [Find The Min And Max With A Single Call](ruby/find-the-min-and-max-with-a-single-call.md) - [Finding The Source of Ruby Methods](ruby/finding-the-source-of-ruby-methods.md) - [Format A Hash Into A String Template](ruby/format-a-hash-into-a-string-template.md) - [Forward All Arguments To Another Method](ruby/forward-all-arguments-to-another-method.md) - [Gather Positional Arguments In Method Definition](ruby/gather-positional-arguments-in-method-definition.md) - [Generate A Signed JWT Token](ruby/generate-a-signed-jwt-token.md) - [Generate Ruby Version And Gemset Files With RVM](ruby/generate-ruby-version-and-gemset-files-with-rvm.md) - [Get Info About Your RubyGems Environment](ruby/get-info-about-your-ruby-gems-environment.md) - [Get The Output Of Running A System Program](ruby/get-the-output-of-running-a-system-program.md) - [Get UTC Offset For Different Time Zones](ruby/get-utc-offset-for-different-time-zones.md) - [Identify Outdated Gems](ruby/identify-outdated-gems.md) - [If You Detect None](ruby/if-you-detect-none.md) - [Iterate With An Offset Index](ruby/iterate-with-an-offset-index.md) - [Include Extra Context In A Honeybadger Notify](ruby/include-extra-context-in-a-honeybadger-notify.md) - [Ins And Outs Of Pry](ruby/ins-and-outs-of-pry.md) - [Invoking Rake Tasks Multiple Times](ruby/invoking-rake-tasks-multiple-times.md) - [IRB Has Built-In Benchmarking With Ruby 3](ruby/irb-has-built-in-benchmarking-with-ruby-3.md) - [Jump Out Of A Nested Context With Throw/Catch](ruby/jump-out-of-a-nested-context-with-throw-catch.md) - [Last Raised Exception In The Call Stack](ruby/last-raised-exception-in-the-call-stack.md) - [Limit Split](ruby/limit-split.md) - [List The Running Ruby Version](ruby/list-the-running-ruby-version.md) - [Listing Local Variables](ruby/listing-local-variables.md) - [Make An Executable Ruby Script](ruby/make-an-executable-ruby-script.md) - [Map With Index Over An Array](ruby/map-with-index-over-an-array.md) - [Mock Method Chain Calls With RSpec](ruby/mock-method-chain-calls-with-rspec.md) - [Mocking Requests With Partial URIs Using Regex](ruby/mocking-requests-with-partial-uris-using-regex.md) - [Multi-Line Comments](ruby/multi-line-comments.md) - [Named Regex Captures Are Assigned To Variables](ruby/named-regex-captures-are-assigned-to-variables.md) - [Navigate Back In The Browser With Capybara](ruby/navigate-back-in-the-browser-with-capybara.md) - [Next And Previous Floats](ruby/next-and-previous-floats.md) - [Or Operator Precedence](ruby/or-operator-precedence.md) - [Output Bytecode For A Ruby Program](ruby/output-bytecode-for-a-ruby-program.md) - [Override The Initial Sequence Value](ruby/override-the-initial-sequence-value.md) - [Parallel Bundle Install](ruby/parallel-bundle-install.md) - [Parse JSON Into An OpenStruct](ruby/parse-json-into-an-open-struct.md) - [Parsing A CSV With Quotes In The Data](ruby/parsing-a-csv-with-quotes-in-the-data.md) - [Pass A Block To Count](ruby/pass-a-block-to-count.md) - [Passing Arbitrary Methods As Blocks](ruby/passing-arbitrary-methods-as-blocks.md) - [Passing Arguments To A Rake Task](ruby/passing-arguments-to-a-rake-task.md) - [Pattern Match Values From A Hash](ruby/pattern-match-values-from-a-hash.md) - [Percent Notation](ruby/percent-notation.md) - [Precedence Of Logical Operators](ruby/precedence-of-logical-operators.md) - [Prevent erb_lint From Removing Opening Tags](ruby/prevent-erb-lint-from-removing-opening-tags.md) - [Print Data To Formatted Table](ruby/print-data-to-formatted-table.md) - [Question Mark Operator](ruby/question-mark-operator.md) - [Rake Only Lists Tasks With Descriptions](ruby/rake-only-lists-tasks-with-descriptions.md) - [Read The First Line From A File](ruby/read-the-first-line-from-a-file.md) - [Rendering ERB](ruby/rendering-erb.md) - [Replace The Current Process With An External Command](ruby/replace-the-current-process-with-an-external-command.md) - [Require Entire Gemfile In Pry Session](ruby/require-entire-gemfile-in-pry-session.md) - [Rerun Only Failures With RSpec](ruby/rerun-only-failures-with-rspec.md) - [Retry A Block After An Exception](ruby/retry-a-block-after-an-exception.md) - [Return The Thing Being Printed](ruby/return-the-thing-being-printed.md) - [Returning With Sequel](ruby/returning-with-sequel.md) - [rexml Is A Bundled Gem As Of Ruby 3.0.0](ruby/rexml-is-a-bundled-gem-as-of-ruby-3-0-0.md) - [Run An Older Version Of Bundler](ruby/run-an-older-version-of-bundler.md) - [Running A Single MiniTest Example](ruby/running-a-single-minitest-example.md) - [Safe Navigation Operator](ruby/safe-navigation-operator.md) - [Scripting With RVM](ruby/scripting-with-rvm.md) - [Scroll To Top Of Page With Capybara](ruby/scroll-to-top-of-page-with-capybara.md) - [Search For Gem Versions Available To Install](ruby/search-for-gem-versions-available-to-install.md) - [Set RVM Default Ruby](ruby/set-rvm-default-ruby.md) - [Shift The Month On A Date Object](ruby/shift-the-month-on-a-date-object.md) - [Show Public Methods With Pry](ruby/show-public-methods-with-pry.md) - [Silence The Output Of A Ruby Statement In Pry](ruby/silence-the-output-of-a-ruby-statement-in-pry.md) - [Single And Double Quoted String Notation](ruby/single-and-double-quoted-string-notation.md) - [Skip Specific CVEs When Auditing Your Bundle](ruby/skip-specific-cves-when-auditing-your-bundle.md) - [Skip The Front Of An Array With Drop](ruby/skip-the-front-of-an-array-with-drop.md) - [Specify Dependencies For A Rake Task](ruby/specify-dependencies-for-a-rake-task.md) - [Specify How Random Array#sample Is](ruby/specify-how-random-array-sample-is.md) - [Split A Float Into Its Integer And Decimal](ruby/split-a-float-into-its-integer-and-decimal.md) - [Squeeze Out The Extra Space](ruby/squeeze-out-the-extra-space.md) - [Stack Heredocs In A Method Call](ruby/stack-heredocs-in-a-method-call.md) - [String Interpolation With Instance Variables](ruby/string-interpolation-with-instance-variables.md) - [Summing Collections](ruby/summing-collections.md) - [Triple Equals: The Case Equality Operator](ruby/triple-equals-the-case-equality-operator.md) - [Turn Key And Value Arrays Into A Hash](ruby/turn-key-and-values-arrays-into-a-hash.md) - [Turning Any Class Into An Enumerator](ruby/turning-any-class-into-an-enumerator.md) - [Turning Things Into Hashes](ruby/turning-things-into-hashes.md) - [Uncaught Exceptions In Pry](ruby/uncaught-exceptions-in-pry.md) - [`undef_method` And The Inheritance Hierarchy](ruby/undef-method-and-the-inheritance-hierarchy.md) - [Uninstall Specific Version Of A Ruby Gem](ruby/uninstall-specific-version-of-a-ruby-gem.md) - [Unpacking Strings Into Binary](ruby/unpacking-strings-into-binary.md) - [Up And Down With Integers](ruby/up-and-down-with-integers.md) - [Update The Gemfile Bundled With Version](ruby/update-the-gemfile-bundled-with-version.md) - [Use A Case Statement As A Cond Statement](ruby/use-a-case-statement-as-a-cond-statement.md) - [Use dotenv In A Non-Rails Project](ruby/use-dotenv-in-a-non-rails-project.md) - [Use Tap For Better Test Data Setup](ruby/use-tap-for-better-test-data-setup.md) - [Using BCrypt To Create And Check Hashed Passwords](ruby/using-bcrypt-to-create-and-check-hashed-passwords.md) - [What To Do When You Don't Rescue](ruby/what-to-do-when-you-dont-rescue.md) - [Who Are My Ancestors?](ruby/who-are-my-ancestors.md) - [Wrap Things In An Array, Even Hashes](ruby/wrap-things-in-an-array-even-hashes.md) - [Zero Padding](ruby/zero-padding.md) ### sed - [Apply Multiple Substitutions To The Input](sed/apply-multiple-substitutions-to-the-input.md) - [Equivalence Classes Of Repetition MetaChars](sed/equivalence-classes-of-repetition-metachars.md) - [Extract Value From Command Output With Sed](sed/extract-value-from-command-output-with-sed.md) - [Grab All The Method Names Defined In A Ruby File](sed/grab-all-the-method-names-defined-in-a-ruby-file.md) - [Grab The First Line Of A File](sed/grab-the-first-line-of-a-file.md) - [OSX sed Does Regex A Bit Different](sed/osx-sed-does-regex-a-bit-different.md) - [Output Only Lines Involved In A Substitution](sed/output-only-lines-involved-in-a-substitution.md) - [Reference A Capture In The Regex](sed/reference-a-capture-in-the-regex.md) - [Use An Alternative Delimiter In A Substitution](sed/use-an-alternative-delimiter-in-a-substitution.md) ### Shell - [Check If The First Argument Is Given](shell/check-if-the-first-argument-is-given.md) - [Format And Print The Current Date And Time](shell/format-and-print-the-current-date-and-time.md) ### SQLite - [Display Results In Readable Column Format](sqlite/display-results-in-readable-column-format.md) - [Explore The Database Schema](sqlite/explore-the-database-schema.md) ### Streaming - [Monitor An Audio Input Device In OBS](streaming/monitor-an-audio-input-device-in-obs.md) ### Tailwind CSS - [Apply Tailwind Classes To Existing CSS Class](tailwind/apply-tailwind-classes-to-existing-css-class.md) - [Base Styles For Text Link](tailwind/base-styles-for-text-link.md) - [Specify Paths For Purging Unused CSS](tailwind/specify-paths-for-purging-unused-css.md) - [Use Tailwind Typography Prose In Dark Mode](tailwind/use-tailwind-typography-prose-in-dark-mode.md) ### tmux - [Access Past Copy Buffer History](tmux/access-past-copy-buffer-history.md) - [Adjusting Window Pane Size](tmux/adjusting-window-pane-size.md) - [Break Current Pane Out To Separate Window](tmux/break-current-pane-out-to-separate-window.md) - [Change Base Directory Of Existing Session](tmux/change-base-directory-of-existing-session.md) - [Change Base Directory Without Detaching](tmux/change-base-directory-without-detaching.md) - [Change The Default Prefix Key](tmux/change-the-default-prefix-key.md) - [Create A Named tmux Session](tmux/create-a-named-tmux-session.md) - [Create A New Session In A New Server](tmux/create-a-new-session-in-a-new-server.md) - [Cycle Through Layouts](tmux/cycle-through-layouts.md) - [Display Titles For Each Pane In A Window](tmux/display-titles-for-each-pane-in-a-window.md) - [Enabling Vi Mode](tmux/enabling-vi-mode.md) - [Get Mouse Copy/Paste Working In Kitty](tmux/get-mouse-copy-paste-working-in-kitty.md) - [Hiding The Status Bar](tmux/hiding-the-status-bar.md) - [Jumping Between Sessions](tmux/jumping-between-sessions.md) - [Kill All Your tmux Sessions](tmux/kill-all-your-tmux-sessions.md) - [Kill Other Connections To A Session](tmux/kill-other-connections-to-a-session.md) - [Kill The Current Session](tmux/kill-the-current-session.md) - [List All Key Bindings](tmux/list-all-key-bindings.md) - [List Sessions](tmux/list-sessions.md) - [Open New Splits To The Current Directory](tmux/open-new-splits-to-the-current-directory.md) - [Open New Window With A Specific Directory](tmux/open-new-window-with-a-specific-directory.md) - [Organizing Windows](tmux/organizing-windows.md) - [Paging Up And Down](tmux/paging-up-and-down.md) - [Pane Killer](tmux/pane-killer.md) - [Reclaiming The Entire Window](tmux/reclaiming-the-entire-window.md) - [Remove The Delay On The Escape Key](tmux/remove-the-delay-on-the-escape-key.md) - [Rename The Current Session](tmux/rename-the-current-session.md) - [Reset An Option Back To Its Default Value](tmux/reset-an-option-back-to-its-default-value.md) - [Set Environment Variables When Creating Session](tmux/set-environment-variables-when-creating-session.md) - [Set Session Specific Environment Variables](tmux/set-session-specific-environment-variables.md) - [Show The Current Value For An Option](tmux/show-the-current-value-for-an-option.md) - [Swap Split Panes](tmux/swap-split-panes.md) - [Switch To A Specific Session And Window](tmux/switch-to-a-specific-session-and-window.md) - [tmux in your tmux](tmux/tmux-in-your-tmux.md) - [Toggle Between Two Common Sessions](tmux/toggle-between-two-common-sessions.md) ### TypeScript - [Add Generic Typing To An Anonymous Function](typescript/add-generic-typing-to-an-anonymous-function.md) - [Add Types To An Object Destructuring](typescript/add-types-to-an-object-destructuring.md) - [Compiler Checks For Unused Params And Variables](typescript/compiler-checks-for-unused-params-and-variables.md) - [Create A Non-Empty Array Type](typescript/create-a-non-empty-array-type.md) - [Create A Union Type From An Array](typescript/create-a-union-type-from-an-array.md) - [Create Union Type From Constants](typescript/create-union-type-from-constants.md) - [Extract Object Type Keys Into A Union Type](typescript/extract-object-type-keys-into-a-union-type.md) - [Extract Object Type Values Into A Union Type](typescript/extract-object-type-values-into-a-union-type.md) - [Generate An Initial tsconfig File](typescript/generate-an-initial-tsconfig-file.md) - [Generate Inferred Type From Zod Schema](typescript/generate-inferred-type-from-zod-schema.md) - [Get The Return Type Of An Async Function](typescript/get-the-return-type-of-an-async-function.md) - [Ignore All Errors In A TypeScript File](typescript/ignore-all-errors-in-a-typescript-file.md) - [Interfaces With The Same Name Are Merged](typescript/interfaces-with-the-same-name-are-merged.md) - [Narrow The Type Of An Array To Its Values](typescript/narrow-the-type-of-an-array-to-its-values.md) - [Re-Export An Imported Type](typescript/re-export-an-imported-type.md) - [Set Path Alias For Cleaner Imports](typescript/set-path-alias-for-cleaner-imports.md) - [Type Narrowing With Const VS Let Strings](typescript/type-narrowing-with-const-vs-let-strings.md) - [Type Narrowing With Similarly Shaped Objects](typescript/type-narrowing-with-similarly-shaped-objects.md) - [Type Promise Results With The Awaited Type](typescript/type-promise-results-with-the-awaited-type.md) - [Use An Array Check For Type Narrowing](typescript/use-an-array-check-for-type-narrowing.md) - [Zero-Config Environments For Trying Out Types](typescript/zero-config-environments-for-trying-out-types.md) ### Unix - [All The Environment Variables](unix/all-the-environment-variables.md) - [Cat A File With Line Numbers](unix/cat-a-file-with-line-numbers.md) - [Cat Files With Color Using Bat](unix/cat-files-with-color-using-bat.md) - [Change Default Shell For A User](unix/change-default-shell-for-a-user.md) - [Change To That New Directory](unix/change-to-that-new-directory.md) - [Check Connected Stripe Account Name](unix/check-connected-stripe-account-name.md) - [Check If A Port Is In Use](unix/check-if-a-port-is-in-use.md) - [Check If Command Is Executable Before Using](unix/check-if-command-is-executable-before-using.md) - [Check SSH Key Fingerprints Of Known Hosts](unix/check-ssh-key-fingerprints-of-known-hosts.md) - [Check The Current Working Directory](unix/check-the-current-working-directory.md) - [Check The Installed OpenSSL Version](unix/check-the-installed-openssl-version.md) - [Clear The Screen](unix/clear-the-screen.md) - [Command Line Length Limitations](unix/command-line-length-limitations.md) - [Compare Two Variables In A Bash Script](unix/compare-two-variables-in-a-bash-script.md) - [Configure cd To Behave Like pushd In Zsh](unix/configure-cd-to-behave-like-pushd-in-zsh.md) - [Convert JPEG To PNG With ffmpeg](unix/convert-jpeg-to-png-with-ffmpeg.md) - [Convert SVG To Favicon](unix/convert-svg-to-favicon.md) - [Copying File Contents To System Paste Buffer](unix/copying-file-contents-to-system-paste-buffer.md) - [Copying Nested Directories With Ditto](unix/copying-nested-directories-with-ditto.md) - [Count The Lines In A CSV Where A Column Is Empty](unix/count-the-lines-in-a-csv-where-a-column-is-empty.md) - [Count The Number Of Matches In A Grep](unix/count-the-number-of-matches-in-a-grep.md) - [Count The Number Of ripgrep Pattern Matches](unix/count-the-number-of-ripgrep-pattern-matches.md) - [Create A File Descriptor with Process Substitution](unix/create-a-file-descriptor-with-process-substitution.md) - [Create A Sequence Of Values With A Step](unix/create-a-sequence-of-values-with-a-step.md) - [Curl With Cookies](unix/curl-with-cookies.md) - [Curling For Headers](unix/curling-for-headers.md) - [Curling With Basic Auth Credentials](unix/curling-with-basic-auth-credentials.md) - [Different Ways To Generate A v4 UUID](unix/different-ways-to-generate-a-v4-uuid.md) - [Display All The Terminal Colors](unix/display-all-the-terminal-colors.md) - [Display Free Disk Space](unix/display-free-disk-space.md) - [Display The Contents Of A Directory As A Tree](unix/display-the-contents-of-a-directory-as-a-tree.md) - [Do A Dry Run Of An rsync](unix/do-a-dry-run-of-an-rsync.md) - [Do Not Overwrite Existing Files](unix/do-not-overwrite-existing-files.md) - [Download A File With Curl](unix/download-a-file-with-curl.md) - [Enable Multi-Select Of Results With fzf](unix/enable-multi-select-of-results-with-fzf.md) - [Exclude A Command From The ZSH History File](unix/exclude-a-command-from-the-zsh-history-file.md) - [Exclude A Directory With Find](unix/exclude-a-directory-with-find.md) - [Exclude Certain Files From An rsync Run](unix/exclude-certain-files-from-an-rsync-run.md) - [Figure Out The Week Of The Year From The Terminal](unix/figure-out-the-week-of-the-year-from-the-terminal.md) - [File Type Info With File](unix/file-type-info-with-file.md) - [Find All Files Matching A Name With fd](unix/find-all-files-matching-a-name-with-fd.md) - [Find All Files With A Specific Extension With fd](unix/find-all-files-with-a-specific-extension-with-fd.md) - [Find Any Dotfiles That Modify Path Env Var](unix/find-any-dotfiles-that-modify-path-env-var.md) - [Find A File Installed By Brew](unix/find-a-file-installed-by-brew.md) - [Find Duplicate Lines In A File](unix/find-duplicate-lines-in-a-file.md) - [Find Files With fd](unix/find-files-with-fd.md) - [Find Newer Files](unix/find-newer-files.md) - [Find Occurrences Of Multiple Values With Ripgrep](unix/find-occurrences-of-multiple-values-with-ripgrep.md) - [Find Top-Level Directories Matching A Pattern](unix/find-top-level-directories-matching-a-pattern.md) - [Fix Unlinked Node Binaries With asdf](unix/fix-unlinked-node-binaries-with-asdf.md) - [Forward Multiple Ports Over SSH](unix/forward-multiple-ports-over-ssh.md) - [Generate A SAML Key And Certificate Pair](unix/generate-a-saml-key-and-certificate-pair.md) - [Generate Base64 Encoding Without Newlines](unix/generate-base64-encoding-without-newlines.md) - [Generate Random 20-Character Hex String](unix/generate-random-20-character-hex-string.md) - [Get A List Of Locales On Your System](unix/get-a-list-of-locales-on-your-system.md) - [Get Matching Filenames As Output From Grep](unix/get-matching-filenames-as-output-from-grep.md) - [Get The SHA256 Hash For A File](unix/get-the-sha256-hash-for-a-file.md) - [Get The Unix Timestamp](unix/get-the-unix-timestamp.md) - [Global Substitution On The Previous Command](unix/global-substitution-on-the-previous-command.md) - [Globbing For All Directories In Zsh](unix/globbing-for-all-directories-in-zsh.md) - [Globbing For Filenames In Zsh](unix/globbing-for-filenames-in-zsh.md) - [Gracefully Exit A Script With Trap](unix/gracefully-exit-a-script-with-trap.md) - [Grep For Files Without A Match](unix/grep-for-files-without-a-match.md) - [Grep For Files With Multiple Matches](unix/grep-for-files-with-multiple-matches.md) - [Grep For Multiple Patterns](unix/grep-for-multiple-patterns.md) - [Hexdump A Compiled File](unix/hexdump-a-compiled-file.md) - [Ignore A Directory During ripgrep Search](unix/ignore-a-directory-during-ripgrep-search.md) - [Ignore The Alias When Running A Command](unix/ignore-the-alias-when-running-a-command.md) - [Include Ignore Files In Ripgrep Search](unix/include-ignore-files-in-ripgrep-search.md) - [Interactively Browse Available Node Versions](unix/interactively-browse-availabile-node-versions.md) - [Interactively Switch asdf Package Versions](unix/interactively-switch-asdf-package-versions.md) - [Jump To The Ends Of Your Shell History](unix/jump-to-the-ends-of-your-shell-history.md) - [Kill Everything Running On A Certain Port](unix/kill-everything-running-on-a-certain-port.md) - [Killing A Frozen SSH Session](unix/killing-a-frozen-ssh-session.md) - [Last Argument Of The Last Command](unix/last-argument-of-the-last-command.md) - [Less With Style](unix/less-with-style.md) - [List All The Enabled ZSH Options](unix/list-all-the-enabled-zsh-options.md) - [List All Users](unix/list-all-users.md) - [List Files In A Single Column](unix/list-files-in-a-single-column.md) - [List Files Ordered By Modification Date](unix/list-files-ordered-by-modification-date.md) - [List Names Of Files With Matches](unix/list-names-of-files-with-matches.md) - [List Of Sessions To A Machine](unix/list-of-sessions-to-a-machine.md) - [List Parent pid With ps](unix/list-parent-pid-with-ps.md) - [List Stats For A File](unix/list-stats-for-a-file.md) - [List The Available JDKs](unix/list-the-available-jdks.md) - [List The Stack Of Remembered Directories](unix/list-the-stack-of-remembered-directories.md) - [List TXT DNS Records For A Domain](unix/list-txt-dns-records-for-a-domain.md) - [Load Env Vars In Bash Script](unix/load-env-vars-in-bash-script.md) - [Look Through All Files That Have Been Git Stashed](unix/look-through-all-files-that-have-been-git-stashed.md) - [Make Direnv Less Noisy](unix/make-direnv-less-noisy.md) - [Manually Pass Two Git Files To Delta](unix/manually-pass-two-git-files-to-delta.md) - [Map A Domain To localhost](unix/map-a-domain-to-localhost.md) - [Negative Look-Ahead Search With ripgrep](unix/negative-look-ahead-search-with-ripgrep.md) - [Occupy A Local Port With Netcat](unix/occupy-a-local-port-with-netcat.md) - [Only Show The Matches](unix/only-show-the-matches.md) - [Open The Current Command In An Editor](unix/open-the-current-command-in-an-editor.md) - [Output The Last N Bytes Of A Large File](unix/output-the-last-n-bytes-of-a-large-file.md) - [Partial String Matching In Bash Scripts](unix/partial-string-matching-in-bash-scripts.md) - [PID Of The Current Shell](unix/pid-of-the-current-shell.md) - [Print A Range Of Lines For A File With Bat](unix/print-a-range-of-lines-for-a-file-with-bat.md) - [Print DateTime Represented By Unix Timestamp](unix/print-datetime-represented-by-unix-timestamp.md) - [Print Milliseconds In Human-Readable Format](unix/print-milliseconds-in-human-readable-format.md) - [Print Out Files In Reverse](unix/print-out-files-in-reverse.md) - [Print The Current Date In Human-Readable Format](unix/print-the-current-date-in-human-readable-format.md) - [Produce A Lowercase V4 UUID](unix/produce-a-lowercase-v4-uuid.md) - [Provide A Fallback Value For Unset Parameter](unix/provide-a-fallback-value-for-unset-parameter.md) - [Remove A Directory Called `-p`](unix/remove-a-directory-called-dash-p.md) - [Repeat Yourself](unix/repeat-yourself.md) - [Replace Pattern Across Many Files In A Project](unix/replace-pattern-across-many-files-in-a-project.md) - [Run A Command Repeatedly Several Times](unix/run-a-command-repeatedly-several-times.md) - [Run A cURL Command Without The Progress Meter](unix/run-a-curl-command-without-the-progress-meter.md) - [Safely Edit The Sudoers File With Vim](unix/safely-edit-the-sudoers-file-with-vim.md) - [Saying Yes](unix/saying-yes.md) - [Search Files Specific To A Language](unix/search-files-specific-to-a-language.md) - [Search For Homebrew Packages To Install](unix/search-for-homebrew-packages-to-install.md) - [Search History](unix/search-history.md) - [Search Man Page Descriptions](unix/search-man-page-descriptions.md) - [Securely Remove Files](unix/securely-remove-files.md) - [Set The asdf Package Version For A Single Shell](unix/set-the-asdf-package-version-for-a-single-shell.md) - [Show A File Preview When Searching With FZF](unix/show-a-file-preview-when-searching-with-fzf.md) - [Show Disk Usage For The Current Directory](unix/show-disk-usage-for-the-current-directory.md) - [Show The Size Of Everything In A Directory](unix/show-the-size-of-everything-in-a-directory.md) - [Skip Paging If Output Fits On Screen With Less](unix/skip-paging-if-output-fits-on-screen-with-less.md) - [SSH Escape Sequences](unix/ssh-escape-sequences.md) - [SSH With Port Forwarding](unix/ssh-with-port-forwarding.md) - [Specify The Language For A File With Bat](unix/specify-the-language-for-a-file-with-bat.md) - [Sort In Numerical Order](unix/sort-in-numerical-order.md) - [Switch Versions of a Brew Formula](unix/switch-versions-of-a-brew-formula.md) - [Tell direnv To Load The Env File](unix/tell-direnv-to-load-the-env-file.md) - [Touch Access And Modify Times Individually](unix/touch-access-and-modify-times-individually.md) - [Type Fewer Paths With Brace Expansion](unix/type-fewer-paths-with-brace-expansion.md) - [Undo Changes Made To Current Terminal Prompt](unix/undo-changes-made-to-current-terminal-prompt.md) - [Undo Some Command Line Editing](unix/undo-some-command-line-editing.md) - [Unrestrict Where ripgrep Searches](unix/unrestrict-where-ripgrep-searches.md) - [Update Package Versions Known By asdf Plugin](unix/update-package-versions-known-by-asdf-plugin.md) - [Use fzf To Change Directories](unix/use-fzf-to-change-directories.md) - [Use Regex Pattern Matching With Grep](unix/use-regex-pattern-matching-with-grep.md) - [View A Web Page In The Terminal](unix/view-a-web-page-in-the-terminal.md) - [View The Source For A Brew Formula](unix/view-the-source-for-a-brew-formula.md) - [Watch The Difference](unix/watch-the-difference.md) - [Watch This Run Repeatedly](unix/watch-this-run-repeatedly.md) - [Where Are The Binaries?](unix/where-are-the-binaries.md) - [xargs Default Command Is echo](unix/xargs-default-command-is-echo.md) - [xargs Ignores Alias Substitution By Default](unix/xargs-ignores-alias-substitution-by-default.md) ### Vercel - [Add Web Server Layer Redirects](vercel/add-web-server-layer-redirects.md) - [Deploy An App Without Pushing An Empty Commit](vercel/deploy-an-app-without-pushing-an-empty-commit.md) - [Naming Of The Vercel Config File](vercel/naming-of-the-vercel-config-file.md) - [Pin Specific pnpm Version For Builds](vercel/pin-specific-pnpm-version-for-builds.md) - [Share Development Environment Variables Via CLI](vercel/share-development-environment-variables-via-cli.md) ### Vim - [Aborting Git Commits And Rebases](vim/aborting-git-commits-and-rebases.md) - [Absolute And Relative Line Numbers](vim/absolute-and-relative-line-numbers.md) - [Add A File Without Loading It](vim/add-a-file-without-loading-it.md) - [Add Custom Dictionary Words](vim/add-custom-dictionary-words.md) - [All The Ways To Write And Quit In Vim](vim/all-the-ways-to-write-and-quit-in-vim.md) - [Almost The End Of The Line](vim/almost-the-end-of-the-line.md) - [Alternate Files With vim-rails](vim/alternate-files-with-vim-rails.md) - [Always Keep The Gutter Open](vim/always-keep-the-gutter-open.md) - [Amend Commits With Fugitive](vim/amend-commits-with-fugitive.md) - [Backspace Options](vim/backspace-options.md) - [Beginning And End Of Previous Change](vim/beginning-and-end-of-previous-change.md) - [The Black Hole Register](vim/the-black-hole-register.md) - [Blank Lines Above And Below](vim/blank-lines-above-and-below.md) - [Breaking The Undo Sequence](vim/breaking-the-undo-sequence.md) - [Buffer Time Travel](vim/buffer-time-travel.md) - [Build And Install A Go Program](vim/build-and-install-a-go-program.md) - [Case-Aware Substitution With vim-abolish](vim/case-aware-substitution-with-vim-abolish.md) - [Case-Insensitive Substitution](vim/case-insensitive-substitution.md) - [Center The Cursor](vim/center-the-cursor.md) - [Check For An Executable](vim/check-for-an-executable.md) - [Check Your Current Color Scheme](vim/check-your-current-color-scheme.md) - [Clear Out The Jump List](vim/clear-out-the-jump-list.md) - [Close All Other Splits](vim/close-all-other-splits.md) - [Close All Other Windows](vim/close-all-other-windows.md) - [Close the Current Buffer](vim/close-the-current-buffer.md) - [Coerce The Current Filetype](vim/coerce-the-current-filetype.md) - [Coercing Casing With vim-abolish](vim/coercing-casing-with-vim-abolish.md) - [Configure FZF To Use fd For File Finding](vim/configure-fzf-to-use-fd-for-file-finding.md) - [Count the Number of Matches](vim/count-the-number-of-matches.md) - [Create A New Directory In netrw](vim/create-a-new-directory-in-netrw.md) - [Create A New File In A New Directory](vim/create-a-new-file-in-a-new-directory.md) - [Creating Non-Existent Directories](vim/creating-non-existent-directories.md) - [Default netrw To Tree Liststyle](vim/default-netrw-to-tree-liststyle.md) - [Delete Every Other Line](vim/delete-every-other-line.md) - [Delete Lines That Match A Pattern](vim/delete-lines-that-match-a-pattern.md) - [Delete To The End Of The Line](vim/delete-to-the-end-of-the-line.md) - [Deleting Buffers In BufExplorer](vim/deleting-buffers-in-bufexplorer.md) - [Deleting Directories Of Files From netrw](vim/deleting-directories-of-files-from-netrw.md) - [Detect If You Are On A Mac](vim/detect-if-you-are-on-a-mac.md) - [Difference Between :wq and :x](vim/difference-between-wq-and-x.md) - [Display Word Count Stats](vim/display-word-count-stats.md) - [Edges Of The Selection](vim/edges-of-the-selection.md) - [Edit A File At A Specific Line Number](vim/edit-a-file-at-a-specific-line-number.md) - [Edit A File Starting On The Last Line](vim/edit-a-file-starting-on-the-last-line.md) - [End Of The Word](vim/end-of-the-word.md) - [Escaping Terminal-Mode In An Nvim Terminal](vim/escaping-terminal-mode-in-an-nvim-terminal.md) - [Filter Lines Through An External Program](vim/filter-lines-through-an-external-program.md) - [Find The Nth Character Position In A File](vim/find-the-nth-character-position-in-a-file.md) - [Fix The Spelling Of A Word](vim/fix-the-spelling-of-a-word.md) - [Fold A Visual Selection And Expand It Back](vim/fold-a-visual-selection-and-expand-it-back.md) - [For When That Escape Key Is Hard To Reach](vim/for-when-that-escape-key-is-hard-to-reach.md) - [Format Long Lines To Text Width](vim/format-long-lines-to-text-width.md) - [From Ruby Variables To JavaScript Variables](vim/from-ruby-variables-to-javascript-variables.md) - [Generate and Edit Rails Migration](vim/generate-and-edit-rails-migration.md) - [Get The pid Of The Session](vim/get-the-pid-of-the-session.md) - [Go Back To The Previous Window](vim/go-back-to-the-previous-window.md) - [Go To File With Line Number](vim/go-to-file-with-line-number.md) - [Grepping Through The Vim Help Files](vim/grepping-through-the-vim-help-files.md) - [Head of File Name](vim/head-of-file-name.md) - [Help For Non-Normal Mode Features](vim/help-for-non-normal-mode-features.md) - [Highlighting Search Matches](vim/highlighting-search-matches.md) - [Horizontal to Vertical and Back Again](vim/horizontal-to-vertical-and-back-again.md) - [Increment All The Numbers](vim/increment-all-the-numbers.md) - [Incremental Searching](vim/incremental-searching.md) - [Interact With The Alternate File](vim/interact-with-the-alternate-file.md) - [Interactive Buffer List](vim/interactive-buffer-list.md) - [Joining Lines Together](vim/joining-lines-together.md) - [Jump Back To The Latest Jump Position](vim/jump-back-to-the-latest-jump-position.md) - [Jump Between And Stage Git Hunks With Fugitive](vim/jump-between-and-stage-git-hunks-with-fugitive.md) - [Jump To Matching Pair](vim/jump-to-matching-pair.md) - [Jump To The Next Misspelling](vim/jump-to-the-next-misspelling.md) - [List All Buffers](vim/list-all-buffers.md) - [List autocmds Configured For The Current Buffer](vim/list-autocmds-configured-for-the-current-buffer.md) - [List Of Plugins](vim/list-of-plugins.md) - [Load A Directory Of Files Into The Buffer List](vim/load-a-directory-of-files-into-the-buffer-list.md) - [Make Directories For The Current File](vim/make-directories-for-the-current-file.md) - [Marks Across Vim Sessions](vim/marks-across-vim-sessions.md) - [Match The Beginning And End Of Words](vim/match-the-beginning-and-end-of-words.md) - [Moving To A Specific Line](vim/moving-to-a-specific-line.md) - [Navigate To The Nth Column On A Line](vim/navigate-to-the-nth-column-on-a-line.md) - [Navigating By Blank Lines](vim/navigating-by-blank-lines.md) - [NETRW Listing Styles](vim/netrw-listing-styles.md) - [Next Modified Buffer](vim/next-modified-buffer.md) - [Normal Node Binding To Just Quit](vim/normal-mode-binding-to-just-quit.md) - [Open A Tag In A Split Window](vim/open-a-tag-in-a-split-window.md) - [Open an Unnamed Buffer](vim/open-an-unnamed-buffer.md) - [Open FZF Result In A Split](vim/open-fzf-result-in-a-split.md) - [Open Routes File With vim-rails](vim/open-routes-file-with-vim-rails.md) - [Open The Directory Of The Current File](vim/open-the-directory-of-the-current-file.md) - [Open The Fugitive Git Summary Window](vim/open-the-fugitive-git-summary-window.md) - [Open The Gemfile](vim/open-the-gemfile.md) - [Open The Latest Rails Migration](vim/open-the-latest-rails-migration.md) - [Open The Selected Lines In GitHub With Gbrowse](vim/open-the-selected-lines-in-github-with-gbrowse.md) - [Open Vim To A Tag Definition](vim/open-vim-to-a-tag-definition.md) - [Opening a URL](vim/opening-a-url.md) - [Opening Man Pages In Vim](vim/opening-man-pages-in-vim.md) - [Paste A Register From Insert Mode](vim/paste-a-register-from-insert-mode.md) - [Preventing Typos with Abbreviations](vim/preventing-typos-with-abbreviations.md) - [Previous Buffer](vim/previous-buffer.md) - [Previous Visual Selection](vim/previous-visual-selection.md) - [Print The Relative Path Of The Current File](vim/print-the-relative-path-of-the-current-file.md) - [Print Version Information](vim/print-version-information.md) - [Quick File Info](vim/quick-file-info.md) - [Quick Man Pages](vim/quick-man-pages.md) - [Quick Quickfix List Navigation](vim/quick-quickfix-list-navigation.md) - [Quickly Fix A Misspelled Word](vim/quickly-fix-a-misspelled-word.md) - [Quickly Switch To A Buffer By Number](vim/quickly-switch-to-a-buffer-by-number.md) - [Quit When There Is An Argument List](vim/quit-when-there-is-an-argument-list.md) - [Re-indenting Your Code](vim/reindenting-your-code.md) - [Read In The Contents Of A Rails File](vim/read-in-the-contents-of-a-rails-file.md) - [Rename A File Through netrw](vim/rename-a-file-through-netrw.md) - [Rename Current File](vim/rename-current-file.md) - [Repeat The Previous Change](vim/repeat-the-previous-change.md) - [Repeating Characters](vim/repeating-characters.md) - [Replace A Character](vim/replace-a-character.md) - [Reset Target tslime Pane](vim/reset-target-tslime-pane.md) - [Reverse A Group Of Lines](vim/reverse-a-group-of-lines.md) - [Rotate Everything By 13 Letters](vim/rotate-everything-by-13-letters.md) - [Rotate The Orientation Of Split Windows](vim/rotate-the-orientation-of-split-windows.md) - [Running Bundle With vim-bundler](vim/running-bundle-with-vim-bundler.md) - [Scrolling Relative to the Cursor](vim/scrolling-relative-to-the-cursor.md) - [Search Backward Through A File](vim/search-backward-through-a-file.md) - [Searching For Hex Digits](vim/searching-for-hex-digits.md) - [Select Several Results From An FZF Search](vim/select-several-results-from-an-fzf-search.md) - [Set End Of Line Markers](vim/set-end-of-line-markers.md) - [Set Your Color Scheme](vim/set-your-color-scheme.md) - [Setting Filetype With Modelines](vim/setting-filetype-with-modelines.md) - [Show All Syntax Highlighting Rules](vim/show-all-syntax-highlighting-rules.md) - [Show Matching Entries For Help](vim/show-matching-entries-for-help.md) - [Specify The Line Height Of The Quick Fix Window](vim/specify-the-line-height-of-the-quick-fix-window.md) - [Split Different](vim/split-different.md) - [Split The Current Window](vim/split-the-current-window.md) - [Splitting For New Files](vim/splitting-for-new-files.md) - [Source Original vimrc When Using Neovim](vim/source-original-vimrc-when-using-neovim.md) - [Sum A Bunch Of Numbers In The Current File](vim/sum-a-bunch-of-numbers-in-the-current-file.md) - [Swap Occurrences Of Two Words](vim/swap-occurrences-of-two-words.md) - [Swapping Split Windows](vim/swapping-split-windows.md) - [Swap The Position Of Two Split Windows](vim/swap-the-position-of-two-split-windows.md) - [Switch Moving End Of Visual Selection](vim/switch-moving-end-of-visual-selection.md) - [Tabs To Spaces](vim/tabs-to-spaces.md) - [The Vim Info File](vim/the-vim-info-file.md) - [Toggle Absolute And Relative Paths In BufExplorer](vim/toggle-absolute-and-relative-paths-in-bufexplorer.md) - [Toggling Syntax Highlighting](vim/toggling-syntax-highlighting.md) - [Turning Off Search Highlighting](vim/turning-off-search-highlighting.md) - [Unloading A Buffer](vim/unloading-a-buffer.md) - [Use Active Window With BufExplorer](vim/use-active-window-with-bufexplorer.md) - [Use The Terminal Inside A Vim Session](vim/use-the-terminal-inside-a-vim-session.md) - [Using vim-surround With A Visual Selection](vim/using-vim-surround-with-a-visual-selection.md) - [Verbose Commits With Fugitive](vim/verbose-commits-with-fugitive.md) - [View Commit History of a File](vim/view-commit-history-of-a-file.md) - [View The Current File In GitHub](vim/view-the-current-file-in-github.md) - [Viewing Man Pages with man.vim](vim/viewing-man-pages-with-man-vim.md) - [Vim Without The Extras](vim/vim-without-the-extras.md) - [What Is On The Runtime Path?](vim/what-is-on-the-runtime-path.md) - [Whole Line Auto-Completion](vim/whole-line-auto-completion.md) - [Wrap With Some Room](vim/wrap-with-some-room.md) ### VSCode - [Add The VSCode CLI To Your Path](vscode/add-the-vscode-cli-to-your-path.md) - [Advance Through Search Results](vscode/advance-through-search-results.md) - [Enable Breadcrumbs For Version 1.26 Release](vscode/enable-breadcrumbs-for-version-126-release.md) - [Find The Location Of User Settings JSON File](vscode/find-the-location-of-user-settings-json-file.md) - [Jump To Problems In The Current File](vscode/jump-to-problems-in-the-current-file.md) - [Open An Integrated Terminal Window](vscode/open-an-integrated-terminal-window.md) - [Pop Open The Quick Fix Window](vscode/pop-open-the-quick-fix-window.md) - [Step Through Project-Wide Search Results](vscode/step-through-project-wide-search-results.md) - [Synchronize Vim Clipboard With System Clipboard](vscode/synchronize-vim-clipboard-with-system-clipboard.md) - [Toggle Between Terminals](vscode/toggle-between-terminals.md) - [Turn Off Display Of Tabs For Files](vscode/turn-off-display-of-tabs-for-files.md) ### Webpack - [Better Module Imports With Aliases](webpack/better-module-imports-with-aliases.md) - [Debugging With Full Source Maps](webpack/debugging-with-full-source-maps.md) - [Run ESLint As A Preloader](webpack/run-eslint-as-a-preloader.md) - [Specify Port Of CRA's Webpack Dev Server](webpack/specify-port-of-cra-webpack-dev-server.md) - [Use A Specific Config File](webpack/use-a-specific-config-file.md) ### Workflow - [Add Hotkeys For Specific Raycast Extensions](workflow/add-hotkeys-for-specific-raycast-extensions.md) - [Add Subscriber To Kit Form Via API](workflow/add-subscriber-to-kit-form-via-api.md) - [Add Subtitles To Existing Mux Video Asset](workflow/add-subtitles-to-existing-mux-video-asset.md) - [Access 1Password Credential From CLI](workflow/access-1password-credential-from-cli.md) - [Allow Key-Repeating With Cursor](workflow/allow-key-repeating-with-cursor.md) - [Change Window Name In iTerm](workflow/change-window-name-in-iterm.md) - [Configure Email Redirect With Cloudflare](workflow/configure-email-redirect-with-cloudflare.md) - [Convert An ePub Document To PDF On Mac](workflow/convert-an-epub-document-to-pdf-on-mac.md) - [Create A Local Sanity Dataset Backup](workflow/create-a-local-sanity-dataset-backup.md) - [Create A Public URL For A Local Server](workflow/create-a-public-url-for-a-local-server.md) - [Enable Dev Tools For Safari](workflow/enable-dev-tools-for-safari.md) - [Forward Stripe Events To Local Server](workflow/forward-stripe-events-to-local-server.md) - [Get URL For GitHub User Profile Photo](workflow/get-url-for-github-user-profile-photo.md) - [Get Your Public IP Address](workflow/get-your-public-ip-address.md) - [Import A Github Project Into CodeSandbox](workflow/import-a-github-project-into-codesandbox.md) - [Interactively Kill A Process With fkill](workflow/interactively-kill-a-process-with-fkill.md) - [Open Slack's Keyboard Shortcuts Reference Panel](workflow/open-slacks-keyboard-shortcuts-reference-panel.md) - [Prune The Excess From node_modules](workflow/prune-the-excess-from-node-modules.md) - [Rotate An Image To Be Oriented Upright](workflow/rotate-an-image-to-be-oriented-upright.md) - [See Overlaps For A Set Of Time Zones](workflow/see-overlaps-for-a-set-of-time-zones.md) - [Send A Message To A Discord Channel](workflow/send-a-message-to-a-discord-channel.md) - [Set Recurring Reminders In Slack](workflow/set-recurring-reminders-in-slack.md) - [Toggle Between Stories In Storybook](workflow/toggle-between-stories-in-storybook.md) - [Update asdf Plugins With Latest Package Versions](workflow/update-asdf-plugins-with-latest-package-versions.md) - [View The PR For The Current GitHub Branch](workflow/view-the-pr-for-the-current-github-branch.md) ### XState - [Always Use Inline Functions With Assign](xstate/always-use-inline-functions-with-assign.md) - [Custom Jest Matcher For XState Machine States](xstate/custom-jest-matcher-for-xstate-machine-states.md) - [Define Event That Does Internal Self Transition](xstate/define-event-that-does-internal-self-transition.md) - [Events Stop Propagating Once Handled](xstate/events-stop-propagating-once-handled.md) - [Inline Actions vs Actions In Machine Options](xstate/inline-actions-vs-actions-in-machine-options.md) - [Make Immediate And Delayed Transitions](xstate/make-immediate-and-delayed-transitions.md) - [Simple States And Composite States](xstate/simple-states-and-composite-states.md) - [Start A Machine In A Specific State](xstate/start-a-machine-in-a-specific-state.md) - [Use An XState Machine With React](xstate/use-an-xstate-machine-with-react.md) ### YAML - [Create Multi-Line Strings Without The Line Breaks](yaml/create-multi-line-strings-without-the-line-breaks.md) - [YAML Is A Superset Of JSON](yaml/yaml-is-a-superset-of-json.md) ### Zod - [Check If An Object Is Empty With Zod](zod/check-if-an-object-is-empty-with-zod.md) - [Create A Schema That Matches On Any Object](zod/create-a-schema-that-matches-on-any-object.md) - [Create Union Type Of Nearly Identical Objects](zod/create-union-type-of-nearly-identical-objects.md) - [Get Readable Errors From Schema Parse](zod/get-readable-errors-from-schema-parse.md) - [Incorporate Existing Type Into Zod Schema](zod/incorporate-existing-type-into-zod-schema.md) - [Set Custom Error Message For Nonempty Array](zod/set-custom-error-message-for-nonempty-array.md) ### Zsh - [Add To The Path Via Path Array](zsh/add-to-the-path-via-path-array.md) - [Link A Scalar To An Array](zsh/link-a-scalar-to-an-array.md) - [Use A Space To Exclude Command From History](zsh/use-a-space-to-exclude-command-from-history.md) ## Usage The `.vimrc` file for this project contains a function `CountTILs` that can be invoked with `<leader>c`. This will do a substitution count of the current number of TILs and display the result in the command tray. ## About I shamelessly stole this idea from [thoughtbot/til](https://github.com/thoughtbot/til). ## Other TIL Collections * [Today I Learned by Hashrocket](https://til.hashrocket.com) * [jwworth/til](https://github.com/jwworth/til) * [thoughtbot/til](https://github.com/thoughtbot/til) ## License &copy; 2015-2022 Josh Branchaud This repository is licensed under the MIT license. See `LICENSE` for details. ", Assign "at most 3 tags" to the expected json: {"id":"4818","tags":[]} "only from the tags list I provide: [{"id":77,"name":"3d"},{"id":89,"name":"agent"},{"id":17,"name":"ai"},{"id":54,"name":"algorithm"},{"id":24,"name":"api"},{"id":44,"name":"authentication"},{"id":3,"name":"aws"},{"id":27,"name":"backend"},{"id":60,"name":"benchmark"},{"id":72,"name":"best-practices"},{"id":39,"name":"bitcoin"},{"id":37,"name":"blockchain"},{"id":1,"name":"blog"},{"id":45,"name":"bundler"},{"id":58,"name":"cache"},{"id":21,"name":"chat"},{"id":49,"name":"cicd"},{"id":4,"name":"cli"},{"id":64,"name":"cloud-native"},{"id":48,"name":"cms"},{"id":61,"name":"compiler"},{"id":68,"name":"containerization"},{"id":92,"name":"crm"},{"id":34,"name":"data"},{"id":47,"name":"database"},{"id":8,"name":"declarative-gui "},{"id":9,"name":"deploy-tool"},{"id":53,"name":"desktop-app"},{"id":6,"name":"dev-exp-lib"},{"id":59,"name":"dev-tool"},{"id":13,"name":"ecommerce"},{"id":26,"name":"editor"},{"id":66,"name":"emulator"},{"id":62,"name":"filesystem"},{"id":80,"name":"finance"},{"id":15,"name":"firmware"},{"id":73,"name":"for-fun"},{"id":2,"name":"framework"},{"id":11,"name":"frontend"},{"id":22,"name":"game"},{"id":81,"name":"game-engine "},{"id":23,"name":"graphql"},{"id":84,"name":"gui"},{"id":91,"name":"http"},{"id":5,"name":"http-client"},{"id":51,"name":"iac"},{"id":30,"name":"ide"},{"id":78,"name":"iot"},{"id":40,"name":"json"},{"id":83,"name":"julian"},{"id":38,"name":"k8s"},{"id":31,"name":"language"},{"id":10,"name":"learning-resource"},{"id":33,"name":"lib"},{"id":41,"name":"linter"},{"id":28,"name":"lms"},{"id":16,"name":"logging"},{"id":76,"name":"low-code"},{"id":90,"name":"message-queue"},{"id":42,"name":"mobile-app"},{"id":18,"name":"monitoring"},{"id":36,"name":"networking"},{"id":7,"name":"node-version"},{"id":55,"name":"nosql"},{"id":57,"name":"observability"},{"id":46,"name":"orm"},{"id":52,"name":"os"},{"id":14,"name":"parser"},{"id":74,"name":"react"},{"id":82,"name":"real-time"},{"id":56,"name":"robot"},{"id":65,"name":"runtime"},{"id":32,"name":"sdk"},{"id":71,"name":"search"},{"id":63,"name":"secrets"},{"id":25,"name":"security"},{"id":85,"name":"server"},{"id":86,"name":"serverless"},{"id":70,"name":"storage"},{"id":75,"name":"system-design"},{"id":79,"name":"terminal"},{"id":29,"name":"testing"},{"id":12,"name":"ui"},{"id":50,"name":"ux"},{"id":88,"name":"video"},{"id":20,"name":"web-app"},{"id":35,"name":"web-server"},{"id":43,"name":"webassembly"},{"id":69,"name":"workflow"},{"id":87,"name":"yaml"}]" returns me the "expected json"