Category: Technology

Install ERPNEXT in Ubuntu

By Robby 0 Comment May 9, 2019

Step 1:Removed all mysql and maria db package using apt-get remove. $ sudo apt-get purge mysql* $ sudo apt-get autoremove $ sudo apt-get autoclean $ sudo apt-get install mariadb-server Restart mysql $ /etc/init.d/mysql start Step 2: https://github.com/frappe/bench#easy-install$ wget https://raw.githubusercontent.com/frappe/bench/master/playbooks/install.py $ sudo python install.py –develop Bench will be installed successfully but it will say ERPNext installed […]

Free Web hosting for Students or hobby

By Robby 1 Comment April 26, 2018

1.Hosting.India.To Free 1 GB Linux Hosting Features 1 GB Web Space 1 GB /month Bandwidth 5 Email Addresses 1 MySQL Database 1 Subdomain & FTP Account 2.Googiehost FREE WEB HOSTING Features 1000 MB storage Unlimited bandwidth 2 Email Addresses 2 FTP Account Website Builder (TRIAL) Auto Installer SEO Tools CDN (Cloud Flare) Monthly Backup Forum […]

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 0 Comment 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