Scraping Data From Wikipedia

Web Scraping Data For Hollywood Actors/Actresses Info A friend of mine and I were discussing about the divorce rate/trends of Hollywood actors. Basically she was claiming that most of the actors have multiple wives and have gone through divorce in Hollywood. I was not so much in agreement and so came this project. I created […]

Read More

Wonderful Opportunity for Software Engineers around the world

Wellington, the capital of New Zealand is welcoming 100  of the best people from around the world to work in their tech companies. The capital is a hot spot for innovative and leading tech companies and now they are creating a wonderful platform for employers to hire people from around the world. It’s a great […]

Read More

Are you ready to work as a SQL Developer?

A SQL Developer is responsible for managing data in a relational database. Database Providers like Microsoft, Oracle and MySql have their own IDE for managing data. For example Microsoft has SQL Server Management Studio for this purpose and Oracle has Oracle Developer Studio. A SQL Developer makes use of these IDEs for managing data. Today […]

Read More

Notes on Spring.NET DAO Code Configuration

In this short article, we will look at how Dependency Injection for Data Access Objects can be implemented using Spring.NET. “Data Access support in Spring is aimed at making it easy to work with data access technologies like ADO.NET and Nhibernate in a standardized way.”- Spring.NET First an interface that exposes the methods that can […]

Read More

Connecting to SQL Server using RODBC package in R

RODBC is a useful package for making SQL queries to SQL Server database for R users. To start using this package, first we need to make sure it is loaded into R studio. is.installed <- function(mypkg) is.element(mypkg, installed.packages()[,1]) if(!is.installed(‘RODBC’)) { install.packages(“RODBC”) } library(RODBC) Now that the package is installed/loaded into our environment, let’s start making […]

Read More

Uploading Unknown Format Excel File To A SQL Database

Introduction Usually it is expected from client side to upload only structured Excel sheets (sheet with defined Column Names and data types for Rows) to load to server. But sometimes you might also require to dump whatever is in the Excel directly to your database. While there is a tool that is provided by SQL […]

Read More

Xamarin Web View

Introduction to Xamarin Cross Platform app development with WebView.

Read More

Youtube Crawler

Here’s a web crawling script to crawl videos from Youtube: https://github.com/psovit/yt_crawler.git The script is written in Python’s Scrapy framework and can be used for finding full list of videos easily by various filters like ‘keyword’, ‘view count’, ‘channel’, ‘votes’ etc. easily. Feel free to clone/fork/modify and let me know if you need any help running […]

Read More

Daily Reflection

Daily Reflection is designed to draw your attention towards internal movement within yourself. A collection of thought provoking questions aimed to raise your level of awareness. Use this app daily towards the end of each day to reach to your contemplative state of mind. Reflect daily upon these questions to bring more awareness in your […]

Read More

Post on ASP.NET Web API

Here are links to my two other posts which were published on TutsPlus. Introduction to ASP.NET Web API Securing the Web API You can find the full code in my git repo. Thanks!        

Read More