Web Application Developer

My current profile is Project Manager, Team Lead & Core Developer. &: Full Stack Web Developer, expert in developing high stability web applications to service workers/bots to automate jobs. Also experts in setting up multi-clusters high end web servers for various type of applications. Having strong programing skills with Python, Django, Virtual Env, PHP, Yii, PostgreSQL, MySQL, Nginx, Virtual Machines, DNS Setup, Firewalls, Application Security, Software Testing, I18/N10, JSON+LD + Accessibility, AMP, Google Tag Manager, HTML 5 + CSS3, jQuery, etc.

[vinaykrsharma]

Tesla To Set Up Electric Car Manufacturing Unit In Karnataka, India

Elon Musk's Tesla Inc will set up an electric-car manufacturing unit in Karnataka, India. According to Karnataka's Chief Minister BS Yediyur

[vinaykrsharma]

Honda CB350 RS Launched | Engine, Price, Features- Stunning Autos

Honda Motorcycle has launched the new Honda CB350 RS in India. It is a modern classic motorcycle and is based on the same platform as the Honda H'Ness CB 350.

[vinaykrsharma]

Top 5 head turner SUV cars in India 2021 - Stunning Autos

Top 5 head turner SUV cars in India 2021. The cars now will serve as a head-turner, along with its primary function of transportation.

[vinaykrsharma]

Tata Safari takes on the Mahindra XUV500 in a drag race: Who will win?

All-new Tata Safari takes on the Mahindra XUV500 in a drag race: Who will win? The Tata Safari has a unique place in the Indian market which was recently discovered and Mahindra XUV500 is one of the successful SUVs that the manufacturer ever built

[vinaykrsharma]

New Jawa 42 v2.1 2021 launched new features, colors, price - Stunning Autos

Jawa bike introduced Classic java 42 version 2.1 in India at Rs 1,83,942 (ex-showroom, Delhi). The Java 2.1, an upgraded version of Java 42 that was the BS6-compliant model launched last year.

[vinaykrsharma]

2021 Suzuki Hayabusa Estimated Price, Launch Date - Stunning Autos

The 2021 Suzuki Hayabusa is one of the most-awaited superbikes. The latest version of the iconic Dhoom bike is all set to arrive around the second half of March 2021

[vinaykrsharma]

Renault Kiger SUV Launch: Price, Features, Design - Stunning Autos

Kiger is a beautiful SUV by Renault, finally launching its long-awaited compact SUV in the Indian domestic market today.

[vinaykrsharma]

Hyundai Tiger X1 UMV: ROLL, RUN, FLY | Ultimate Mobility Vehicle

Hyundai has developed Tiger X1 UMV that can roll, run and fly. It is the world’s first transformer-class vehicle, also known as the Ultimate Mobility Vehicle

[vinaykrsharma]

Ubuntu: How to fix if screen brightness is not working

(adsbygoogle = window.adsbygoogle || []).push({ google_ad_client: "ca-pub-2506679117428139", enable_page_level_ads: true });

Recently I bought a new Dell Inspiron 3521 and Installed Ubuntu 13.10. Then I seen a minor issue it was screen brightness was not working. But in Try Ubuntu mode screen brightness was working well.

It may be your machine having same issue. So, lets go to fix this problem. Here is the solution I found some where:

First open /etc/default/grub:

$ sudo nano /etc/default/grub

In /etc/default/grub around line 12 there could be a line with written this:

GRUB_CMDLINE_LINUX=""

If found then change it as below line or if not then paste the below line:

GRUB_CMDLINE_LINUX="acpi_backlight=vendor"

Now save changes by pressing Ctrl+O then Enter Key

That's it, you have done

But you should update Grub to apply changes. So also do this:

$ sudo update-grub

And what? Restart you machine.

[vinaykrsharma]

How to find date interval in JavaScript

(adsbygoogle = window.adsbygoogle || []).push({ google_ad_client: "ca-pub-2506679117428139", enable_page_level_ads: true });

