GitHub Workflow Tips
GitHub Workflow notes for cleaning up disk space of and installing PostgreSQL to the runner.
Embedding Vector Search w/ Django & PostgreSQL, Part 2
Data Model for Embedding Typically, a model is used whose record includes: the text being embedded the embedding (vector of floats) However, RDBMSes have strict and relatively static schemas that…
Embedding Vector Search w/ Django & PostgreSQL, Part 1
Sigh. 🙄 Yes--yet another "AI" article in a blog. The pgvector extension allows PostgreSQL to support vector searches. This ability is useful for implementing RAG solutions. The link has all…
PostgreSQL Pager OFF
This is a useful but difficult-to-remember command for PSQL: \pset pager off Or, if the invocation of psql is within control, add the -P pager=off argument: psql -P pager=off ...…
Postgresql and Mysql Docker containers
To quickly get an instance of PostgreSQL and MySQL up and running, use the following docker-compose setup: Create a subdirectory to place the docker-compose.yml and optionally the data files for…
Django Dev Env w/ Docker Compose
A few years back I ran into a problem when working with Django on Windows while my colleagues were on Mac OS where a datetime routine (forgot which one) behaved…
Rails w/ MySQL (Windows 7-64)
Mainly notes on setting up the following (suitable for Dreamhost's Rails setup): Ruby 1.8.7-p374 Rails 3.0.3 Ruby devkit  (from http://rubyinstaller.org/downloads/) MySQL Installer 5.6.17 Community Server 64-bit mysql2 GEM '0.2.22' Install Ruby 1.8.7 by…