Skip to content

Instantly share code, notes, and snippets.

@caarmen
caarmen / git-bisect-refs-regression.md
Created February 15, 2025 11:31
When git bisect refs stopped being included in git log
@caarmen
caarmen / legacy-android-emulator.md
Last active January 12, 2025 16:31
Run Android 1.5 Cupcake emulator on MacOS Intel (MacOS 15), in 2025
@caarmen
caarmen / monitor_active_app.bash
Created August 5, 2024 11:27
Script to monitor which application is currently opened (based on dbus-monitor).
#!/bin/bash
process_active_app() {
local last_date_str=""
local last_timestamp_s=0
local last_active_app=""
while IFS= read -r current_active_app; do
local current_timestamp
command="ls -la"
process=command.execute()
process.waitFor()
def output = process.in.text
println "Output:\n$output"
def error = process.err.text
println "Error:\n$error"
@caarmen
caarmen / fixrabbitmq.md
Created June 30, 2023 15:33
reinstall rabbitmq on ubuntu
@caarmen
caarmen / fixdbcharset.md
Created June 28, 2023 11:05
mysql/mariadb: fix weird errors about fk constraints, when the real problem is database charset

Dump the whole database:

mysqldump -u myuser my_database -p > dump.sql

Open the dump.sql file.

Do a search and replace: for example replace all occurrences of utf8mb3 with utf8mb4. Save the file.

<?xml version="1.0" encoding="UTF-8"?>
<feed xmlns="http://www.w3.org/2005/Atom" xmlns:dc="http://purl.org/dc/elements/1.1/">
<title>Poema del día de Francisco Álvarez Hidalgo</title>
<link rel="alternate" href="http://www.poesiadelmomento.com" />
<link rel="self" href="http://www.poesiadelmomento.com/poemadeldia.xml" />
<subtitle>Poema del día de Francisco Álvarez Hidalgo</subtitle>
<id>http://www.poesiadelmomento.com/</id>
<updated>2022-10-08T16:19:32.274011+00:00</updated>
<dc:date>2022-10-08T16:19:32.274011+00:00</dc:date>
<entry>
@caarmen
caarmen / swapi-graphql-client.py
Last active May 22, 2022 16:20
Script to retrieve paginated data from the star wars graphql server.
"""
Exploration of a graphql client in Python
"""
import asyncio
from dataclasses import dataclass
from typing import Generator
from gql import gql
from gql.client import Client, AsyncClientSession
from gql.transport.aiohttp import AIOHTTPTransport
@caarmen
caarmen / reinstall-mariadb-mysql.txt
Last active May 20, 2022 15:12
reinstall mariadb/mysql on mac
Remove contents of /usr/local/var/mysql
brew uninstall mysql
brew uninstall mariadb
brew install mariadb
mysql_install_db
mysql.server start
sudo mysql
- this opens a session. Just exit mysql for now
mysql_secure_installation
- Answer yes to everything
Language feature Kotlin Scala