EasyCSV2SQLite icon

App Specs
File size:
255.80 KB
Version:
1.0
Released:
August 3, 2011
Updated:
January 9, 2013


Follow Uson Google+

Description
NOW OPEN SOURCED AT GITHUB!

https://github.com/pj4533/EasyCSV2SQLite

EasyCSV2SQLite makes it easy to convert comma delimited text files to sqlite databases. The primary use would be to include datasets inside development projects. To further enable this, EasyCSV2SQLite will generate objective-c code necessary to read the created SQLite database.

EasyCSV2SQLite is a very simple application, but does its job well!

  • each column is a VARCHAR(255)
  • line endings for the CSV file can be LF/CR/CRLF
  • first line used as column headers
  • objective-c code generated for reading database
  • uses NSScanner rather than componentsSeparatedByString so it properly parses commas in quotation marks

    The code generation was initially based on code from a blog post at dBlog.com.au. Thanks to them for showing how easy it is to read SQLite from objective-c!

  • EasyCSV2SQLite (com.saygoodnight.easycsv2sqlite) is a Mac software application that has been discovered and submitted by users of Software.com.

    Operating System: Mac

    Default Install Path: /Applications/EasyCSV2SQLite.app

    Minimum OS version: 10.6

    Copyright: Copyright (c) 2011 Say Goodnight Software. All rights reserved.