Re: [sqlite] creating unique data takes many hours, help

Hi, Yes, I am dealing with dna sequences, the data is huge, human genome is about 3.2 billion records, others are of similar size. Before I found squile, using native C, I extracted the strings, testing for uniqueness. With sqlite I did the same and it took about the same time, once I added the

Re: [sqlite] creating unique data takes many hours, help

Thanks very much. I will try different values for the loops until a get an optimal number, and I will try the "PRAGMA cache_size = <#pages>". command. question: When you say > 2)Sort your input file on the PRIMARY KEY > or on some other INDEX I thought that while sqlite inserts the

Re: [sqlite] [C] API: INSERT OR REPLACE

Hi Severin, I found very useful the actual code samples at this location: http://www.apress.com/book/downloadfile/2847 The samples for C are under the subdirectory CAPI, there is no subdirectory called C Also you will find additional information at http://www.sqlite.org/c_interface.html

Re: [sqlite] writting a text file from sqlite db in C

Thanks for your help. I checked those sites, and I worked with sqlite3.exe using the command line tool, no problems, however I can not find anywhere samples of how to applied these commands in C. Thru trial and error, I can now use sqlite3_open(), sqlite3_close(), to open and close databases as

[sqlite] how many tables can I have in one database

Dear colleagues, I understand that Sqlite can handle databases with 2 teragytes of data each. I would like to know how many tables can a dabase have. Thank you Michael ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] writting a text file from sqlite db in C

Hi everybody, I would like to find the exact code in C to output to a text file, data from a sqlite db in "C" Also, is there a place to find C sample code for Sqlite? Thank you very much Michael ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] insert in C

Hi Rajesh Nair, It works perfectly, Thank you, Michael > If you want to use sqlite3_exec function then try this > > char *zSQL = sqlite3_mprintf("INSERT INTO probes VALUES(%Q)", temp); > sqlite3_exec(db, zSQL, 0, 0, 0); > sqlite3_free(zSQL); > > This will format "temp" to hold any special

[sqlite] insert in C

Good Morning, I would like to write in C the equivalent code for: insert into table1 values('Hello'); using a variable char temp[20]= "Hello"; instead of the literal Hello I have used multiple variations of the following, but no luck char temp[20]= "Hello"; sql = "INSERT INTO

[sqlite] manual with sample C programs

Hello users group, I have been looking in the documentation for sample programs in C, but no luck yet. Could you tell me where can I find such documentation, or can you recommend some books. Thanks very much Michael R ___ sqlite-users mailing list

Re: [sqlite] running sqlite with gcc C, continuation.....

Thank you very much it works fine Michael > Hi, > > you have to compile sqlite3.c, using something like > > gcc -c sqlite3.c > > making an object file, and then linking it to your own program. > Your call combines compiler and linker using only your own source file. > > Also, it should not be

Re: [sqlite] running sqlite with gcc C

Thank you, it works perfectly The links at the bottom of your email helped a lot. Michael > On Wed, 25 Feb 2009 09:05:29 -0500 (EST), > mrobi...@cs.fiu.edu wrote in General Discussion of SQLite > Database : > >>Dear sqlite users group, >> >>I am new at SQlite3 and I

[sqlite] running sqlite with gcc C, continuation.....

Sorry, Maybe I should have included the following details: This is the program: #include #include #include int sqlite3_open( const char *filename, /* Database filename (UTF-8) */ sqlite3 **ppDb /* OUT: SQLite db handle */ ); int sqlite3_close(sqlite3 *); int main() {

[sqlite] running sqlite with gcc C

Dear sqlite users group, I am new at SQlite3 and I would be very thankful for your help. I read that SQlite does not require installation, so I downloaded the Precompiled Binaries For Windows and run sqlite3.exe in windows xp, no problem, however, I have some gcc C programs that I run in windows