Archives
All the articles I've archived.
-
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.
-
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.
-
Deploy static website to Firebase using Gitlab CI
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.
-
Build iOS apps using Kotlin Multiplatform
In this topic, we will use SwiftUI and Kotlin to create a simple iOS application to demonstrate the power of KMM. It is a location-based weather app that can display the current weather conditions in the city.
-
Query nearest latitude and longitude from SQLite
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 with a large dataset of location records. We will see how to calculate the distance and find the closest bus stop to our location.
-
Manage multiple languages using Google Spreadsheets
Manage multiple languages in an Android project using Google Spreadsheets