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…
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…
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 ...…
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…
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…