How to Hire Ninja Coders Without Visiting the Silicon Valley?
Hiring people is difficult, and hiring coders, especially ninja coder is even more than difficult! But who is a Ninja coder?
They are known as the developer polyglots who don’t limit themselves to one language. Instead, they have a base programming language and are comfortable working with other coding languages as well. A ninja coder is skilled enough to navigate through various languages and databases in order to solve every possible technical challenge.Continue reading →
Last week I stumbled upon livecoding.tv – a website that teaches students coding live. Here is how it works: Developers stream live video and users can ask questions and provide feedback.
You can teach yourself almost anything. Currently, the site has tutorials about Python, Java, Ruby, C, C++, C#, WordPress etc. etc.
Using a free account you can view live videos and chat with members. If you want more support or want to create your own private channel then you can sign up for a pro account which cost around $10/m. Overall the site is excellent not only for beginners but for skilled professionals who want to sharpen their skills. So what are you waiting for ? Go ahead sign up and start streaming.
Up until now we have been using fetchall() method of cursor object to fetch the records. This process of accessing all records in one go is not every efficient. As a result MySQLdb has fetchone() and fetchmany() methods of cursor object to fetch records more efficiently.
This method returns one record as a tuple, If there are no more records then it returns None
This method accepts number of records to fetch and returns tuple where each records itself is a tuple. If there are not more records then it returns an empty tuple.
In the previous post we have seen how to execute sql queries using execute() method. execute() method returns affected rows, it doesn’t return the result. To fetch result we use the fetchall() method of the cursor object
MySQLdb is an api for accessing MySQL database using python. It is built on top of MySQL C API.
MySQLdb don’t yet have support for python 3, it supports only python 2.4 – 2.7 . As a result you need to use python 2 for this tutorial. We will be using python 2.7.9, which you can download from here. Continue reading →