baslinux AT lists.ibiblio.org
Subject: Baslinux mailing list
List archive
Re: [BL] Importing csv to sqlite db, was Re: dbf to sql convertor, was Re: Spanish dollybase,
- 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
-
Re: [BL] dbf to sql convertor, was Re: Spanish dollybase,
, (continued)
- Re: [BL] dbf to sql convertor, was Re: Spanish dollybase,, baslinux, 07/12/2008
- Re: [BL] dbf to sql convertor, was Re: Spanish dollybase,, baslinux, 07/12/2008
- [BL] upgrading glibc 2.2.5 to 2.3.1, baslinux, 07/12/2008
- [BL] Opera 9.51 was Re: upgrading glibc 2.2.5 to 2.3.1, baslinux, 07/13/2008
- Re: [BL] Opera 9.51 was Re: upgrading glibc 2.2.5 to 2.3.1, baslinux, 07/15/2008
- Re: [BL] dbf to sql convertor, was Re: Spanish dollybase,, baslinux, 07/13/2008
- Re: [BL] dbf to sql convertor, was Re: Spanish dollybase,, baslinux, 07/15/2008
- Re: [BL] dbf to sql convertor, was Re: Spanish dollybase,, baslinux, 07/14/2008
- Re: [BL] dbf to sql convertor, was Re: Spanish dollybase,, baslinux, 07/14/2008
- [BL] Importing csv to sqlite db, was Re: dbf to sql convertor, was Re: Spanish dollybase,, baslinux, 07/14/2008
- Re: [BL] Importing csv to sqlite db, was Re: dbf to sql convertor, was Re: Spanish dollybase,, baslinux, 07/15/2008
- Re: [BL] Importing csv to sqlite db, was Re: dbf to sql convertor, was Re: Spanish dollybase,, baslinux, 07/15/2008
- Re: [BL] Importing csv to sqlite db, was Re: dbf to sql, baslinux, 07/16/2008
- Re: [BL] Importing csv to sqlite db, was Re: dbf to sql, baslinux, 07/16/2008
- Re: [BL] Importing csv to sqlite db, was Re: dbf to sql, baslinux, 07/17/2008
- Re: [BL] dbf to sql convertor, was Re: Spanish dollybase,, baslinux, 07/14/2008
- Re: [BL] dbf to sql convertor, was Re: Spanish dollybase,, baslinux, 07/14/2008
Archive powered by MHonArc 2.6.24.