Skip to content

Instantly share code, notes, and snippets.

View gtr's full-sized avatar
🇲🇽

Gerardo Torres Castro gtr

🇲🇽
View GitHub Profile
@gtr
gtr / file.kml
Created September 3, 2024 17:28
a sample kml file to test duckdb
<?xml version="1.0" encoding="UTF-8"?>
<kml xmlns="http://www.opengis.net/kml/2.2" xmlns:gx="http://www.google.com/kml/ext/2.2" xmlns:kml="http://www.opengis.net/kml/2.2" xmlns:atom="http://www.w3.org/2005/Atom">
<Document>
<Folder>
<name>Portfolio A</name>
<Placemark>
<name>Placemark 1</name>
<Point>
<coordinates>-73.8855,40.7411</coordinates>
</Point>
Time: 11ms total (execution 10ms / network 2ms)
root@:26257/defaultdb> SHOW SESSIONS;
node_id | session_id | user_name | client_address | application_name | active_queries | last_active_query | session_start | oldest_query_start | status
----------+----------------------------------+-----------+-----------------+------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------------------------------+----------------------------+----------------------------+---------
1 | 16e18084832cf4400000000000000001 | root | [::1]:51006 | ycsb | UPDATE usertabl
@gtr
gtr / keybase.md
Created December 20, 2020 21:22
keybase !!

Keybase proof

I hereby claim:

To claim this, I am signing this object:

@gtr
gtr / secret-santa.py
Created December 18, 2020 21:29
a quick script to generate random pairings for #secret #santa gifts 🎄 🎅
import random
def getNames():
names = []
f = open('names.txt', 'r')
for line in f:
names.append(line.strip('\n'))
return names
def makePairings(names):
@gtr
gtr / cats.jpg
Last active March 14, 2020 10:32
cats.jpg