| 3251 |
mrmanese |
1 |
\name{SQLiteDF-package}
|
|
|
2 |
\alias{SQLiteDF-package}
|
|
|
3 |
\alias{SQLiteDF}
|
|
|
4 |
\docType{package}
|
| 3324 |
mrmanese |
5 |
\title{ SQLite data frames }
|
|
|
6 |
\description{ S3 and utility methods to implement SQLite data frames. }
|
| 3251 |
mrmanese |
7 |
\details{
|
| 3324 |
mrmanese |
8 |
This package aims to transparently operate on data frames stored in
|
| 3432 |
mrmanese |
9 |
SQLite databases. The following functions are known to be working with
|
|
|
10 |
SQLiteDF types:\\
|
|
|
11 |
|
|
|
12 |
\strong{sqlite.vector}
|
|
|
13 |
\itemize{
|
|
|
14 |
\item{Math, Summary, Ops groups}{except for those with 2 args in Math
|
|
|
15 |
like \code{round}, and \code{\%\%} and \code{\%/\%} in Ops}
|
|
|
16 |
\item{summary}{out of the box works for numeric, integer, character.
|
|
|
17 |
Also works for logical, factor using "group by", however factor's do not
|
|
|
18 |
handle NA's specially. }
|
|
|
19 |
\item{length}{Ok}
|
|
|
20 |
\item{\code{\[}}{not yet \code{\[<-}}
|
|
|
21 |
\item{sort}{sorts to a new sqlite.vector}
|
| 3251 |
mrmanese |
22 |
}
|
| 3432 |
mrmanese |
23 |
|
|
|
24 |
\strong{sqlite.data.frame}
|
|
|
25 |
\itemize{
|
|
|
26 |
\item{length}{returns no. of variables}
|
|
|
27 |
\item{dimnames, names, row.names}{returns names of variables and rows}
|
|
|
28 |
\item{dim, nrow, ncol}{dimension of variables}
|
|
|
29 |
\item{\code{\$}, \code{[[}}{returns columns as sqlite.vector. no assignments yet}
|
|
|
30 |
\item{\code{[}}{works for numeric & integer indexing (ranges and vectors),
|
|
|
31 |
logical indexes with recycling. does not support negative and character (row/column name) indexing.}
|
|
|
32 |
\item{is.list}{returns false, so that other functions can }
|
|
|
33 |
\item{rbind}{works only when rbind()-ing data frames with the same names()}
|
|
|
34 |
\item{with}{Ok}
|
|
|
35 |
\item{as.data.frame}{just returns itself}
|
|
|
36 |
\item{as.list}{returns a list of sqlite.vector for each variable}
|
|
|
37 |
\item{rbind}{currently works only with data.frame's}
|
|
|
38 |
\item{lapply, sapply}{out of the box}
|
|
|
39 |
\item{summary}{out of the box, after implementing sqlite.vector}
|
|
|
40 |
}
|
|
|
41 |
}
|
| 3251 |
mrmanese |
42 |
\author{
|
|
|
43 |
Miguel A. R. Manese
|
|
|
44 |
Maintainer: Miguel A. R. Manese <jjonphl@gmail.com>
|
|
|
45 |
}
|
|
|
46 |
\keyword{ package }
|
The R Project SVN
R-packages