EllisLab text mark
Advanced Search
2 of 2
2
   
CUBRID Database Support
Posted: 09 August 2011 12:49 AM   [ # 16 ]   [ Rating: 0 ]
Joined: 2011-01-19
22 posts

Hi,

Here is the complete CUBRID Driver classes for CodeIgniter 2.0.2. The archive contains:

codeigniter-cubrid-driver.zip\
-database.php
-cubrid\
--cubrid_driver.php
--cubrid_result.php
--cubrid_forge.php
--cubrid_utility.php
--index.html 

1. Place the database.php file under the \application\config\ directory and make appropriate adjustments for the DB connection.

2. Place the cubrid\ driver directory under the \system\database\drivers\ directory.

Now it should be ready. Before launching you web app make sure:

- you have started the CUBRID Service (cubrid service start)
- you have started the database(s) you plan to use (cubrid server start db_name).

You are more than welcome to test this CUBRID Driver. If you encounter any issues, please report them here. I will do my best to fix them.

 
Posted: 10 August 2011 04:00 AM   [ # 17 ]   [ Rating: 0 ]
Joined: 2011-01-19
22 posts

Just in case, here is the configurations necessary to establish DB Connection with CUBRID.

$db['default']['hostname''localhost';
$db['default']['port''33000';
$db['default']['username''dba';
$db['default']['password''ci_pass';
$db['default']['database''ci_demo';
$db['default']['auto_commit'TRUE;
$db['default']['dbdriver''cubrid';
$db['default']['dbprefix''tbl_'

1. port parameter represents the port of the CUBRID Broker. By default it is 33000. To check which one is yours, run the following command. This assumes that your CUBRID Service is running.

cubrid service status 

should output something like:

cubrid master status
++ cubrid master is running.
cubrid server status
 Server ci_demo 
(rel 8.4pid 5042)
cubrid broker status
  NAME           PID  PORT  
AS  JQ      REQ  TPS  QPS    LONG-T    LONG-Q  ERR-Q
================================================================================
query_editor  5007 30000   5   0        0    0    0    0/0.0    0/0.0      0
broker1       5017 33000   5   0       12   10    4    0/0.0    0/0.0      0
cubrid manager server status
++ cubrid manager server is running

As you can see the CUBRID Broker (broker1) is listening to port 33000.

2. Also you can set the auto_commit parameter to FALSE which will allow you to run your Web app in dry mode, i.e. all INSERTs to the DB will not be committed.

If any questions, feel free to ask.

 
Posted: 26 August 2011 04:39 AM   [ # 18 ]   [ Rating: 0 ]
Joined: 2011-01-19
22 posts

CUBRID Driver for CI has been committed. Read this blog where I tried to cover the driver development.

 
Posted: 08 February 2012 01:30 AM   [ # 19 ]   [ Rating: 0 ]
Joined: 2011-01-19
22 posts

First of all, thanks to CI team for having accepted CUBRID Driver for CI. Second, the new CUBRID 8.4.1 database server is available now with over 70% performance improvement. The new release brings lots of new features and improvements to SQL compatibility with MySQL.

I have already ran preliminary tests with CI checked out the latest code from Github and CUBRID 8.4.1. I can say that so far all works as with 8.4.0.

Nevertheless, I plan to update the driver. The new 8.4.1 PHP API has many improvements and support for MySQL’s PHP API, as well as persistent connection on API level. Once completed I will send a pull request as before and will update this forum. Anyone willing to help me will always be welcomed!

 
2 of 2
2