TIL
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