note

RAG Search to 0.1ms: Ultra-High-Speed Design with ChromaDB + SQLite FTS5 Dual Indexing

While building and operating the AI automation system 'PrimeQUADRAFLOW (PQF)' on my own, I am constantly pushing the limits of performance. In particular, information retrieval speed in Retrieval ...
note

Turn Order CSVs into a Database! The Complete SQLite & Python Template

I have covered these points so far. This time, we finally move on to the practical application. First, create a dictionary to map the Japanese CSV column names to English. (You can keep adding to this ...
GitHub

A Python-powered CLI tool for creating, managing, and optimizing SQLite databases for local development projects.

sqlite-db-manager is a robust command-line interface (CLI) application designed to streamline the creation, management, and optimization of SQLite databases. It is tailored for local development ...
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 ...
GitHub

Track changes to SQLite tables using triggers

This library can be used to configure triggers on a SQLite database such that any inserts, updates or deletes against a table will have their changes recorded in a ...
Android Authority

Using a simple SQLite database in your Android app

I recently published a tutorial describing the different available methods to store data locally in an Android app. However, due to article length constraints, I could not adequately cover creating ...