This tutorial shows you how to use SQLite full-text search feature by using the FTS5 virtual table module.
SQLite Home Page
SQLite is a C-language library that implements a small, fast, self-contained, high-reliability, full-featured, SQL database engine. SQLite is the most used database engine in the world. SQLite is built into all mobile phones and most computers and comes bundled inside countless other applications that people use every day. More Information...
Deep Dive into ParadeDB's v2 API: The Future of SQL Search
Explore ParadeDB's v2 API that eliminates schema duplication, simplifies tokenization, and provides transparent search operators for intuitive SQL-based full-text search.
Command Line Shell For SQLite
The SQLite project provides a simple command-line program named sqlite3 (or sqlite3.exe on Windows) that allows the user to manually enter and execute SQL statements against an SQLite database or against a ZIP archive. This document provides a brief introduction on how to use the sqlite3 program.
SQLite: How it works, by Richard Hipp
ParadeDB — Search without a second system
One Postgres for your application data, full-text search, vector retrieval, and aggregations. Home of the pg_search extension.
🔎 atproto sqlite store - Google Search
🔎 sqlx base - Google Search
Introduction
A complete search engine and RAG pipeline in your browser, server or edge network with support for full-text, vector, and hybrid search in less than 2kb.
Whey‽ (@whey.party)
red dwarf now supports full text search using @mackuba.eu 's lycan https://tangled.org/@mackuba.eu/lycan
Results by region
Type a minimum of three characters then press UP or DOWN on the keyboard to navigate the autocompleted search results
Short 🧵 on bsky38.com 's stack! We use sqlite.
Bailey Townsend 🦀
Will probably do a thread on bsky38.com 's stack tonight. We tried our best to not rely too much on Bluesky's AppView by using things like typeahead.waow.tech, porxie, and slingshot. But it is a Bsky lexicon centric app so we used some since it was the easiest way to get likes