Skip to content

Instantly share code, notes, and snippets.

View electron0zero's full-sized avatar
🎯
Focusing

Suraj Nath electron0zero

🎯
Focusing
217 followers · 77 following
View GitHub Profile
@electron0zero
electron0zero / tmux-cheatsheet.markdown
Created April 12, 2018 06:46 — forked from MohamedAlaa/tmux-cheatsheet.markdown
tmux shortcuts & cheatsheet

tmux shortcuts & cheatsheet

start new:

tmux

start new with session name:

tmux new -s myname
@electron0zero
electron0zero / find_dups.rb
Created May 28, 2018 07:02 — forked from rob-murray/find_dups.rb
Rails find duplicate records
columns_that_make_record_distinct = [:some_id, :another_name]
distinct_ids = Model.select("MIN(id) as id").group(columns_that_make_record_distinct).map(&:id)
duplicate_records = Model.where.not(id: distinct_ids)
@electron0zero
electron0zero / postgres_queries_and_commands.sql
Created June 15, 2018 04:49 — forked from rgreenjr/postgres_queries_and_commands.sql
Useful PostgreSQL Queries and Commands
-- show running queries (pre 9.2)
SELECT procpid, age(query_start, clock_timestamp()), usename, current_query
FROM pg_stat_activity
WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%'
ORDER BY query_start desc;
-- show running queries (9.2)
SELECT pid, age(query_start, clock_timestamp()), usename, query
FROM pg_stat_activity
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'
@electron0zero
electron0zero / gist:e2cdc3a6187c54f7696a84212defc147
Created January 3, 2019 10:50 — forked from petasittek/gist:1378951
Find all subdomains of given domain with dig
# let's dig the server
dig example.com
# from the DNS answer we are interested in the authority section
#;; AUTHORITY SECTION:
#example.com. 79275 IN NS a.iana-servers.net.
#example.com. 79275 IN NS b.iana-servers.net.
# now we find out all subdomains
dig @a.iana-servers.net example.com axfr
@electron0zero
electron0zero / slack_delete.rb
Created January 8, 2019 17:47 — forked from jamescmartinez/slack_delete.rb
This Ruby script will bulk remove all Slack files older than 30 days. Just add your API token from https://api.slack.com/web#authentication into the token quotes at the top of the file.
require 'net/http'
require 'json'
require 'uri'
@token = ''
def list_files
ts_to = (Time.now - 30 * 24 * 60 * 60).to_i # 30 days ago
params = {
token: @token,
@electron0zero
electron0zero / monitor.rb
Created July 1, 2020 20:38 — forked from lfittl/monitor.rb
# Copyright (c) 2014 Lukas Fittl <lukas@pganalyze.com>
#
# Released in the public domain - fork as you wish.
require 'rubygems'
require 'mixlib/cli'
require 'pg'
require 'pg_query'
require 'curses'
@electron0zero
electron0zero / sidekiq_monitoring
Created July 7, 2020 12:27 — forked from ngsmrk/sidekiq_monitoring
Sidekiq queue checking via rails console
stats = Sidekiq::Stats.new
stats.queues
stats.enqueued
stats.processed
stats.failed
@electron0zero
electron0zero / dell-D6000-dock-ubuntu.md
Last active September 19, 2023 17:24 — forked from noahp/dell-D6000-dock-ubuntu.md
Dell Universal Dock D6000 on ubuntu - Updated Sep 19, 2023
@electron0zero
electron0zero / convert_go-kit_slog.bash
Created October 25, 2024 13:26 — forked from tjhop/convert_go-kit_slog.bash
Convert go-kit/log to slog calls
#!/usr/bin/env bash
#
# License: Apache-2.0
#
# Description: Convert go-kit/log to slog calls
#
# Authors:
# - Ben Kochie (@superq)
# - TJ Hoplock (@tjhop)
#