Re: [sqlite] Importing a big text file (CSV?)

2007-07-19 Thread Veikko Mäkinen
Alberto Simões wrote: Hi I have a file (big file with 16 000 000 lines) with records like 2 3 4 4 3 2 5 4 387 5 8 5473 ... and I want to import this to an SQLite table. Although I can replace all this to INSERT commands very easily, I would like to ask first if there is any faster method. I

Re: [sqlite] Finding record position

2007-07-17 Thread Veikko Mäkinen
Colin Manning wrote: Hi Assume I have a simple table for a phone directory - names, addresses, and phone numbers etc. Next, assume the user wants to jump to a specific record in the list, or to (say) the first entry for a specific name. How do you do this with sqlite, without forcing the

Re: [sqlite] Compiling for Classic VB?

2007-07-14 Thread Veikko Mäkinen
Kees Nuyt wrote: On Sat, 14 Jul 2007 02:42:34 +0200, you wrote: PS : BTW, is there a plan to add a forum on the www.sqlite.org site to replace the mailing-list? To be honest: I hope not. +1 -veikko - To

Re: [sqlite] SQLite Documentation (take # 2)

2007-07-13 Thread Veikko Mäkinen
Griggs, Donald wrote: Hi, Veikko, I think I recall Dr. H writing that he'd set up the wiki in the hope that this would allow the user community to contribute toward excellent documentation. Would it perhaps be a good idea for you to take your new material and improvements to the old, and

Re: [sqlite] SQLite Documentation (take # 2)

2007-07-13 Thread Veikko Mäkinen
Forgot to remind that the docbook xml source is available via SVN in http://svn.projectbin.org/sqlitemanual/trunk/ and a compiled version (might not always be up-to-date) in http://projectbin.org/sqlitemanual/. - To

[sqlite] SQLite Documentation (take # 2)

2007-07-13 Thread Veikko Mäkinen
as a community effort) that would serve as a basic manual for anyone using SQLite. Yours Sincerely, Veikko Mäkinen - To unsubscribe, send email to [EMAIL PROTECTED] -

[sqlite] SQLite (3) Documentation

2007-07-05 Thread Veikko Mäkinen
Hi everyone, I'm a semi-active SQLite user and it has always bothered me how the documentation of this brilliant tool is somewhat scattered in sqlite.org/docs.html and in the wiki. Quite often when I try to help other users in #sqlite IRC channel (irc.freenode.net) I know I have seen the