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
41,605 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