SQLite

SQLite is embedded and file-based, so there is no server to run. Point TableR at an existing database file, or let it create a new one locally.

Overview

TableR opens a SQLite database directly from a file on disk. There is no host, port, or credential — the file is the database. This makes SQLite ideal for local development, prototypes, and inspecting shipped .sqlite/.db files.

• File-based — open a .sqlite or .db file; there is no server.
• No credentials — access is controlled by file permissions on disk.
• Local bootstrap — TableR can create a new empty database file for you.

Before you start

• The path to a .sqlite or .db file, or a folder where you want to create one.
• Read/write permission on the file if you plan to modify it.

Connection fields

SQLite needs only a database file — there is no host, port, or credential to enter.

Connect with the form

1. 1
   Choose SQLite

   Open the launcher and pick the SQLite card.

2. 2
   Select a database file

   Browse to an existing .sqlite or .db file.

3. 3
   Or create a new file

   Choose a location and name to start an empty database.

4. 4
   Save and connect

   Save the profile so it reappears in the launcher, then connect.

Local bootstrap

Local bootstrap for SQLite simply creates a new database file on your machine — no install or server required.

1. 1
   Select SQLite

   Pick SQLite in the launcher.

2. 2
   Create a new database file

   Choose a folder and file name; TableR creates an empty SQLite database.

3. 3
   Start querying

   A connection opens on the new file; create a table and insert rows.

Verify the connection

Once connected, open a SQL tab and run a quick check:

SELECT sqlite_version();
SELECT name FROM sqlite_master WHERE type = 'table';

The first statement returns the SQLite version; the second lists tables (empty on a new database).

Troubleshooting

Next steps