Skip to content

Instantly share code, notes, and snippets.

View jace's full-sized avatar

Kiran Jonnalagadda jace

View GitHub Profile
@jace
jace / rpi5-usb-power-log.txt
Created February 23, 2024 12:21
RPi5 USB power log (until crash, log ends before power button shutdown)
This file has been truncated, but you can view the full file.
timestamp sample_in_packet voltage_V current_A dp_V dn_V temp_C_ema energy_Ws capacity_As
1708689447.777 0 5.12897 0.61260 0.058 0.077 37.300 0.031420 0.006126
1708689447.787 1 5.12897 0.59865 0.057 0.077 37.300 0.062125 0.012113
1708689447.797 2 5.12897 0.57829 0.057 0.077 37.300 0.091785 0.017895
1708689447.807 3 5.12897 0.59220 0.057 0.077 37.310 0.122159 0.023817
1708689447.817 0 5.12916 0.59021 0.057 0.077 37.400 0.152432 0.029720
1708689447.827 1 5.12916 0.58798 0.057 0.077 37.400 0.182590 0.035599
1708689447.837 2 5.12916 0.58525 0.056 0.077 37.400 0.212608 0.041452
1708689447.847 3 5.12916 0.60039 0.057 0.077 37.400 0.243403 0.047456
@jace
jace / denoise.sh
Last active October 11, 2023 10:17
Remove noise from video using sox and ffmpeg
# 1. extract audio from all videos (assuming .mp4 videos).
for FILE in *.mp4; do ffmpeg -i $FILE ${FILE%%.mp4}.wav; done
# 2. use the first second of the first audio file as the noise sample.
sox `ls *.wav | head -1` -n trim 0 1 noiseprof noise.prof
# Replace with a specific noise sample file if the first second doesn't work for you:
# sox noise.wav -n noiseprof noise.prof
# 3. clean the audio with noise reduction and normalise filters.
@jace
jace / hasgeek-cla.md
Created May 16, 2022 13:36
Hasgeek CLA

Hasgeek Individual Contributor License Agreement

Thank you for your interest in contributing to open source software projects (“Projects”) made available by Hasgeek Learning Private Limited or its affiliates (“Hasgeek”). This Individual Contributor License Agreement (“Agreement”) sets out the terms governing any source code, object code, bug fixes, configuration changes, tools, specifications, documentation, data, materials, feedback, information or other works of authorship that you submit or have submitted, in any form and in any manner, to Hasgeek in respect of any of the Projects (collectively “Contributions”). If you have any questions respecting this Agreement, please contact support@hasgeek.com.

You agree that the following terms apply to all of your past, present and future Contributions. Except for the licenses granted in this Agreement, you retain all of your right, title and interest in and to your Contributions.

Copyright License. You hereby grant, and agree to grant, to Hasgeek a non

"""Test whether a descriptor's __set_name__ is called in multiple scenarios."""
from flask_sqlalchemy import SQLAlchemy
from sqlalchemy import Column, Integer, String
from sqlalchemy.ext.declarative import declarative_base, declared_attr
Base = declarative_base()
db = SQLAlchemy()
# Performance test for coaster.sqlalchemy.registry.InstanceRegistry
import timeit
class Registry:
def __init__(self, param=None):
self.param = param
class Namespacer1:
@jace
jace / partial.py
Created May 10, 2020 07:13
Performance difference of Python's partial vs partialmethod
from functools import partial, partialmethod
from timeit import timeit
class Partial(Base):
def __init__(self):
self.p = partial(self.foo, 1)
class PartialMethod(Base):
@jace
jace / dump.sql
Created September 14, 2012 18:58
SQLAlchemy joined table inheritance and mixins
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE node (
id INTEGER NOT NULL, -- from Mixin
name VARCHAR(200), -- from Mixin
published BOOLEAN NOT NULL,
type VARCHAR(20),
title VARCHAR(200), -- from Mixin
PRIMARY KEY (id),
CHECK (published IN (0, 1))
@jace
jace / twitter.ublock
Last active June 4, 2018 03:39
Remove spam from Twitter notifications
! Add these under uBlock Settings -> My filters
twitter.com##.js-new-items-bar-container
twitter.com##.js-activity-favorite
twitter.com##.js-activity-favorited_retweet
twitter.com##.js-activity-retweet
twitter.com##.stream-item-favorited_mention
twitter.com##.stream-item-retweet
twitter.com##.stream-item-retweeted_retweet
twitter.com##.stream-item-retweeted_mention
twitter.com##li.people.notifications .count.new-count
@jace
jace / bulletinbabu.py
Created December 14, 2017 15:58
Bulletin Babu for #SpeakForMe
#!/usr/bin/env python
"""
Script to count the emails received by #SpeakForMe
"""
import os
import sys
import tweepy
import requests
@jace
jace / upgrade.sh
Created December 22, 2016 04:43
Upgrade Python 2.7 virtualenv under Homebrew
#!/bin/bash
if [ $# -ne 1 ]; then
echo "Usage: $0 <venv_dir>"
else
rm $1/bin/pip
rm $1/bin/pip2
rm $1/bin/pip2.7
rm $1/bin/python
rm $1/bin/python2