bilalinamdar’s gists

bilalinamdar / free-database-hosting.md

Created September 21, 2023 15:39 — forked from bmaupin/free-database-hosting.md

Free database hosting

Service	Type	Storage	Limitations
Amazon DynamoDB	⚠️ Proprietary NoSQL	25 GB	⚠️ Payment method required
Amazon RDS	⚠️ Proprietary RDBMS		⚠️ Only free for 1 year
Azure SQL Database	MS SQL Server		⚠️ Only free for 1 year
👉 Clever Cloud	PostgreSQL, MySQL, MongoDB, Redis	256 MB (PostgreSQL)	Max 5 connections (PostgreSQL)

Activate wsl2

dism.exe /online /enable-feature /featurename:Microsoft-Windows-Subsystem-Linux /all /norestart
dism.exe /online /enable-feature /featurename:VirtualMachinePlatform /all /norestart
wsl --set-default-version 2

Install and Configure Ubuntu

bilalinamdar / best.ps1

Created January 3, 2023 14:35 — forked from chrisisbeef/best.ps1

Bitdefender GravityZone Remote Installation Scripts (Works with JumpCloud Command-Runner Agent)

	# Insert your company-hash here. When you get the download link, this is the long alpha-numeric scring
	# that comes after setupdownloader_ in the filename.
	# Do not include the square brackets (but do include the = if there is one).
	$CompanyHash = ""

	### Modify below this line at your own risk!

	# If it's already installed, just do nothing
	$Installed = Get-ItemProperty "HKLM:\Software\Microsoft\Windows\CurrentVersion\Uninstall\*" \|
	Where-Object { $_.DisplayName -eq "Bitdefender Endpoint Security Tools" }

bilalinamdar / Json to mysql

Created August 6, 2021 17:52 — forked from lodow/Json to mysql

Script to import json to mysql in php

	<?php

	$content = json_decode(file_get_contents("filename.json")), true);

	mysql_connect('localhost', 'user', 'pass');
	mysql_select_db('db');

	foreach($content as $item) {
	$columns = implode(", ",array_keys($item));
	$escaped_values = array_map('mysql_real_escape_string', array_values($item));

bilalinamdar / mastdon-bootstrap.sh

Created March 11, 2021 14:19 — forked from metastable/mastdon-bootstrap.sh

mastodon on AmazonLinux2

	#!/usr/bin/env bash
	echo "mastodon.example.com" \| sudo tee /etc/hostname > /dev/null
	sudo localectl set-locale LANG=en_US.UTF-8
	sudo timedatectl set-timezone Asia/Tokyo
	sudo tee /etc/sysctl.d/ipv4-tuning.conf << EOF
	# Drop it so lack of FIN times out quicker
	net.ipv4.tcp_fin_timeout = 30
	# reuse TIME-WAIT sockets
	net.ipv4.tcp_tw_reuse = 1
	net.ipv4.tcp_tw_recycle = 1

bilalinamdar / install-proxmox-s3-snippet-storage.sh

Created March 11, 2021 14:08 — forked from JanHolger/install-proxmox-s3-snippet-storage.sh

This script will install an s3 snippet storage server for ProxMox (cicustom) using Samba and MinIO

	#!/bin/bash
	echo "Password for Samba User 'snippets':"
	read -s smb_password_snippets
	echo "Password for S3 User 'admin':"
	read -s s3_password_admin
	echo "Password for S3 User 'dev' (min-length: 8):"
	read -s s3_password_dev
	echo "Password for S3 User 'api' (min-length: 8):"
	read -s s3_password_api
	wget -O /usr/local/bin/minio https://dl.min.io/server/minio/release/linux-amd64/minio

bilalinamdar / install-proxmox-s3-snippet-storage.sh

Created March 11, 2021 14:08 — forked from JanHolger/install-proxmox-s3-snippet-storage.sh

This script will install an s3 snippet storage server for ProxMox (cicustom) using Samba and MinIO

	#!/bin/bash
	echo "Password for Samba User 'snippets':"
	read -s smb_password_snippets
	echo "Password for S3 User 'admin':"
	read -s s3_password_admin
	echo "Password for S3 User 'dev' (min-length: 8):"
	read -s s3_password_dev
	echo "Password for S3 User 'api' (min-length: 8):"
	read -s s3_password_api
	wget -O /usr/local/bin/minio https://dl.min.io/server/minio/release/linux-amd64/minio

bilalinamdar / addselftosqlsysadmin.cmd

Created August 1, 2020 05:56 — forked from wadewegner/addselftosqlsysadmin.cmd

Script to add the current user to the sysadmin role in SQL Server

	@echo off
	rem
	rem ****************************************************************************
	rem
	rem Copyright (c) Microsoft Corporation. All rights reserved.
	rem This code is licensed under the Microsoft Public License.
	rem THIS CODE IS PROVIDED AS IS WITHOUT WARRANTY OF
	rem ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING ANY
	rem IMPLIED WARRANTIES OF FITNESS FOR A PARTICULAR
	rem PURPOSE, MERCHANTABILITY, OR NON-INFRINGEMENT.

bilalinamdar / test.ps1

Last active July 19, 2020 15:05

This is test #powershell

	#Test
	echo 'Powershell'

bilalinamdar / 0_reuse_code.js

Created August 28, 2016 08:51

Here are some things you can do with Gists in GistBox.

	// Use Gists to store code you would like to remember later on
	console.log(window); // log the "window" object to the console

Bilal Inamdar bilalinamdar

Activate wsl2

Install and Configure Ubuntu