Monthly Archives: July 2014

CSV import for MySQL and MongoDB

Posted on July 24, 2014 by buminda

1. For MySQL LOAD DATA INFILE ‘xxxxx_csv_file’ INTO TABLE table_name FIELDS TERMINATED BY ‘,’ ENCLOSED BY ‘”‘  LINES TERMINATED BY ‘\r\n’ IGNORE 1 LINES; * create the table_name table. * make sure to copy the csv file to /var/lib/mysql/db_name/ with correct permission … Continue reading →

Posted in CSV, MongoDB | Tagged , | Leave a comment

Common web application threats

Posted on July 17, 2014 by buminda

Threat Measures SQL Injection : Appends existing SQL of the application , and generate unexpected queries. Avoid dynamically generated queries. ( use parameterised queries ). Always use properly tested libraries to access DB. OS Command Injection : Change applications OS … Continue reading →

Posted in web security | Leave a comment

What’s new in Ubuntu Server 14.04 LTS?

Posted on July 12, 2014 by buminda

What’s new in Ubuntu Server 14.04 LTS?

Posted in Uncategorized | Leave a comment

MVC with AngularJS

Posted on July 9, 2014 by buminda

  1. When you start the application , it parses the markups or tags using the compiler. 2. The DOM generated after parsing is the View . 3. <ng-app/> is the directive that initializes the application. 4. The <ng-model/> directive … Continue reading →

Posted in AngularJS | 1 Comment