Early Access Program

IntelliJ IDEA 13 EAP and Android SQLite Database

Great news for everyone waiting for more new features from the upcoming IntelliJ IDEA 13. Today we have rolled out IntelliJ IDEA 132.556, one more preview build with a number of bugfixes and new features.

One of the most important changes in the build is the long-awaited (by many Android developers) support for Android SQLite database. With the latest build you can explore and change device-embedded database directly from the IDE. 

Before you try it make sure that Database Support plugin is enabled. Then open Database tool window, click New button and choose Android SQLite Data Source.

You’ll see the following dialog:

The IDE automatically detects all databases available on the selected device for specified package. After you chose a database and pressed OK, the IDE will configure a data source. After that you’re able to browse the tables and edit its data using the database tools integrated into the IDE:

If you choose a data source in the tool window and press Synchronize, the IDE will check if the remote database has been changed and will download the changes from the device or emulator. Vice versa if you changed something locally, you can upload the changes to the device by pressing Upload from the popup menu.

A few notes on the new functionality:

  • It works only with devices and emulators based on Android 2.2 or higher.
  • It works with not-rooted devices too.
  • Installed application has to be built as debuggable. The IDE builds it in this way by default when you launch your app using run configuration. Accessing databases from production builds is not supported.
  • It works in IntelliJ IDEA Ultimate Edition only, since all database tools depend on Database Support plugin.

Find the full list of changes in Release Notes.

Feel free to share your feedback on our discussion forum and submit bug reports to the issue tracker.

Develop with Pleasure!

image description