SQLite
In the Database tool window ( ), click the Data Source Properties icon .
On the Data Sources tab in the Data Sources and Drivers dialog, click the Add icon () and select SQLite.
Check if there is a Download missing driver files link at the bottom of the data source settings area. As you click this link, DataSpell downloads drivers that are required to interact with a database. The IDE does not include bundled drivers in order to have a smaller size of the installation package and to keep driver versions up-to-date for each IDE version.
You can specify your drivers for the data source if you do not want to download the provided drivers. For more information about creating a database connection with your driver, see Add a user driver to an existing connection.
To connect to an existing SQLite database, specify a file path to the database file in the File field.
To create a new SQLite database, change the default name of the database if needed
identifier.sqlite
and click OK.Also, to create a database, you can drag an SQLite DB file to the Database tool window.
To ensure that the connection to the data source is successful, click the Test Connection link.