CUBRID - Open Source Database Management System Optimized for Web

Presentations

2013-01-08T07:28:05-08:00

nGrinder 3.0 : Load Test even kids can do written by JunHo Yoon

nGrinder_だれもが簡単にできる性能テスト(Japanese)

Performance Test with nGrinder written by Mavlarn
[nGrinder Real Deployment in the large organization] written by JunHo Yoon
nGrinder 사용자지원 프로세스 written by Jo, JiWon (Korean)
[nGrinder: Why we should have developed our own load test tool?]

Professional Service

2013-01-30T08:28:20-08:00

nGrinder is the open source project which is free to use now and forever. We're developing nGrinder to make the web more stable and reliable. However there might be some organizations who want to deploy nGrinder as their base development infrastructure. For these guys, we can provide some professional services to facilitate the performance centric culture in your organization. This may include followings.

Training

How to use nGrinder system
How to write the scripts

Deployment

Construct the nGrinder clustering instance across multiple IDCs
Provide a plugin which can make the network safe from heavy loads.
Provide a SSO plugin for your organization

Tools

You can still use open source TCPProxy to record scripts. However we can provide the better script recorder.

Monitoring

Monitor test execution patterns and help developers to write correct scripts.
(We really have good effects from this support. Everyone started to write valid tests just after 2~3 failures)

Price? It's depends on how big your requests are. If you're a big committer for nGrinder, we're willing to do without charge.
If not, we might charge the amount of the time we put on to solve your requests. Please contact to ngrinderglobal at gmail.com if you're interested in.

Philosophy

2013-01-14T00:30:37-08:00

Reliability over Accuracy
TPS over VUser
Code is always better than GUI Editor
Do not limit!!
File System is faster than DB if we use it correctly.
Convention over Configuration
Open Closed code by Plugin Model
One shot Installation
Need to add code? Remove same amount of code first.

Official Django backend for CUBRID Database

2013-02-04T23:46:42-08:00

[Solved] CUBRID Python: ImportError: libcascci.so.8: cannot open shared object file: No such file or directory

2013-02-05T01:04:59-08:00

I have encountered this error "ImportError: libcascci.so.8: cannot open shared object file: No such file or directory" when running my sample Python program on Ubuntu 12.04.2 using the CUBRID Python driver.

Solution

The problem was quite trivial: the environment variables haven't been set after CUBRID and the Python driver have been installed.

So, what I did is simply export the necessary environment variables.

In my case, CUBRID is installed using Chef Cookbook to /opt/cubrid. Considering this path, I set the necessary CUBRID environment variables as follows:

export CUBRID=/opt/cubrid
export LD_LIBRARY_PATH=$CUBRID/lib:$LD_LIBRARY_PATH
export CUBRID_DATABASES=$CUBRID/databases
export CUBRID_LANG=en_US
export PATH=$CUBRID/bin:$PATH

Done! And the problem is gone!

In your case if CUBRID is installed in another location, simply change the first command and set your path. If you still have problems, leave your comment below.

CUBRID Python Tutorials

2012-01-03T22:35:15-08:00

Installation Instructions

[CUBRID Python Driver Installation Instructions]

CUBRID Perl Driver Build Guide

2011-12-01T00:12:48-08:00

Description

This document describes the installation and configuration of DBD::cubrid, a Perl DBI driver for CUBRID database. Before reading on, make sure that you have the prerequisites installed: Perl, CUBRID and DBI. For details see the Prerequisites section below.

Depending on the version of your Perl, it may be possible to use a binary distribution of DBD::CUBRID. If possible, this is recommended. Otherwise you need to install it from the sources. If so, you will definitely need a C compiler. Installation from sources is described in separate Installation from Source section below.

Prerequisites

Perl

Preferrably a version of Perl, that comes preconfigured with your system. For example, all Linux and FreeBSD distributions come with Perl. For Windows, ActivePerl is recommended, see www.activestate.com for details.
CUBRID

You need install the actual CUBRID database management system. You can download CUBRID here. If you want to install from source code an build it, see How to Download CUBRID Source Code and Build it for details.

DBI

DBD::cubrid is a DBI driver, hence you need DBI. The DBI home page is dbi.perl.org/.
The DBI 1.61 or higher version is needed in Cubrid Perl driver.

DBI Installation from source:

1. Download the DBI-1.x.x.tar.gz from search.cpan.org/~timb/DBI/
2. Unpack the source code.

  tar -zxf DBI-1.x.x.tar.gz

3. Build and install.

  perl Makefile.PL
  make
  make install

