Category: analytics

  • How to check if you respect web design standards and best practices?

    , ,

    webmaster desktop (Photo credit: FSA 2006-07) Do you know how to check if your web page respect web design standards and best practices? If no, the following web page provides a great checklist, which permits you to verify (or discover) if you have designed your website correctly:  http://webdevchecklist.com/ It may be a good idea too…

  • How to configure Django with PostgreSQL?

    ,

    In this post, I will explain you how to configure Django with PostgreSQL instead of MySQL. I did several changes locally before deploying my app to heroku and Amazon S3. I changed my configuration to use postgreSQL instead of mySQL. I did not have any data stored in MySQL, so I reinitiated a brand new…

  • How to know the size (number of row/records) of a mysql database?

    ,

    In this post, I will show you how to know the size (number of row/records) of a MySql database. I wanted to host an app on heroku. They offer free database for up to 10000 rows. So, I needed to know if my database fits into that limit… $ mysql -u root -p mysql> use…

  • How to migrate Django from Mysql to south (the radical way)?

    database (Photo credit: Sean MacEntee) I am new to south, and I made some mistakes with it. Fortunately, my database does not contain important data and I can recreate it from scratch. So let’s do it. mysql -u root -p> show databases;> use my_db> show tables; Then i drop my web app‘s tables (and not…

  • A first tutorial to learn Basic sql commands – SQL cheatsheet

    , ,

    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

    ,

    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…