Rapture in Everything

Posts tagged "python"

csv-to-sqlite 2.1.3 - security update

Over on GitHub, the Dependabot opened several PRs/notifications about security-compromised dependencies in my tool for guessing the types of data in your CSV files and importing them into a SQLite DB. I noticed it's really been quite a while since the last update, so I went ahead and fixed that. Dependabot warned that some of the updates can't be done automatically because there were larger version bumps to overcome, but I wasn't bothered - the script is quite simple, and the trivial functional...

csv-to-sqlite 2.1 - script support, encodings and brackets

Version 2.1 of csv-to-sqlite [https://pypi.org/project/csv-to-sqlite/] was just released. There are a few new things, suggested in GitHub [https://github.com/zblesk/csv-to-sqlite] issues: you can now specify that you do not want brackets around your column names, you can specify the encoding your files (the default still is UTF-8) and it's now easier to use csv-to-sqlite in scripts. If you wish to do that, simply install it as a dependency: pip install csv-to-sqlite As an aside: if you're...

csv-to-sqlite 2.0 - memory improvements

My csv-to-sqlite script got some updates - most importantly it now requires far less memory....

PyCon SK 2019

Last time I've written about PyCon was in in 2016, when it came to Slovakia for the first time. I have attended every year since, and if I was impressed then, I have to say each subsequent year was better than the one before it. It always covers a bevy of topics, from Python to machine learning, various projects people are working on, best practices in architecture, social and societal impacts of technology (people from slovensko.digital always make an appearance) and more. I especially appreci...

csv-to-sqlite - copying from CSV files to a SQLite database

csv-to-sqlite is a command line tool that **takes CSV files and dumps their contents into a SQLite database**. The basic gist: for each file, the script creates a database table with the same name, tries to guess the data type, then copies all the data into the database....