Category: Big data

A first tutorial to learn Basic sql commands – SQL cheatsheet

November 8, 2012

ad-tech, analytics, Big data

You can enter the mysql console with: mysql -u root -p Then you can select a database show databases;use my_db; Then you can see the tables show tables; To see the content of a given table: select * from my_table; To add a column named ’email’ to the table ALTER TABLE table_name ADD email…
Discovering django on Debian – part 2: configuring django databases

November 7, 2012

analytics, Big data

MySQL (Photo credit: Wikipedia) In the previous Django tutorial, we left when a website run locally. Now, we will fill it with content. As always with python, we do not like to repeat ourselves. So if our website has several pages with common information elements, we will not repeat them. Instead, we will store all…