Description Usage Arguments Value Examples
Fetch a full table from an SQLite database
1 |
table |
Name of the database table to fetch. |
file |
Path to the SQLite database file |
The table as a data.frame.
1 2 3 4 5 6 7 8 9 10 11 12 13 | # Setup ----
library(RSQLite)
database_file <- tempfile()
conn <- dbConnect(SQLite(), dbname = database_file)
dbWriteTable(conn, "mtcars", mtcars[1:5, ])
dbWriteTable(conn, "USArrests", USArrests[1:5, ])
dbDisconnect(conn)
# Example ----
sqliteReadTable("mtcars", database_file)
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.