Technical Fast xlsx parsing with Python So you have tried all the tools and libraries, but extracting data from giant Excel sheets is still too slow ? On the menu for this blog post we have: Quick
Technical CTE and closure tables Closure tables There is a lot of techniques to store and manipulate tree-like structures in a relational database. Among them, the one that is noteworthy for his simplicity and performance
Technical Paramiko and corporate proxies Since November 2012 and the release 1.9, the Paramiko API allows to use a proxy command when the ssh connection is created. For example: sock = paramiko.ProxyCommand(proxy_command)