‘RSQLite’ January 21, 2024 Title SQLite Interface for R Version 2.3.5 Date 2024-01-20 Description Embeds the SQLite database engine in R and provides an interface compliant with the DBI package. The source n() is a convenient wrapper that makes sure that dbCommit() or dbRollback() is called. A helper function sqliteIsTransacting() is available to check the current transaction status of the connection. Usage not coerce character data to factors. Value A data frame. See Also The corresponding generic function DBI::dbReadTable(). Examples library(DBI) db <- RSQLite::datasetsDb() dbReadTable(db, "mtcars")

....................................................................................... 18 3.3. Foreign Keys ........................................................................................... ...................................................................................... 97 5.12. Foreign Data ........................................................................................... ..................................................................................... 718 22.6. Function Security ..................................................................................... 719

....................................................................................... 17 3.3. Foreign Keys ........................................................................................ 17 Partitioning ................................................................................ 91 5.12. Foreign Data ..................................................................................... 105 5 Roles ................................................................................ 685 22.6. Function Security ............................................................................... 686 23

....................................................................................... 15 3.3. Foreign Keys ........................................................................................ 15 Partitioning ................................................................................ 81 5.11. Foreign Data ....................................................................................... 93 5 Roles .................................................................................... 596 21.6. Function Security ............................................................................... 597 22

....................................................................................... 16 3.3. Foreign Keys ........................................................................................... ...................................................................................... 86 5.11. Foreign Data ........................................................................................... ..................................................................................... 626 21.6. Function Security ..................................................................................... 626

....................................................................................... 18 3.3. Foreign Keys ........................................................................................... ...................................................................................... 97 5.12. Foreign Data ........................................................................................... ..................................................................................... 699 21.6. Function Security ..................................................................................... 700

....................................................................................... 17 3.3. Foreign Keys ........................................................................................ 17 Partitioning ................................................................................ 91 5.12. Foreign Data ..................................................................................... 105 5 Roles .................................................................................... 662 21.6. Function Security ............................................................................... 663 22

....................................................................................... 17 3.3. Foreign Keys ........................................................................................ 17 Partitioning ................................................................................ 92 5.12. Foreign Data ..................................................................................... 106 5 Roles .................................................................................... 660 21.6. Function Security ............................................................................... 661 22

....................................................................................... 18 3.3. Foreign Keys ........................................................................................... Partitioning .................................................................................... 102 5.13. Foreign Data ........................................................................................... ..................................................................................... 775 21.6. Function Security ..................................................................................... 777

....................................................................................... 18 3.3. Foreign Keys ........................................................................................... Partitioning .................................................................................... 100 5.12. Foreign Data ........................................................................................... ..................................................................................... 751 22.6. Function Security ..................................................................................... 753