This tutorial shows you how to use SQLite full-text search feature by using the FTS5 virtual table module.
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
Bluesky Advanced Search
A simple tool to search Bluesky posts, users, and tags. Just type what you need, and it'll open a new tab with the required specific search formats.
SQLite for Everything | JoeCode
Code with distinct characteristics traceable to its author.
Here's how we leverage @semble.so's wonderful service in search results 👀. This is currently the only working search integration but 20+ more are in the works right now!
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
