CUBRID Tutorials

Quick Start

It is very easy to get started with CUBRID. Follow these step-by-step tutorials and you will see how fun it is to learn CUBRID.

• Follow CUBRID Installation Instructions (Windows, Linux)
• Start CUBRID Service
• Create a sample CUBRID Database from the command line
• Start or Autostart CUBRID Database
• Getting started with demodb (CUBRID Demo Database)
• Create the demodb CUBRID Demo Database
• Connecting to a remote CUBRID Database
• Important Facts to Know about CUBRID

Easy Database Administration

• Download CUBRID Manager (Windows, Linux, Mac OS X)
• Run CUBRID Manager. This tutorial will show you how to:
• Add and Connect to a host
• Login to and Start a database
• Execute queries (SELECT, UPDATE, DELETE)
• More details are available at CM Manual.

Install CUBRID Database Drivers

• PHP Driver
• PDO Driver
• Python Driver
• Perl Driver
• Ruby Driver
• ADO.NET Driver
• ODBC Driver
• OLEDB Driver
• JDBC Driver

Have Questions?

So far so easy! But if you have questions, head to CUBRID Q&A site. If you run into issues, post them on CUBRID Forum. We will be very glad to help you out!

Going Further

• Growing in the Wild. The story by CUBRID Database Developers. - RIT++ 2012 Conference presentation
• CUBRID Configurations
• CUBRID – Open Source RDBMS Highly Optimized for the Web - M&T Magazine, Sprint 2012, Vol. 20, Issue 1.
• How to Get the CUBRID Version Number

CUBRID SQL Tutorials

• CUBRID RDBMS Size Limits
• Shared Query Plan Caching in CUBRID
• Why prepare queries if auto-parameterization already does that?
• Execute prepared SQL in CUBRID
• CUBRID Query Tuning
• What is Covering Index in CUBRID 8.4.0?
• CUBRID Click Counter
• Comparison of Implicit Type Conversion in MSSQL, Oracle, MySQL, and CUBRID
• CUBRID vs. MySQL vs. Oracle Data Type Mapping
• How SQL UPDATE is performed in CUBRID
• CUBRID Serials
• Database Information in CUBRID
• CUBRID SQL Guide
• Hierarchical Queries in CUBRID
• CUBRID Hierarchical Queries
• Hierarchical Query - Manual
• How to Concatenate Column Values from Different Rows
• Working with CUBRID BLOB / CLOB Data Types
• CUBRID Transaction and Lock
• Obtaining Basic Database Information
• Best Way to Store IP Address in CUBRID

Advanced CUBRID Server Topics

• CUBRID Architecture
• CUBRID Inside - Architecture, Source & Management Components
• CUBRID Reference Architecture for Social Networking Service
• CUBRID Release Policy
• The Architecture of CUBRID
• Architecture of CUBRID - Blog article
• The CUBRID Broker Story
• CUBRID Query Processing
• CUBRID Performance
• CUBRID 8.4.0 Key Features
• CUBRID 8.4.0 QA Completion Report
• CUBRID 8.4.0 vs. 8.3.1 Volume Space Reusability Comparison
• CUBRID vs. MySQL Benchmark Test Results for SNS Data and Workload
• Increasing Database Performance by Query Tuning
• CUBRID vs. MySQL performance test results before and after the SSD usage
• NBD Benchmark Results
• CUBRID Developer's Course
• Introduction to CUBRID Security - Part I
• Introduction to CUBRID Security - Part II
• CSQL Interpreter
• How to Use CSQL (CUBRID SQL Interpreter)
• CSQL - Command Line SQL Interpreter - Blog article
• Server Error Msg
• CUBRID Error Codes
• Data Structures
• Connection Management and Threads in CUBRID Server
• Server Startup/Shutdown Process
• CUBRID Log Files
• CUBRID HA
• How CUBRID HA Works?
• CUBRID HA Starting Guide
• Overview of New High-Availability Features in CUBRID 8.4.0 - Blog article
• CUBRID HA - Guaranteed Way to Never-Die Web Services - OSCON 2011 Conference presentation
• CUBRID SHARD
• CUBRID Database Sharding User Specifications
• Database Sharding with CUBRID - Blog article
• Database Sharding Platform at NHN - Blog article
• CUBRID Automated Scripts for DB Hosting Service
• Backup & Restore
• How to Backup a Database in CUBRID
• How to Restore a Database in CUBRID
• CUBRID Backup & Restore - Part I (Backup)
• CUBRID Backup & Restore - Part II (Restore)
• How to Efficiently Import Large Files in CUBRID
• CUBRID Triggers
• Java Stored Procedures
• CUBRID Java Stored Procedures
• Java Stored Procedure - Manual

Working with Third-party Tools

• CUBRID Service through CUBRID Manager
• RCP Application
• Using Solr / Lucene for full text search with CUBRID Database on Ubuntu
• Install CUBRID with AutoSet
• Use Apache DdlUtils and Scriptella to migrate databases to CUBRID
• Apache DDLUtils & Scriptella: Migrating to CUBRID - Video Tutorial
• Scriptella for CUBRID - Video Tutorial
• How to Do Replication on UNIX & Linux
• CUBRID Administration Tools - Blog article
• CUBRID WebQuery Tutorial
• Uniform Server - CUBRID Video Tutorial
• phpMyEdit for CUBRID - Video Tutorial
• SQL Buddy for CUBRID - Video Tutorial
• Eclipse
• CUBRID Through SQuirrel SQL Client
• CUBRID Through Eclipse SQL Explorer
• CUBRID through QuantumDB Eclipse plugin
• Using CUBRID in AquaDataStudio
• Installing WordPress for CUBRID
• Using Hibernate with CUBRID
• Analyzing JDBC Logs with log4jdbc
• Store Java Logs to Database Using log4j
• Clj-DBCP Clojure Library for Connecting to CUBRID Database
• Using CUBRID with PowerShell