4 ms·
So I'm actually doing this right now, I write about it on my blog. None of the apps I've written have hitten any kind of crazy traffic peak, so I started wonde
by hardwaresofton 9y ago
So I'm actually doing this right now, I write about it on my blog.
None of the apps I've written have hitten any kind of crazy traffic peak, so I started wondering why the hell I was using postgres or other database types after reading https://www.sqlite.org/whentouse.html https://www.sqlite.org/whentouse.html.
Seeing how simple SQLite has been for me to use has inspired me to write a bunch of dead-simple good-enough approximations for other tools that exist. High up on my list is a Graylog competitor that just uses SQLITE FTS (https://sqlite.org/fts3.html/https://sqlite.org/fts5.html https://sqlite.org/fts3.html/https://sqlite.org/fts5.html), that just is super easy to start and handles that micro-to-mid-size case before you really need something like graylog or ELK.
Blog post if anyone's interested:
https://vadosware.io/post/adding-sqlite-powered-fts-search-to-a-servant-powered-haskell-app/ https://vadosware.io/post/adding-sqlite-powered-fts-search-t...
- xellisx 9y agoHow does SQLite FTS compare to things like Sphinx and Elastic Search?
- hardwaresofton 9y agoProbably not well, in the long run? FTS is just a plugin to SQLite where as Sphinx and ES are purpose-built software. It all comes down to what your actual need is though. I think for most smal projects SQLite + FTS offers a pretty simple easy to setup solution that doesn't require much compute power, either. The simplicity is also a bonus.
- the_duke 9y agoFTFY: https://sqlite.org/fts5.html https://sqlite.org/fts5.html
- hardwaresofton 9y agoUnfortunately I can't edit the comment anymore, but I meant to put both links there, and made the sily mistake of putting a "/" between them...