RSQLite

R RSQLite package for SQLite databases. Use for embedded SQLite database connections.

LeoLin990405 Updated 6 repo stars
r-analytics-skill banner

File contents

RSQLite Package

SQLite database interface.

Connect

library(DBI)
library(RSQLite)

# File database
con <- dbConnect(SQLite(), "database.db")

# In-memory
con <- dbConnect(SQLite(), ":memory:")

Basic Operations

# Write table
dbWriteTable(con, "mtcars", mtcars)

# List tables
dbListTables(con)

# Read table
df <- dbReadTable(con, "mtcars")

# Query
result <- dbGetQuery(con, "SELECT * FROM mtcars WHERE mpg > 20")

# Remove table
dbRemoveTable(con, "mtcars")

Parameterized Queries

# Safe from SQL injection
dbGetQuery(con,
  "SELECT * FROM users WHERE id = ?",
  params = list(user_id)
)

# Named parameters
dbGetQuery(con,
  "SELECT * FROM users WHERE name = :name AND age > :age",
  params = list(name = "John", age = 25)
)

Transactions

dbBegin(con)
tryCatch({
  dbExecute(con, "INSERT INTO ...")
  dbExecute(con, "UPDATE ...")
  dbCommit(con)
}, error = function(e) {
  dbRollback(con)
  stop(e)
})

Disconnect

dbDisconnect(con)

LeoLin990405/r-analytics-skill commit cccfcf4aba

Frequently asked questions

npx get-skill add leolin990405/rsqlite