corporatepiyush

sudo  sysctl   kern.sysv.shmmax=16777216
sudo  sysctl   kern.sysv.shmmin=1
sudo  sysctl   kern.sysv.shmmni=128
sudo  sysctl   kern.sysv.shmseg=32
sudo  sysctl   kern.sysv.shmall=4096
sudo  sysctl   kern.ipc.somaxconn=8192
sudo  sysctl   kern.maxfiles=1048576
sudo  sysctl   kern.maxfilesperproc=65535
sudo  sysctl   kern.ipc.maxsockbuf=16777216
sudo  sysctl   net.inet.tcp.delayed_ack=0

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 ) for MacOS.
# 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 /private/etc/hosts
 
curl https://raw.githubusercontent.com/StevenBlack/hosts/master/alternates/fakenews-gambling-porn/hosts > hosts

sudo mv hosts /private/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

corporatepiyush

/* commands to run on the coordinator */

CREATE EXTENSION citus;
SELECT master_add_node('10.0.0.2', 5432);
SELECT master_add_node('10.0.0.3', 5432);
SELECT start_metadata_sync_to_node(nodename, nodeport) FROM pg_dist_node;
SET citus.replication_model TO 'streaming'

CREATE TABLE events (
  event_id bigserial primary key,

corporatepiyush

const _ = require('ramda')

const ngrams = function (string) {
    var r = [];
    for (var n = 2; n <= string.length; n++)
        for (var i = 0; i <= string.length - n; i++)
            r.push(string.substring(i, i + n));
    return r;
}