http://www2.sqlite.org/src/dir?name=ext/csv
On Sat, Apr 24, 2010 at 9:43 AM, Jan <janus...@gmx.net> wrote: > This sounds very useful. But where can I get this extension? > > Sorry, I could not find anything. > > Jan > > Am 21.04.2010 20:22, schrieb gwenn: > > Thanks for this great extension. > > It works smoothly with 500Mo files. > > > > And it's a workaround to some shortcomings of the '.import' command: > > - no need to create a table before, > > - no need to delete the header row before/after, > > - no error if the number of columns is not homogeneous, > > - ... > > It's a nightmare to work with the CSV format but I have to. > > > > I made a quick and dirty fix to the USE_HEADER_ROW mode to replace > > whitespaces, slashes or hyphens by underscores. > > But I look for a better solution. Is there any way to make sure a string > is > > a valid column name? > > > > Regards > > > > On Mon Apr 19 17:32:13 GMT 2010, Shane Harrelson<shane at sqlite.org> > > wrote: > >> Thanks for the report. The extension is still very a much a > >> work-in-progress and any feedback is greatly appreciated. > >> > >> -Shane > >> > >> > >> On Sun, Apr 18, 2010 at 12:51 PM, gwenn<gwenn.kahz at gmail.com> > wrote: > >>> Hello, > >>> There is a little bug/typo in the csv extension when lines exceed 100 > >>> characters: > >>> *** glibc detected *** sqlite3: realloc(): invalid pointer: > >>> 0x0000000000ad1a78 *** > >>> ======= Backtrace: ========= > >>> /lib/libc.so.6[0x7f6dab009d16] > >>> /lib/libc.so.6(realloc+0x321)[0x7f6dab00fda1] > >>> ./libSqliteCsv.so[0x7f6da9ef9dbf] > >>> > >>> A possible patch is: > >>> --- /tmp/SQLite-d474195a997b9d94/ext/csv/csv.c 2009-11-05 > > 05:14:30.000000000 > >>> +0100 > >>> +++ csv.c 2010-04-18 18:48:04.000000000 +0200 > >>> @@ -160,7 +160,7 @@ > >>> } > >>> } > >>> if( bShrink ){ > >>> - pCSV->zRow = realloc( pCSV->zRow, n+1 ); > >>> + pCSV->zRow = sqlite3_realloc( pCSV->zRow, n+1 ); > >>> pCSV->maxRow = n+1; > >>> } > >>> return bEol ? pCSV->zRow : 0; > >>> > >>> Regards. > >>> _______________________________________________ > >>> sqlite-users mailing list > >>> sqlite-users at sqlite.org > >>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > >>> > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users