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 ...
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 ...
Hacker

A Closer Look at the Top 3 Embedded Databases: SQLite, RocksDB, and DuckDB

A seasoned software engineer with extensive experience in building complex distributed data-intensive backend services. In the vast expanse of the digital realm, data is the lifeblood that sustains, ...