var get_date = function(interval) { // Get current time var now = (new Date).getTime(); // Check if interval has some value if(!isNaN(parseInt(interval))) { now += parseInt(interval); } // Initialize date object var today = new Date(now); var yyyy = today.getFullYear(); var mm = today.getMonth() + 1; var dd = today.getDate(); var hh = today.getHours(); var ii = today.getMinutes(); var ss = today.getSeconds(); // Lead 0 if month is less than 10 if(mm < 10) { mm = '0' + mm; } // Lead 0 if day is less than 10 if(dd < 10) { dd = '0' + dd; } // Lead 0 if hours is less than 10 if(hh < 10) { hh = '0' + hh; } // Lead 0 if minutes is less than 10 if(ii < 10) { ii = '0' + ii; } // Lead 0 if seconds is less than 10 if(ss < 10) { ss = '0' + ss; } return yyyy + '-' + mm + '-' + dd + ' ' + hh + ':' + ii + ':' + ss; }

if(get_date===undefined) { var get_date = function(interval) { // Get current time var now = (new Date).getTime(); // Check if interval has some value if(!isNaN(parseInt(interval))) { now += parseInt(interval); } // Initialize date object var today = new Date(now); var yyyy = today.getFullYear(); var mm = today.getMonth() + 1; var dd = today.getDate(); var hh = today.getHours(); var ii = today.getMinutes(); var ss = today.getSeconds(); // Lead 0 if months is less than 10 if(mm < 10) { mm = '0' + mm; } // Lead 0 if days is less than 10 if(dd < 10) { dd = '0' + dd; } // Lead 0 if hours is less than 10 if(hh < 10) { hh = '0' + hh; } // Lead 0 if minutes is less than 10 if(ii < 10) { ii = '0' + ii; } // Lead 0 if seconds is less than 10 if(ss < 10) { ss = '0' + ss; } return yyyy + '-' + mm + '-' + dd + ' ' + hh + ':' + ii + ':' + ss; } }

Now use the function above to add interval to current date:

// Get current date console.log(get_date());

document.write('Result: ' + get_date());

// Add one day to current date var interval = 86400000 * 1; console.log(get_date(interval));

document.write('Result: ' + get_date(86400000 * 1));

// Similarly add 20 days to current date var interval = 86400000 * 20; console.log(get_date(interval));

document.write('Result: ' + get_date(86400000 * 20));

// Subtract 20 days to current date to past date var interval = 86400000 * -20; console.log(get_date(interval));

document.write('Result: ' + get_date(86400000 * -20));

[vinaykrsharma]

Find last 10 days records even some days is missing between

(adsbygoogle = window.adsbygoogle || []).push({ google_ad_client: "ca-pub-2506679117428139", enable_page_level_ads: true });

Here I'm selecting last 10 days records from transaction table even there is some days has no any transaction.

SELECT * FROM `transaction` `t` WHERE DATE(`t`.`timestamp`) < ( SELECT DATE(`s`.`timestamp`) FROM `transaction` `s` GROUP BY DATE(`s`.`timestamp`) ORDER BY DATE(`s`.`timestamp`) DESC LIMIT 10,1 ) ORDER BY `t`.`timestamp` DESC

SAMPLE: Results will be only for previous date:

/*<![CDATA[*/ var getDate = function(interval) { now = (new Date).getTime(); if(!interval) { interval = 0; } var today = new Date(now + interval), yyyy = today.getFullYear(), mm = today.getMonth() + 1, dd = today.getDate(); if(mm < 10) { mm = '0' + mm; } if(dd < 10) { dd = '0' + dd; } return yyyy + '-' + mm + '-' + dd; } var interval = 86400000; document.write(getDate(interval * -1) + ' '); document.write(getDate(interval * -2) + ' '); document.write(getDate(interval * -4) + ' '); document.write(getDate(interval * -7) + ' '); document.write(getDate(interval * -8) + ' '); document.write(getDate(interval * -9) + ' '); document.write(getDate(interval * -11) + ' '); document.write(getDate(interval * -12) + ' '); document.write(getDate(interval * -13) + ' '); /*]]>*/

  And for next 10 days records just change < to > for matching criteria as:

SELECT * FROM `transaction` `t` WHERE DATE(`t`.`timestamp`) > ( SELECT DATE(`s`.`timestamp`) FROM `transaction` `s` GROUP BY DATE(`s`.`timestamp`) ORDER BY DATE(`s`.`timestamp`) DESC LIMIT 10,1 ) ORDER BY `t`.`timestamp` DESC

[vinaykrsharma]

Searching for HTML content slider?

(adsbygoogle = window.adsbygoogle || []).push({ google_ad_client: "ca-pub-2506679117428139", enable_page_level_ads: true });

Here I found a Cool and Fully customizable carousel which full fills our each type of requirements.

If you are using this then there is no any option to find other carousel. This fits with our every need.

This is carouFredSel.

jQuery.carouFredSel is a plugin that turns any kind of HTML element into a carousel. It can scroll one or multiple items simultaneously, horizontal or vertical, infinite and circular, automatically or by user interaction. Oh, and it's responsive too.

Also find cool carousels built with carouFredSel. Here is lots of carousel which completes our any type of requirements.

Cool Carousels

Good Luck.

[vinaykrsharma]

How to find Database size?

(adsbygoogle = window.adsbygoogle || []).push({ google_ad_client: "ca-pub-2506679117428139", enable_page_level_ads: true });

Here I found some important query to find database and table sizes. Execute the below SQL script to list out the entire schema/database size:

MySQL

Find entire databases and sizes

SELECT `table_schema` AS "Database", (SUM( `data_length` + `index_length`) / (1024 * 1024)) AS "Size(MB)" FROM `information_schema`.`TABLES` GROUP BY `table_schema`;

Find size for a single schema/database

SELECT SUM(ROUND(((data_length + index_length) / 1024 / 1024),2)) "Total Size(MB)" FROM `information_schema`.`TABLES` WHERE `table_schema` = "";

Find size for all table in a single schema/database

SELECT `TABLE_NAME` , `table_rows` , `data_length` , `index_length` , ROUND(((data_length + index_length) / 1024 / 1024),2) "Size(MB)" FROM `information_schema`.`TABLES` WHERE `table_schema` = "";

Find total size for a single table

SELECT `TABLE_NAME` , `table_rows` , `data_length` , `index_length` , ROUND(((data_length + index_length) / 1024 / 1024),2) "Size(MB)" FROM `information_schema`.`TABLES` WHERE `table_schema` = "test" AND `TABLE_NAME` = 'employees';

Also can calculate all of the files in the database path stored by MySQL by executing below line to Terminal

sudo ls /var/lib/mysql/ -lh | grep -m 1 '^total'

PostgreSQL

Find entire databases and its sizes

SELECT pg_database.datname, pg_size_pretty(pg_database_size(pg_database.datname)) AS size FROM pg_database;

Find size for a single schema/database

SELECT pg_size_pretty(pg_database_size(''));

Find total size for a single table with indexes and relations

SELECT pg_size_pretty(pg_total_relation_size(''));

Find total size for a single table without indexes and relations

SELECT pg_size_pretty(pg_relation_size(''));

Oracle

SELECT (SELECT (SUM(bytes)/1024/1024/1024) "data_size" FROM dba_data_files ) + (SELECT (NVL(SUM(bytes),0)/1024/1024/1024) "temp_size" FROM dba_temp_files ) + (SELECT (SUM(bytes)/1024/1024/1024/1024) "redo_size" FROM sys.v_$log ) + (SELECT (SUM(BLOCK_SIZE * FILE_SIZE_BLKS)/1024/1024) "controlfile_size" FROM v$controlfile) "Size (MB)" FROM dual

MSSql Server

EXEC sp_helpdb '' GO

SQLite

-- Call below two statement using any scripting language and store values in two different variables and multiply both to get final result. pragma page_size; pragma page_count;

Visit SQLite docs for more

[vinaykrsharma]

jQuery Addon Tagging

(adsbygoogle = window.adsbygoogle || []).push({ google_ad_client: "ca-pub-2506679117428139", enable_page_level_ads: true });

jQuery Tagging helps to select tags for new post

Find more info here: Tagging

[vinaykrsharma]

Don’t be stupid, get past your old fashioned reactive measures to douse protests – times have changed. Communicate but more than that lend the peaceful protesters your ears…

[vinaykrsharma]

Ubuntu Phone OS

Wow, It's good to hear about Ubuntu Phone OS. Today canonical has announced Ubuntu for phone.  [Read more](http://www.ubuntu.com/devices/phone)

[vinaykrsharma]

Contrary to popular imagination that employees leave jobs for money; the truth is ‘people don’t leave jobs – they leave managers!’