Sergio Conde Gómez skgsergio

😸

Meow

Site Reliability Engineer

skgsergio / meshtastic_ping.yaml

Created October 26, 2025 12:14

	alias: "Meshtastic: Automated PONG"
	description: ""
	triggers:
	- trigger: event
	event_type: meshtastic_api_text_message
	event_data:
	data:
	to:
	node: null
	channel: 0

skgsergio / getcursor.sh

Last active November 12, 2025 08:32

I fucking hate software distribution using AppImage

	#!/bin/bash
	set -uo pipefail

	echo -e "⚠️ This script needs root permissions, it will request privileges for sudo.\n"

	BASE_PATH="/opt/cursor"
	APPLICATIONS_PATH="/usr/share/applications"

	sudo mkdir -p "$BASE_PATH"

skgsergio / docker-compose.yaml

Created March 19, 2025 12:36

Tinybird self-managed region using cloudflared

	services:
	## Create a Tinybird self-managed region
	# Docs: https://www.tinybird.co/docs/forward/get-started/self-managed/manual
	#
	# 1. Run: tb infra add
	# 2. Create an .env.tinybird file with TB_INFRA values
	tinybird:
	image: tinybirdco/tinybird-local:beta
	env_file:
	- .env.tinybird

skgsergio / Uptime_Kuma_Backup.json

Last active April 5, 2025 12:53

skgsergio / zigbee_ota_version_patch.py

Created July 17, 2024 18:21

	import sys
	import pathlib

	from zigpy.ota.image import parse_ota_image

	if len(sys.argv) != 4:
	print(f"Usage: {sys.argv[0]} ota_file new_version_hex_or_int output_dir")
	sys.exit(1)

	ota_file = pathlib.Path(sys.argv[1])

skgsergio / datauri.sh

Created January 23, 2024 17:52

	#!/bin/bash
	mimetype=$(file -bN --mime-type "$1")
	content=$(base64 -w0 < "$1")
	echo "data:$mimetype;base64,$content"

skgsergio / toyota.py

Last active October 26, 2023 21:39

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 / 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 / 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):