So the
Second Programming Contest CUBRID it! come to an end - time to lower the curtain and announce the winners.
But before that, I propose to briefly summarize the competition.
The competition began on the 1st of June, and participants had 3 weeks to:
- find the most optimized solution for SQL problems in PHP or Java and send them to us;
- spread information about the competition on Twitter, blogs and other sites.
The first 10 places in the competition among the solutions will receive various prizes. 8 most actin in social. User networks will also be awarded with expensive prizes.
')
"Well, and how did it go !?" - you ask. After 3 weeks, we received more than 40 solutions from more than 350 participants from around the world. And what is very pleased, the decisions were of very good quality!
Therefore I want to say to all the participants.
Thank you very much for your diligence and attention to CUBRID !
How were the winners selected?
We knew that selecting winners would not be easy. It turned out to be even more difficult than we expected, mainly because of the large number of correct and high-quality decisions.
How do they usually check so many solutions? The commission usually launches a series of tests and discards everyone whose solutions did not pass the tests. But we went the other way. We decided that even if the solution does not produce the correct output, we must evaluate the quality of the solution itself, the approach, the algorithms used, and the quality of the documentation. For each of these criteria a certain number of points was assumed. As a result, each participant had a certain number of points.
Exactly the assessment of all this delayed the date of announcement of the results.
The result was a list of about 30 participants with quite high points worthy of attention.
Therefore, we decided to increase the numbering of prizes from 10 to 18.
From the list of all participants who submitted their decision, we chose 18 with the highest score.
Before announcing this list, I want to share with some facts of the competition and ask a couple of questions.
- So, the first place was taken by the participant who solved the problem using the capabilities of PHP only. CUBRID was used only to get input and save output. The entire load was traced on the client application. For this, he received the highest score - 92 out of 100.
- There were those who solved the problem using the computing power of the Google infrastructure :). Wow!!!
- One of the winners forgot to provide your username :). Do not worry! We finally found out who it is.
- This is interesting! Java solutions were 3 times more than PHP. They did not expect!
- Question to all: what to do if the participant sends a solution that, well, that's great, works very fast, except that the output does not output in the required format? What advice do we have next time?
- Question to the participants: Did you make sure that your program passes only on those tables that the public user has access to? (This was a requirement.)
- You also tested your solution to work with both CUBRID 8.3.1 and new 8.4.0?
- One of the participants solved the problem using CONNECT BY ! That's cool! (One of the important advantages of CUBRID for processing hierarchical queries, which is not in MySQL. By the way, Oracle also exists! It is very convenient for implementing hierarchical components, such as comments.)
- One of the users decided to sacrifice performance and give a huge amount of output data (to the console). Unfortunately, penalty points pulled down.
- What pleases were the participants who solved the problem in both Java and PHP!
- 95% of the solutions were received in .zip archives, 2% - .rar, 2% - unarchived, 1% - .gz, .tar, etc.
Active users of social. nets
For active participation in the dissemination of information about this competition, we awarded 8x Twitter users. Let me remind you that it was necessary to simply tweet about the competition, about CUBRID, or retweet our
@CUBRID tweets and posts on
Facebook .
Winners of the competition CUBRID it!
The list of the main winners of this programming competition was made up of the following participants. Congratulations!
I also want to highlight three participants: mubinov , Ekstazi and halyavin , who are also Habra users. You are great!
Members | Prizes |
mubinov | iPad 2 !!! |
rafaljaw | Kindle e-book Reader |
iverbitskiy | Kindle e-book Reader |
k.volgin | Nikon camera |
italia-fan | Nikon camera |
Alin.Nedelcu | Amazon Gift Certificate $ 100 |
mcyurdal | Amazon Gift Certificate $ 100 |
artemkv | Amazon Gift Certificate $ 100 |
Mihai Cazacu | Amazon Gift Certificate $ 100 |
eljiudia | Amazon Gift Certificate $ 100 |
Extazi | Amazon Gift Certificate $ 50 |
caoy | Amazon Gift Certificate $ 50 |
haji_armitage | Amazon Gift Certificate $ 50 |
newpcraft | Amazon Gift Certificate $ 50 |
a.grison | Amazon Gift Certificate $ 50 |
halyavin | Amazon Gift Certificate $ 50 |
hnguyendng | Amazon Gift Certificate $ 50 |
oleg.britva | Amazon Gift Certificate $ 50 |
What's next?
And then there will be another competition! Soon I will write about it, but I will give a hint - it will already concern applications. If you already have an application that you are working on, try testing with CUBRID. Maybe it will work with CUBRID without major, and maybe no, changes.
Your feedback
During the entire competition and after, we received various kinds of feedback from the participants. Some sent us their rather interesting ideas for the next competition. We even decided to hold one of them this year. So know that we always listen and really appreciate your feedback.
Below are the clippings from the wishes of several participants.
- "... thanks for this competition and for the opportunity ..." (Claudiu Nita)
- “Thank you for this competition! Next time I would like to see tasks where there will be more SQL. Optimization of SQL queries is the most interesting in such competitions. ”(Mubinov)
- “CUBRID version for Mac OS X - it would be cool even if Mac is not often used for web servers.” (Alexandre Grison)
- “Overall, I am pleasantly surprised at how fast CUBRID is.” (Mihai)
- “The idea of ​​moving the database to another format or cloning it somewhere would be interesting.” (Claudiu Nita)
- “Please make it possible to use variables in the FROM statements in Prepared queries.” (Artemkv)
- “Wonderful competition. I really liked it. Thank you! ”(MC)
- "... I would like to participate in a competition where CUBRID could be used in real-time web applications with a high load." (Alexandre Grison)
And do you, Habra users, have any comments on this?