csv-to-sqlite
This is a simple, datatype-guessing script that takes CSV files as input and copies their contents into a SQLite database.
(Column names are taken from the headers (first row) in the csv file.)
Intended for Python 3. (I know it did run on Py2 as some people tried, but I haven't tested it.)
Links
- Source on GitHub
- PyPI page
- Introductory blog post with basic intro + a how-to
- Other related blog posts
Overview
Installs via
pip install csv-to-sqlite
To find out more, run
csv-to-sqlite --help
If you've installed the package as a dependency for your own script, you can use it like this:
import csv_to_sqlite
# all the usual options are supported
options = csv_to_sqlite.CsvOptions(typing_style="full", encoding="windows-1250")
input_files = ["abilities.csv", "moves.csv"] # pass in a list of CSV files
csv_to_sqlite.write_csv(input_files, "output.sqlite", options)