Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

SIDU CUBRID Tutorial


Using SIDU to connect and run SQL in CUBRID is very easy and straightforward. No need to install or configure SIDU.

Download and extract

Just download the zip archive and extract into a directory accessible by your Web browser. In this tutorial we will extract it to http://localhost/sidu35/.

Connect to a database

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.

sidu_db_connection.png

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.

sidu_test_db_connection.png

Databases and tables

Once you are connected, you can see a list of databases and tables on the left panel.

sidu_db_table_list.png

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".

sidu_table_select.png

Editing in Query Results

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!?

Filter in Query Results

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.

sidu_filter_results.png

Execute Multiple Queries

In SIDU you can also execute multiple SQL. There are two different ways to do this:

  1. Run All will execute all SQL statements one by one, but display the results from only the first query.
  2. Multi will execute all SQL statements one by one, and will displays all results obtained from each query.

Below is the output of Run All command.

sidu_run_all_sql.png

And this is the output of Multi command. Notice that both queries results are displayed.

sidu_run_multiple_sql.png

Refresh Window

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.

Conclusion

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!

comments powered by Disqus
Page info
viewed 2789 times
translations en
Author
posted 2 years ago by
CUBRID
Contributors
updated 2 years ago by
View revisions
tagged
Share this article