Skip to content

Instantly share code, notes, and snippets.

Working from home

Istvan l1x

Working from home
Block or report user

Report or block l1x

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
l1x /
Last active Jan 25, 2020
SQL structure of Safari's history tables
sqlite3 ~/Library/Safari/History.db
sqlite> .tables
history_client_versions  history_items            history_tombstones
history_event_listeners  history_items_to_tags    history_visits
history_events           history_tags             metadata
View presto.mem.issue
Query failed (#20200116_080226_04202_txkag) in Presto:
Query exceeded per-node user memory limit of 20GB
[ Allocated: 20.00GB,
Delta: 688.14kB,
Top Consumers:
{ OrderByOperator=20.00GB,
ExchangeOperator=5.71MB } ]
l1x /
Last active Dec 2, 2019
Installing the environment for AWS Lambda and F# (Fsharp)

Installing .NET SDK

brew tap isen-ng/dotnet-sdk-versions
brew cask install dotnet-sdk-2.2.400

Creating Serverless Service

I think it is a good option to have separate dev and prod services in separate folders so we cannot accidentally deploy to prod, that is a problem when relying on environment variables.


Keybase proof

I hereby claim:

  • I am l1x on github.
  • I am l1x ( on keybase.
  • I have a public key ASCW3LuhleISdHbcI77ZHqThTbH0BUfhK58fm9eBuf9zxwo

To claim this, I am signing this object:

l1x /
Last active Oct 9, 2019
Python 3 version of converting JSON to YAML one liner
python -c 'import sys, yaml, json; j=json.loads(; print(yaml.safe_dump(j))'
# on windows(PS):
# Get-Content example.json | python -c 'import sys, yaml, json; j=json.loads(; print(yaml.safe_dump(j))' > example.yaml
# on Unix clones
# python -c 'import sys, yaml, json; j=json.loads(; print(yaml.safe_dump(j)) < example.json > example.yaml
l1x /
Last active Sep 17, 2019
One liner to print out runtime statistics for the last N Athena queries
export PROFILE=foxi-maxi
export REGION=eu-west-1
aws --region $REGION --profile $PROFILE athena list-query-executions --max-items 10 \
| jq '.QueryExecutionIds[]' \
| xargs -I {} aws --region $REGION --profile $PROFILE athena get-query-execution --query-execution-id {} \
| jq '.QueryExecution.Statistics'
l1x /
Last active Sep 10, 2019
Merging Parquet files with Python
import os
import pyarrow.parquet as pq
# Warning!!!
# Suffers from the same problem as the parquet-tools merge function
#parquet-tools merge:
#Merges multiple Parquet files into one. The command doesn't merge row groups,
#just places one after the other. When used to merge many small files, the
l1x /
Created Sep 10, 2019
Wat moments while coding in Python
# nope
for folder in "state/" "logs/":
# nope #2
for folder in [ "state/" "logs/" ]:
# yes
for folder in "state/", "logs/":
l1x /
Created May 29, 2019
Git aliases for PowerShell
function gpom { git pull origin master }
Set-Alias -Name pull -Value gpom
function gpod { git pull origin develop }
Set-Alias -Name gpod -Value gpod
You can’t perform that action at this time.