wiremoons/csv2sql

csv2sql - conversion program to convert a CSV file to SQL format to allow easy checking / validation, and subsequent import into a SQLite3 database using SQLite '.read' command

Welcome!

My programs primarily focus on command line interface (CLI) tools that provide utilities for my own personal use. These are shared as open source in case they are of use to others. Most of my programs should work on any mainstream operating system (ie Linux; Windows; macOS; FreeBSD; etc), as I tend to use them all from time to time. My primary OS is Linux, so most of my code and activities originate on that platform.

You can also visit my main web site here: www.wiremoons.com

I hope you find something useful or interesting 😄

If you want to report a problem with one of my code repositorties, or you just want to leave me a message or comment, you are welcome use the GitHub form here: Open Issue.

Other Places

csv2sql's Issues

Oracle enhancement request

Would be awesome if you could enhance it for Oracle and possibly Postgres/Mysql (through some flag options hopefully)
For Oracle, the CREATE statement would need the datatype and size (you can default it to VARCHAR2 (1024) ) and the column name cannot exceed 30 characters. The insert statements need single-quoting. May be this too much of an ask.

BTW, this is an outstanding tool. And your documentation is perfect. I love it!

M1 Support

I get this error on M1 mac:

rosetta error: overlapping Mach-O segments:
./csv2sql-macx64[1] 65753 abort ./csv2sql-macx64 -f mycsv.csv -k=true -t