posted 5 years ago in News category by Esen Sagynov
Today I would like to start this blog stating that there are so many great improvements being achieved by our CUBRID Community every day. I am just amazed by how hardworking are the developers. Below I have prepared a brief summary of what we achieved this month.
After CUBRID 3.0 has been successfully released this month, we moved on with version 3.1. development which will introduce new data types in CUBRID such as BLOB and CLOB. These will allow developers to store byte or character data in a separate location and reference to them from withing the tables in CUBRID Database. So, today we have successfully completed the testing process of CUBRID 3.1 which revealed no issues. We plan to release the new version next month.
Another positive activity going on here is that we decided to move CUBRID Manager, the main GUI-based database administration tool for CUBRID, to SF.net (https://sourceforge.net/projects/cubridtools/) and continue its development as a separate project. This will allow us to develop the two projects independently and avoid lingering one of them due to the delays in the second project. This will also allow us to faster locate the issues and release the new updates.
This month we have successfully released the CUBRID Migration Toolkit, a software tool which allows to migrate user data from MySQL to CUBRID database server in several unbelievably easily steps. This is a really powerful and must-have tool to DBAs. The data and schema in the source database can be as sofisticated as possible. CMT provides the default settings to cast native MySQL data types to native CUBRID data types. If it is necessary to have the destination column data type different from the default settings, it can be easily customized before the migration process starts.
From the same category, the CUBRID WebQuery has also been released this month. This is an open source, lightweight and intuitive web-based database management tool originated from the well known SQL Buddy. We have updated it, optimized it for CUBRID and enriched with new features. The key difference of WebQuery is its usage of AJAX. Users do not have to wait for the whole page to reload when trying to simply add a new record into a table. WebQuery will fetch just the content that has changed and display it to the user without refreshing the page. It is lightweight, easy to install, easy to learn and use.
Now the good news for Ruby developers. We have accomplished the development of Ruby Active Record Adapter for CUBRID. It follows the general Active Record syntax and allows users to perform the database operations in Ruby using the common Object-Relational Mapping rules. See Using Ruby Active Record with CUBRID for examples. Download Ruby Active Record Adapter for CUBRID and enjoy the ease of Ruby development.
We cannot leave the PHP developers without a candy. We have good news for them too. PHP PDO Driver for CUBRID is now completed. This is a driver that implements the PHP Data Objects (PDO) interface to enable access from PHP to CUBRID databases. Now the developers who have applications which use the PDO interface can use CUBRID Migration Toolkit to easily move their data to CUBRID and enjoy its increased performance. See Why Use CUBRID for more information. The PHP PDO Driver for CUBRID will be available next week through PHP PECL repository. Moreover, we have released the new version for PHP Extension as well, which is already available from PECL. Visit PHP Programming with CUBRID for more information.
Many users have asked us to provide more materials to learn CUBRID. We heard you all, and this month we worked hard to create more manuals and more tutorials for you. The featured articles explain how to use WebQuery, Ruby Active Record, Hibernate and ADOdb Lite with CUBRID. More tutorials can be found at http://www.cubrid.org/tutorials.
One of the most important achievement of this month is the official release of Joomla for CUBRID. Since the Release Candidate we have worked hard to make Joomla for CUBRID package more stable and more optimized. And today I am incredibly happy to announce one more news that now Joomla works faster with CUBRID Database than with MySQL. I will do my best to publish the test results next week and let all Joomla fans, like myself, see how faster their websites could run if CUBRID is used as the back-end database system.
This is the great work of this month. Stay tune and be happy!