vivek0460’s gists

vivek0460 / postgres_queries_and_commands.sql

Created October 12, 2023 06:19 — forked from rgreenjr/postgres_queries_and_commands.sql

Useful PostgreSQL Queries and Commands

	-- show running queries (pre 9.2)
	SELECT procpid, age(clock_timestamp(), query_start), usename, current_query
	FROM pg_stat_activity
	WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%'
	ORDER BY query_start desc;

	-- show running queries (9.2)
	SELECT pid, age(clock_timestamp(), query_start), usename, query
	FROM pg_stat_activity
	WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'

vivek0460 / amazon_cell_compete.js

Created June 16, 2020 03:46 — forked from juanfurattini/amazon_cell_compete.js

	/*
	Cell compete:
	Eight houses, represented as a cells, are arranged as a straight line.
	Each days every cells competes with adjacent cells. An integer value 1
	represents an active cell and a value of 0 represent an inactive cell.
	if the neigbour on both the sides of the cell are both active or inactive,
	the cell become inactive in the next day, otherwise the become active.
	The two cells on each or have a single adjacent cell, so asume that
	the onoccupied space in the opposite side is an inactive cell. even after
	updating the cell state, consider its previus state when updating the state

vivek0460 / wp-config.php

Created September 11, 2018 11:22

Set WordPress site URL in the config file instead of the database

	<?php

	// WordPress stores the site URL in the database by default (which I have never
	// understood), and it's a pain to have to type out the UPDATE SQL or search in
	// phpMyAdmin to change it. This is a simple way to put the URL into
	// wp-config.php instead.

	// Note that you will still need to update any URLs that appear in the content,
	// especially when you copy a database from a development site to production:
	// https://gist.github.com/davejamesmiller/a8733a3fbb17e0ff0fb5

vivek0460 / QueueRetryAllCommand.php

Created August 29, 2018 06:07 — forked from JacobBennett/QueueRetryAllCommand.php

Laravel Queue:Retry-Multiple and Queue:Retry-All

	<?php

	namespace App\Console\Commands;

	use Illuminate\Console\Command;

	class RetryAllCommand extends Command
	{
	/**
	* The name and signature of the console command.

vivek0460 / image-src-regexpr.php

Created August 23, 2018 13:46 — forked from vyspiansky/image-src-regexpr.php

PHP: get image src attribute (regular expression)

	<?php
	// Source: http://goo.gl/qyLFbg

	$html = '<img border="0" src="/images/image.jpg" alt="Image" width="100" height="100" />';

	preg_match( '@src="([^"]+)"@' , $html, $match );

	$src = array_pop($match);

	// will return /images/image.jpg

vivek0460 / Strong Password RegEx

Created July 23, 2018 11:02 — forked from ravibharathii/Strong Password RegEx

A Regular Expression for a Strong Password

	Description of this regular expression is as below:

	Passwords will contain at least 1 upper case letter
	Passwords will contain at least 1 lower case letter
	Passwords will contain at least 1 number or special character
	Passwords will contain at least 8 characters in length
	Password maximum length should not be arbitrarily limited


	(?=^.{8,}$)((?=.\d)\|(?=.\W+))(?![.\n])(?=.[A-Z])(?=.[a-z]).*$

vivek0460 / helpers.php

Created July 13, 2018 10:32 — forked from shengyou/helpers.php

env() helper functions without Laravel framework

	<?php

	if (! function_exists('env')) {
	/**
	* Gets the value of an environment variable. Supports boolean, empty and null.
	*
	* @param string $key
	* @param mixed $default
	* @return mixed
	*/

vivek0460 / chrome update.txt

Last active September 10, 2018 10:57 — forked from mrtns/gist:78d15e3263b2f6a231fe

Upgrade Chrome from Command Line on Ubuntu

	# Install
	# via http://askubuntu.com/questions/510056/how-to-install-google-chrome

	wget -q -O - https://dl-ssl.google.com/linux/linux_signing_key.pub \| sudo apt-key add -
	sudo sh -c 'echo "deb http://dl.google.com/linux/chrome/deb/ stable main" >> /etc/apt/sources.list.d/google-chrome.list'
	sudo apt-get update
	sudo apt-get install google-chrome-stable


	# Update

vivek0460 / error.interceptor.ts

Created March 4, 2018 16:39 — forked from jotatoledo/error.interceptor.ts

	import { Injectable, ClassProvider } from '@angular/core';
	import { HttpEvent, HttpInterceptor, HttpHandler, HttpRequest, HttpErrorResponse, HTTP_INTERCEPTORS } from '@angular/common/http';
	import { Observable } from 'rxjs/Observable';
	import { _throw } from 'rxjs/observable/throw';
	import 'rxjs/add/operator/catch';

	/**
	* Intercepts the HTTP responses, and in case that an error/exception is thrown, handles it
	* and extract the relevant information of it.
	*/

vivek0460 / emojis.json

Created February 27, 2018 05:50 — forked from oliveratgithub/emojis.json

Emoji-list with emojis, names, shortcodes, unicode and html entities [massive list]

	{
	"emojis": [
	{"emoji": "👩‍👩‍👧‍👧", "name": "family_mothers_two_girls", "shortname": "", "unicode": "", "html": "👩&zwj;👩&zwj;👧&zwj;👧", "category": "p", "order": ""},
	{"emoji": "👩‍👩‍👧‍👦", "name": "family_mothers_children", "shortname": "", "unicode": "", "html": "👩&zwj;👩&zwj;👧&zwj;👦", "category": "p", "order": ""},
	{"emoji": "👩‍👩‍👦‍👦", "name": "family_mothers_two_boys", "shortname": "", "unicode": "", "html": "👩&zwj;👩&zwj;👦&zwj;👦", "category": "p", "order": ""},
	{"emoji": "👨‍👩‍👧‍👧", "name": "family_two_girls", "shortname": "", "unicode": "", "html": "👨&zwj;👩&zwj;👧&zwj;👧", "category": "p", "order": ""},
	{"emoji": "👨‍👩‍👧‍👦", "name": "family_children", "shortname": "", "unicode": "", "html": "👨&zwj;👩&zwj;👧&zwj;👦", "category": "p", "order": ""},
	{"emoji": "👨‍👩‍👦‍👦", "name": "family_two_boys", "shortname": "", "unicode": "", "html": "👨&zw

Vivek Pandey vivek0460