Varun Bansal’s weblog

1. Moving existing table from one engine to another-

ALTER TABLE table_name ENGINE=engine_name;

Engine names could be -> InnoDB, MyISAM

For further reference, browse thru "A fast and furious guide to MySQL database engines"

2. "MySQL Indexs" a glimpse.

3. Creating Full Text index and playing with it "How it works"

4. Creating Full Text index on an existing table-

CREATE FULLTEXT INDEX index_name ON table_name (column_names);

5. Implementing Full Text search in Django using MySQL - "Extending Django's database API to include full-text search"

Loading mentions Retweet

The following code snippet in SQL is occasionally used by me and I tend to forget the basic syntax or the same.

So here it is, just for reference for future use.

How to backup database in mysql:

Mysqldump –u username –p database_name > dump.sql

Loading mentions Retweet

In order to the save some extra information about a user,  you will need to extend the standard User object.

Go through the following set of links to get a deeper insight into extending User object in Django:

1.       A good explanation from Django Book @ http://www.djangobook.com/en/beta/chapter12/

2.       django-profiles project by James Bennett @ http://bitbucket.org/ubernostrum/django-profiles/wiki/Home

3.       http://shityoucantremember.wordpress.com/2009/02/14/unriddling-the-django-user-profile/

4.       http://www.amitu.com/blog/2007/july/django-extending-user-model/

5.       Displaying custom user profile in django admin http://www.thenestedfloat.com/articles/displaying-custom-user-profile-fields-in-djangos-admin

6.       http://wolfram.kriesing.de/blog/index.php/2007/extend-djangos-user-class

7.       http://www.codekoala.com/blog/2009/quick-django-tip-user-profiles/

8.       http://www.codekoala.com/blog/2009/quick-django-tip-user-profiles/

Loading mentions Retweet

Test mail

Loading mentions Retweet

I have recently quit from my first employers after a 2.5  years stint @ Infy Hyderabad.

Now working full time on a new venture with another friend. Looks like the archetypal

two guys in a garage, isn’t it? Well, sort of, but we are both put up in different cities of

India, ma frnd working frm Hyderabad and myself from nOiDa.s

Loading mentions Retweet

Visiting Bangalore to attend Pycon India 09 conference. First of its kind for py developers in India.

Flying on 25^th to Bangalore and would be returning on the 28^th.

Recently tried my hands on python and found it pretty easy to pick up for any starter.

Hope to gain some insight into the vast py world and also network with some experienced py

Developers from India.

Loading mentions Retweet

Hi everyone

This is my very first post @ posterous. I dropped down at this wonderful site by chance.

Loading mentions Retweet