Skip to content

Home

Jump to bottom
KCoder Programming edited this page Aug 22, 2025 · 1 revision
How to Use the SQLite App

How to Use the SQLite App

Introduction

This application is a lightweight, user-friendly tool for executing SQLite database operations. You can create/open databases, run SQL commands, view outputs in tabular format, save notebooks, and customize your interface with themes and output styles.

Main Features

  • Create new or open existing SQLite databases (.db, .sqlite, .db3, .sqlite3).
  • Write and execute SQL queries directly in the command editor.
  • View formatted output using different table styles.
  • Use an integrated Notepad to save and run SQL notebooks (.nbdb files).
  • Switch between beautiful themes and change the table display format.
  • Auto-clear input after running SQL commands (optional).
  • Shortcut keys for faster operations.

Using the Application

1. Open or Create a Database

Use the File menu:

  • Open Database – Choose an existing database file to work with.
  • New Database – Create a new empty SQLite database.

2. Write SQL Commands

Type your SQL queries inside the Command Editor (upper text box).

3. Run Commands

Click the Run button or press F5 to execute commands. The output appears below.

4. View Outputs

Results are displayed in a readable table format using the selected tabulate style. If no data is returned, a success message is shown.

5. Clear Output or Input

Use Edit > Clear Output to clear the output area. Enable Clear Input to automatically wipe the command editor after running a command.

6. Save and Open SQL Notebooks

Use New File or Open File from the File menu to manage .nbdb notebook files. These are SQL script files that can be saved and reopened later.

7. Theme and Table Style

Go to the Style menu:

  • Themes – Switch between multiple UI themes (Dark, Light, Colorful, etc.).
  • Format – Choose how your SQL output table looks (grid, fancy grid, github, psql, etc.).

Menus and Options

  • File Menu: Database and file operations.
  • Edit Menu: Clear outputs, auto-clear input, adjust font size.
  • Style Menu: Switch themes and output formats.
  • Help Menu: Open Help and SQLite Tutorial pages.

Shortcut Keys

  • Ctrl + N – New database
  • Ctrl + O – Open database
  • Ctrl + S – Save notebook in Notepad
  • F5 – Run SQL command
  • F5 – Run SQL script inside Notepad editor
  • Ctrl + Mousewheel – Zoom in/out editor and output text

Special Features

  • Run multiple commands separated by ; (semicolon).
  • Error Handling – Errors are shown clearly in the output.
  • Tabulate Output – Output is neatly presented in different customizable styles.
  • Integrated Notepad – Create, save, and execute long SQL scripts conveniently.
  • Zoom Text – Quickly adjust text size using shortcuts.

Table Styles Preview

