posted 3 years ago in News category by Esen Sagynov
Greetings to everyone!
Today we have several good news we would like to share with all of you! Most of the times we post the latest activities of our community through Twitter and Facebook. So make sure you follow us. For the last two months there have been quite an impressive amount of work accomplished at CUBRID Community. We have pushed the CUBRID gem to RubyGems.org, updated our tutorials for JDBC & Java Programming, released the Python Connector, published PHP API to Official PHP.net PECL Repository, released the CUBRID 3.0 Beta, and started Joomla CMS porting. Let's see in more details...
CUBRID account at RubyGems.org was created on July 11th, 2010. The CUBRID Connector testing has been started since then. Windows OS compatible cubrid-0.6-x86-mswin32-60.gem was first pushed to RubyGems.org on July 11th. Later on July 27th with slight changes in the extconf.rb gem installer file the cubrid-0.61-x86-mswin32.gem has been refreshed. Then, we have created the detailed tutorial and API documentation for the Connector. And finally announced to the community about these changes.
Later we received some user comments to host the CUBRID-Ruby source code on Github. After some conversation we decided to create Github account and upload the source code of the connector. On August 9th, 2010 we pushed cubrid-0.64.gem to Rubygems.org which is now cross-platform, i.e. can be installed both on Linux and Windows. Use the following command in the terminal to install the CUBRID gem for Ruby.
The main database connector for CUBRID is the JDBC Driver. Most external applications like CUBRID Manager connect to CUBRID through JDBC. To help users get started with Java Programming for CUBRID faster, we have created a tutorial with several detailed examples users can just copy and paste to get them up and running. Beside that there are numerous other manuals and documentations CUBRID users can refer to when building applications around CUBRID.
Python Programming with CUBRID
Python is an established programming language. It has been used by many professional web developers worldwide to create sophisticated web applications. Now Python developers can use the CUBRID-Python Connector to create the Web applications which use CUBRID as a back-end database management system. We encourage users to download the Python Library and read the API Documentation and Tutorial.
CUBRID API on PHP.net
This is probably one of the most important moves we make toward making the CUBRID Database more open to global users. We have contacted with the PECL members and received the approval for a new account for CUBRID. After several comments from PECL users we have made quite a lot modifications to the PHP API for CUBRID. Entire code has been reviewed and rewritten to comply with latest Zend Engine 2 API.
- Added more than 20 new APIs, see the PHP API Documentation for more details.
- Added two new schema types for cubrid_schema: CUBRID_SCH_DIRECT_SUPER_CLASS and CUBRID_SCH_PRIMARY_KEY.
- More data types support for cubrid_bind, the following types are added: CHAR, VARCHAR, BIGINT, MONETARY, VARBIT and DATETIME.
- Fix a bug in cubrid_get: If parameter attr is given and its type is string, and the function returns successfully, then there will be memory leak.
On July 19th, 2010, we have announced the latest CUBRID 3.0 Beta release. Overall we have fixed 42 bugs, and introduced 62 new SQL syntax extensions and other enhancements. Now users can leave most of their MySQL compatible SQL statements as they are without any modifications. With CUBRID 3.1 and 3.2 we plan to reach 95% MySQL syntax compatibility, thus providing users not only the increased performance but also the ease of porting their Web applications to CUBRID. As a matter of fact, we have started porting the most popular Content Management System in the world - the Joomla! CMS. Below you can see the current status and the brief explanations about how we leverage the CUBRID MySQL compatibility and optimizations for Web applications to make Joomla CMS porting faster and easier.
Porting Joomla! CMS to CUBRID
These days we are porting the most popular content management system – the Joomla! CMS. Until now none of other database system providers managed porting Joomla to seamlessly work with their system. Previously there were attempts by Postgres and MS SQL communities but stalled before reaching the implementation phase, while Joomla porting for CUBRID already has the feasible results. We estimate that by the end of this month we might have the Joomla alpha release for CUBRID. The project contributors mention that Joomla will have higher performance on CUBRID because of CUBRID's numerous Web optimizations. At this moment we have completed several large tasks like SQL parsing, Joomla Installer. Only a few details remained to get polished. Hope soon we will have another tool to make our users even happier!
You can join the discussions forum of Joomla for CUBRID at SF.net