[sqlite] PhD student

2015-02-26 Thread Hadley Wickham
I'd also recommend Paul Murrell's "Introduction to Data Technologies": https://www.stat.auckland.ac.nz/~paul/ItDT/ Hadley On Thu, Feb 26, 2015 at 2:11 PM, Jim Callahan wrote: > Books that discuss BOTH R and SQL are a very small subset and assume some > knowledge of both. > R INTRODUCTORY BOOKS

Re: [sqlite] Artificially slow VACUUM by injecting a sleep() somewhere?

2014-12-09 Thread Hadley Wickham
> Also, SSD drives wear out fast. We don't have good figures yet for > mass-produced drives (manufacturers introduce new models faster than the old > ones wear out, so it's hard to gather stats) but typical figures show a drive > failing in from 2,000 to 3,000 write cycles of each single

Re: [sqlite] Bug report: USBAN failure

2014-12-02 Thread Hadley Wickham
>> The block of code that refers to is: >> >> if( p->azVar ){ >> p->nzVar = pParse->nzVar; >> memcpy(p->azVar, pParse->azVar, p->nzVar*sizeof(p->azVar[0])); >> memset(pParse->azVar, 0, pParse->nzVar*sizeof(pParse->azVar[0])); >> } >> >> So maybe the check should be on

[sqlite] Bug report: USBAN failure

2014-12-02 Thread Hadley Wickham
Hi, I'm the maintainer of RSQLite, the R language binding for SQLite. Recently, CRAN (the common R archive network) has started running all R packages with USBAN. This reveals a problem in sqlite.c (http://www.stats.ox.ac.uk/pub/bdr/memtests/UBSAN-gcc/RSQLite/tests/testthat.Rout) >