[Bioc-devel] size limit of a string or a BLOB

Hi Simon,

This might be better directed to the R-sig-db list.  But anyway...

Simon Lin <simonlin at duke.edu> writes:

I have got the following error message when using RSQLite. So, what is 
the size limit of a string? and what is the limit of the BLOB (by 
defination, I assume it shoud be in the TB range at least)? Thanks! -Simon

# trying to insert a DNA sequence of about 500MB into a table

 > query01<-dbSendQuery(connect, statement = paste ("

+     insert into dna values ('", seq0, "')", sep="")
+ )

Error in sqliteExecStatement(conn, statement, ...) :
  RS-DBI driver: (error in statement: String or BLOB exceeded size limit)
+

This is a Sqlite error message, that is, not something being generated
in RSQLite directly.  The hard coded limit from the SQLite sources
is just undr 1GB.  Here's the relevant SQLite code:

    /*
    ** The maximum length of a TEXT or BLOB in bytes.   This also
    ** limits the size of a row in a table or index.
    **
    ** The hard limit is the ability of a 32-bit signed integer
    ** to count the size: 2^31-1 or 2147483647.
    */
    #ifndef SQLITE_MAX_LENGTH
    # define SQLITE_MAX_LENGTH 1000000000
    #endif

How many columns does the dna table have?  Perhaps there is a
different way to organize the data?

+ seth

Seth Falcon | seth at userprimary.net | blog: http://userprimary.net/user/