How to build a local retrieval-augmented generation application using Postgres, the pgvector extension, Ollama, and the Llama 3 large language model.

As you might recall from a previous episode, I'm trying to create a database for the circuit records at my office. I have imported all the equipment id's/locations/etc into 8 tables (one table for ...

I still use MySQL for a variety of tasks and expect to continue doing so, but, increasingly, I find that PostgreSQL is a better fit for my needs. This month, we will look at PostgreSQL, starting with ...

More options for distributed partitioned tables Citus 13 provides three new options specifically for working with distributed partitioned tables. Firstly, users can now use CREATE TABLE ...

Tom demos table joins, shell scripts for repetitive tasks and using "exec" to run commands inside a container from the host system. In my previous article on running applications on Docker, I deployed ...