R Under development (unstable) (2024-07-15 r86902 ucrt) -- "Unsuffered Consequences"
Copyright (C) 2024 The R Foundation for Statistical Computing
Platform: x86_64-w64-mingw32/x64

R is free software and comes with ABSOLUTELY NO WARRANTY.
You are welcome to redistribute it under certain conditions.
Type 'license()' or 'licence()' for distribution details.

R is a collaborative project with many contributors.
Type 'contributors()' for more information and
'citation()' on how to cite R or R packages in publications.

Type 'demo()' for some demos, 'help()' for on-line help, or
'help.start()' for an HTML browser interface to help.
Type 'q()' to quit R.

> suppressMessages(library(filehashSQLite))
> 
> dbCreate("test1", "SQLite")
> db <- dbInit("test1", "SQLite")
> 
> set.seed(234)
> val <- rnorm(1000)
> 
> dbInsert(db, "a", val)
[1] 1
> x <- dbFetch(db, "a")
> 
> str(x)
 num [1:1000] 0.661 -2.053 -1.499 1.471 1.459 ...
> 
> stopifnot(identical(x, val))
> 
> dbInsert(db, "b", 1:10)
[1] 1
> dbList(db)
[1] "a" "b"
> 
> dbFetch(db, "b")
 [1]  1  2  3  4  5  6  7  8  9 10
> dbMultiFetch(db, c("a", "b")) |> 
+         str()
List of 2
 $ a: num [1:1000] 0.661 -2.053 -1.499 1.471 1.459 ...
 $ b: int [1:10] 1 2 3 4 5 6 7 8 9 10
> 
> dbDisconnect(db)
> 
> 
> proc.time()
   user  system elapsed 
   0.71    0.17    0.89