Skip to content

Instantly share code, notes, and snippets.

import sqlalchemy as sa
import urllib
import pandas as pd
import pickle5 as pickle
from tqdm import tqdm
class PandasToSQL:
"""
This class wrap to_sql function from pandas with tqdm progress bar

Install Android SDK CLI Ubuntu 20.04 WSL2 (Work in Progress)

Install Java 8

sudo apt install openjdk-8-jdk-headless

Android SDK

@bodokaiser
bodokaiser / context.ts
Last active June 19, 2025 19:36
React Hook integration for AWS Amplify Auth
import React from "react"
import { CognitoUser } from "@aws-amplify/auth"
import { useAuth } from "./hooks"
import { SignInInput } from "./types"
interface AuthState {
user: CognitoUser | null
signIn(input : SignInInput): Promise<void>
signOut(): Promise<void>
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@opus-x
opus-x / Spotify_Eliminate_Advertisements
Last active October 25, 2025 11:48
Eliminate Spotify Advertisements + Complete Server List
##################################################################################
# ELIMINATE SPOTIFY ADS (VERSION 1.2 - 8.5) - ABANDONED FOR NOW #
##################################################################################
#
# NOTE: SOMETIMES ONLY ANNOUNCEMENT OF AN AD WHILE USING APP VERSION 7.5-7.9?-8.x.
# USING AN OFFICIAL OLDER VERSION SOLVES THIS. TEST IT (APKMIRROR). THIS WILL NOT
# OCCUR USING CHROMECAST / GOOGLE HOME.
#
# COULD NOT SOLVE THE AUDIO AD INRO/OUTRO IN THE APP.
# SUGGESTIONS? WRITE A COMMENT BELOW.
@toransahu
toransahu / config.yml
Last active February 2, 2025 17:48
CircleCI config file: Setup for Pipenv; Created for ethereal-machines-backend in BitBucket
# Python CircleCI 2.0 configuration file
#
# Check https://circleci.com/docs/2.0/language-python/ for more details
#
version: 2
jobs:
build:
docker:
# specify the version you desire here
# use `-browsers` prefix for selenium tests, e.g. `3.6.1-browsers`
@naotokui
naotokui / GAN-808_keras.ipynb
Created July 14, 2017 10:17
GAN-based drumloop generation (work in progress)
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@kekru
kekru / add CA cert on CentOS Debian Ubuntu.md
Last active July 30, 2025 02:13
Add CA cert to local trust store on CentOS, Debian or Ubuntu
  • Open a webpage that uses the CA with Firefox
  • Click the lock-icon in the addressbar -> show information -> show certificate
  • the certificate viewer will open
  • click details and choose the certificate of the certificate-chain, you want to import to CentOS
  • click "Export..." and save it as .crt file
  • Copy the .crt file to /etc/pki/ca-trust/source/anchors on your CentOS machine
  • run update-ca-trust extract
  • test it with wget https://thewebsite.org
@genepool99
genepool99 / CharShiftDecrypt.py
Created December 23, 2016 20:14
CharShiftDecrypt in Python
'''
This is a common way of obfuscating email addresses on websites. The JavaScript
has been (badly) translated into this Python function. I have no idea who wrote the
orignal JavaScript function.
'''
def CharShiftDecrypt(strInVal, shiftval, shiftCharSet):
strInString = strInVal
intInString = len(strInString)
strCharSet = shiftCharSet
intCharSetLen = len(strCharSet)

Aligning images

This is a guide for aligning images.

See the full Advanced Markdown doc for more tips and tricks

left alignment