Using SIDU to connect and run SQL in CUBRID is very easy and straightforward. No need to install or configure SIDU.
When you navigate to your http://localhost/sidu35/. Choose "CUBRID" as your database engine and fill out the necessary database connection fields.
Notice that you can connect to more than one database simultaneously by separating them with semicolon. This assumes that the database user is the same, i.e. username and password are the same for both databases.
Also you can easily to any remote database considering that ports are open on the remote server.
Before you actually connect to a database, you may want to test the connection by clicking on the Test button. If the connection can be established using the provided credentials, you will see the "Connection OK" message in green as shown below. Now you can press the "Connect" button.
Once you are connected, you can see a list of databases and tables on the left panel.
If you click on any table, SIDU will display first 15 records of this table by running "SELECT * FROM tbl ORDER BY 1 DESC LIMIT 15".
You can edit records/column directly from the query results. Each field in the query result is an editable input field. Place the cursor and start typing and changing values. You can change multiple rows at once. When done editing, press the "Save" icon (7th in the results panel toolbar above the results). This will save all the changes automatically. Isn't it super convenient!?
Another great feature in SIDU is the filtering the results. In the "where" field right below the results toolbar enter a valid SQL condition. Then press the green arrow button, which is to right of the "where" field, to narrow the search scope.
Remember that in CUBRID strings are wrapped in single quotes.
In SIDU you can also execute multiple SQL. There are two different ways to do this:
Below is the output of Run All command.
And this is the output of Multi command. Notice that both queries results are displayed.
When you create/drop/alter a table, the panel with a list of databases and tables is not automatically refreshed. In order to refresh the page, click on the Refresh "Window" icon on the main toolbar.
There are many other things that SIDU can do, but we leave the rest to you! SIDU is a really great app. It does exactly what its name says: SELECT, INSERT, DELETE, UPDATE. If you do not need any sophisticated database administration functionality, SIDU may be exactly what you need. It is ideal for Web developers!