It comes preloaded on Mac OSX and is available for all other major OSes. For that reason I tend to stick to the sqlite3 command line tool. My weapon of choice is generally the command line. First we’ll need a tool to actually interact with a SQLite database… In order to make this a little less painful of an experience, let’s take a look at a very simple way to inspect SQLite databases, and where we can find those databases on various mobile platforms. What records are present on the tables? This is critical in determining if you model layer is working as expected.What is the structure of the tables? Primary keys?.What tables are created on those databases?.What SQLite database files are installed?.There’s some common things it would be great to know quickly about your deployed databases, like: Jump to: sqlite3 command | Android | iOS | SQLite database inspection This is especially true when developing for multiple platforms and having gone through multiple iterations of your data structure. Unfortunately, the current data and structure of SQLite databases can sometimes be tricky to ascertain when housed on mobile devices, emulators, and simulators. SQLite is a powerful and relatively simple way to store data for offline use, or just to cache remote data to speed up interactions. One aspect of my current project, the Alloy MVC framework for building cross-platform mobile apps, is simple integration with local storage via SQLite databases.

Sqlite editor android