Metis

Write

Better understanding of Postgres Vacuum

Jun 6, 20245 min read

Monitoring PostgreSQL Activity

Apr 29, 20247 min read

Warning: Transaction ID Wraparound Can Freeze Your PostgreSQL Server – Here's How to Prevent It

Halloween is near, but there's something scarier in your PostgreSQL server—Transaction ID wraparound.

Oct 13, 20243 min read

Running SQL Commands Directly from Jupyter: The Power of %%sql

Apr 28, 20243 min read

DB Tools - Azimutt is an Open Source DB Schema Tool

Apr 24, 20241 min read

Co-Pilot for DB-Ops: Using Vanna.ai (text2sql)

This is part of the blog series about building a Co-Pilot for DB Ops. The journey starts here. Thesis Fetching data from the system tables (performance schema) is basically a text2sql task. A good text2sql solution should be able to generate high qua...

Apr 23, 20244 min read

Co-Pilot for DB-Ops: Testing a local LLM using GPT4All

This is part of the blog series about building a Co-Pilot for DB Ops. The journey starts here. Thesis Running the co-pilot locally, on a local LLM solves a few problems: No cost. Send as many tokens as you want Secured: No need of any extra service...

Apr 15, 20242 min read

Co-Pilot for DB-Ops: Testing pg_vectorize and RAG

This is part of the blog series about building a Co-Pilot for DB Ops. The journey starts here. Thesis: The backed of the system can be Postgres. Extensions, such as pg_vectorize, can simplify adding new documents for the tests. Everything is done usi...

Apr 13, 20244 min read

Co-Pilot for DB Ops - First tests using ChatBase

This is part of the blog series about building a Co-Pilot for DB Ops. The journey starts here. Thesis: Sending detailed documentation of every column will ensure high quality SQL. Sending a long context, with detailed information about the schema of ...

Apr 12, 20242 min read

Co-Pilot for DB-Ops: What's wrong with OpenAI?

This is part of the blog series about building a Co-Pilot for DB Ops. The journey starts here. Testing GPT-3.5 as a Copilot: Navigating Uncharted Territory In software testing, we usually have clear plans for testing regular programs. But trying out ...

Apr 10, 20243 min read

Co-Pilot for DB Ops - User Stories and Personas

TLDR 🗺 In this series of posts I'll write about a long journey to build a Co-Pilot for DB Operations. In the first post I wrote about what is a Co-Pilot for DB Ops, the main motivation and the guidelines for building the tool. In this post I want...

Apr 8, 20244 min read

Command Palette

Latest articles