- Use pytest-xdist to Speed Up Testing
- How to Remove a Stubborn Snap
- Using uv and subprocess module
- The Git Commands I Run Before Reading Any Code
- Python tip: name your unicode characters
- uv Python Upgrade
- Find Error in pg_dump
- Use filter() instead of for loop
- How to Version in pyproject
- Use SQL Linter
- Bash trick: using grep for faster history search
- List table columns in PostgreSQL database
- Use Grep to Find Content and Move
- Remove Tracking File or Folder from Git
- Last Updated Columns with Postgres
- Remove Telemetry from Streamlit
- Data Alignment to Save Space
- Remove Characters from a String
- uv Cheatsheet
- Firefly III Personal Access Token Expires
- Start all of your commands with a comma
- git diff with pytest
- Get Schema Sizes
- How to Append Text in PostgreSQL
- Python Gotcha: Logging an uncaught exception
- Linking to external files & folders
- Finding Differences in Images with Python and Pillow
- Install pre-commit with uv
- A PostgreSQL planner gotcha with CTEs DELETE and LIMIT
- Validating Data Types from Semi-Structured Data Loads in Postgres with pg_input_is_valid
- SQL Noir
- PostgreSQL_Language Server
- selfh.sh
- Python sh Package
- De-duplicate with sets & dict.fromkeys
- A Quick Guide to Generating Fake Data with Pandas
- How to use Fuzzy String Matching with PostgreSQL
- Writing Python Like It's Rust
- How to List Active Connections on PostgreSQL
- Working with Time in Postgres
- Vim Tips
- Escape Keys using psycopg2
- psql is Awesome
- How to use Variables in a psql Script
- Prune Docker Images
- Ultimate Guide to Python Debugging
- Clear Highlighting in Vim
- Find and Replace in Vim
- Improving GROUP BY with CREATE STATISTICS
- Include Schema in psycopg2 Connection String
- Practical Decorators
- Create Read Only User in PostgreSQL
- Using a Data Dictionary as Your Roadmap to Quality Data
- MERGE Command with Examples
- How to Create PowerShell Alias
- Creating Histograms with Postgres
- Self-Contained Python Scripts with uv
- Check Iterable Equality the Right Way
- Data Spines
- Using Assert Never in Python
- Create Assert Function in SQL
- List Table Columns in PostgreSQL Database
- Stub Code
- List of Named Color for Pandas
- Using Document Properties to Track Your Excel Reports
- How to Generate a list of Tables to Drop
- Passing a List of Arguments with Click
- Using Regex in PostgreSQL
- Linear Regression
- Interpolation
- Date Functions
- Using DuckDB in Streamlit
- Sampling
- Random
- Create Table with Existing Table with No Data
- Self Joins
- Recursive CTEs
- Starting in Read Only Mode the Easy Way
- Exporting Notebooks from DuckDB UI
- Postgres query cancellation
- VS Code to Copy and Paste to Terminal
- An introvert’s 3 secrets to networking
- Some New Unix/Linux Tools
- Uv has a killer feature you should know about
- Using uv to build and install Python CLI apps
- Generate CREATE TABLE query for an existing table
- The Reverse of cat is tac
- Browsing DuckdB Offline
- Open Mateo Weather API
- Great Tables and StreamLit
- How to Reinstall Python with uv
- WAT Python Inspection Tool
- RightTyper to Generate Types
- Count Number of Lines in a Git Repository
- Fastest Way to Read Excel in Python
- Check for unused Indexes
- Powershell Remoting
- View Code of Stored Procedure
- See the History of a Method with git log -L
- Using psql Variables to Introspect Your Script
- psql Watch Improvements
- How to List Active Connections on PostgreSQL
- Check for Unvalidated Database Constraints
- Deprecated
- Get Battery Status in CLI
- How to Read a Vim Swapfile
- Delete Files Older Than x Days on Linux
- How to Use a match case Statement
- Vim Tips
- Create Git Branch and Checkout
- Set Statement Timeout
- Built-in Functions in Python
- Escape Keys using psycopg2
- Setup Python Package to use with Pipx
- Prune Docker Images
- Clear Highlighting in Vim
- Application Name in PostgreSQL
- Find and Replace in Vim
- Calculate the Distance between two Latitudes and Longitudes
- Get Disk Size for Each Database
- Include Schema in psycopg2 Connection String
- Create Automatic Timestamps in PostgreSQL
- Using Rich Inspect to Interrogate Python Objects
- Use IN and EXIST in the Right Situations
- Pasting Text in Vim
#Access Token
#Adam Johnson
#Al Sweigart
#Ally Piechowski
#Ami Vora
#Andrew Wegner
#Anton Zhiyanov
#Apache
#Api
#Application_name
#Apt-Mirror
#Array
#Ashish Bhatia
#Assert Never
#Assert_never
#Astral
#Atuin
#Autoindent
#B-Tree
#Bash
#Bashrc
#Battery
#Ben Rogojan
#Bernoulli
#Beyond the Basic Stuff With Python
#Bite Code
#Blog
#Brag Document
#Branch
#Brandon Rhodes
#Brian Okken
#Brin_index
#Caleb Hearth
#Career
#Cat
#Ceil
#Cheatsheet
#Checkout
#Chris Moffitt
#Cli
#Click
#Coalesce
#Code Snippet
#Codebook
#Command Line
#Commandline Interface
#Comp_keyword_case
#Console
#Constraints
#Create Statistics
#Create Table
#Crystal Lewis
#Cte
#Dashboards
#Data Dictionary
#Database
#Dataclass
#Date
#Date_part
#Dave Johnson
#Decorators
#Deprecated
#Dict
#Dmitri Popov
#Docker
#Document Properties
#Documentation
#Drop_table
#Duckdb
#Duckdb Ui
#Duckduckgo
#Echo_hidden
#Elizabeth Christensen
#Enumerate
#Erin Mullaney
#Error
#Excel
#Exceptions
#Explain_analyze
#Faker
#Fillna
#Find
#Firefly Iii
#Flit
#Function
#Fuzzy
#Fuzzystrmatch
#Gdesc
#Generate_series
#Gexec
#Gist
#Git
#Git Leaks
#Git Submodules
#Github
#Github Actions
#GitHub CoPilot
#Great_tables
#Grep
#Group By
#Gset
#Gunnar Morling
#Haki Benita
#Hans-Jürgen Schönig
#Hextra Theme
#Highlighting
#Histogram
#Hugo
#Hynek Schlawack
#Idle_in_transaction
#Image
#Images
#Index
#Inspect
#Iterable
#Jakub Beránek
#Jean Niklas Lorange
#John Hagen
#Julian Domke
#Kaarel Moppel
#Laetitia Avrot
#Late Night Linux
#Levenshtein
#License Check
#Linear Regression
#Linkedin
#Linux
#Log
#Logging
#Lsp
#Luca Ferrari
#Lucas Ferrari
#Lukas Valatka
#Macos
#Marat Badykov
#Martin Heinz
#Mastodon
#Match Case
#Mehdi
#Merge
#Metaphone
#Mike Driscoll
#Ms Sql Server
#Ms Sql Server Management Studio
#Mssms
#Mtime
#Neovim
#Networking
#Newtype
#Nopaste
#Nosey Parker
#Numpy
#Nvim
#Obsidian
#Oop
#Open Source
#Open-Mateo
#Open_mateo
#Openlibrary
#Openweather_report
#Openweathermap
#Overlaps
#Pandas
#Paste
#Pelican
#Pelican-Jupyter
#Performance Review
#Peter Gleeson
#Petrica Leuca
#Pg_constraint
#Pg_database
#Pg_dump
#Pg_dumpall
#Pg_input_is_valid
#Pg_read_all_data
#Pg_stat_activity
#Pg_tables
#Pg_trgm
#Pg_upgrade
#Philipp Steinrötter
#Phonetic
#Pillow
#Pipx
#Planner
#Postgres
#Postgreslq
#Postgresql
#Powershell
#Pre-Commit
#Precommit
#Pretty_html_table
#Project
#Prune
#Pset
#Psql
#Psycopg2
#Psycopg2-Binary
#Pybites
#Pycon
#Pyenv
#Pyproject
#Pytest
#Python
#Python 3.10
#Python Bytes
#Random
#Recursive
#Regex
#Regr_intercept
#Regr_slope
#Remote
#Renaud Viot
#Replace
#Replace()
#Requirements
#Reuven Lerner
#Review
#Rich
#Rm
#Robin Moffatt
#Rodrigo Girao Serrao
#Row_count
#Ruff
#Rust
#Sampling
#Scanned_isbn
#Scipy
#Sed
#Sehrope Sarkuni
#Self Joins
#Self-Hosted
#Selfh.sh
#Service File
#Set
#Sh
#Shayon Mukherjee
#Show_all_results
#Similarity
#Simon Willison
#Smart Goals
#Snap
#Soundex
#Sql
#SQL for Data Scientists
#Sqlalchemy
#Stackoverflow
#Statement Timeout
#Statement_timeout
#Streamlit
#String
#String_to_array
#Stub
#Subprocess
#Substitute
#Superbase
#Swapfile
#Tablesample
#Tac
#Taop
#Telemetry
#The Art of PostgreSQL
#Til
#Time
#Time Zone
#Timeout
#Timestamp
#Timezone
#To_char
#Traceback
#Training
#Trey Hunner
#Trigger
#Trigram
#Tstzmultirange
#Tucker Beck
#Types
#Ubuntu
#Unicode
#Utc
#Uv
#Variables
#Venv
#Vim
#Visidata
#Vs Code
#Wat
#Wc
#Weather
#Width_bucket
#Windows
#Windows 10
#Windows 11
#Xargs
#Xlsxwriter
#Youtube
#Zach Merill
#Zip