SQL Editor
Overview
The SQL Editor is a tool designed for database management, allowing users to execute SQL commands and manage data. It provides an interface to connect to multiple databases, run queries, and view results.
Installation
To access the SQL Editor, you need to install the SQL Explorer plugin. The installation process follows the standard procedure for Eclipse plugins:
Navigate to the menu and select Help > Install New Software.
Select the SQL Explorer Updates location
Click Next, accept the license agreement, and then click Finish.
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