Database guides
SQLite and Turso
Sheeta AI works with local SQLite database files through libSQL, the SQLite fork from Turso. The SQLite and Turso SQLite types in the connection form both open a local file. There is no server to install.
Sheeta AI 0.5.2 does not connect to databases hosted on Turso Cloud. Only local files are supported.
Create a local database
The fastest way is Create Local DB in an empty Database sidebar. It creates a connection named Local (then Local 2 and so on) with a new database file in the project.
To create one with your own name:
- Click Manage database connections, then Add.
- Select SQLite or Turso SQLite.
- Enter a Connection Name. The Database Location fills in as
sqlite-db/<connection-name>.dbinside the project. - Click Test Connection, then Save. The file and its folder are created on first use.
Because the file is inside the project, it is shared with the project when you use Git, unless you add it to .gitignore.
Open an existing database file
In the same form, click the folder button next to Database Location and choose a .db, .sqlite or .sqlite3 file anywhere on your computer. The form shows Connecting to an existing database when the file exists.
To copy tables from another SQLite file into a different database, use Importing Data.
SQLite syntax notes
- SQLite uses flexible types: TEXT, INTEGER, REAL and BLOB.
- Use
INTEGER PRIMARY KEYfor an auto-incrementing id. - All tables live in the
mainschema. - The
ilikefilter operator is not available, because SQLite has noILIKE.
When to use SQLite
- Quick prototyping without a database server
- Exploring CSV or Excel files with SQL after importing them
- Learning SQL
- Working offline