Blog

How to write a Secure API

By Robby 0 Comment December 4, 2017

All API Request must contain the below points You must send all API request in the POST Method and also check that all API Requested in the POST Method in server Side. API must be hosted in Sub-Domain and should be an HTTPS. The API Domain should not be crawl by Google or any other services. In each […]

Razorpay Intro

By Robby 0 Comment October 10, 2017

Razorpay A quick and brief intro about Razorpay payment gateway. For why you choose Razorpay from Robert Robinson

Nodejs crud using Mysql

By Robby 2 Comments August 26, 2017

I have created a sample and basic crud operation using Nodejs with express js  https://github.com/Robertrobinson777/Nodejs-crud Download a project and type a command npm install Then SQL file is in project (student.sql) Change the user, passowrd, database name in app.js node app.js The project will run in http://localhost:7000/

Find a Median in Tables

By Robby 0 Comment July 13, 2016

The simplest query to find the Median SELECT x.val from table x, table y GROUP BY x.val HAVING SUM(SIGN(1-SIGN(y.val-x.val))) = (COUNT(*) +1)/2