Connecting with SQLite

The automatic of Scriptcase already comes with the SQLite enabled.

To do the connection with SQLite, please follow the steps below.

Driver SQLite

Currently Scriptcase offers two drivers to connect with the SQLite database: SQLite PDO e SQLite.

You can see the features below:

SQLite PDO ( Recommended ) : Driver version SQLite 3. Allows the connection to be made with SQLite using the native PHP driver, which is superior in processing speed and constantly updated. .

SQLite : Driver version SQLite 2. Allows the connection to be made with SQLite.

Creating a connection on Scriptcase

Now we’ll access Scriptcase from Scriptcase from the browser and create a connection with the SQLite database.

Step 1: Access your Scriptcase, for example, http://localhost:8081/scriptcase/ on the toolbar go to the marked icon in the image below, referring to “New Connection”.

Step 2: After clicking “New Connection”, the page for creating connections will appear, click on the SQLite database image.

Step 3: On the following image, place the required information:

• Connection Name - Define the name of your new connection.
• DBMS Driver - Allows you to define the driver that’ll be used, by default it’s SQLite PDO.
• Test Connection - Validates the connection and informs if it was successful or not.
• PATH - Inform the full path to the file SQLite database file (file.db).

For more details on configuring the connection of the database click on Advanced

• Decimal Separator - Select the type of separator, between coma and period.
• Persistent Connection - Persistent connections are connections that don’t close after running your script.
• Use the schema before the table name - Allows the use of schemas before the table names.

• Show - Allows to show Tables, Views, System Tables and Procedures.
• Searches - Allows to define which tables and owners will be shown.

Step 4: Always test your connection before saving, if the message “Connection Success” appears, then save the connection. If it fails to connect, revise the fields that were informed, especially Username, Password, Database and Server/Host.

Verify if the module is enabled in the diagnosis.