Posts
All the articles I've posted.
-
Enhancing Performance with Indexing in SQLite
Updated: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.
-
Query nearest latitude and longitude from SQLite
Updated: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.
-
Deploy static website to Firebase using Gitlab CI
Updated:Writing a technical blog is one of the most important tasks for developers today, but it has never been easy to implement a low-cost and high-efficiency website for programmers who have less experience in front-end technologies.
-
Mock Data Strategies for Faster Android App Development
Updated:When developing Android applications that interact with backend services, developers often face challenges such as backend unavailability or incomplete APIs. Utilizing mock data and mock servers can significantly boost the development process.