Documentation

Manuals / Getting Started / FAQ

Here you can find CUBRID user manuals and detailed documentation on what you can do with CUBRID and how we do things in CUBRID. If you just want to take a quick CUBRID tour, you can explore the usage examples and the Frequently Asked Questions section.

CUBRID 10.0.0 Manual

Available in: English
Looking for other versions?

Are you new around here ?

Don’t worry, it’s easy to get started with CUBRID.

 

Picking up new things might not always be easy. But with the step by step CUBRID guides, you can get started right away. Just pick one option and follow the simple instructions below.

Step 1

Install CUBRID engine

Simply go to Downloads/Engine and follow the instructions there.

Step 2

Open command prompt (on Win) or shell (on Linux)

On Windows: open run window, type cmd, click

Step 3

Start CUBRID service

Run the command

cubrid service start

Step 4

Create and start database

Run the command

cubrid createdb test en_US
cubrid server start test

Step 5

Connect to database using CSQL.

Run the command

csql --user PUBLIC test

Step 6

Run SQL queries

 

Step 1

Install CUBRID engine

Simply go to Downloads/Engine and follow the instructions there.

Step 2

Install CUBRID Manager

Simply go to Downloads/Manager and follow the instructions there.

Step 3

Start CUBRID Manager server.

Open a console and run:
cubrid manager start

Step 4

Start CUBRID Manager client (depends on OS)

Windows: Start button, select and start CUBRID manager from program list.
Alternatively, run cubrid_manager.exe from CUBRID/bin folder.

Step 5

Access host

From CUBRID Manager user interface in Hosts tab, right click on the localhost choice (or create a new host) and choose "Connect Host" menu.
Fill in the credentials and click "Connect" button.

Step 6

Create database

Create database from CUBRID Manager interface or from command console.
Under localhost, right click on Databases and choose "Create Database".

Step 7

Start database and connect.

Under localhost, right click database name (create with previous step), click "Start Database". Then from the same menu, click "Login Database".
Alternatively, you may directly click "Login Database".

Step 8

Run SQL queries

Under localhost, right click database name, then choose "New Query Editor" and start writing and running your queries.

Complete the Minimal installation or Standalone installation

Start with one of the two previous installation guides.

Step 1

Install CUBRID engine

Simply go to Downloads/Engine and follow the instructions there.

Step 2

Install JDBC Driver

Go to Downloads/JDBC Driver and follow the steps there. Skip this step if the JDBC Driver is already installed.

Step 3

Check if brokers have started

You can check this in CUBRID Manager interface (right click on localhost->Brokers) or run the command:

cubrid broker start

Step 4

Write a Java code (sample here):

package org.cubrid.demo;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;

import static java.sql.DriverManager.getConnection;

public class Main {

public static void main(String[] args) {
        String url = "jdbc:cubrid:localhost:33000:demodb:public::?charSet=utf8";
try {
            Class.forName("cubrid.jdbc.driver.CUBRIDDriver");
            Connection conn = getConnection(url, null, null);
            conn.setAutoCommit(false);
try (Statement stmt = conn.createStatement()) {
// Create a new table and insert some data
stmt.execute("drop table if exists mytable");
                stmt.execute("create table mytable(mycolumn string)");
                stmt.execute("insert into mytable values('This is my first inserted string')");
                ResultSet rs = stmt.executeQuery("select * from mytable");
// Retrieve and output the table data
while (rs.next()) {
                    System.out.println(rs.getString("mycolumn"));
                }
            }
            conn.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}

Step 5

Compile and run your program

javac TestCUBRID.java
java TestCUBRID

Step 6

Check JDBC API for more complex programs

 

Step 1

Install CUBRID engine

Simply go to Downloads/Engine and follow the instructions there.

Step 2

Install PHP Driver

Simply go to Downloads/PHP Driver and follow the instructions there.

Step 3

Install Karybu

1. Create folder “files” inside Karybu directory with permission to read and write.

On Linux:

cd [Karybu directory]
sudo mkdir files
sudo chmod 707 files

2. Enable rewrite module in Apache server (recommended)

3. Browse your site via a browser and follow the steps:

Select your language
Check necessary dependencies
Choose database type
Provide database connection information
Set time zone and enable rewrite mode
Input administrator information

Step 4

Using Karybu

1. Creating a page

On Linux:

Go to extension on the right menu
Click on page (If you prefer a shortcut, you can click on star near the page module to add it to your favorite module list)
Click on create page
Select page type:

Article: for page with content, title, and tags
Widget page: for page with built-in available widget like: login info, counter status, and so on
External page: for HTML or PHP page

Input module name which is the slug name of the page
Input browser title
Select a layout
Submit
When the page is created, just simply click on the page from page to edit the content.

2. Setting site’s index page

Go to settings
Go to general tab
Select site default module
Save

3. Setting a menu

Go to menu on the right side
Add new menu
Input menu name
Save
Add menu item

Add menu name
Select module or URL

Create module: create new page and link to current menu
Select module: link existing module to current menu
Menu URL: input external link

Save

Assign menu to specific layout

Want to ask something about CUBRID?

 

Find answers provided by our core development team to some of the most frequent questions about CUBRID.

You can find the latest CUBRID version (including major and minor patches) at
http://www.cubrid.org/downloads.

In addition to currently supporting Linux and Microsoft Windows, CUBRID will soon support UNIX OSes such as Oracle's Solaris, HP's HP-UX and IBM's AIX.

Yes, 64-bit binaries are also provided (starting with CUBRID 2008 R2.0). On a 64-bit OS that supports 32-bit software you can also use the 32-bit CUBRID binaries. See
http://www.cubrid.org/downloads.

The world awaits for you to change it

Join a community of developers. Experts. People

Find us on