Skip to content

Instantly share code, notes, and snippets.

View jddcef's full-sized avatar

David de Caires e Freitas jddcef

View GitHub Profile
tanaikech /
Last active July 11, 2024 13:14
Benchmark: Process Costs for Searching Values in Spreadsheet using Google Apps Script

Benchmark: Process Costs for Searching Values in Spreadsheet using Google Apps Script


Here, I would like to report the process costs for searching values in Spreadsheet using Google Apps Script (GAS). When the values are searched in Google Spreadsheet, the following 3 patterns can be considered. Ref

  1. Retrieve all values using getValues, and the values are searched from the retrieved array.
  2. Use TextFinder.
  3. Use Query language.
darwin /
Last active April 9, 2024 22:30
APFS Container cloning/replicating under Catalina (with a bootable system)

Today I wanted to move existing APFS-resident macOS Catalina installation to a new disk. I upgraded my late 2014 Mac Mini with a shiny new 1TB SSD. This took way too many hours of my life I will never get back. Hope this saves some time to you.

Good news:

  1. it is possible to create a DMG image from existing APFS container with macOS Catalina installation including metadata needed for complete restore (the DMG contains OS, OS Data, Preboot, Recovery and VM volumes)
  2. it is possible to restore this DMG image into empty APFS container and get a bootable copy of the original system

This information is relevant for Catalina (I'm currently running macOS 10.15.1).

devdattaT /
Last active July 1, 2024 11:36
How to Visualize your Google Location History

Google is extremely transparent about the Location History it has on you. You can check it out on the timeline feature in the Google Maps application on the phone, or on It is possible that you have that turned off, and in that case, consider yourself lucky.

If there is data there, you can view it online, or Download and Analyze it yourself.

Note: The conversion script has been updated on 2024-06-24, to match the updated format which is now generated by Google Takeout

import json
import csv
import sys
from datetime import datetime
import os
def has_keys(dictionary, keys):
return all(key in dictionary for key in keys)
def make_reader(in_json):

Tuning Windows 10 for Slow Machines

Windows 10 on slow netbook

This guide is for those who dares to install Windows 10 on slow netbooks (1GB of RAM).
Though Windows update program is over, you still may use old Windows product keys from license stickers to install Windows 10 on old machines.

UPD Jan 2019
This article is quite old, some instructions may be obsolete.

IntergalacticApps / make_windows10_great_again.bat
Last active December 28, 2023 08:16
Make Windows 10 Great Again - stop Windows 10 spying!
@echo off
setlocal EnableDelayedExpansion
ver | find "10." > nul
if errorlevel 1 (
echo Your Windows version is not Windows 10... yet. Brace yourself, Windows 10 is coming^^!
alirobe / reclaimWindows10.ps1
Last active July 3, 2024 09:36
This Windows 10 Setup Script turns off a bunch of unnecessary Windows 10 telemetery, bloatware, & privacy things. Not guaranteed to catch everything. Review and tweak before running. Reboot after running. Scripts for reversing are included and commented. Fork of (different defaults). N.…
### UPDATE: For Win 11, I recommend using this tool in place of this script:
### iwr -useb | iex
ishu3101 /
Created November 24, 2015 08:35
Transfer a gist to a GitHub repository

Transfer a gist to a GitHub repository

clone the gist

git clone

rename the directory

mv 6fb35afd237e42ef25f9 ConvertTo-Markdown

change the working directory to the newly renamed directory

cd ConvertTo-Markdown

DorianDepriester / GoogleBookDownloader
Created July 2, 2014 08:27
Google Book Downloader
// ==UserScript==
// @name Google Book Downloader
// @namespace
// @description Download any book from
// @include*
// @include*
// @require
// @version 2.3
// ==/UserScript==
aaronpowell / gist:6695293
Created September 25, 2013 04:55
Copy Umbraco files on build
<Target Name="BeforeBuild">
<UmbracoFiles Include="..\packages\UmbracoCms.6.1.5\UmbracoFiles\umbraco\**\*;" />
<UmbracoClientFiles Include="..\packages\UmbracoCms.6.1.5\UmbracoFiles\umbraco_client\**\*;" />
<Copy SourceFiles="@(UmbracoFiles)" DestinationFiles="@(UmbracoFiles->'umbraco\%(RecursiveDir)%(Filename)%(Extension)')" />
<Copy SourceFiles="@(UmbracoClientFiles)" DestinationFiles="@(UmbracoClientFiles->'umbraco_client\%(RecursiveDir)%(Filename)%(Extension)')" />