redraiment / DuckDB.bas

Last active October 30, 2025 19:59

DuckDB ODBC UTF-8 Character Encoding Fix for Excel VBA

	Function ConvertUtf8ToUnicode(bytes() As Byte) As String

	Dim ostream As Object
	Set ostream = CreateObject("ADODB.Stream")
	With ostream
	.Type = 1 ' Binary
	.Open
	.Write bytes
	.Position = 0
	.Type = 2 'Text

andrewchilds / saveGPT.bookmarklet.js

Last active January 4, 2026 00:06

Download ChatGPT conversations as markdown files.

javascript:function parseChatGPTData(data) { const mapping = data.mapping; const conversationTitle = data.title; const createDate = new Date(data.create_time * 1000).toISOString().slice(0, 10); const messagesArray = Object.values(mapping) .filter(node => node.message) .map(node => { const message = node.message; const sender = message.author.role === 'user' ? 'You' : 'Assistant'; const content = message.content.parts.join(''); const createTime = message.create_time; return { sender: sender, content: content, createTime: createTime, }; }); messagesArray.sort((a, b) => a.createTime - b.createTime); return { date: createDate, title: conversationTitle, messages: messagesArray.map(({ sender, content }) => ({ sender, content })), }; } function download(filename, text) { const element = document.createElement('a'); element.setAttribute('href', 'data:text/plain;charset=utf-8,' + encodeURIComponent(text)); element.setAttribute('download', filename); element.style.display = 'none'; document.body.appendChild(element); e

kesor / 1-voice-synthesis.js

Last active December 27, 2025 05:35

Making chat OpenAI use TTS

	// paste this into your chrome dev console for Speech Synthesis

	const originalFetch = window.fetch

	const patchedFetch = (...args) => {
	if (args[1].method == 'POST' && args[1].body.length > 0 && /moderations$/.test(args[0])) {
	const aiResponse = JSON.parse(args[1].body)["input"].split("\n\n\n")
	if (aiResponse.length > 1) {
	const text = aiResponse.slice(1).join(". ").trim()
	console.log(text)

modem7 / useful-one-liners.sh

Created April 12, 2022 23:20 — forked from johnnypea/useful-one-liners.sh

Useful one liners

	# Run the last command as root
	sudo !!
	# Serve current directory tree at http://$HOSTNAME:8000/
	python -m SimpleHTTPServer
	# Save a file you edited in vim without the needed permissions
	:w !sudo tee %
	# change to the previous working directory
	cd -
	# Runs previous command but replacing
	^foo^bar

dalegaspi / DynamicPostTransformFilter.java

Last active August 28, 2023 04:32

Spring Cloud Gateway Response Modification

	package yeet;

	import lombok.extern.slf4j.Slf4j;
	import org.bouncycastle.util.Strings;
	import org.reactivestreams.Publisher;
	import org.springframework.cloud.gateway.filter.GatewayFilter;
	import org.springframework.cloud.gateway.filter.NettyWriteResponseFilter;
	import org.springframework.cloud.gateway.filter.OrderedGatewayFilter;
	import org.springframework.cloud.gateway.filter.factory.rewrite.CachedBodyOutputMessage;
	import org.springframework.cloud.gateway.filter.factory.rewrite.MessageBodyDecoder;

y0ngb1n / docker-registry-mirrors.md

Last active May 5, 2026 15:36

国内的 Docker Hub 镜像加速器，由国内教育机构与各大云服务商提供的镜像加速服务 | Dockerized 实践 https://github.com/y0ngb1n/dockerized

Docker Hub 镜像加速器

国内从 Docker Hub 拉取镜像有时会遇到困难，此时可以配置镜像加速器。

Dockerized 实践 https://github.com/y0ngb1n/dockerized

1️⃣ Docker daemon 配置代理（推荐）

参考 Docker daemon 配置代理

nicebyte / dyn_arr.h

Last active December 27, 2025 05:35

dyn_arr

	#pragma once

	#define DYN_ARR_OF(type) struct { \
	type *data; \
	type *endptr; \
	uint32_t capacity; \
	}

	#if !defined(__cplusplus)
	#define decltype(x) void*

LiTong litong-2017

Docker Hub 镜像加速器

1️⃣ Docker daemon 配置代理（推荐）