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
• Change database user password
• 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
• How to ... using CUBRID - a set of HowTo tutorials.

Easy Database Administration

• CUBRID Web Manager - the next generation SQL client with monitoring features - Blog article
• 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
• Node.js Driver
• Interactive Connection String Builder - user blog

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

• How to Contribute to CUBRID Project
• Growing in the Wild. The story by CUBRID Database Developers. - RIT++ 2012 Conference presentation
• Database Sharding the Right Way: Easy, Reliable, and Open source - HighLoad++ 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
• Things to Understand When Moving from MySQL to CUBRID - blog article
• How SQL UPDATE is performed in CUBRID - blog article.
• 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
• Inserting a BLOB file to a CUBRID database
• Playing with CLOB data in CUBRID - user blog
• CUBRID Transaction and Lock
• Obtaining Basic Database Information
• Best Way to Store IP Address in CUBRID

Advanced CUBRID Server Topics

• CUBRID Architecture
  • CUBRID Source Code
  • 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 - Blog article
  • CUBRID Database Processes - Blog article
  • Basic Operations of CUBRID Processes - Blog article
  • CUBRID Query Processing
  • All about Two-Phase Locking and a little bit MVCC - Blog article
  • How data is stored in CUBRID RDBMS? Intro to Objects, Classes, OID and Inheritance - Blog article
• 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?
  • Configure CUBRID HA with Vagrant and Chef Cookbook under 4 minutes
  • CUBRID HA Starting Guide
  • CUBRID HA Guide Extended
  • 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
  • Database Sharding the Right Way: Easy, Reliable, and Open source - HighLoad++ 2012 Conference presentation
  • Configure CUBRID SHARD with Vagrant and Chef Cookbook under 2 minutes
  • Easy MySQL Database Sharding with CUBRID SHARD - 2013 Percona MySQL Conference presentation
  • Быстрый и простой способ шардирования MySQL с помощью CUBRID SHARD - 2013 RIT++
  • CUBRID Database Sharding User Specifications
  • Database Sharding with CUBRID - Blog article
  • Database Sharding Platform at NHN - Blog article
  • Getting started with CUBRID SHARD - Forum post
• 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
  • Emulate long running SQL queries in CUBRID - user blog

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
• [Solved] Chef: NameError: Cannot find a resource for converge_by on centos