elabx Posted February 10, 2023 Share Posted February 10, 2023 I have found that SQLite has full text search and it is quite fast! I built a couple million rows table and i'm very impressed!! Has anyone had any experience implementing this either in ProcessWire or in another context? Link to comment Share on other sites More sharing options...
LostKobrakai Posted February 10, 2023 Share Posted February 10, 2023 I've been working with sqlite on an embedded project for the last few years, though not using the FTS. It's generally faster than client/server databases just by the nature of its implementation. It also hardly suffers from N+1 queries and other common pitfalls. It would certainly be interesting to see how it could work beneight processwire, but really sqlite is a different beast with a lot of different tradeoffs to other databases, even if many people (looking at laravel or rails using sqlite for tests) think switching databases doesn't come with costs. 1 Link to comment Share on other sites More sharing options...
elabx Posted February 10, 2023 Author Share Posted February 10, 2023 3 hours ago, LostKobrakai said: It would certainly be interesting to see how it could work beneight processwire I can at least envision a module filling up a full text search table on a page save hook! Could be pretty useful to have at hand if budget doesn't cover an ElasticSearch/Lucene/Meiliseach instance. Which is my current scenario lol Link to comment Share on other sites More sharing options...
Pixrael Posted June 17 Share Posted June 17 tursodatabase/turso-client-php: Turso - libSQL client libraries and utilities for PHP (github.com) 2 Link to comment Share on other sites More sharing options...
Recommended Posts