🐢

Gabriel Garcia Torrico Garciat

🐢

Garciat / todo.php

Last active January 25, 2026 11:24

	<?php

	// connect to the database
	$pdo = new PDO('sqlite:todo.db');
	$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
	$pdo->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);

	// create the table if it doesn't exist
	$pdo->exec("CREATE TABLE IF NOT EXISTS todos (
	id INTEGER PRIMARY KEY,

Garciat / capture.html

Created February 27, 2025 18:10

	<!DOCTYPE html>
	<html>

	<head>
	<meta charset="UTF-8">
	<title>Screen Capture</title>
	<meta name="viewport" content="width=device-width, initial-scale=1">

	</head>

Garciat / fd-listener.deno.ts

Created February 22, 2025 19:25

Garciat / vscode-tunnel.tsx

Last active February 22, 2025 07:33

Manage your VS Code Remote Tunnel with Deno + CGI.

	#!/usr/bin/env -S /home/garciat/homebrew/bin/deno --allow-env --allow-run --allow-read --allow-write --allow-net

	import "jsr:@std/dotenv/load";

	import { readAllSync } from "jsr:@std/io/read-all";
	import { writeAllSync } from "jsr:@std/io/write-all";

	import { deleteCookie, getCookies, setCookie } from "jsr:@std/http/cookie";

	import { Application, Context, Router } from "jsr:@oak/oak";

Garciat / vscode-tunnel.py

Last active February 22, 2025 08:07

Manage your VS Code Remote Tunnel with Python 3 + CGI.

	# pip install google-api-python-client python-dotenv

	from typing import Optional, List, Tuple, Dict
	from dataclasses import dataclass

	import http.cookies
	import os
	import subprocess
	import sys
	import urllib.parse

Garciat / vscode-tunnel.php

Created February 20, 2025 19:21

Manage your VS Code Remote Tunnel with PHP.

	<?php

	function println($s)
	{
	echo "$s\n";
	}

	function shell_exec_trim($cmd, $nonzero_throw = true)
	{
	$lines = array();

Garciat / enum-gui.ts

Created December 15, 2024 17:31

	type KeyEnumOf<T> = {[P in keyof T]: P}

	class Enum {
	static make<T>(source: T): Readonly<KeyEnumOf<T>> {
	let result = {} as KeyEnumOf<T>;
	for (const k in source) {
	result[k] = k;
	}
	return Object.freeze(result);
	}

Garciat / sql.go

Last active May 13, 2024 08:03

Garciat / Stages.java

Created August 23, 2022 14:19

	package com.example.stages;

	import java.util.Optional;

	interface Person<Name, Age> {
	Name name();
	Age age();
	}

	record Person_Any<Name, Age>(Name name, Age age) implements Person<Name, Age> {}

Garciat / SpringPropertiesToJson.java

Last active January 25, 2026 11:31

	package com.uber.money.caribbean.paymentprofilev2.spring;

	import com.fasterxml.jackson.core.JsonProcessingException;
	import com.fasterxml.jackson.databind.JsonNode;
	import com.fasterxml.jackson.databind.ObjectMapper;
	import com.fasterxml.jackson.databind.node.ArrayNode;
	import com.fasterxml.jackson.databind.node.BooleanNode;
	import com.fasterxml.jackson.databind.node.DoubleNode;
	import com.fasterxml.jackson.databind.node.JsonNodeFactory;
	import com.fasterxml.jackson.databind.node.LongNode;