note

Dual Index Design with ChromaDB and FTS5 That Dramatically Improved RAG Search for App16 Plant Guardian

"I wish RAG search could be a little faster..." We've all had that feeling, haven't we? Especially when dealing with a large volume of documents, the response speed starts to become a concern. Vector ...
note

Chapter 8 [Development Log]: Saving MCP Server Execution Logs to SQLite for Later Review

If you haven't seen the previous article, check it out here. Chapter 7 [Development Log]: Installing Claude Code and Using It to Read and Fix My Own Code Without 'Just Dumping It' Up to Chapter 7, we ...
GitHub

techouse/sqlite3-to-mysql

A Python CLI for transferring SQLite 3 schema and data to MySQL or MariaDB. sqlite3mysql reads the source schema from SQLite, creates equivalent MySQL/MariaDB tables, indexes, foreign keys, and views ...
GitHub

dbt-duckdb

DuckDB is an embedded database, similar to SQLite, but designed for OLAP-style analytics. It is crazy fast and allows you to read and write data stored in CSV, JSON, and Parquet files directly, ...
InfoWorld

Using PostgreSQL as a vector database in RAG

PostgreSQL with the pgvector extension allows tables to be used as storage for vectors, each of which is saved as a row. It also allows any number of metadata columns to be added. In an enterprise ...