Showing posts from 2017

MySQL connect utility in Mac OS

Using DbVisualizer, we can connect to MySQL database on Mac.
Download the installer (select appropriate Platform & Installer Type) here
DbVisualizer offers setup for following platforms:-
Windows 32 bitWindows 64 bitMac OS XLinuxUNIX

Play youtube video in iOS app

Youtube video can be played in iOS app using webview. MPMoviePlayerController is not able to open youtube video automatically. Integrate the below script to show thumbnail, clicking on it the video will play in full screen.

NSString *url = @""; NSString* embedHTML = @"\     <html><head>\     <style type=\"text/css\">\     body {\     background-color: transparent;\     color: white;\     }\     </style>\     </head><body style=\"margin:0\">\     <iframe id=\"yt\" src=\"%@\" type=\"application/x-shockwave-flash\" \     width=\"%0.0f\" height=\"%0.0f\" frameborder=\"0\" feature=player_detailpage allowfullscreen></iframe>\     </body></html>"; NSString* html = [NSStringstringWithFormat:embedHTML, url, self.view.frame.size.width, 200.0];
    [webviewloadHTMLString:html baseURL:nil];

Working with MongoDB

Generate a new SSH key ( If you have already ssh key generated at mac, then copy the key using:-
pbcopy < ~/.ssh/
Pass the key to your server developer (DevOps). He will give access to a server, for eg: he add your key, then open the terminal and type command:- ssh root@ You will see this in terminal:-The authenticity of host ' (' can't be established. RSA key fingerprint is SHA256:supbA7wsdvc3xXnVyHvj7fXGjlpCpt1kigJrljR4. Are you sure you want to continue connecting (yes/no)? Enter yes Enter your server addresss ( in your browser and it connects and start working. Mongo official reference for queries:-