Posts

LLMs and evals

Cursor IDE rules for various languages and tasks

Delete all folders within a directory while excluding certain filters

Handling deprecation warnings in python

Python libraries for convex optimisation and portfolio optimisation

Single LLM-prompt for API discovery for use by actions / agents

LLM leaderboard and evaluations

FastAPI to include servers when generating OpenAPI spec

How to normalise a deeply nested JSON-like object with pandas

GPT actions, actions library, sql database connections

Fuzzy search in vscode

Caplog to capture logging outputs in pytest

Insert / upsert sql example persist strategy

Data engineering in python

RSS parsing in python

GitHub Models and other LLM inference services

Server login accounts vs user accounts

Check which drivers are installed on RHEL server

Compiling sqlite-vec

Using pywin32 to query Outlook and extract email metadata and attachments

Python tools for packaging and distribution

Bulk insert / update / upsert in SQLAlchemy

Dagster Deep Dive on Data quality

Slow Changing Data types

Local drives, network drives, and ssh / file clients for servers

Stale file handles for mounted drives on Linux

Local LLM

Portecle, DER and PEM files, and PEM encodings for private key files

Using Ollama to run Llama3.1

Fixture set up and tear down in pytest

Script to unmount drives

Overview of new security features in ChatGPT Enterprise

Utility script to create schema

Convert code repo to LLM prompt

SSH tunneling in Clojure REPL

Pandas and Polars using PyArrow backend

How to change username password on linux

AI links for routing, multiple data sources, agents, model selection

LLMs for structured output

Shiny for Python

GPTs for financial statement analysis

Database columns that serve as helpful metadata fields

Visualise SEC 13F filings

Building CLIs with argparser

The difference between stored procedures and SQL views

Using espanso as a global text editor

Application of Gradient Boosted Decision Trees in Time-Series Analysis

Usage of ML models in financial time series prediction

Weekly report of the work done by Infra team at Fly.io

A collection of essays on technology and work

Minimalist example of using HTTPX library for both sync and async requests

Pytest incremental checker

Cache clear

The difference between directory / distribution / package names in python packaging

A git workflow to reset branch and commit correctly

Python protocols

Repository Pattern, Unit of Work Pattern, Dependency Injection

Why "prefer composition over inheritance"?

Example launch.json file for VSCode

Macquarie Research Equities, The A-Z of Quant

Resources on GenAI

AI-generated artwork winning art festival award

Common Crawl web data

Dagster and Databricks integration

Explicit dependency sources in Poetry

Getting started with Rust

Python and Rust compilation, packages, bindings

The issue with pie charts, and other visualiation tricks

Python extensions and distributing python packages with pinned dependencies

Built distributions vs building wheels

Python library to validate API services and resources

Longest study on happiness

Ansible playbooks, roles with default / override values

Determine the file storage of each sub-directory in a directory

Working with ansible vault

Portfolio optimisation inputs

Updating fine grained tokens on github

Llamafile

Designing pythonic APIs

Creatine and cognition

GitHub Actions does not support python 3.6 on ubuntu-22.06 (ubuntu-latest)

Contex windows using LanceDB

Function calling as the forth role in GPT models

How much content should be contained within an embedding?

Markdown parsing libraries in python

Nexus URLs for installing and pushing packages, using it with pip

Refugees by Brian Bilston

Consolidation of model architecture

Python as C++'s limiting case

Adding shortcuts for snippets in VSCode

Foundations of deep learning

Chain of density prompting for LLM summarisation

Image embeddings

Multi-prompt chains with LangChain

Search algorithms when using vector databases

Working with cronjobs and kerberos tickets

Tesla Valuation

Parse, validate and reformat standard numbers in Python

Download Audio and Subtitle Files from YouTube

ZAR/USD Calendar Year Moves

Run Dagit UI in Debug Mode on VSCode

Troubleshooting VSCode Remote Extension

Git reset for cleaner commit message

Alembic type conversions and table alter instructions

PEPs on python typing, forward references, postponed evaluation of annotations

Relevant PEPs related to python packaging

