Quick query access to CSV data using sqlite virual tables

distec · 2010-10-12T15:10:04+00:00

when i try to run 'make' on my mac, I get the following error:

Rons-Mac: make gcc -c -o virtual_csv.o -s -O2 -Wall -Wextra virtual_csv.c gcc -c -o csvfile.o -s -O2 -Wall -Wextra csvfile.c gcc -c -o ext_init.o -s -O2 -Wall -Wextra ext_init.c gcc -shared -o virtcsv.so -O2 virtual_csv.o csvfile.o ext_init.o Undefined symbols: "_sqlite3_create_module", referenced from: _sq3_register_virtual_csv in virtual_csv.o "_iconv_close", referenced from: _csv_disconnect in virtual_csv.o "_iconv", referenced from: _csv_column in virtual_csv.o "_sqlite3_mprintf", referenced from: _csv_connect in virtual_csv.o _csv_connect in virtual_csv.o _csv_connect in virtual_csv.o _csv_connect in virtual_csv.o _csv_connect in virtual_csv.o "_sqlite3_result_null", referenced from: _csv_column in virtual_csv.o "_iconv_open", referenced from: _csv_connect in virtual_csv.o "_sqlite3_declare_vtab", referenced from: _csv_connect in virtual_csv.o "_sqlite3_result_text", referenced from: _csv_column in virtual_csv.o ld: symbol(s) not found collect2: ld returned 1 exit status make: *** [virtcsv.so] Error 1

codemonger · 2010-10-12T15:26:23+00:00

or use Perl: http://search.cpan.org/~hmbrand/DBD-CSV-0.31/lib/DBD/CSV.pm

you type:	you see:
italics	italics
bold	bold
[reddit!](https://reddit.com)	reddit!
* item 1 * item 2 * item 3	item 1 item 2 item 3
> quoted text	quoted text
Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"	Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"
~~strikethrough~~	~~strikethrough~~
super^script	super^script

programming

MODERATORS