- https://wiki.postgresql.org/wiki/Lock_Monitoring
- https://wiki.postgresql.org/wiki/Don't_Do_This
- Checks for potentially unsafe migrations
- https://www.crunchydata.com/postgres-tips
- Avoid avoid using nested transactions and
SELECT FOR SHARE
- Notes on some PostgreSQL implementation details
From: https://jolynch.github.io/posts/use_fast_data_algorithms/
Application | Common Bad Performance Choices | Better Performance Choices | Expected Performance Gain |
---|---|---|---|
Trusted data hashing | md5, sha2, crc32 | xxhash | ~10x |
Untrusted data hashing | md5, sha2, sha1 | blake3 | ~10x |
Fast compression | snappy, gzip (zlib) | lz4 | 10x over gzip~2x over snappy |
Good compression | gzip (zlib) | zstd | ~2-10x |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Show hidden characters
{ | |
"name": "Minimal", | |
"author": "Gonçalo Cabrita", | |
"variables": | |
{ | |
"black": "#000000", | |
"white": "#ffffff", | |
"green": "#009300", | |
"red": "#ff0000", | |
"yellow": "#cccc00" |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
DetectHiddenWindows True | |
EXCEPT:="Progman WorkerW Shell_TrayWnd" | |
#!LButton:: | |
{ | |
moveActiveWindow | |
Return | |
} |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
gem_name = "ruby-progressbar" | |
`gem install #{gem_name}` | |
gem_folder_path = `gem which #{gem_name}`.strip.toutf8.gsub("#{gem_name}.rb", "") | |
$: << gem_folder_path |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#F3F3F4,#121016,#DEDFE1,#060607,#DEDFE1,#313335,#558A66,#B16364,#E4E5E7,#313335 |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
package main | |
import ( | |
"context" | |
"fmt" | |
"sync" | |
"cloud.google.com/go/firestore" | |
firebase "firebase.google.com/go" | |
) | |
var ( |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// This file was initially generated by Windows Terminal 1.0.1811.0 | |
// It should still be usable in newer versions, but newer versions might have additional | |
// settings, help text, or changes that you will not see unless you clear this file | |
// and let us generate a new one for you. | |
// To view the default settings, hold "alt" while clicking on the "Settings" button. | |
// For documentation on these settings, see: https://aka.ms/terminal-documentation | |
{ | |
"$schema": "https://aka.ms/terminal-profiles-schema", |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
function $e(tag='div', props={}, children=[]){ | |
let element = document.createElement(tag); | |
Object.assign(element, props); | |
element.append(...children); | |
return element; | |
} | |
// With `elem.append(...children)` - with the added benefit that plain strings passed to .append() get turned into text nodes automatically, so you probably don't need $t any more. | |
var $t=document.createTextNode.bind(document); |