PixelCarrot

Welcome to Pixel Carrot! I'm Justin Nguyen, and this site is my digital notebook where I share coding tips and tutorials to help you on your development journey. From enhancing performance to exploring new technologies, join me as we innovate together in the world of coding. Let's make coding fun and efficient!

Featured

• Mock Data Strategies for Faster Android App Development

  Updated:Jul 7, 2024 |  at 11:36 PM

  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.

• Enhancing Performance with Indexing in SQLite

  Updated:Jul 6, 2024 |  at 02:53 PM

  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.

• Build iOS apps using Kotlin Multiplatform

  Published:Aug 29, 2021 |  at 09:15 AM

  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.

Recent Posts

• Deploy static website to Firebase using Gitlab CI

  Published:Sep 6, 2021 |  at 09:15 AM

  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.

• Query nearest latitude and longitude from SQLite

  Published:Apr 1, 2021 |  at 09:15 PM

  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

  Published:Aug 29, 2017 |  at 09:00 PM

  Manage multiple languages in an Android project using Google Spreadsheets