TE
TechEcho
Home24h TopNewestBestAskShowJobs
GitHubTwitter
Home

TechEcho

A tech news platform built with Next.js, providing global tech news and discussions.

GitHubTwitter

Home

HomeNewestBestAskShowJobs

Resources

HackerNews APIOriginal HackerNewsNext.js

© 2025 TechEcho. All rights reserved.

Real-Time Full-Text Site Search with SQLite FTS5 extension

54 pointsby marcobambiniabout 2 years ago

3 comments

psanfordabout 2 years ago
I&#x27;m a big fan of FTS5 as a cheap&#x2F;easy way of adding full text search to datasets.<p>Recently I&#x27;ve been storing these datasets in S3 and been querying them directly via a VFS[0]. Its a simple way to have FTS available to lambda functions without the cost of using an online database.<p>[0]: <a href="https:&#x2F;&#x2F;github.com&#x2F;psanford&#x2F;sqlite3vfshttp">https:&#x2F;&#x2F;github.com&#x2F;psanford&#x2F;sqlite3vfshttp</a>
评论 #35980047 未加载
meghan_rainabout 2 years ago
&gt; sqlite cloud<p>lmao
评论 #35976732 未加载
avinasshabout 2 years ago
so, why use SQLite in cloud? Why not Postgres or MySQL?