Rapture in Everything

Posts tagged "csv-to-sqlite"

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....

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....