Skip to content

Instantly share code, notes, and snippets.

View zzl0's full-sized avatar

zzl zzl0

164 followers · 158 following
View GitHub Profile
@zzl0
zzl0 / learning_rust.md
Created February 6, 2024 05:40 — forked from noxasaxon/learning_rust.md
Learn Rust!
@zzl0
zzl0 / sapling-basic-test.txt
Last active November 14, 2023 00:00
sl version
sl clone https://github.com/zzl0/sapling-test.git && cd sapling-test
echo 1 >> a.txt
sl ci -m 'update a.txt'
sl isl
sl push
@zzl0
zzl0 / version_control_diff_patch_merge_analysis.md
Created September 4, 2023 21:47 — forked from CMCDragonkai/version_control_diff_patch_merge_analysis.md
Version Control Diff, Patch and Merge Analysis (mostly Git)

Version Control Diff, Patch and Merge Analysis (mostly Git)

Inspired by this: https://github.com/mndrix/merge-this

Intrafile-Intraline Change

Where branch A and branch B changes 2 different contiguous sets of characters on the same line, but the changes are non-overlapping. Both changes can change the line length arbitrarily.

@zzl0
zzl0 / merger.py
Created September 3, 2023 03:04 — forked from stepchowfun/merger.py
My three-way merge algorithm, originally designed for 6.033 DP2.
#!/usr/bin/python -O
################################################################################
################################################################################
#
# State-Based Text Merging Algorithm
# For 6.033 Design Project 2
# TA: Katherine Fang
# 9 May 2012
#
@zzl0
zzl0 / README.md
Created June 5, 2023 19:58 — forked from borekb/README.md
Why Git doesn't track renames – original email by Linus Torvalds

Why Git doesn't track renames – original email by Linus Torvalds

A copy / backup of Linus' email from 15 Apr 2005.

@zzl0
zzl0 / your-first-report
Created December 18, 2020 19:41 — forked from dbrent-amazon/your-first-report
Note that this is sandbox. If you have not registered profiles in sandbox you
will need to do so prior to making these calls. You will also need at least
one campaign, ad group, and keyword before you see anything in the report.
While in sandbox, we will return “dummy” data so that you can see how an actual
report would look.
To make it look nicer, I always export my access token prior to making calls.
You could do the same for API-Scope (profile Id) if you wish. Make sure to use
quotes around the access token if it isn’t URL encoded. It has a | (pipe)
symbol and your shell won’t like it.
@zzl0
zzl0 / redash-test.csv
Created November 18, 2020 22:10
redash-test
Date Country/Region Province/State Confirmed Recovered Deaths
2020-01-22 Afghanistan 0 0 0
2020-01-23 Afghanistan 0 0 0
2020-01-24 Afghanistan 0 0 0
2020-01-25 Afghanistan 0 0 0
2020-01-26 Afghanistan 0 0 0
2020-01-27 Afghanistan 0 0 0
2020-01-28 Afghanistan 0 0 0
2020-01-29 Afghanistan 0 0 0
2020-01-30 Afghanistan 0 0 0
@zzl0
zzl0 / gpdb-except-bug.md
Created August 19, 2020 21:36

GPDB Version

$ git log --all --graph --decorate
* commit ce261a87769335185480b4b0c7f251669018938f (HEAD -> dev, origin/6X_STABLE)
| Author: Lisa Owen <lowen@pivotal.io>
| Date:   Wed Aug 19 10:32:32 2020 -0700
|
|     docs - clarify gpcopy supported greenplum versions (#10621)
@zzl0
zzl0 / ParsingExpressions.md
Last active March 15, 2020 04:51
@zzl0
zzl0 / sql-mysteries.md
Last active January 2, 2020 02:54
https://github.com/NUKnightLab/sql-mysteries 
select * from crime_scene_report where date=20180115 and type='murder' and city='SQL City'

Description: Security footage shows that there were 2 witnesses. The first witness lives at the last house on "Northwestern Dr". The second witness, named Annabel, lives somewhere on "Franklin Ave".

select id, name, address_number, address_street_name, transcript
from person join interview