[PR #1241] [MERGED] Add new SQLite FTS5 full-text search backend #1361

New issue

Closed

opened 2026-03-01 14:49:28 +03:00 by kerem · 0 comments

kerem commented

2026-03-01 14:49:28 +03:00

Owner

📋 Pull Request Information

Original PR: https://github.com/ArchiveBox/ArchiveBox/pull/1241
Author: @overhacked
Created: 10/9/2023
Status: ✅ Merged
Merged: 10/31/2023
Merged by: @pirate

Base: dev ← Head: fts5-search

📝 Commits (7)

c53ec45 WIP: add sqlite search backend boilerplate
8fe5faf Introduce SQLite FTS5-powered search backend
e0f8eee Improve search.backends.sqlite retry logic
adb9f0e sqlite search: Rename connection to get_connection
1e604a1 sqlite search: clean up errors and type-checking
9b85f35 sqlite search: check SQLite version when indexing
53355be Merge branch 'dev' into fts5-search

📊 Changes

2 files changed (+201 additions, -0 deletions)

View changed files

📝 archivebox/config.py (+6 -0)
➕ archivebox/search/backends/sqlite.py (+195 -0)

📄 Description

WIP: add sqlite search backend boilerplate
Introduce SQLite FTS5-powered search backend

_{🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.}

## 📋 Pull Request Information **Original PR:** https://github.com/ArchiveBox/ArchiveBox/pull/1241 **Author:** [@overhacked](https://github.com/overhacked) **Created:** 10/9/2023 **Status:** ✅ Merged **Merged:** 10/31/2023 **Merged by:** [@pirate](https://github.com/pirate) **Base:** `dev` ← **Head:** `fts5-search` --- ### 📝 Commits (7) - [`c53ec45`](https://github.com/ArchiveBox/ArchiveBox/commit/c53ec45a296b264ca4d0a1301f33b580e88b4c3f) WIP: add sqlite search backend boilerplate - [`8fe5faf`](https://github.com/ArchiveBox/ArchiveBox/commit/8fe5faf4d062da9de8c0d4f9261287b691bc3193) Introduce SQLite FTS5-powered search backend - [`e0f8eee`](https://github.com/ArchiveBox/ArchiveBox/commit/e0f8eeeaa77b581756d32f6525374695610d3c37) Improve search.backends.sqlite retry logic - [`adb9f0e`](https://github.com/ArchiveBox/ArchiveBox/commit/adb9f0ecc9f0f8edee49ccfb2c3f966367c2bce3) sqlite search: Rename `connection` to `get_connection` - [`1e604a1`](https://github.com/ArchiveBox/ArchiveBox/commit/1e604a1352cfd838d2b7504dad3d92fd3c79e3d3) sqlite search: clean up errors and type-checking - [`9b85f35`](https://github.com/ArchiveBox/ArchiveBox/commit/9b85f35b63c874fcc738aed1966490f397adaf0b) sqlite search: check SQLite version when indexing - [`53355be`](https://github.com/ArchiveBox/ArchiveBox/commit/53355be46a47f2c25e7873caa17ded1d0ae8771b) Merge branch 'dev' into fts5-search ### 📊 Changes **2 files changed** (+201 additions, -0 deletions) <details> <summary>View changed files</summary> 📝 `archivebox/config.py` (+6 -0) ➕ `archivebox/search/backends/sqlite.py` (+195 -0) </details> ### 📄 Description - WIP: add sqlite search backend boilerplate - Introduce SQLite FTS5-powered search backend --- <sub>🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.</sub>