Skip to content

Instantly share code, notes, and snippets.

View skgsergio's full-sized avatar
😸
Meow

Sergio Conde Gómez skgsergio

😸
Meow
View GitHub Profile
#!/bin/bash
mimetype=$(file -bN --mime-type "$1")
content=$(base64 -w0 < "$1")
echo "data:$mimetype;base64,$content"
@skgsergio
skgsergio / current_stack.yaml
Created November 30, 2023 10:48
Cards for HA Toyota
type: vertical-stack
cards:
- type: entity
entity: sensor.corolla_ts_mc23_odometer
name: Odometer
- type: gauge
entity: sensor.corolla_ts_mc23_fuel_level
needle: true
severity:
green: 25
#!/usr/bin/env python3
import os
import sys
import json
import logging
import pathlib
import argparse
import requests
@skgsergio
skgsergio / postgres_queries_and_commands.sql
Created February 22, 2023 14:24 — forked from rgreenjr/postgres_queries_and_commands.sql
Useful PostgreSQL Queries and Commands
-- show running queries (pre 9.2)
SELECT procpid, age(clock_timestamp(), query_start), 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(clock_timestamp(), query_start), usename, query
FROM pg_stat_activity
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'
@skgsergio
skgsergio / Makefile
Last active April 12, 2016 16:27
Makefile para G3D
# Compilador, puede cambiarse con make CC=clang CXX=clang
CC ?= gcc
CXX ?= g++
# Flags normales
CCFLAGS = -march=native -O2 -fomit-frame-pointer -pipe
CXXFLAGS = $(CCFLAGS)
LDFLAGS = -Wl,-O1 -Wl,--as-needed
# Flags para debug
@skgsergio
skgsergio / estaviva.py
Last active September 4, 2015 21:20
Comprobación de si una web carga de forma rapida y sencilla.
#!/usr/bin/env python
# -*- coding: utf-8 -*-
try:
import urllib2 # Python 2
except ImportError:
import urllib.request as urllib2 # Python 3
def isup(url):

Keybase proof

I hereby claim:

  • I am skgsergio on github.
  • I am skgsergio (https://keybase.io/skgsergio) on keybase.
  • I have a public key whose fingerprint is 487D 62C8 523C 9BBF 7CC8 D029 959E A15D 1867 A20A

To claim this, I am signing this object:

@skgsergio
skgsergio / update.sh
Last active December 6, 2022 10:33
Script for updating an Arch Linux system using reflector for mirror updates, yay as package manager and printing pacnew files.
#!/bin/bash
#
# System update script for Arch Linux.
#
# Requires:
# - yay as package manager.
# - reflector as mirror list updater.
#
# Sergio Conde <skgsergio@gmail.com>
#