Posts
All the articles I've posted.
-
Tuva column extensions: carry a custom column from eligibility to core
How to carry a custom column like contract_type from Tuva's eligibility input layer to core__eligibility using x_ extension columns, without forking.
-
Extracting the last part of a string after a delimiter in SQL Server
· UpdatedGet the text after the last underscore in SQL Server with REVERSE + CHARINDEX, RIGHT or PARSENAME, and avoid the off-by-position and no-delimiter errors.
-
Python datetimes: naive vs aware, date parts, next day and total_seconds
· UpdatedFix 'can't compare offset-naive and offset-aware datetimes', split YYYYMMDD into year/month/day, add a day with timedelta, and why .seconds isn't total_seconds().
-
Python logging: levels, file output, and separate console and file handlers
· UpdatedReplace print() with Python's logging module: levels, basicConfig to a file, and a named logger with DEBUG to file and INFO+ to console (yfinance example).
-
Selecting, dropping and inserting rows in a pandas DataFrame
· UpdatedFilter pandas rows with boolean masks and str.startswith, drop rows by value, reset the index, and add rows with loc or concat now that append() is gone.
-
Retries in Python: from a basic retry loop to exponential backoff for API rate limits
· UpdatedRetry in Python from a basic try/except loop to production: Retry-After, exponential backoff with full jitter, idempotency, urllib3 Retry and tenacity.
-
Selenium vs Beautiful Soup: when to use each, and how to combine them
· UpdatedSelenium drives a browser for JavaScript pages and form clicks; Beautiful Soup parses HTML you already fetched. Selenium 4 examples and a combined workflow.
-
Soda Core with SQL Server: connection, Windows auth, SSL errors and checks
· UpdatedConnect Soda Core to SQL Server: ODBC driver, SQL login or Windows auth, fixing SSL: CERTIFICATE_VERIFY_FAILED, and count-distinct checks in SodaCL.