SQLite Foray

In getting started with using Android and local storage, the simplest and most recommended approach is to use the SQLite database. This is the same technology used for HTML5 local storage and has been around for quite awhile.

I was curious about the performance, so I ran a simple test: Query 280k text records (inserted via alphabetical order).

Before I get to the results, here is a tool to avoid that I used: SQLite Database Browser. The reasons are simple:

1. It freezes on you if the syntax is invalid.
2. Importing 260k+ records was going to take over an hour (compared to less than 5 seconds with the tool I ended up with)

The best tool I was able to find, which is also free, is SQLite Studio. The website looks a bit sketch. Maybe that's how they roll in Poland, or maybe after they steal my credit card information by installing a keyboard sniffer, they'll be able to give it a facelift.