from Hacker News

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

by marcobambini on 5/17/23, 2:03 PM with 6 comments

• by psanford on 5/17/23, 4:04 PM

  I'm a big fan of FTS5 as a cheap/easy way of adding full text search to datasets.

  Recently I'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.

  [0]: https://github.com/psanford/sqlite3vfshttp

• by meghan_rain on 5/17/23, 3:09 PM

  > sqlite cloud

  lmao

• by avinassh on 5/18/23, 4:48 AM

  so, why use SQLite in cloud? Why not Postgres or MySQL?