corporatepiyush

CREATE PROCEDURE GenericPivot(
    IN tableName VARCHAR(255),
    IN pivotColumn VARCHAR(255),
    IN pivotValues VARCHAR(255),
    IN aggregateColumn VARCHAR(255),
    IN groupByColumn VARCHAR(255)
)
BEGIN
    DECLARE columnsList TEXT;
    DECLARE sql_query TEXT;

corporatepiyush

#!/bin/bash

# File: /usr/local/bin/configure_malloc.sh

set_malloc_config() {
    local total_ram=$1
    local arena_max mmap_threshold trim_threshold top_pad

    mmap_threshold=524288    # 512 KB
    trim_threshold=524288   # 512 KB

corporatepiyush

#!/bin/bash

# Array to store user choices
declare -A choices

# Log file
LOGFILE="/var/log/linux_hardening.log"

# Function to log messages
log() {

corporatepiyush

// ignore_for_file: prefer_function_declarations_over_variables

import 'dart:async';
import 'dart:collection';
import 'dart:convert';
import 'dart:io';
import 'dart:typed_data';
import 'package:basics/basics.dart';
import 'package:quiver/cache.dart';

corporatepiyush

const pg = require('pg-promise')();
const fs = require('fs');

const db = pg({
    user: "****",
    password: "*****",
    host: "******",
    port: 5432,
    database: "*****",
    ssl: {

corporatepiyush

# Protection from Malicious Domain (ads, malware, hack scripts, fakenews and gambling )
# You may not be doing it but various apps installed on your system doing it internally, so having ad blocker in Browser does not helps.
# Execute below command in your terminal once every week.

sudo chmod 774 /etc/hosts
 
curl https://raw.githubusercontent.com/StevenBlack/hosts/master/alternates/fakenews-gambling-porn/hosts > hosts

sudo mv hosts /etc/hosts

corporatepiyush

package main

import (
	"database/sql"
	"database/sql/driver"
	"fmt"
	"net"
	"os"
	"time"

corporatepiyush

CREATE TABLE rollups (
  name text,
  rolled_up_generation bigint default -1
);

-- Create a stub on workers to allow usage as a default in distributed tables
SELECT run_command_on_workers($$
CREATE OR REPLACE FUNCTION current_rollup_generation(rollup_name text)
RETURNS bigint LANGUAGE sql
AS $function$

corporatepiyush

-- Create the raw events table
CREATE TABLE page_views (
    site_id int,
    path text,
    client_ip inet,
    view_time timestamptz default now(),
    view_id bigserial
);

-- Allow fast lookups of ranges of sequence IDs

corporatepiyush

// suppose you spawned 16 node processes on 16 core CPU

ps axf | grep node | grep -v grep | awk '{print $1}' | xargs -n 1 taskset -cp 0-15