Skip to content

Instantly share code, notes, and snippets.

View corporatepiyush's full-sized avatar

Piyush Katariya corporatepiyush

View GitHub Profile
@corporatepiyush
corporatepiyush / dial-pq-via-ssh.go
Created May 27, 2023 09:02 — forked from vinzenz/dial-pq-via-ssh.go
Use postgres via SSH in Golang
package main
import (
"database/sql"
"database/sql/driver"
"fmt"
"net"
"os"
"time"
@corporatepiyush
corporatepiyush / blockAds.sh
Last active August 15, 2023 07:39
Block ads and malware for MacOS
# 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
corporatepiyush / fetchSave.js
Created June 29, 2023 15:07
Taking a day wise backup of large SQL Table incrementally
const pg = require('pg-promise')();
const fs = require('fs');
const db = pg({
user: "****",
password: "*****",
host: "******",
port: 5432,
database: "*****",
ssl: {
@corporatepiyush
corporatepiyush / FileDB.dart
Last active August 15, 2023 14:15
Using File System as Key Value Database
// 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
corporatepiyush / tune.sh
Last active September 12, 2023 07:07
MacOS Optimisation
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