This article details how to build a 100% local MCP (Model Context Protocol) client using LlamaIndex, Ollama, and LightningAI. It provides a code walkthrough and explanation of the process, including setting up an SQLite MCP server and a locally served LLM.
An article detailing Phoenix.new, Fly.io's AI-assisted app development platform built on Phoenix and Elixir. It explores the platform's capabilities, the author's experience building a notebook application with it, and its potential for expansion beyond Elixir.
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.
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.
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.
* **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.
* **Sentiment Analysis Example:**
+ Update a `sentiment` column in a `messages` table using `chatgpt()` function.
