Home
About
SK blog
Rapture in Everything
Posts tagged "csv-to-sqlite"
2022 Dec 13
2022 Dec 13
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
cli
tools
2020 Apr 18
2020 Apr 18
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...
tools
python
csv-to-sqlite
2019 Apr 24
2019 Apr 24
csv-to-sqlite 2.0 - memory improvements
My csv-to-sqlite script got some updates - most importantly it now requires far less memory....
tools
python
open source
2016 May 04
2016 May 04
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....
tools
python
open source