BI Architect in the CDN biz. Database nerd: PostgreSQL, Python, Redis. Recovering DBA.
Joined October 2012
·
PostgreSQL UPSERT pattern
Matt Keranen
·
0 responses
·
postgresql, upsert
Simple quote-comma CSV parsing in Awk
Matt Keranen
·
0 responses
·
awk, csv
Live console charts with gnuplot and feedgnuplot
Matt Keranen
·
0 responses
·
bash, gnuplot
Generate Redis protocol from csv using Awk
Matt Keranen
·
2 responses
·
redis, awk
Monitor zfs send and receive (with parallel compression)
Matt Keranen
·
2 responses
·
hybriddba, zfs
Query MS SQL Server from Linux
Matt Keranen
·
1 response
·
hybriddba, sql server, mssql
PostgreSQL data and index size by table
Matt Keranen
·
7 responses
·
hybriddba, postgresql
View blocked / blocking processes
Matt Keranen
·
0 responses
·
hybriddba, postgresql
Simple bulk import automation using psql COPY
Matt Keranen
·
0 responses
·
python, hybriddba, postgresql
Pipe Viewer views pipes - and long running restores
Matt Keranen
·
0 responses
·
database, hybriddba, bash, postgresql
Chunking large text files with multiple Python processes (and Redis)
Matt Keranen
·
0 responses
·
python, redis, hybriddba
Yet another script to split PostgreSQL dumps into object files
Matt Keranen
·
0 responses
·
python, hybriddba, postgresql
Achievements
406 Karma
39,382 Total ProTip Views
Forked
Have a project valued enough to be forked by someone else
Charity
Fork and commit to someone's open source project in need
Python 3
Have at least three original repos where Python is the dominant language
Python
Would you expect anything less? Have at least one original repo where Python is the dominant language