Skip to Content.
Sympa Menu

baslinux - Re: [BL] Importing csv to sqlite db, was Re: dbf to sql convertor, was Re: Spanish dollybase,

baslinux AT lists.ibiblio.org

Subject: Baslinux mailing list

List archive

Chronological Thread  
  • From: baslinux AT lists.ibiblio.org
  • To: baslinux AT lists.ibiblio.org
  • Subject: Re: [BL] Importing csv to sqlite db, was Re: dbf to sql convertor, was Re: Spanish dollybase,
  • Date: Tue, 15 Jul 2008 15:30:00 +0000 (UTC)

sqlite 2 does not have the .import feature, only sqlite3.

After I imported the csv data with sqlite3, the resulting database works with sqlite3 but not with sqlite (2), which says it is not in database format.

The import feature is very handy for creating the database and also
it should be possible to save files (.output filename before selecting what to put into the file with select COLUMN from TABLE), edit with text editor (in order to duplicate an entry then modify it), and reimport.

Perhaps Steven could make a uclibc-static or libc5 dynamic sqlite3 for BL.


There is also an SQlite Analyzer which probably uses the libsqlite3 so library so I will leave the library as a separate file, but how would I compile it into sqlite3?

./configure --enable-static I think would include ALL the libraries including libc.

Sindi Keesan





Archive powered by MHonArc 2.6.24.

Top of Page