TIL
A Quick Guide to Generating Fake Data with Pandas
#Erin Mullaney#pandas#python#faker#numpy
A excellent article from Erin.
April 6, 2025
How to use Fuzzy String Matching with PostgreSQL
#Peter Gleeson#postgresql#fuzzy#string#pg_trgm#trigram#phonetic#fuzzystrmatch#soundex#string_to_array#metaphone#similarity#levenshtein
Good article from Peter.
April 6, 2025
Writing Python Like It's Rust
#python#rust#dataclass#newtype#Jakub Beránek
Good article from Jakub.
April 6, 2025
Working with Time in Postgres
#Elizabeth Christensen#postgresql#overlaps#brin_index#tstzmultirange#b-tree
Yet another good article from Elizabeth.
April 6, 2025
psql is Awesome
#echo_hidden#comp_keyword_case#show_all_results#pset#gdesc#gexec#postgresql#Laetitia Avrot#psql#service file#row_count
Excellent talk from Laetitia.
April 6, 2025
Ultimate Guide to Python Debugging
#python#logging#log#Martin Heinz
A good guide to Python debugging.
April 6, 2025
Improving GROUP BY with CREATE STATISTICS
#postgresql#create statistics#explain_analyze#group by#Hans-Jürgen Schönig
Improve planning by using Create Statistics from Hans.
April 6, 2025
Include Schema in psycopg2 Connection String
#postgresql#psycopg2#sqlalchemy
A method to connect to a specific schema.
April 6, 2025
Practical Decorators
#python#decorators#training#Reuven Lerner#pycon
Reuven’s talk from PyCon 2019.
April 6, 2025
Using a Data Dictionary as Your Roadmap to Quality Data
#data dictionary#codebook#Crystal Lewis
Good article from Crystal.
April 6, 2025
Creating Histograms with Postgres
#postgresql#Elizabeth Christensen#histogram#width_bucket#generate_series
A nice article on how to do histograms in PostgreSQL.
April 4, 2025
Self-Contained Python Scripts with uv
#uv#python#Tucker Beck#Dave Johnson
As long as uv is installed, be able to run a python script with dependencies.
April 4, 2025
Create Assert Function in SQL
#sql#assert never#error#Haki Benita
Using an assert to instead of sending NULL.
April 1, 2025
Stub Code
#stub#beyond the basic stuff with python#python#Al Sweigart
A better way to have a new function that is not ready.
March 31, 2025
Using Document Properties to Track Your Excel Reports
#excel#document properties#python#xlsxwriter#vs code#code snippet#Chris Moffitt
A good way to add some info to an Excel file.
March 29, 2025
How to Generate a list of Tables to Drop
#sql#pg_tables#drop_table#postgresql
An easy method to get a list of tables to remove.
March 29, 2025
Passing a List of Arguments with Click
This can be useful when an option can take multiples at the same time.
March 29, 2025
Linear Regression
#linear regression#python#sql#postgresql#scipy#regr_slope#regr_intercept
How to do linear regression with SQL.
March 29, 2025
Interpolation
#pandas#python#sql#Haki Benita#fillna#coalesce
One method to fill in data.
March 29, 2025
Using DuckDB in Streamlit
#Petrica Leuca#duckdb#streamlit
There were a handful of useful things from this article.
March 29, 2025
Sampling
#sql#postgresql#sampling#random#bernoulli#tablesample#Haki Benita
Sampling data with SQL.
March 29, 2025
Random
#sql#postgresql#random#generate_series#ceil#array#Haki Benita
Some different ways to create random data
March 29, 2025
Starting in Read Only Mode the Easy Way
#postgreslq#psql#Kaarel Moppel
Easy way to ensure that you are in read only mode.
March 27, 2025
Postgres query cancellation
Couple of different ways to add a timeout to a PostgreSQL query.
March 18, 2025
VS Code to Copy and Paste to Terminal
#Mehdi#vs code#duckdb#python#postgresql
Very useful tip from Mehdi without leaving your IDE
March 10, 2025
An introvert’s 3 secrets to networking
#Ami Vora#networking#career#linkedin
Excellent article from Ami
February 23, 2025
Using uv to build and install Python CLI apps
#python#uv#cli#commandline interface#Rodrigo Girao Serrao
Not the full article but a couple of new items I did not know about.
February 22, 2025
Generate CREATE TABLE query for an existing table
When you do not have the script that created the table.
February 22, 2025
Open Mateo Weather API
#open_mateo#python#weather#api
Open Mateo can be an alternative to Open Weather Map.
February 1, 2025
Great Tables and StreamLit
#python#great_tables#streamlit
The Great Tables package is all about making it simple to produce nice-looking display tables.
February 1, 2025
WAT Python Inspection Tool
A powerful inspection tool to help with unknown Python objects.
January 1, 2025
Count Number of Lines in a Git Repository
If you were ever curious how many lines of code you have in a repo.
September 5, 2024
View Code of Stored Procedure
#til#ms sql server#ms sql server management studio#mssms
I needed to see the code of a stored procedure in MS SQL Server at work so that I could create a modified query. I normally don’t use Stack Overflow much anymore but this was actually useful and well described. Using SQL Server Management Studio do the following: Go to Database -> Programmmability -> Stored Procedure. Right click on the procedure you want to view and click Modify. Be careful not to modify it when you only want to view it.
November 28, 2023
How to List Active Connections on PostgreSQL
#til#pg_stat_activity#postgresql
How to check using a query what is actively running.
October 17, 2023
Check for Unvalidated Database Constraints
#til#postgresql#constraints#pg_constraint#mastodon
Verify that you don’t have a constraint created without validation.
October 10, 2023
How to Read a Vim Swapfile
How to read a swapfile, especially where there isn’t an reference file.
September 12, 2023
Get Battery Status in CLI
How to get the battery status using standard CLI tools in Linux.
September 12, 2023
Delete Files Older Than x Days on Linux
Quickly delete files older than a certain number of days.
September 5, 2023
How to Use a match case Statement
#til#python 3.10#match case#python
Some examples of how to use match case statement in Python.
August 29, 2023
Set Statement Timeout
#til#timeout#statement_timeout#postgresql#idle_in_transaction
Set a timeout in case you want to terminate a long running query.
August 1, 2023
Escape Keys using psycopg2
#til#psycopg2#python#postgresql
Making sure that using % in PostgreSQL works with psycopg2.
June 2, 2023
Setup Python Package to use with Pipx
#til#python#pipx#pyproject#flit
Setting up your Python project to work with pipx and pyproject.toml
May 26, 2023
Clear Highlighting in Vim
Clearing highlighting after performing a search for an example.
April 14, 2023
Application Name in PostgreSQL
#til#postgresql#application_name#taop#The Art of PostgreSQL
Send application name to PostgreSQL.
March 31, 2023
Find and Replace in Vim
#til#vim#find#replace#substitute
Different ways to find and replace items using vim.
March 24, 2023
Calculate the Distance between two Latitudes and Longitudes
#til#sql#SQL for Data Scientists
Calculation using SQL.
March 17, 2023
Get Disk Size for Each Database
#til#taop#postgresql#psql#The Art of PostgreSQL#pg_database
Get the disk size for each database in PostgreSQL.
March 10, 2023
Include Schema in psycopg2 Connection String
#til#postgresql#psycopg2#sqlalchemy
Include schema in PostgreSQL connection string.
December 19, 2022
Create Automatic Timestamps in PostgreSQL
#til#postgresql#timestamp#function
Create automatic timestamps by default.
December 16, 2022
Using Rich Inspect to Interrogate Python Objects
Using Rich can help format an object in the REPL.
November 13, 2022