search for: loboz

Currently in R, constructing a string containing values of variables is done using 'paste' and can be an error-prone and traumatic experience. For example, when constructing a db query we have to write, paste("SELECT " value " FROM table where date ='",cdate,"'") we are getting null result from it, because without (forgotten...)

Installing R on Knoppix Knoppix is a small LINUX distribution (http://www.knoppix.net/) runnable from a CD (without an installation) It can be also installed on a hard drive from a single CD. The idea was to reuse an old laptop with 6gb hard drive and 128mb memory. I had few days experience with Linux and few years experience with R. The latter was not required :-) The Knoppix installation

..., ...) > methods?dbWriteTable ## see documentation for details * dbConnect() now accepts values for the "cache_size" and "synchronous" to tune/improve SQLite performance (see methods?dbConnect for details). Thanks to Seth Falcon, Ronggui Huang, and Charles Loboz for their patches, suggestions, bug reports and testing. -- David _______________________________________________ R-packages mailing list R-packages at stat.math.ethz.ch https://stat.ethz.ch/mailman/listinfo/r-packages

..., ...) > methods?dbWriteTable ## see documentation for details * dbConnect() now accepts values for the "cache_size" and "synchronous" to tune/improve SQLite performance (see methods?dbConnect for details). Thanks to Seth Falcon, Ronggui Huang, and Charles Loboz for their patches, suggestions, bug reports and testing. -- David _______________________________________________ R-packages mailing list R-packages at stat.math.ethz.ch https://stat.ethz.ch/mailman/listinfo/r-packages

How can I change SQLite cache size for R session? SQLite cache size can be set by a pragma, for the duration of the session - or by default. .pragma cache_size .pragma default_cache_size my questions are about RSQLite, version 0.4, running on Windows: - what is the cache size set to when SQLite is invoked from R? - if the page_size is set to 4096 what will be the cache size in bytes

Installing Damn Small Linux and R Following my experiences with Knoppix (described in another mail) I did similar test on Damn Small Linux (dsl -http://www.damnsmalllinux.org/ ). DSL was interesting, because it is the smallest yet fully functional version of Linux, hence more suited to older and smaller computers than Knoppix. Importantly, it uses lightweight windowing system (no KDE or GNOME) so

1. That was a part of a private email exchange. It has been suggested that more people may be interested. 2. I did use various databases (significant part of my job) for the last 15 years. Some with R for the last 3 years as a hobby. Some comments on the ones used below. Sorry, no links - I am time-constrained at the moment - please google if interested in details. The remarks are from the point

A question about: Kalman in R, time series and deJong-Penzer statistic - how to compute it using available artefacts of KalmanXXXXX? Background. in the paper http://www.lse.ac.uk/collections/statistics/documents/researchreport34.pdf 'Diagnosing Shocks in TIme Series', de Jong and Penzer construct a statistic (tau) which can be used to locate potential shocks. [p15, Theorem 6.1 and

(re-formulate, re-send, without html) for vector y = c(1,2,3,4,5), H = 0.66 manual calculations using the equations below give a = c(1,1.66,2.55,3.51,4.50). KalmanRun with these parameters gives res$states = (1,1,1,1,1)! for Kalman Filter Durbin/Koopman give at p67 eqs 4.13: v = y - Z a, F = Z P Z' + H, K = T P Z' / F + H, a[t+1] = T a + K v, P[t+1] = T P L'

This thread discussed R memory limitations, compared handling with S and SAS. Since I routinely use R to process multi-gigababyte sets on computers with sometimes 256mb of memory - here are some comments on that. Most memory limitations vanish if R is used with any relational database. [My personal preference is SQLite (RSQLite packaga) because of speed and no-admin (used in embedded mode)].