Published inAndroidPub·Sep 12, 2017How to use AsyncListUtilA tutorial for the Support Library’s AsyncListUtil, and how to correctly back your RecyclerView with data from a SQLite database. — RecyclerView is great, but when you need to provide hundreds or thousands of items to display using an Adapter you can quickly run out of memory. Last week, I gave a talk called “Get Creative to squeeze performance from SQLite” at Droidcon Berlin. In it, I suggested an approach to…Android8 min readAndroid8 min read
Aug 2, 2017Get an APK’s manifest versionName and versionCode using GradleI recently needed to create a gradle task which will archive release APK files, and rather than relying on the defaultConfig values in build.gradle to know what to call the archive file I thought it would be better to directly inspect the APK itself for the correct values. …Android2 min readAndroid2 min read
Jun 22, 2017Squeezing Performance from SQLite: Indexes? Indexes!Are your queries taking too long to run? In this episode of the series, I will explain how indexes work in SQLite, and how to design indexes that can take your most important queries to the next level of performance. Primary Keys, Query Planning, and Binary Search When you define a table in SQLite, you have the…Database8 min readDatabase8 min read
Published inHackerNoon.com·May 21, 2017Squeezing Performance from SQLite: Insertions (with Room)At I/O last week, Google announced a new tool called Room which makes working with SQLite databases a lot easier, but it begs the question: How well does it perform? This is a followup to my earlier insertions experimentation results. First we’ll look at some results from a couple of…Database6 min readDatabase6 min read
May 14, 2017Introducing: Android DebugPort 2.0A drop-in tool to connect to your app and execute both Java and SQL commands from the comfort of your computer’s terminal. Nowadays it’s fairly common for languages and platforms to provide a REPL (Read Eval Print Loop) to make it easy to execute arbitrary code from the command line…Android5 min readAndroid5 min read
Apr 23, 2017Squeezing Performance from SQLite: EXPLAINing the Virtual MachineThe virtual machine? Yep, but not the Java Virtual Machine. In this post I will focus on providing you with a basic understanding SQLite’s “Virtual DataBase Engine” or VDBE. My “Squeezing Performance from SQLite” series is primarily meant for Android engineers, but this post in particular will dive into SQLite…Sql12 min readSql12 min read
Apr 14, 2017Squeezing Performance from SQLite: InsertionsSometimes we need to manage a lot of data in our apps. What’s the fastest way to get all of that data into your Android app’s SQLite database? In this post I will investigate the the options available to you when it comes to inserting a ton of data into…Database8 min readDatabase8 min read
