How to connect to SQLite

SQLite is a file, not a server, so connecting just means pointing Tamery at it. The one wrinkle is the web app, where the file sits on your machine and the browser cannot reach it.

Open a SQLite file

On desktop, the fastest way is to drop the database file onto Tamery. Or choose SQLite under Engine and pick the file with the folder button.

Pasting a path works too, as long as the file ends in .db, .db3, .sqlite or .sqlite3:

sqlite:///Users/me/app.db

For any other filename, paste sqlite3 /path/to/file instead, so Tamery knows it is a SQLite file and not something else.

The file has to exist already. A ~/ path points to the home folder of whatever computer opens the connection, so the same synced connection can work on your laptop and your desktop. Syncing the connection does not copy the file itself, only the pointer to it.

Opening a local file from the web app

The browser cannot read a file off your disk, so run tamery bridge on the computer that holds the file. The web app then runs its queries through the bridge.

What you can edit in SQLite

Browse and edit rows, run SQL, explore relationships, and manage indexes and triggers.

• You can add, rename and drop columns. Changing an existing column's type or nullability is not supported, because SQLite would have to rebuild the whole table to do it.
• Existing constraints are read-only.

Turso and Cloudflare D1

If you are looking for hosted SQLite, Tamery connects to both Turso and Cloudflare D1. They are SQLite-compatible but remote, so they have their own short guides.

FAQ

How do I open a SQLite file in Tamery?

On desktop, drop the file onto the window, or pick it under the SQLite engine. You can also paste a path ending in .db, .db3, .sqlite or .sqlite3.

Can I open a local SQLite file in the web app?

Yes, but run tamery bridge on the computer that holds the file first, since the browser cannot read your disk directly.

Does Tamery create a new SQLite database?

No. The file has to exist already; Tamery opens it, it does not create one.

Can I change a column's type in SQLite?

You can add, rename and drop columns, but not change an existing column's type or nullability, since SQLite would rebuild the whole table to do it.

Download Tamery and drop a .db file onto the window. The full reference is in the SQLite docs.