1\name{load_tweets_db} 2\alias{load_tweets_db} 3\alias{load_users_db} 4\alias{store_tweets_db} 5\alias{store_users_db} 6\title{ 7 Functions to persist/load twitteR data to a database 8} 9\description{ 10 These functions allow a user to store twitteR based data to a database backend 11 as well as retrieving previously stored data 12} 13\usage{ 14store_tweets_db(tweets, table_name="tweets") 15store_users_db(users, table_name="users") 16load_users_db(as.data.frame = FALSE, table_name = "users") 17load_tweets_db(as.data.frame = FALSE, table_name = "tweets") 18} 19\arguments{ 20 \item{tweets}{A list of \code{status} objects to persist to the database} 21 \item{users}{A list of \code{user} objects to persist to the database} 22 \item{as.data.frame}{if \code{TRUE}, data will be returned as a data.frame instead of twitteR objects} 23 \item{table_name}{The database table to use for storing and loading} 24} 25\value{ 26 \code{store_tweets_db} and \code{store_users_db} return \code{TRUE} of \code{FALSE} 27 based on their success or not. The loading functions return either a \code{data.frame} 28 of the data (representing the underlying table) or a list of the appropriate \code{twitteR} 29 objects. 30} 31\author{Jeff Gentry} 32\seealso{ 33\code{\link{register_db_backend}}, \code{\link{register_sqlite_backend}}, \code{\link{register_mysql_backend}} 34} 35\examples{ 36 \dontrun{ 37 register_sqlite_backend("/path/to/sqlite/file") 38 tweets = searchTwitter("#scala") 39 store_tweets_db(tweets) 40 from_db = load_tweets_db() 41 } 42} 43\keyword{ utilities}