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

[Sean Davis]

Simon Lin wrote:
> 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)
> +
>   

Hi, Simon.  I cannot comment directly on the RSQLite limits, but here is 
what SQLite says about limits:

http://www.sqlite.org/limits.html

Sean