Here is an example of different table output styles available in the app:

  • double_grid

    ╔════╦═══════╦════════╦═════════╦═══════════╦══════════════╦══════╗
    ║ ║ cid ║ name ║ type ║ notnull ║ dflt_value ║ pk ║
    ╠════╬═══════╬════════╬═════════╬═══════════╬══════════════╬══════╣
    ║ 0 ║ 0 ║ id ║ INTEGER ║ 0 ║ ║ 1 ║
    ╠════╬═══════╬════════╬═════════╬═══════════╬══════════════╬══════╣
    ║ 1 ║ 1 ║ name ║ TEXT ║ 1 ║ ║ 0 ║
    ╠════╬═══════╬════════╬═════════╬═══════════╬══════════════╬══════╣
    ║ 2 ║ 2 ║ age ║ INTEGER ║ 0 ║ ║ 0 ║
    ╠════╬═══════╬════════╬═════════╬═══════════╬══════════════╬══════╣
    ║ 3 ║ 3 ║ email ║ TEXT ║ 0 ║ ║ 0 ║
    ╚════╩═══════╩════════╩═════════╩═══════════╩══════════════╩══════╝

  • double_outline

    ╔════╦═══════╦════════╦═════════╦═══════════╦══════════════╦══════╗
    ║ ║ cid ║ name ║ type ║ notnull ║ dflt_value ║ pk ║
    ╠════╬═══════╬════════╬═════════╬═══════════╬══════════════╬══════╣
    ║ 0 ║ 0 ║ id ║ INTEGER ║ 0 ║ ║ 1 ║
    ║ 1 ║ 1 ║ name ║ TEXT ║ 1 ║ ║ 0 ║
    ║ 2 ║ 2 ║ age ║ INTEGER ║ 0 ║ ║ 0 ║
    ║ 3 ║ 3 ║ email ║ TEXT ║ 0 ║ ║ 0 ║
    ╚════╩═══════╩════════╩═════════╩═══════════╩══════════════╩══════╝

  • fancy_grid

    ╒════╤═══════╤════════╤═════════╤═══════════╤══════════════╤══════╕
    │ │ cid │ name │ type │ notnull │ dflt_value │ pk │
    ╞════╪═══════╪════════╪═════════╪═══════════╪══════════════╪══════╡
    │ 0 │ 0 │ id │ INTEGER │ 0 │ │ 1 │
    ├────┼───────┼────────┼─────────┼───────────┼──────────────┼──────┤
    │ 1 │ 1 │ name │ TEXT │ 1 │ │ 0 │
    ├────┼───────┼────────┼─────────┼───────────┼──────────────┼──────┤
    │ 2 │ 2 │ age │ INTEGER │ 0 │ │ 0 │
    ├────┼───────┼────────┼─────────┼───────────┼──────────────┼──────┤
    │ 3 │ 3 │ email │ TEXT │ 0 │ │ 0 │
    ╘════╧═══════╧════════╧═════════╧═══════════╧══════════════╧══════╛

  • fancy_outline

    ╒════╤═══════╤════════╤═════════╤═══════════╤══════════════╤══════╕
    │ │ cid │ name │ type │ notnull │ dflt_value │ pk │
    ╞════╪═══════╪════════╪═════════╪═══════════╪══════════════╪══════╡
    │ 0 │ 0 │ id │ INTEGER │ 0 │ │ 1 │
    │ 1 │ 1 │ name │ TEXT │ 1 │ │ 0 │
    │ 2 │ 2 │ age │ INTEGER │ 0 │ │ 0 │
    │ 3 │ 3 │ email │ TEXT │ 0 │ │ 0 │
    ╘════╧═══════╧════════╧═════════╧═══════════╧══════════════╧══════╛

  • github

    | | cid | name | type | notnull | dflt_value | pk |
    |——|———-|————|————-|—————-|———————|———|
    | 0 | 0 | id | INTEGER | 0 | | 1 |
    | 1 | 1 | name | TEXT | 1 | | 0 |
    | 2 | 2 | age | INTEGER | 0 | | 0 |
    | 3 | 3 | email | TEXT | 0 | | 0 |

  • html

    <table>
    <thead>
    <tr><th></th><th> cid </th><th> name </th><th> type </th><th> notnull </th><th> dflt_value </th><th> pk </th></tr>
    </thead>
    <tbody>
    <tr><td> 0 </td><td> 0 </td><td> id </td><td> INTEGER </td><td> 0 </td><td> </td><td> 1 </td></tr>
    <tr><td> 1 </td><td> 1 </td><td> name </td><td> TEXT </td><td> 1 </td><td> </td><td> 0 </td></tr>
    <tr><td> 2 </td><td> 2 </td><td> age </td><td> INTEGER </td><td> 0 </td><td> </td><td> 0 </td></tr>
    <tr><td> 3 </td><td> 3 </td><td> email </td><td> TEXT </td><td> 0 </td><td> </td><td> 0 </td></tr>
    </tbody>
    </table>

  • latex

    \begin{tabular}{rrllrlr}
    \hline
    & cid & name & type & notnull & dflt\_value & pk \\
    \hline
    0 & 0 & id & INTEGER & 0 & & 1 \\
    1 & 1 & name & TEXT & 1 & & 0 \\
    2 & 2 & age & INTEGER & 0 & & 0 \\
    3 & 3 & email & TEXT & 0 & & 0 \\
    \hline
    \end{tabular}

  • mediawiki

    {| class=“wikitable” style=“text-align: left;”
    |+ <!— caption ->
    |
    ! align=“right”| !! align=“right”| cid !! name !! type !! align=“right”| notnull !! dflt_value !! align=“right”| pk
    |-
    | align=“right”| 0 || align=“right”| 0 || id || INTEGER || align=“right”| 0 || || align=“right”| 1
    |-
    | align=“right”| 1 || align=“right”| 1 || name || TEXT || align=“right”| 1 || || align=“right”| 0
    |-
    | align=“right”| 2 || align=“right”| 2 || age || INTEGER || align=“right”| 0 || || align=“right”| 0
    |-
    | align=“right”| 3 || align=“right”| 3 || email || TEXT || align=“right”| 0 || || align=“right”| 0
    |}

  • moinmoin

    ||<style=“text-align: right;”> ‘’’ ‘’’ ||<style=“text-align: right;”> ‘’’ cid ‘’’ || ‘’’ name ‘’’ || ‘’’ type ‘’’ ||<style=“text-align: right;”> ‘’’ notnull ‘’’ || ‘’’ dflt_value ‘’’ ||<style=“text-align: right;”> ‘’’ pk ‘’’ ||
    ||<style=“text-align: right;”> 0 ||<style=“text-align: right;”> 0 || id || INTEGER ||<style=“text-align: right;”> 0 || ||<style=“text-align: right;”> 1 ||
    ||<style=“text-align: right;”> 1 ||<style=“text-align: right;”> 1 || name || TEXT ||<style=“text-align: right;”> 1 || ||<style=“text-align: right;”> 0 ||
    ||<style=“text-align: right;”> 2 ||<style=“text-align: right;”> 2 || age || INTEGER ||<style=“text-align: right;”> 0 || ||<style=“text-align: right;”> 0 ||
    ||<style=“text-align: right;”> 3 ||<style=“text-align: right;”> 3 || email || TEXT ||<style=“text-align: right;”> 0 || ||<style=“text-align: right;”> 0 ||

    ;

  • orgtbl

    | | cid | name | type | notnull | dflt_value | pk |
    |——-——————-————————--—————-———|
    | 0 | 0 | id | INTEGER | 0 | | 1 |
    | 1 | 1 | name | TEXT | 1 | | 0 |
    | 2 | 2 | age | INTEGER | 0 | | 0 |
    | 3 | 3 | email | TEXT | 0 | | 0 |

  • grid

    --———--——-————--———————————-—-
    | | cid | name | type | notnull | dflt_value | pk |
    =====+==================+
    | 0 | 0 | id | INTEGER | 0 | | 1 |
    --———--——-————--———————————-—-
    | 1 | 1 | name | TEXT | 1 | | 0 |
    --———--——-————--———————————-—-
    | 2 | 2 | age | INTEGER | 0 | | 0 |
    --———--——-————--———————————-—-
    | 3 | 3 | email | TEXT | 0 | | 0 |
    --———--——-————--———————————-—-

  • outline

    --———--——-————--———————————-—-
    | | cid | name | type | notnull | dflt_value | pk |
    =====+==================+
    | 0 | 0 | id | INTEGER | 0 | | 1 |
    | 1 | 1 | name | TEXT | 1 | | 0 |
    | 2 | 2 | age | INTEGER | 0 | | 0 |
    | 3 | 3 | email | TEXT | 0 | | 0 |
    --———--——-————--———————————-—-

  • pipe

    | | cid | name | type | notnull | dflt_value | pk |
    |—-:|———:|:———-|:————|—————:|:——————-|——-:|
    | 0 | 0 | id | INTEGER | 0 | | 1 |
    | 1 | 1 | name | TEXT | 1 | | 0 |
    | 2 | 2 | age | INTEGER | 0 | | 0 |
    | 3 | 3 | email | TEXT | 0 | | 0 |

  • plane

    cid name type notnull dflt_value pk
    0 0 id INTEGER 0 1
    1 1 name TEXT 1 0
    2 2 age INTEGER 0 0
    3 3 email TEXT 0 0

  • presto

    | cid | name | type | notnull | dflt_value | pk
    ---——————-————————--—————-———
    0 | 0 | id | INTEGER | 0 | | 1
    1 | 1 | name | TEXT | 1 | | 0
    2 | 2 | age | INTEGER | 0 | | 0
    3 | 3 | email | TEXT | 0 | | 0

  • pretty

    -——--——————--—————————--
    | | cid | name | type | notnull | dflt_value | pk |
    -——--——————--—————————--
    | 0 | 0 | id | INTEGER | 0 | | 1 |
    | 1 | 1 | name | TEXT | 1 | | 0 |
    | 2 | 2 | age | INTEGER | 0 | | 0 |
    | 3 | 3 | email | TEXT | 0 | | 0 |
    -——--——————--—————————--

  • psql

    --———--——-————--———————————-—-
    | | cid | name | type | notnull | dflt_value | pk |
    |——-——————-————————--—————-———|
    | 0 | 0 | id | INTEGER | 0 | | 1 |
    | 1 | 1 | name | TEXT | 1 | | 0 |
    | 2 | 2 | age | INTEGER | 0 | | 0 |
    | 3 | 3 | email | TEXT | 0 | | 0 |
    --———--——-————--———————————-—-

  • rst

    == === == === === ==== ==
    .. cid name type notnull dflt_value pk
    == === == === === ==== ==
    0 0 id INTEGER 0 1
    1 1 name TEXT 1 0
    2 2 age INTEGER 0 0
    3 3 email TEXT 0 0
    == === == === === ==== ==

  • simple

    cid name type notnull dflt_value pk
    - -—- -—- -—— -——— -————- --
    0 0 id INTEGER 0 1
    1 1 name TEXT 1 0
    2 2 age INTEGER 0 0
    3 3 email TEXT 0 0

  • simple_grid

    ┌────┬───────┬────────┬─────────┬───────────┬──────────────┬──────┐
    │ │ cid │ name │ type │ notnull │ dflt_value │ pk │
    ├────┼───────┼────────┼─────────┼───────────┼──────────────┼──────┤
    │ 0 │ 0 │ id │ INTEGER │ 0 │ │ 1 │
    ├────┼───────┼────────┼─────────┼───────────┼──────────────┼──────┤
    │ 1 │ 1 │ name │ TEXT │ 1 │ │ 0 │
    ├────┼───────┼────────┼─────────┼───────────┼──────────────┼──────┤
    │ 2 │ 2 │ age │ INTEGER │ 0 │ │ 0 │
    ├────┼───────┼────────┼─────────┼───────────┼──────────────┼──────┤
    │ 3 │ 3 │ email │ TEXT │ 0 │ │ 0 │
    └────┴───────┴────────┴─────────┴───────────┴──────────────┴──────┘

  • simple_outline

    ┌────┬───────┬────────┬─────────┬───────────┬──────────────┬──────┐
    │ │ cid │ name │ type │ notnull │ dflt_value │ pk │
    ├────┼───────┼────────┼─────────┼───────────┼──────────────┼──────┤
    │ 0 │ 0 │ id │ INTEGER │ 0 │ │ 1 │
    │ 1 │ 1 │ name │ TEXT │ 1 │ │ 0 │
    │ 2 │ 2 │ age │ INTEGER │ 0 │ │ 0 │
    │ 3 │ 3 │ email │ TEXT │ 0 │ │ 0 │
    └────┴───────┴────────┴─────────┴───────────┴──────────────┴──────┘

  • textile

    |. |. cid |. name |. type |. notnull |. dfltvalue |. pk |
    |>. 0 |>. 0 |<. id |<. INTEGER |>. 0 |<. |>. 1 |
    |>. 1 |>. 1 |<. name |<. TEXT |>. 1 |<. |>. 0 |
    |>. 2 |>. 2 |<. age |<. INTEGER |>. 0 |<. |>. 0 |
    |>. 3 |>. 3 |<. email |<. TEXT |>. 0 |<. |>. 0 |

Command Line Options

You can launch the SQLite App with special flags using the command line:

—portable: Launches the app in portable mode, saving settings locally.

Example usage:

sqlite.exe --portable

Enjoy using the SQLite App! Feel free to experiment and explore your databases easily. 🚀

Clone this wiki locally