SQLiteDevStudio is a SQLite database manager/editor for developing and maintaining databases on an Android device/emulator. It has been primarily developed for developers to create databases for their own application needs which can then be exported into their own projects.

It can also be used to simply view and edit data. This is particuarly useful when wishing to see the current state of data during the testing phase of application development.

For a limited time the app can be trialled as the full premium version. Even when the trial period ends you can continue to use the app with premium services. Re-installing SQLiteDevStudio after the trial period will result in the loss of premium services. A one time in-app purchase can be made to restore the premium functionality.

SQLiteDevStudio can access databases from a number of locations on a given device:

SQLiteDevStudio Internal Storage: Databases can be created and modified within SQLiteDevStudio’s internal storage. Once complete can be exported to another project in the form of a database adapter .java file.

External Shared Storage: A database that is located in a device’s shared storage can be imported into SQLiteDevStudio’s internal storage where it can be viewed and edited. To push any changes made to the external version a database restore will need to be done.

Third-party app via Content Provider: Another option when you are developing your own app is to include a content provider to allow SQLiteDevStudio to access the database(s) within your app’s internal storage. The required content provider can be found here (https://github.com/jonnybateman/SQLiteContentProvider.git) along with instructions on how to apply it.

Third-Party App via ROOT: To access internal storage databases of other third-party apps the device needs to be rooted. If this is the case then the databases can be accessed, viewed, and modified directly. SQLiteDevStudio has a built in file explorer for navigating to the required database.

SQLiteDevStudio can also be installed on an Emulator (with Google Play) in your own development environment. This is useful during development and testing of your own applications.

After install a user account needs to be set up to access the application. User will be prompted for an email address. This is used only in the event that the user has forgotten their password. Password will be sent to the email address that was used during account setup. Email address is encrypted and only stored locally on the device. It is not shared amongst any other parties.

SQLiteDevStudio has the following functionality:

Note: Only certain functionality is available in the free version. A one-time in-app purchase can be made to access all functions. This app is targeted towards Android 10(Q) and above. Certain functions may not be available on older devices (see Terms of Service here https://github.com/jonnybateman/SQLiteDevStudio-ReadMe.git). SQLiteDevStudio can be installed on devices with Android 8.0 or higher.

Create/Delete database.

Open existing databases.

Restore external database.

Export database (exported as a database adapter .java file for applying to your own projects).

Write and execute your own SQL statements with the built in editor.

SQL keywords/data types/functions/etc are highlighted within the editor.

Previously executed statements for the current session can be re-called through the SQL History dialog.

Transaction functionality (commit/rollback)

View, update, delete, and insert data via a dialog interface.

View existing foreign keys.

Enable/Disable foreign key constraints.

Limit number of rows returned.

Sort the rows returned.

Describe table.

Create, alter, and drop tables.

Create and drop triggers.

Display database indexes.

Create and drop indexes.

BLOB viewer (images, PDFs, and text files supported).

Extract the SQL for database objects and display code in the SQL Editor.

Import table data in the form of a CSV file.

Export table data to a CSV file.

What's New in the Latest Version 1.1.2

Last updated on Dec 5, 2023

Target SDK Tiramisu (33). Bug Fixes