sfunke / get apple note link

Created July 12, 2025 15:43 — forked from ys-qb/get apple note link

copying the link of apple note into clipboard - macos

	#!/bin/bash
	export LC_ALL=en_US.UTF-8

	noteId=$(osascript -e 'tell application "Notes"
	set noteID to «class seld» of (selection as record)
	get noteID
	end tell' \| cut -d/ -f5 \| cut -c2-)

	echo "SELECT '['\|\|note.ztitle1\|\|'](applenotes:note/'\|\|note.zidentifier\|\|')' FROM ziccloudsyncingobject AS note WHERE note.z_pk = $noteId;" \|
	sqlite3 ~/Library/Group\ Containers/group.com.apple.notes/NoteStore.sqlite \|

sfunke / parallels-reset.sh

Created March 25, 2022 17:32

Reset Parallels' trial

	#!/bin/sh
	# Reset Parallels Desktop's trial and generate a casual email address to register a new user
	rm /private/var/root/Library/Preferences/com.parallels.desktop.plist /Library/Preferences/Parallels/licenses.xml
	jot -w pdu%[email protected] -r 1

sfunke / ConnectivityChecker.kt

Created February 14, 2022 06:39 — forked from Farbklex/ConnectivityChecker.kt

Android: Check if the device has internet access on devices with API level >= 23.

	package me.a_hoffmann.gists

	import android.content.Context
	import android.net.ConnectivityManager
	import android.net.NetworkCapabilities

	/**
	* Checks if the device has an internet connection.
	* NOTE: Works only on android API level 23 and above!
	*/

sfunke / RecomposeDemo.kt

Created November 4, 2021 07:56

	import androidx.compose.foundation.layout.*
	import androidx.compose.foundation.lazy.LazyColumn
	import androidx.compose.material.*
	import androidx.compose.runtime.Composable
	import androidx.compose.runtime.mutableStateOf
	import androidx.compose.runtime.*
	import androidx.compose.ui.Modifier
	import androidx.compose.ui.unit.dp
	import kotlinx.coroutines.CoroutineScope
	import kotlinx.coroutines.Dispatchers

sfunke / macos-virtualbox-ubuntu-server-docker.md

Created May 3, 2021 08:25 — forked from kevin-smets/macos-virtualbox-ubuntu-server-docker.md

macOS VirtualBox headless Ubuntu Server and Docker setup

Get started

Install virtualbox and the extension pack:

brew install --cask docker virtualbox virtualbox-extension-pack

Download the ubuntu server image and create a VBox for it, the rest of the readme assumes it is named "Ubuntu Server".

Enable SSH

sfunke / patch_apk_for_sniffing.md

Created April 21, 2021 12:59 — forked from unoexperto/patch_apk_for_sniffing.md

How to patch Android app to sniff its HTTPS traffic with self-signed certificate

Download apktool from https://ibotpeaches.github.io/Apktool/
Unpack apk file: java -jar /home/expert/work/tools/apktool.jar d [email protected]
Modify AndroidManifest.xml by adding android:networkSecurityConfig="@xml/network_security_config" attribute to application element.
Create file /res/xml/network_security_config.xml with following content:

<?xml version="1.0" encoding="utf-8"?>
<network-security-config>
    <base-config>

sfunke / multiple image match.py

Created April 22, 2020 15:51 — forked from varunpalekar/multiple image match.py

OpenCV Python

sfunke / convert.sql

Created November 19, 2019 22:06 — forked from paracycle/convert.sql

Convert and merge WhatsApp databases from iPhone format to Android

	-- Clear tables
	DROP TABLE chat_list;
	DROP TABLE messages;

	-- Create new tables
	CREATE TABLE chat_list (_id INTEGER PRIMARY KEY AUTOINCREMENT, key_remote_jid TEXT UNIQUE, message_table_id INTEGER);
	CREATE TABLE messages (_id INTEGER PRIMARY KEY AUTOINCREMENT, key_remote_jid TEXT NOT NULL, key_from_me INTEGER, key_id TEXT NOT NULL, status INTEGER, needs_push INTEGER, data TEXT, timestamp INTEGER, media_url TEXT, media_mime_type TEXT, media_wa_type TEXT, media_size INTEGER, media_name TEXT, latitude REAL, longitude REAL, thumb_image TEXT, remote_resource TEXT, received_timestamp INTEGER, send_timestamp INTEGER, receipt_server_timestamp INTEGER, receipt_device_timestamp INTEGER, raw_data BLOB, media_hash TEXT, recipient_count INTEGER, media_duration INTEGER, origin INTEGER);

	-- Attach Android and iPhone databases
	ATTACH 'msgstore.db' AS android;