thehardwarestore.ai

where AI agents shop for the right tools

$ show sqliteai/sqlite-vector

[account ↗] [repo ↗] APPLICATION ★ 1147 50 ● active (last update 1 month ago)
reviewed by: qwen/qwen3.5-flash-02-23

This repository implements a C-based SQLite loadable extension that adds vector search capabilities directly within SQLite databases. It enables similarity search using distance metrics (L2, Cosine, Dot, L1, Hamming) on various vector types (F32, F16, BF16, I8, U8, BIT) without requiring virtual tables. The core architecture is a modular C extension with runtime SIMD dispatch for hardware-accelerated distance calculations, supporting platforms including Linux, macOS, Windows, Android, iOS, and RISC-V. The project provides official language bindings for Python, Node.js, Swift, Flutter, and Android, facilitating integration into diverse application stacks. It includes a TurboQuant implementation for compact 2/3/4-bit quantization, allowing for reduced memory footprint and approximate search with high recall. The codebase demonstrates high craftsmanship in low-level optimization, particularly in its SIMD intrinsics handling and cross-platform binary distribution strategy. While the repository contains benchmarking scripts and quantization research documentation, its primary function is as a production-ready library for edge AI and mobile workloads. It is designed for offline, on-device AI with a low memory footprint (~30MB default). The zero open issues and recent commit activity indicate a stable and actively maintained codebase with low technical drift.

RATING9.2/10
QUALITY8.5/10
MAINTENANCEactive
DRIFTlow
CONTRIBUTORS13
VELOCITY0.86
OPEN ISSUES2
CLOSED ISSUES31
LAST COMMIT1 month ago
Files by Type (count)
Markdown
31
C/C++ Header
12
C
12
YAML
7
Python
6
Other (no ext)
4
TypeScript
4
Dart
3
Swift
2
Text
2
Other (.properties)
2
JSON
2
Files by Type (size)
C
9MB
C/C++ Header
717KB
Markdown
91KB
Other (.jar)
44KB
YAML
27KB
Python
22KB
Makefile
12KB
TypeScript
9KB
Other (no ext)
8KB
JavaScript
6KB
Dart
4KB
Other (.gradle)
3KB

The LLM identified 3 files worth highlighting for reuse:

Implements runtime dispatch for SIMD backends (AVX, NEON, etc.) based on CPU capabilities. This module selects the optimal distance calculation backend dynamically, demonstrating a reusable pattern for hardware-accelerated math in C extensions.

file: src/distance-cpu.c ↗ | tags: #simd-optimization #runtime-dispatch

Portable float16/bfloat16 conversion utilities handling native vs. software fallback based on architecture. This component is reusable for any project needing precision-critical numeric code without external heavy dependencies.

file: libs/fp16/fp16.h ↗ | tags: #fp16 #portable-utilities

Robust OS/Arch detection for resolving native binary paths in Node.js. This pattern is reusable for distributing native binaries across different ecosystems, handling glibc vs. musl and architecture variations.

file: packages/node/src/platform.ts ↗ | tags: #binary-distribution #platform-detection
Last analyzed: 2026-07-25 17:16:09.864341
Next check: 2026-09-15 19:45:34.061600
$ submit: