Adimian
  • Home
  • Portfolio
  • Consulting
  • Training
  • Jobs
  • Blog
Sign in Subscribe
Bertrand Chenal

Bertrand Chenal

Fast xlsx parsing with Python
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 dive into the structure of XLSX files * The lxml library and the XSLT transformation * How to use XSLT to parse
Sep 4, 2018 10 min read
CTE and closure tables
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 is the Closure Table approach.The basic idea is to store all the ancestor-descendant relation and their depths. So from
Oct 23, 2014 4 min read
Paramiko and corporate proxies
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) client.connect( hostname=host, port=port, username=username, password=password, sock=sock, ) where proxy_command contains a string with a
Oct 16, 2014 1 min read
Page 1 of 1
Adimian © 2023
Powered by Ghost