Skip to content

Archives

All the articles I've archived.

2024 2
July 1
  • 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.

June 1
  • 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.

2021 3
September 1
  • 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.

August 1
  • 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.

April 1
  • 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.

2017 1
August 1