I think a great (open source) full stack startup I go back and reference often is dub. Dub's a linkshortner.

And you can go dig deeper into their code in terms of how they implement indexing.

However, one thing I found at an immediate glance is indexing in it's core is handled in the middleware for next projects at least.