RUBRIKPULSA SOFTWARE, CO. ← Back to Home

Help & Tutorials Center

Your official guide to mastering DB CommanderX™ for SQLite.

Welcome!

This guide is designed to help you navigate the features of DB CommanderX™ for SQLite. Whether you're opening your first database, running complex queries, or managing table structures, you'll find step-by-step instructions here. Below, you can jump directly to a topic that interests you.

Table of Contents

Opening an Existing Database

1. On the main screen, tap the "Open Database" button.

2. Use the file explorer to navigate to your database file's location on your device.

3. Select your database file (usually with a .db, .sqlite, or .sqlite3 extension).

4. If it's a standard database, it will open immediately. If the file is encrypted, a dialog will appear prompting you to enter the correct password. Our free version allows you to open and work with existing encrypted files.

Creating a New Database

A. Creating a Basic (Unencrypted) Database

1. On the main screen, tap the "Create New Database" button.

2. Enter your desired filename (e.g., `my_project.db`).

3. Tap the "Create" button. A new, empty database will be created and opened.

B. Creating a New Encrypted DatabasePRO

Creating a new, password-protected database from scratch is a premium feature. To unlock this ability, please see the PRO Features & Upgrades section below.

Once you have PRO access, the creation process is simple: when creating a new database, check the box for "Encrypt Database" and set a secure password.

Using the Query Editor

1. After opening a database, tap the "SQL" button/tab to enter the Query Editor.

2. Write your custom SQL commands in the editor. You can use pre-existing commands from your query history or create new ones.

3. With the Query Editor, you can run any command, including creating temporary or permanent Views using `CREATE VIEW...`.

4. Tap the "Run" (▶) icon to execute the query. Results will be displayed below.

Exporting & Backing Up Data

Exporting a Single Table

1. Open the table whose data you wish to export.

2. Tap the 3-dot overflow menu and select the "Export Table" option.

3. Choose your desired format (CSV, PDF, or TXT) and follow the prompts to save the file.

Backing Up the Entire Database

1. From the main screen (table list), tap the 3-dot overflow menu next to the database name and select "Backup Database".

2. For Free Users: You will be prompted to watch a short rewarded ad. After the ad finishes, you can save a full copy of your `.db` file to your device's storage.

3. For PRO UsersPRO: This ad-watching step is skipped, allowing you to save the backup immediately.

Quick Guides for Other Features

Advanced Search

To search for specific data across tables with conditions (`LIKE`, `BETWEEN`, `IN`, etc.), tap the "Search" button and build your search filter.

Adding a New Table

Tap the "Add Table" button after opening a database. You will be prompted to define a table name and fill in the attributes for each column (name, data type, etc.).

Modifying a Table

To modify an existing table (e.g., add/drop a column), use the 3-dot overflow menu on the table list and select "Modify Table".

PRO Features & Upgrades

To get PRO features like database encryption, you have several options. Please choose the one that best suits your needs.

Option 1: Subscription (In-App)

For maximum flexibility, you can subscribe on a recurring basis (e.g., monthly). This unlocks all PRO features and removes ads, but these benefits are only active as long as your subscription is maintained.

  • Tap the yellow "Upgrade to PRO" button inside the app.
  • Choose your desired subscription plan through Google Play Billing.
  • Benefits are temporary and tied to your subscription period.

Option 2: One-Time Purchase (Separate PRO App)

For lifetime access with a single payment, we offer a separate, standalone app on the Google Play Store. This is the best value if you dislike recurring fees.

  • Search for and purchase "DB CommanderX™ PRO for SQLite" on the Play Store.
  • All PRO features are unlocked, and the app is ad-free forever.
  • Benefits are permanent.

Option 3: Remove Ads Only (Permanent)

If you don't need PRO features but want an ad-free experience, this option is for you. This one-time purchase only removes ads permanently and does not unlock any PRO functionality like database encryption.

  • Go to the Settings menu inside the app.
  • Tap the "Remove Ads" option and complete the one-time purchase.
  • For more details, please see our FAQ.