SemanticScuttle - klotz.me

Tags: llm* + sqlite*

0 bookmark(s) - Sort by: Date ↓ / Title /

1. How I Made a Useful AI Assistant with One SQLite Table and a Handful of Cron Jobs

   This article details the creation of 'Stevens', a personal AI assistant built using a single SQLite table to store 'memories' and cron jobs to ingest data and generate daily briefs. It emphasizes a simple architecture leveraging Val.town for hosting and highlights the benefits of broader context for personal AI tools.

   2025-04-17 Tags: assistant, sqlite, cron, llm, val.town, rag, agent by klotz
2. SQLite RAG Tutorial

   A simple project demonstrating Retrieval Augmented Generation (RAG) using SQLite, sqlite-vec, and OpenAI. It embeds text files, stores them in a SQLite database, and retrieves relevant documents using vector search. The project features lightweight single-file SQLite databases, vector search capabilities, and OpenAI integration for embeddings and chat responses.

   2025-02-20 Tags: sqlite, rag, sqlite-vec, vector search, embeddings, llm, github, edizaguirre by klotz
3. Ask questions of SQLite databases and CSV/JSON files in your terminal

   A new plugin for sqlite-utils CLI tool called sqlite-utils-ask allows users to ask human-language questions directly of SQLite databases and CSV/JSON files, using an LLM to generate SQL queries and execute them.

   2024-11-25 Tags: sqlite, sqlite-utils, llm, ai, sql, terminal, csv, json by klotz
4. Enriching data with GPT3.5 and SQLite SQL functions

   • New Feature: openai-to-sqlite tool now allows enriching data in a SQLite database using OpenAI's GPT3.5 model.
   • Sentiment Analysis Example:

   • Update a sentiment column in a messages table using chatgpt() function.

   2024-10-29 Tags: llm, cli, simon willison, foss, chatgpt, sqlite by klotz

Top of the page

First / Previous / Next / Last / Page 1 of 0