CUBRID Contributions Project

One of the many ways to help the CUBRID project is to help with developing tools that cover some areas where we don’t yet have enough support available, either built-in or via third-party tools.

The CUBRID Contributions Project is intended to provide an organized framework for contributors by:

Providing a list of fields which need contributions
Monitoring the status of assigned contributions
Providing support and publishing resources
And encouraging contributors by handing prizes to the most valuable contributions, on a regular basis!

Users are encouraged to contribute to various areas too:

The database engine
The API libraries
Develop applications which support CUBRID as the back-end database
Create and Publish tutorials, source code demos
Etc.

Existing projects:

CUBRID Trigger Audit

http://sourceforge.net/projects/triggeraudit/

CUBRID WebShell

http://sourceforge.net/projects/cubridwebshell/

Cubrid Database Schema

http://www.cubrid.org/cubriddbbschema

CUBRID Mobile Browser

The following are the proposed projects users are encouraged to work on.

Encrypt/Decrypt Java Stored Procedure

Description:

Currently, we do not have built-in support to encrypt data in the database.The project is intended to create a Java stored procedure which users can CALL to encrypt/decrypt data programmatically.

Programming language:

Java

Estimated effort:

Depends on the algorithms used to encrypt/decrypt data.

CUBRID Database Documentation Tool

Description:

We are missing now a tool which is capable of generating a database documentation. Such documentation would cover at minimum:

Tables
Column names
Whether the column is a primary key
Column data types
Column lengths
Column names
Views
Column data types
Column lengths
Stored Procedures list
Functions list
Triggers list

Programming language:

Java or PHP

Estimated effort:

10 days

Database Diff tool

Description:

There are many open source applications which already implement diff tools for databases. For example, there are many on SF http://sourceforge.net/search/?q=database+diff. What we need is to have a diff tool compatible with CUBRID.

Programming language:

Java

Estimated effort:

20-30 days

Import/Export data in XML

Description:

We would like to have a tool which will allow users to export/import data from/in a database, using an XML storage format. Preferably, the XML format will be the same as the one used by MySQL. See http://dev.mysql.com/tech-resources/articles/xml-in-mysql5.1-6.0.html

Programming language:

Java or PHP

Estimated effort:

5-10 days

Database Search tool

Description:

We would like to have a tool similar to grep in a concept, but which would allow users to search for data in a CUBRID Database. The tool should be able to:

Search for tables data
Search for aggregated data: Views data
Accept various input search parameters, like the data types, case etc.
Accept regular expressions

Programming language:

Java

Estimated effort:

10 days

PHP Application Generator

We need to provide better support for the developers who would like to start developing applications for CUBRID. This project is about providing a tool capable of generating automatically the PHP code to deal with:

Database connection
Tables data CRUD operations
Data paging and filtering
Etc.

For example, consider these MySQL tools:

Programming language:

PHP

Estimated effort:

10-15 days

Java Application Generator

We need to provide a better support for the developers who would like to start developing applications for CUBRID. This project is about providing a tool capable of generating automatically the Java code to deal with:

Database connection
Tables data CRUD operations
Data paging and filtering
Etc.

For example, consider these MySQL tools:

Programming language:

Java

Estimated effort:

10-15 days

Notes

All the projects must be released under the GPL or BSD license.

If a project includes any third-party source code, the project developers must verify that the code can be released under the GPL or BSD license.

The projects must comply with the coding best practices used in CUBRID developments.

The projects must include a help documentation and usage examples.