Register Cubrid driver into DBI.pm
Edit the DBI.pm file installed in the above step, and add the red line below. For example: perl-5.16.1/lib/site_perl/5.16.1/x86_64-linux/DBI.pm

 my $dbd_prefix_registry = {
    ……
    sys_         => { class => 'DBD::Sys',            },
    tdat_        => { class => 'DBD::Teradata',       },
    tmpl_        => { class => 'DBD::Template',       },
    tmplss_      => { class => 'DBD::TemplateSS',     },
    tree_        => { class => 'DBD::TreeData',       },
    tuber_       => { class => 'DBD::Tuber',          },
    uni_         => { class => 'DBD::Unify',          },
    vt_          => { class => 'DBD::Vt',             },
    wmi_         => { class => 'DBD::WMI',            },
    x_           => { }, # for private use
    xbase_       => { class => 'DBD::XBase',          },
    xl_          => { class => 'DBD::Excel',          },
    yaswi_       => { class => 'DBD::Yaswi',          },
    cubrid_      => { class => 'DBD::cubrid',         },
 };

C compiler

A C compiler is only required, if you install from source. In most cases there are binary distributions of DBD::cubrid available. However, if you need a C compiler, make sure, that it is the same C compiler that was used for compiling Perl and CUBRID. Otherwise you will almost definitely encounter problems because of differences in the underlying C runtime libraries.

In the worst case, this might mean to compile Perl and CUBRID yourself. But believe me, experience shows that a lot of problems are fixed this way.

Installation from Source

So you need to install from sources. If you are lucky, the Perl module CPAN will do all for you. Otherwise you will need to do a manual installation. Some of you, in particular system administrators of multiple sites, will choose automatic installation. All of these installation types have an own section.

CPAN installation

Install the latest version of DBD::cubrid

Installation of DBD::cubrid can be incredibly easy:

$ cpan
cpan> install DBD::cubrid

If you are using the CPAN module for the first time, just answer the questions by accepting the defaults which are fine in most cases. If you are using an older version of Perl, you might instead need a

$  perl -MCPAN -e shell
cpan> install DBD::cubrid

If you cannot get the CPAN module working, you might try to manual installation.

Install a givern version of DBD::cubrid

By default, CPAN will install the latest release of a module. If you want to install a given release, you can follow the below steps:

1. List releases.

you can use the ls command to get this path listed.

cpan> ls CUBRID

The result maybe like the below. It shows which versions are available.

     638 2011-10-21 CUBRID/DBD-cubrid-8.4.0.0001.meta
   25043 2011-12-02 CUBRID/DBD-cubrid-8.4.0.0001.tar.gz
     643 2012-01-20 CUBRID/DBD-cubrid-8.4.0.0002.meta
   71812 2012-01-20 CUBRID/DBD-cubrid-8.4.0.0002.tar.gz
     643 2012-03-26 CUBRID/DBD-cubrid-8.4.1.0001.meta
   71956 2012-03-26 CUBRID/DBD-cubrid-8.4.1.0001.tar.gz
     643 2012-05-23 CUBRID/DBD-cubrid-8.4.3.0001.meta
   71926 2012-11-16 CUBRID/DBD-cubrid-8.4.3.0001.tar.gz
     643 2012-09-21 CUBRID/DBD-cubrid-9.0.0.0001.meta
   73257 2012-10-15 CUBRID/DBD-cubrid-9.0.0.0001.tar.gz

2. Install the given version.

You have to specify the partial path starting with the author id(uppercased) to the tarball you wish to install. The author id of DBD-cubrid is cubrid. The tarball file name is DBD-cubrid-<version>.tar.gz. For example, you want to install version 8.4.3.0001.

cpan> install CUBRID/DBD-cubrid-8.4.3.0001.tar.gz

If you cannot get the CPAN module working, you might try to manual installation.

Manual installation

For a manual installation you need to fetch the DBD::cubrid source distribution. The latest version is always available from

  https://sourceforge.net/projects/cubrid/files/CUBRID-Drivers/Perl_Driver/

The name is typically something like

  DBD-cubrid-X.X.X.tar.gz

The archive needs to be extracted. On Windows you may use a tool like WinZip, on Unix you type

  tar zxvf DBD-cubrid-X.X.X.tar.gz

This will create a subdirectory RB-X.X.X. Enter this subdirectory and type

  perl Makefile.PL
  make
  make test

(On Windows you may need to replace ``make'' with ``nmake'' or ``dmake''.)If the tests seem to look fine, you may continue with

  make install

Support

Finally, if everything else fails, you are not alone. Post a question on our Q&A site and we will help you out.

How to run the multiple tests with different weight

2013-01-07T21:44:51-08:00

The real user is not simple. There might have multiple usage scenarios for the target system. If you want to simulate this on The Grinder script, you may need to run multiple tests with different weight.

With following The Grinder script technique, it’s possible to simulate this case. You can upload the each scenarios in the lib folder(refer [How to use library]) and create the test script which control each test scenario like following.

# Run test scripts in parallel
# Run TestScript1 in 50% of threads, TestScript2 in 30% of threads,
# and TestScript3 in 20% of threads.

