SQL Editor

Installation

To access the SQL Editor, you need to install the SQL Explorer plugin. The installation process follows the standard procedure for Eclipse plugins:

  1. Navigate to the menu and select Help > Install New Software.

  2. Select the SQL Explorer Updates location

  3. Click Next, accept the license agreement, and then click Finish.

  4. Trusting Certificates:

  • During the installation process, a dialog will appear asking you to trust certificates from the update site.

  • Accept other certificates which will appear in the process

  • Once the installation is complete, you will be prompted to restart Servoy Developer.

Using SQL Editor

The SQL editor can be accessed through the context menu of any database of table.

SQL Editor overview

The SQL Editor in Servoy Developer is designed for managing and interacting with SQL databases directly within the IDE.

SQL Editor Area

Each SQL connection is displayed in its own tab, allowing you to work on multiple SQL scripts simultaneously. For example, the screenshot shows tabs for user_data.sql and example_data.sql. Write the SQL query in the SQL input area and use the Execute button in the toolbar to run it. The query results will be displayed at the bottom.

Database Connection Selector

This dropdown allows you to select the database connection for the query. In the image, the selected value, example_data/anonymous, shows the selected database and the connection type.

Limit Rows Option

This option allows you to limit the number of rows returned by the query.

Connections Panel

The Connections panel on the right side lists all available database connections, highlighting the databases with active SQL sessions (next to the connection name). In the image, we see that example_data and user_data both have active sessions. Various operations are available in this panel from the context menu.

You may use any SQL editor to interact with the Servoy database; however, the integrated SQL Editor provides a faster and more convenient way to manage your databases directly within the Servoy Developer environment. This eliminates the need to install a third-party tool, streamlining the workflow and enhancing productivity.

Last updated