Re: [sqlite] bulk processes with dll or obj versions?
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?
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?
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?
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?
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