from net.grinder.script.Grinder import grinder

 
# You can locate Scenario1,2,3.py files in the lib folder.
scripts = 〔"Scenario1", "Scenario2", "Scenario2"〕


# Ensure modules are initialised in the process thread.
for script in scripts: exec("import %s" % script)

def createTestRunner(script):
    exec("x = %s.TestRunner()" % script)
    return x

class TestRunner:
    def __init__(self):
        tid = grinder.threadNumber
        s = tid % 10
        if s in range(1,5):
            self.testRunner = createTestRunner(scripts〔0〕)
        elif s in range(6,8):
            self.testRunner = createTestRunner(scripts〔1〕)
        else:
            self.testRunner = createTestRunner(scripts〔2〕)

    # This method is called for every run.
    def __call__(self):
        self.testRunner()

CUBRID ADO.NET Schema Provider

2012-12-24T22:40:09-08:00

The CUBRIDSchemaProvider class provides support for database schema, provides the following functions: query user tables, indexes, views, database users, etc.

Need to add the following code:

using System.Data;
using System.Data.Common;
using CUBRID.Data.CUBRIDClient;

Define the connection string:

/* conection string, please modify before using. */
string _connString = "server=localhost;database=demodb;port=33000;user=public;password=";

Use CUBRIDConnectionStringBuilder class generated connection string:

string server = "localhost";
int port = 33000;
string database = "demodb";
string user = "public";
string password = "";
string encoding = "utf-8";
CUBRIDConnectionStringBuilder sb = new CUBRIDConnectionStringBuilder(server, port, database, user, password, encoding);
string _connString = sb.GetConnectionString();

Get All User Tables:

/* create a new CUBRIDConnection instance */
using (CUBRIDConnection conn = new CUBRIDConnection())
{
    try
    {
        /* set the connection string */
        conn.ConnectionString = _connString;
        /* connect to db server */
        conn.Open();
 
        /* create a new CUBRIDSchemaProvider instance */
        CUBRIDSchemaProvider schema = new CUBRIDSchemaProvider(conn);
        /* get all tables */
        DataTable dt = schema.GetTables(new string[] { "%" });
 
        /* print all tables */
        for (int i = 0; i < dt.Rows.Count; i++)
            Console.WriteLine(dt.Rows[i][2].ToString());
    }
    catch (Exception exp)
    {
        Console.WriteLine(exp.Message);
    }
}

Get all users:

/* create a new CUBRIDConnection instance */
using (CUBRIDConnection conn = new CUBRIDConnection())
{
    try
    {
        /* set the connection string */
        conn.ConnectionString = _connString;
        /* connect to db server */
        conn.Open();

        /* create a new CUBRIDSchemaProvider instance */
        CUBRIDSchemaProvider schema = new CUBRIDSchemaProvider(conn);
        /* get all users */
        DataTable dt = schema.GetUsers(null);

        /* print all users */
        for (int i = 0; i < dt.Rows.Count; i++)
            Console.WriteLine(dt.Rows[i][0].ToString().ToUpper());
    }
    catch (Exception exp)
    {
        Console.WriteLine(exp.Message);
    }
}

Get all views:

/* create a new CUBRIDConnection instance */
using (CUBRIDConnection conn = new CUBRIDConnection())
{
    try
    {
        /* set the connection string */
        conn.ConnectionString = _connString;
        /* connect to db server */
        conn.Open();

        /* create a new CUBRIDSchemaProvider instance */
        CUBRIDSchemaProvider schema = new CUBRIDSchemaProvider(conn);
        /* get all tables */
        DataTable dt = schema.GetViews(new string[] { "%" });

        /* print all tables */
        for (int i = 0; i < dt.Rows.Count; i++)
            Console.WriteLine(dt.Rows[i][2].ToString());
    }
    catch (Exception exp)
    {
        Console.WriteLine(exp.Message);
    }
}

Sample Code: SchemaProviderTest.cs

How to using the CUBRID ADO.NET Data Provider?

2013-02-04T18:15:29-08:00

CUBRID Python Driver Installation Instructions

2012-01-03T22:24:09-08:00

Requirements

CUBRID: 8.4.0+
OS:
- Windows x32/x64
- Linux x32/x64
- Other UNIX and UNIX-like OS
Python: 2.4+

Installation

There are several ways to install CUBRID Python Driver. Below you will see instructions for each of them.

[Installing CUBRID Python Driver using yum (Fedora, CentOS)]
[Installing CUBRID Python Driver using apt-get (Ubuntu)]
[Install CUBRID Python Driver from Source (Linux)]
[CUBRID Python easy_install (Linux)]
[Install CUBRID Python Driver using pip (Linux)]
[Downloading and Installing Precompiled CUBRID Python Driver (windows)]
Create a CUBRID Database VM with Vagrant and Chef Cookbook under 5 minutes (Linux)
Official Django backend for CUBRID Database

