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,747 Total ProTip Views
![](https://dj1symwmxvldi.cloudfront.net/assets/badges/forked1-63f23ad054823f6065b4526f8552dbc2c4fbaa75d22db7150d700201218ac426.png)
Forked
Have a project valued enough to be forked by someone else
![](https://dj1symwmxvldi.cloudfront.net/assets/badges/charity-bab6d575c53894cc9e395db7cdb1f0f91f176fa0cc8122c5f824e672f3d556a4.png)
Charity
Fork and commit to someone's open source project in need
![](https://dj1symwmxvldi.cloudfront.net/assets/badges/python3-355595aad795b512954169cb5ac4dbd80454a302a3b891581faa58b988650a46.png)
Python 3
Have at least three original repos where Python is the dominant language
![](https://dj1symwmxvldi.cloudfront.net/assets/badges/python-df746136c133c10a796100239e3563e3419fb4d5a7b8cc9bed181c941f6dbf55.png)
Python
Would you expect anything less? Have at least one original repo where Python is the dominant language