Cartesian product of a dataframe and a list

Problem with mypy not type checking overload functions correctly due to missed signatures

Datetime arithmetic logic

First use-case of the walrus operator

Restore local branch that has been deleted

Typing second-order decorators that may be called with and without arguments

Python underscore naming conventions

Testing Azure Blob storage with Azurite

Decrease coupling in Python code

Interactive rebase in VScode with GitLens

Undo most recent commit both locally and remotely

General thoughts on essays by Vitalik about Ethereum and blockchain

Changing the default response class of FastAPI

Pip clear cache

Install packages from trusted host and with default timeout

Object References and Argument Parsing

Storing objects in the application instance

Pivot and convert rows to columns in pandas groupby

Render child elements inside component

Create df with specified columns

MSSQL Optimisation

Testing middleware and async function

Data structures to represent data in Python

Handling exception chaining and raising from context

How does installing from a git branch or tag effect python package resolution?

Use for loops inside f strings

Create clustered index

Convert SQLAlchemy core statement into raw SQL string

Create a simple class to expose dictionary keys with dot notation

Conditional files and directories with cookiecutter

Send data to debug console instead of REPL in python vscode

Add global exception handlers to FastAPI app

Working with tracebacks in python

Adding an on_event middleware to FastAPI to check server resources

Difference between the json and data parameter in python requests library post call

Pandas Date Offsets and Frequencies

Handling endpoints / requests with interesting parameter combinations

SQL query to return first row from groupby query

Black excludes files in gitignore

Determine Version of Powershell

Introduction to GraphQL

Checkout tag, cherry pick commits, create new release

VSCode debugger error when running debugger with justmycode set to false

Pythonic enums with better string support

Clearing cached folders of VSCode

Pytest exit codes and how to suppress them in Jenkins

Python function syntax and argument parsing

Env Variables using Powershell

Handling Environment Variables in VSCode

Source Distributions vs Binary Distributions

Set script execution policy in Powershell

Understanding different naming conventions in python packaging

Function Syntax and the Python Grammar

Python Package Index Old API Old vs New API

Useful Git Commands

Configure iPython with Rich for Pretty REPL Formatting

Git show all differences between current branch and default branch

SQLAlchemy Flushing vs Committing

Use python to clean up cached pytest and executable files

Use Sqlite Database Browser to view local db files

Adding Rich tracebacks to Python shell output

Ignoring Revisions with Git Blame

Python keyword-only and position-only arguments

SQLAlchemy and Alembic Troubleshooting

Delete remote git branches

Install and configure python linters in vscode

Determine the local Python directory of an OS machine

Add example for enum in FastAPI query parameters

WSGI and ASGI

SQL queries to select first or last set of rows

Export github tag version to env variable within github action

GitHub Action to trigger workflow on label change

47% mechanical keyboard

Configuration to enforce python virtual environment's

Optional Parameters and Mutability

Checkout old git revision and then jump back to current revision

Get current git revision hash

Clear Poetry local cache

Debug code in external libraries with VSCode

Render diffs in GitHub-flavoured markdown

Set environment variable for Windows

Dependency specification when packaging

Select duplicates from postgres table

Setting python interpreter / environment in VSCode

Version specifiers for Python dependencies in a requirements file

Installing node and yarn

Cache python environment in GitHub Actions

Create snippets in VSCode

Install poetry venv with specific version of python

VSCode launch script configuration

Deploying a Droplet with DigitalOcean

Bored Ape Yacht Club

Structural Subtyping with Python Protocols

The State Machine

Structural Subtyping with Python Protocols

Configuring an SSH Key Between a Client and Server

Working with Instance, Class and Static Methods

Enforcing Abstract Class Variables in Python

Setting up a Mac for Development

Configuring Environment Variables with Starlette

Parsing Data with Pydantic

A Graceful Guide to Git

Implementing an Interface for Non-Fungible Tokens

Statistical Data Testing with Pandera

Choosing the Structure of a Python Package

Configuring Git Hooks with Pre-Commit

Installing Private GitHub Dependencies in Workflows

Bootstrapping Development with Poetry