How to use Django with CUBRID

2013-01-13T20:58:00-08:00

Overview

Django_cubrid is the official Django backend for CUBRID Database which is distributed together with the CUBRID Python driver (CUBRIDdb). When using Django web framework with CUBRID database, the django_cubrid backend should be used.

For more information about CUBRID Database, refer to Important Facts to Know about CUBRID.

Prerequisites

Python 2.5 - 2.7
Being a Python Web framework, Django requires Python version from 2.5 to 2.7 (due to backwards incompatibilities in Python 3.0, Django does not currently work with Python 3.0).
So, when using django_cubrid, the Python version should also be from 2.5 to 2.7.
CUBRIDdb (the CUBRID Python driver)
The django_cubrid backend will call the Python interface to access CUBRID DB.
Django Web Framework
The django_cubrid backend requires Django 1.4 (tested with Django-1.4.2).

Relevant links:

www.python.org/getit/
www.cubrid.org/wiki_apis/entry/cubrid-python-driver-installation-instructions
https://docs.djangoproject.com/en/1.4/intro/install/

Build and Install

Since django_cubrid backend is distributed together with the CUBRID Python driver, all you need to do is install the CUBRID driver.

Configure django_cubrid

Configure the DATABASES part in your setting.py as shown below:

DATABASES = {
    'default': {
        'ENGINE': 'django_cubrid',       # The backend name: django_cubrid
        'NAME': 'demodb',                  # CUBRID database name: eg. demodb
        'USER': 'public',                      # a database user: eg. public
        'PASSWORD': '',                     # a database user password: eg. an empty password
        'HOST': '',                            # Set to empty string for localhost.
        'PORT': '33000',                 # Set to empty string for default 33000.
    }
}

Known issues

The Django sqlflush command may fail because of the foreign constraints between database tables.
After using the Django loaddata command, the insert SQL manipulation in the application may fail, becuse of the unique constraint violations.
You may also encounter the below warning:
RuntimeWarning: DateTimeField received a naive datetime (2013-01-15 06:38:37.463000) while time zone support is active.
The reason is that CUBRID doesn't support timezone. You can set "USE_TZ" to False in settings.py to avoid this warning.

License

CUBRID is distributed under two licenses:

The CUBRID Database Engine is distributed under GPL v2 or later.
The drivers including the django_cubrid backend are distributed under BSD license.

For more information about the licensing policy, visit www.cubrid.org/license.

CUBRID ADO.NET Tutorials

2012-01-04T00:01:41-08:00

Latest Announcements

CUBRID ADO.NET Driver Stable 1.0 version has been released
Official ADO.NET Driver for CUBRID is now available

Installation Instructions

[CUBRID ADO.NET Driver Installation Guide]

CUBRID ADO.NET TestCases

[ADO.NET TestCases] - Find Out How To Use ADO.NET Driver with CUBRID

Guides and Tutorials

[A Simple Query/Retrieve Code]
[Batch Commands]
[Connection Options]
[Connection String]
[CUBRID Collections]
[CUBRID LOBs]
[CUBRID Metadata support]
[CUBRID NHibernate Tutorial]
[CUBRID OIDs]
[DataTable Support]
[Transactions]
[Working With Parameters]
[CUBRID ADO.NET Error Codes and Messages]
Sample
- [How to using the CUBRID ADO.NET Data Provider?]
- [Connect to CUBRID Database]
- [Manage Table]
- [CUBRID ADO.NET Schema Provider]
- [How to add multiple rows of data?]
- [How to calling Java Stored Function/Procedure(C#)?]
- [Using ENUM data type]
ADO.NET MSDN Documentation

Questions and Answers

CUBRID - Open Source Database Management System Optimized for Web

Presentations

Professional Service

Philosophy

Official Django backend for CUBRID Database

[Solved] CUBRID Python: ImportError: libcascci.so.8: cannot open shared object file: No such file or directory

Solution

CUBRID Python Tutorials

Installation Instructions

Latest News

Guides and Tutorials

Questions and Answers

CUBRID Perl Driver Build Guide

Description

Prerequisites

Installation from Source

CPAN installation

Install the latest version of DBD::cubrid

Install a givern version of DBD::cubrid

Manual installation

Support

How to run the multiple tests with different weight

CUBRID ADO.NET Schema Provider

How to using the CUBRID ADO.NET Data Provider?

CUBRID Python Driver Installation Instructions

Requirements

Installation

How to use Django with CUBRID

Overview

Prerequisites

Build and Install

Configure django_cubrid

Known issues

License

CUBRID ADO.NET Tutorials

Latest Announcements

Installation Instructions

CUBRID ADO.NET TestCases

Guides and Tutorials

Questions and Answers