In which I show how ElasticSearch, Solr or another search specific database is probably unnecessary for a lot of PostgreSQL users.
@vampatori@feddit.uk
link
fedilink
English
21Y

This is a truly excellent pair of articles, brilliantly written.

Explains the problem, show the solution iterating step by step so we start to build an intuition about it, and goes as far as most people actually need for their applications.

Very well written article. I’d like some performance comparison aswell, because ElasticSearch can already do less than 20ms on a 100k documents, with each having more than 10 queries fields.

Of course, for simple sites, this is great!

@troye888@lemmy.one
link
fedilink
English
21Y

The second part has some of this, but not as in depth as i’d like.

@Hazzard@lemm.ee
link
fedilink
English
11Y

Eh, I’d assume the comparison isn’t flattering. I think the point of this article is to argue you don’t need ElasticSearch to implement a competent Full Text Search for most applications. Splitting hairs over a few milliseconds would just distract from that point, when most applications should be prioritizing simplicity and maintainability over such tiny gains in a reasonable dataset.

Might be interesting to try to analyze at exactly what point elasticsearch becomes significantly useful, however. Maybe at the point where it saves a full tenth of a second? Or where it’s returning in half the time? Could be an interesting follow up article.

Create a post

Welcome to the main community in programming.dev! Feel free to post anything relating to programming here!

Cross posting is strongly encouraged in the instance. If you feel your post or another person’s post makes sense in another community cross post into it.

Hope you enjoy the instance!

Rules

Rules

  • Follow the programming.dev instance rules
  • Keep content related to programming in some way
  • If you’re posting long videos try to add in some form of tldr for those who don’t want to watch videos

Wormhole

Follow the wormhole through a path of communities !webdev@programming.dev



  • 1 user online
  • 1 user / day
  • 1 user / week
  • 1 user / month
  • 1.11K users / 6 months
  • 1 subscriber
  • 1.21K Posts
  • 17.8K Comments
  • Modlog