Apr 12, 2018
First-class SQLite support for Android Studio and IntelliJ IDEA.
View, manage and update SQLite databases in your Android device (
in real time) and file system, from Android Studio and IntelliJ IDEA.
Recent change notes
- When creating a "Live Device" connection, now SQLScout checks whether the current selected build variant has SQLScout's server declared as dependency.
- Removed check where Android applications need to be launched from the IDE before connecting to a database.
- Local data sources are now automatically removed if the database files they point to no longer exist.
- Added additional logging to troubleshoot issues with Samsung devices.
- Updated Xerial JDBC driver to version 3.21.01.
- Support for Android Studio 3.1.
- Room Migration:
- Added support for nullability when generating Entity classes from a database schema:
- Kotlin: field types are marked as nullable (using the
- Java: getters and setter-parameters are annotated with
@Nullable (from the package
- Generated code is automatically formatted.
- SQL editor:
- Added support for compound queries using the
EXCEPT operators. Support includes parsing, syntax highlighting and code completion.
- Fixed parsing and syntax highlighting of block comments.
- Added support for connecting to databases by opening database files (with extensions ".db" and ".sqlite") from the file system or Android Studio's Device Explorer view.
- Support for database views.
- Ability to save BLOBs as local files.
- "File saved" notifications (SQL files, diagrams and BLOBs) now include a link to reveal the saved file in the system's file manager.
- Support for SQLScout Server 4.0.0, which replaces XML with FlatBuffers for client/server communication in "Live Device" connections. This change fixes several bugs related to String encodings, invalid XML characters present in database columns, and BLOB handling.
- Added support for automatically adding SQLScout Server and the IDEScout Maven repository to build.gradle files.
- Fixed deadlock in IDE when attempting to create a new "Live Device" connection.
- Fixed bug where "Room Migration" action was never enabled if the initial database sync failed to find ADB.
- Fixed bug in "Room Migration" where migration got interrupted when project contained Kotlin code.
- "Room Migration" wizard now works with projects that do not have a root module.
- Database Console can now delete and update rows in tables without primary keys.
- Added support for executing SQL statements inside Room's @Query annotation.
- "Room Migration" wizard now can handle column names that are Java or Kotlin keywords.
- Added support for executing parameterized SQL statements.
- Added support for expressions using 'IN' operator.
- Improved code completion for subqueries.
- Added support for automated migration to Android's Room persistence library.
- Added support for Android Studio 3.0.1.
- Fixed plugin jar timestamp issue.
- Added ability to connect to any database in an Android device, from the 'Device File Explorer' view.
- Now it is possible to download database files from devices using Android 7 or later.
- Android database files can now be downloaded to a user-specified folder.
- Better error messages for failed license validations.
- Compatible with Android Studio 3.0.0.
- Port used for 'Live Database' connection is now configurable.
- Improvements to SQL editor:
- Added support for comments.
- Improved support for subqueries.
- Added support for 'between' operator.
- Added support for 'when' operator.
- Compatible with Android Studio 2.3.0.
- Bug fixes.
- Support for Android 7 (Nougat.)
- Now 'Live Device Connection' can handle large tables (e.g. 20,000 records.)
- Fixed handling of null values.
- Bug fixes.
- Compatible with Android Studio 2.2.0.
- Bug fixes.
- Unified "trial" and "registered" versions. Users no longer need to download 2 versions of the plugin.
- Fixed license number check.
- Fixed assertion error thrown when querying an empty table from the 'SQLite Explorer'.
- Added ability to manage and update databases in Android devices, in real time.
- Editor gutter now displays an "Execute Statement" action next to each SQL statement.
- Bug fixes.