- postgresqlUpsert in postgres
- postgresqlDrop a constraint
- postgresqlAdd a unique constraint in postgres
- sqlHaving to filter aggregates
- postgresqlSelect rows for update
- pythonThe
-kflag for pytest - cliMake a bash script fail on command failure
- pythonAutoreload imports in
ipythonREPL - pythonClear namespace in ipython session
- gitRemove a file from git repo
- githubForce cancelling a github action workflow
- postgresqlImport/Export a table
- postgresqlCopy a table in Postgres
- postgresqlCheck the size of a database or table
- python
inspect.get_filefunction - pythonThe
__file__Attribute in Python - pythonLoad or run python files from
ipython - css
box-sizing: border-boxin CSS - gitCreate a branch at a given commit
- sqlalchemyCheck whether an attribute has been loaded
- pythonThe
itemgetterfunction from theoperatormodule. - postgresqlThe
cardinalityfunction in PostgreSQL - postgresqlHow to insert array literals
- gitCherry-pick multiple commits
- sqlalchemyGet the corresponding SQL from a query object
- redisDelete multiple keys in redis
- redisCheck redis version
- cliPgrep to find PIDs by name
- pythonSetting a signal handler
- claude-codeHow to resume a previous session with claude code.
- pythonRunning a python script from a REPL session
- cliUse
stty saneto restore terminal - postgresqlChange table display mode in
psqlandpgcli - python
str.partition - jsCreate DOM elements programatically
- jsCheck dependencies and their versions in a node project
- js
Array.prototype.atget the element at a specified index. - sqlEscape single quotes in a SQL query
- react
useMemohook - sqlalchemyLog SQL to stdout
- python
datetime.replace - postgresqlSelect a random row
- httpUse a file to specify the http payload with curl
- httpSkip certificate verification for https in curl
- tmuxMoving panes in tmux
- postgresqlGet the postgres version
- postgresqlList all values of a Postgres enum
- postgresqlUseful queries to check existing connections
- typescript! operator in typescript
- js
Array.prototype.flatMap - js
Array.prototype.flatto flatten nested arrays. - cli
networkQualitytool in macos - jsUse
%cto apply styling toconsole.logoutput - js
console.groupCollapsedfunction - djangoHow to keep the database from the previous test run with
pytest-django - httpCheck Latency with
curl - chromeCopy Property Path Option in Chrome DevTools
- jsJavaScript
console.dirFunction - postgresqlDump and restore PostgreSQL databases
- docker
docker compose upcan be used to execute only one service - postgresqlUse COPY to export to CSV
- pythonThe
-ucli flag in Python - python
re.DOTALLflag in python regular expressions - python
%historymagic function in ipython - gitApplying a stash without removing it from the list
- cli
aliasprints all defined aliases - djangoUse
override_settingsas a context manager - jsEscape sequence to add emojis to javascript strings
- pythonEscape sequence to use emojis in Python strings
- pythonCPU profiling with
cProfile - dockerDocker compose watch
- dockerUsing YAML anchors and aliases in docker compose files
- dockerExtensions in the compose file
- goDoubly Linked List in Go
- dockerPort forwarding in docker run
- dockerSetting environment variables in a container with docker run
- python
str.isnumericmethod to check if all characters are numeric - jsGet the data attributes of a DOM element with javascript
- go
utf8.RuneCountInStringutility function to count runes in a string. - pythonUsing
functools.cacheto memoize functions - cssAdd style rules for dark mode
- pythonFile copy functions in
shutil - tmuxResizing panes in tmux
- bash
*in shell globbing does not match hidden files - nodeUninstalling packages and dependencies
- go
strings.Repeatin go - python
str.splitlines - go
slices.Reverse - dockerCheck volume size in docker
- go
slices.Contains - httpTools to test HTTP clients
- docker
docker compose restart - docker
docker compose exec - python
types.SimpleNamespace - python
operator.attrgetter - djangoAvoid autogenerated
varchar_pattern_opsindices created when usingdb_index=Trueorunique=True - pythonPython stdlib functions to calculate GCD (greatest common divisor) and LCM (lowest common multiple)
- python
collections.Counter'smost_commonmethod - chromeCmd + Shift + A (Ctrl + Shift + A in windows)
- go
log.Fatallnandlog.Fatalf - cli
trcommand in linux - python
slicebuilt-in object - python
bisectmodule - cliWhat does
real,userandsysfrom the output oftimemean? - gitSearch codebase history using
git log -S - gitList tags and see the changes in the commit a tag points to
- jsOptional chaining with methods in JS
- jsString.prototype.concat
- js
document.activeElement - typescriptUsing the
asoperator for mocks in jest tests - jsArray.isArray
- pythonUsing
glob.globto find files - sqliteCreate a sqlite database
- vscodeCustomize directories where VSCode search for virtualenvs
- python
typing.NamedTuple - python
pytest --trace - gitStash individual files
- goUse
reflect.Typeofget the type of a variable - goUsing
log.Fatal - go
defer - pythonCustomize iPython shell
- bashMulti line comments in a bash script
- pythonUsing
unittest.mock.patchas a class decorator - tmuxShow pane numbers
- git
git applyto apply a patch - pythonThe
endoptional kwarg of theprintbuilt-in function. - pythonHow to reference values using hex in strings
- react
useCallback - react
memo - pythonDebug f-strings
- django
python manage.py sqlmigrate - python
defaultkwarg inmaxbuiltin - vimPrint the content of registers
- chromeReplay an AJAX request in Chrome
- js
donefunction in Jest tests - react
screen.logTestingPlaygroundURL()to debug queries when using testing-library - jsReact strict mode
- typescript
Pickgeneric - postgresqlIdentify long running queries and kill them.
- celeryDebugging celery tasks
- jsThe comma operator (,)
- gitPull and resolve conflicts by using changes from the origin.
- djangoCheck the database connection settings from the Django shell
- tmuxList clients connected to a tmux session.
- vimCheck what Python interpreter vim is using.
- pythonCheck what interpreter is running from a Python REPL or script
- tmuxDisconnect sessions from tmux
- markdownNested lists in markdown
- jsDestructure and renaming in ES6
- djangoCheck Django version from the command line
- tmuxTmux scrolling
- bashDifference between single and double quotes in bash.
- bashFor loops in bash
- jsNullish coalescing operator (??)
- gitHow do I git rebase the first commit?
- gitFixing commits with
git commit --fixupandgit rebase -i --autosquash - pythonPretty print JSON
- httpContent-Type HTTP header
- httpAccept HTTP header
- pythonUsing multiple
pytest.mark.parametrizedecorators - cliEdit cli command in $EDITOR
- dockerExecute command in running container
- pythonPoetry Cheatsheet
- pythonWhat does
/represent in the argument list of a function - pythonWhat does
...mean in python? - python
dict.setdefault - pythonWhat does an asterisk represent in the argument list of a function
- cliLsof to get the process listening on a given port
- python
itertools.countto create an iterator that returns an infinite sequence of numbers - gitShow changes in staged files.
- gitTo amend the previous commit and keep the same log message, run:
- cssPseudo-elements
- cssPseudo-classes
- gitRebase when pulling
- djangoDjango performance debugging tools
- pythonDictionary view objects
- vscodeKeyboard shortcut to resize built-in VSCode's terminal
- tmuxReload tmux configuration
- nodeCheck what global packages has been installed and where.
- python
itertools.productto calculate the cartesian products of input iterables - jsJS
encodeURIandencodeURIComponentfunctions - cliw command
- jsTagged Template Literals
- reactuseEffect react hook
- jsJS Promises.
- chromeThrottle network connection in Chrome
- gitRename the current branch.
- gitCheck what's stashed and the changes they introduce.
- sshDisconnecting from unresponsive connection
- tmuxReconciling Tmux and SSH Agent Forwarding.
- gitMultiple SSH Keys for different Github Accounts
- sshSSH Agent forwarding
- gitRemove everything from the staging area.
- jsDebugging jest tests with breakpoints.
- jsComputed property names
- gitAdding changes by hunk to the staging area.
- jsJS
console.count()andconsole.countReset()functions - js
**operator - reactReact Fragments
- dockerDebugging with ipdb in a docker-compose environment
- sshExecute command in a remote machine via ssh
- bashObtain the definition of an alias
- bashBash Special Variables
- conceptualConcurrency and Parallelism