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 dive into the structure of XLSX files * The lxml library and the XSLT transformation * How to use XSLT to parse

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 is the Closure Table approach.The basic idea is to store all the ancestor-descendant relation and their depths. So from

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) client.connect( hostname=host, port=port, username=username, password=password, sock=sock, ) where proxy_command contains a string with a