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
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
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 da
Hi,
I am new with sqlite, and I create a program that reads several mllion
records and puts them into a sqlite db using.
The table has one column ONLY indexed and unique, but it takes many hours.
Is it necessary to pre-allocate the space, or is the anything that I can
do to reduce the time it ta
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
Good
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 w
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
http://sqlite.org:8080/cgi-bi
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
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 chars
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 pro
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
sq
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 n
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 would be very thankful for
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()
{
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
15 matches
Mail list logo