SQLite
Using SQLite in Kythia Workspace.
SQLite is a fast, file-based database. It does not require a background server process, making it incredibly lightweight and portable.
Usage
In Kythia Workspace, you do not need to install a standalone SQLite server.
Go to Databases -> SQLite
Use the interface to create, manage, and delete .sqlite database files directly from the Kythia UI.
Data Location
All your managed SQLite database files are stored centrally at:
C:\kythia\data\sqlite\You can connect to these files using any standard database client (like DBeaver or DataGrip) or directly from your application's connection string by pointing to the absolute path of the file.