Open in app

Sign in

Write

Sign in

Jason Feinstein
Jason Feinstein

565 Followers

Home

About

Published in

AndroidPub

·Sep 12, 2017

How to use AsyncListUtil

A 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…

Android

8 min read

How to use AsyncListUtil
How to use AsyncListUtil
Android

8 min read


Aug 2, 2017

Get an APK’s manifest versionName and versionCode using Gradle

I 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. …

Android

2 min read

Android

2 min read


Jun 22, 2017

Squeezing 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…

Database

8 min read

Squeezing Performance from SQLite: Indexes? Indexes!
Squeezing Performance from SQLite: Indexes? Indexes!
Database

8 min read


Published in

HackerNoon.com

·May 21, 2017

Squeezing 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…

Database

6 min read

Squeezing Performance from SQLite: Insertions (with Room)
Squeezing Performance from SQLite: Insertions (with Room)
Database

6 min read


May 14, 2017

Introducing: Android DebugPort 2.0

A 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…

Android

5 min read

Introducing: Android DebugPort 2.0
Introducing: Android DebugPort 2.0
Android

5 min read


Apr 23, 2017

Squeezing Performance from SQLite: EXPLAINing the Virtual Machine

The 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…

Sql

12 min read

Squeezing Performance from SQLite: EXPLAINing the Virtual Machine
Squeezing Performance from SQLite: EXPLAINing the Virtual Machine
Sql

12 min read


Apr 14, 2017

Squeezing Performance from SQLite: Insertions

Sometimes 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…

Database

8 min read

Squeezing Performance from SQLite: Insertions
Squeezing Performance from SQLite: Insertions
Database

8 min read

Jason Feinstein

Jason Feinstein

565 Followers

Software Engineer at Google. You can find my stuff on GitHub at https://github.com/jasonwyatt

Following
  • Denilson Nastacio

    Denilson Nastacio

  • Scott Klein

    Scott Klein

  • Chet Haase

    Chet Haase

  • Pujie

    Pujie

  • Alex Golec

    Alex Golec

See all (122)

Help

Status

About

Careers

Blog

Privacy

Terms

Text to speech

Teams