In this article, we will explore how indexing works in SQLite, differentiate the performance when applying indexing, and experiment with scenarios where it may break the utilization of the index.

Searching for nearby locations is one of the most popular features we see in every app. In this topic, we will see how to implement a SQL query with a large dataset of location records. We will see how to calculate the distance and find the closest bus stop to our location.