Rapture in Everything

Posts tagged "csv-to-sqlite"

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

Version 2.1 of csv-to-sqlite was just released. There are a few new things, suggested in GitHub 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-sqliteAs an aside: if you're not using Pipenv yet, take a look at it. It's great.Then import it and call write_csv(). import csv_to_sqlite # all the usual options are supported...

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