Re: [sqlite] bulk processes with dll or obj versions?

2006-02-06 Thread Randall

Someone else is doing it for me;
I'll notify them;
Additionally, the interpreted language using the dll is really slow for csv 
import; whereas the ".import" is really fast!
best, Randall 



Re: [sqlite] bulk processes with dll or obj versions?

2006-02-06 Thread Clay Dowling

Randall said:
> Hi,
> Thanks so much for your offer, but i am not able to compile "C"; I'll see
> if
> anyone else here could do it.
> [if it is so easy, why does it not get included...?]
> Best, Randall

Randall,

If C won't work for you, it's highly likely that whatever language you are
using has facilities for reading comma-separated values already.  It's a
very common format.

I can't personally see a good reason for the library to include the
ability to read CSV text.  It's easy to write in most languages (many
include it as a native import format), and if you're using the library
rather than the command line client you're obviously a programmer.  If
you're not a programmer, you won't find the library very useful.

Clay


>> These features aren't built directly into the library, but implemented
>> in
>> the client.  However it's very easy to implement those in code.  If
>> you'd
>> like I can supply C source to parse the CSV text.
>>
>> Clay Dowling
>> --
>> http://www.lazarusid.com/notes/
>> Lazarus Notes
>> Articles and Commentary on Web Development
>
>


-- 
Simple Content Management
http://www.ceamus.com



Re: [sqlite] bulk processes with dll or obj versions?

2006-02-05 Thread Randall

Hi,
Thanks so much for your offer, but i am not able to compile "C"; I'll see if 
anyone else here could do it.

[if it is so easy, why does it not get included...?]
Best, Randall
These features aren't built directly into the library, but implemented in 
the client.  However it's very easy to implement those in code.  If you'd 
like I can supply C source to parse the CSV text.


Clay Dowling
--
http://www.lazarusid.com/notes/
Lazarus Notes
Articles and Commentary on Web Development 




Re: [sqlite] bulk processes with dll or obj versions?

2006-02-05 Thread Clay Dowling

Randall wrote:

Hi,
I have a DOS wrapper running sqlite3.exe at present.
Do either the dll version or obj wrapper versions accept ".import" or 
".output" or equivalent as a bulk process to and from csv, or only line 
by record?
If so, what are the commands? [noting that "copy" is removed from 
version 3 on?..] (or where can i find them?...)


These features aren't built directly into the library, but implemented 
in the client.  However it's very easy to implement those in code.  If 
you'd like I can supply C source to parse the CSV text.


Clay Dowling
--
http://www.lazarusid.com/notes/
Lazarus Notes
Articles and Commentary on Web Development


[sqlite] bulk processes with dll or obj versions?

2006-02-05 Thread Randall

Hi,
I have a DOS wrapper running sqlite3.exe at present.
Do either the dll version or obj wrapper versions accept ".import" or 
".output" or equivalent as a bulk process to and from csv, or only line by 
record?
If so, what are the commands? [noting that "copy" is removed from version 3 
on?..] (or where can i find them?...)
Thanks, Randall