Hi
Thanks for taking your time.
I usually do it by "Packages" tab. But i had problems there.
Then i was looking for help in my past exercises an found this: origin from the local installed RStudio verson.
install.packages("RSQLite")
Error in install.packages : Updating loaded packages
> library(rsqlite)
Error in library(rsqlite) : there is no package called ‘rsqlite’
I tryed later at home with this which obviously not worked.
> install.packages("RSQLite")
Error in install.packages : Updating loaded packages
> install.packages("RSQLite")
Installing package into ‘/home/rstudio-user/R/x86_64-pc-linux-gnu-library/3.6’
(as ‘lib’ is unspecified)
also installing the dependencies ‘bit’, ‘bit64’, ‘blob’, ‘DBI’, ‘memoise’
trying URL 'http://cran.rstudio.org/src/contrib/bit_1.1-15.tar.gz'
Content type 'application/x-gzip' length 56620 bytes (55 KB)
==================================================
downloaded 55 KB
trying URL 'http://package-proxy/src/contrib/bit64_0.9-7.tar.gz'
Content type 'application/x-tar' length 539438 bytes (526 KB)
==================================================
downloaded 526 KB
trying URL 'http://package-proxy/src/contrib/blob_1.2.0.tar.gz'
Content type 'application/x-tar' length 42606 bytes (41 KB)
==================================================
downloaded 41 KB
trying URL 'http://package-proxy/src/contrib/DBI_1.1.0.tar.gz'
Content type 'application/x-tar' length 592955 bytes (579 KB)
==================================================
downloaded 579 KB
trying URL 'http://package-proxy/src/contrib/memoise_1.1.0.tar.gz'
Content type 'application/x-tar' length 34441 bytes (33 KB)
==================================================
downloaded 33 KB
trying URL 'http://package-proxy/src/contrib/RSQLite_2.2.0.tar.gz'
Content type 'application/x-tar' length 4056414 bytes (3.9 MB)
==================================================
downloaded 3.9 MB
* installing *source* package ‘bit’ ...
** package ‘bit’ successfully unpacked and MD5 sums checked
** using staged installation
** libs
gcc -I"/opt/R/3.6.0/lib/R/include" -DNDEBUG -I/usr/local/include -fpic -g -O2 -c attrutil.c -o attrutil.o
gcc -I"/opt/R/3.6.0/lib/R/include" -DNDEBUG -I/usr/local/include -fpic -g -O2 -c bit.c -o bit.o
gcc -I"/opt/R/3.6.0/lib/R/include" -DNDEBUG -I/usr/local/include -fpic -g -O2 -c chunkutil.c -o chunkutil.o
gcc -I"/opt/R/3.6.0/lib/R/include" -DNDEBUG -I/usr/local/include -fpic -g -O2 -c clone.c -o clone.o
gcc -I"/opt/R/3.6.0/lib/R/include" -DNDEBUG -I/usr/local/include -fpic -g -O2 -c init.c -o init.o
gcc -I"/opt/R/3.6.0/lib/R/include" -DNDEBUG -I/usr/local/include -fpic -g -O2 -c rle.c -o rle.o
gcc -shared -L/opt/R/3.6.0/lib/R/lib -L/usr/local/lib -o bit.so attrutil.o bit.o chunkutil.o clone.o init.o rle.o -L/opt/R/3.6.0/lib/R/lib -lR
installing to /home/rstudio-user/R/x86_64-pc-linux-gnu-library/3.6/00LOCK-bit/00new/bit/libs
** R
** exec
** inst
** byte-compile and prepare package for lazy loading
** help
*** installing help indices
** building package indices
** testing if installed package can be loaded from temporary location
** checking absolute paths in shared objects and dynamic libraries
** testing if installed package can be loaded from final location
** testing if installed package keeps a record of temporary installation path
* DONE (bit)
* installing *binary* package ‘blob’ ...
* DONE (blob)
* installing *binary* package ‘DBI’ ...
* DONE (DBI)
* installing *binary* package ‘memoise’ ...
* DONE (memoise)
* installing *binary* package ‘bit64’ ...
* DONE (bit64)
* installing *binary* package ‘RSQLite’ ...
* DONE (RSQLite)
The downloaded source packages are in
‘/tmp/Rtmpx1xizJ/downloaded_packages’
> library(rsqlite)
Error in library(rsqlite) : there is no package called ‘rsqlite’
> library(RSQLite)
Error: package or namespace load failed for ‘RSQLite’ in loadNamespace(i, c(lib.loc, .libPaths()), versionCheck = vI[[i]]):
namespace ‘DBI’ 1.0.0 is already loaded, but >= 1.1.0 is required
> library(RSQLite)
Error: package or namespace load failed for ‘RSQLite’ in loadNamespace(i, c(lib.loc, .libPaths()), versionCheck = vI[[i]]):
namespace ‘DBI’ 1.0.0 is already loaded, but >= 1.1.0 is required
> library(RSQLite)
Error: package or namespace load failed for ‘RSQLite’ in loadNamespace(i, c(lib.loc, .libPaths()), versionCheck = vI[[i]]):
namespace ‘DBI’ 1.0.0 is already loaded, but >= 1.1.0 is required
> politician_db <- DBI::dbGetQuery(zh_politicians.db)
Error in DBI::dbGetQuery(zh_politicians.db) :
object 'zh_politicians.db' not found
> dbConnect(zh_politicians.db)
Error in dbConnect(zh_politicians.db) :
could not find function "dbConnect"
> library(RSQLite)
Error: package or namespace load failed for ‘RSQLite’ in loadNamespace(i, c(lib.loc, .libPaths()), versionCheck = vI[[i]]):
namespace ‘DBI’ 1.0.0 is already loaded, but >= 1.1.0 is required
*********** Last try
install.packages("RSQLite")
Installing package into ‘/home/rstudio-user/R/x86_64-pc-linux-gnu-library/3.6’
(as ‘lib’ is unspecified)
trying URL 'http://package-proxy/src/contrib/RSQLite_2.2.0.tar.gz'
Content type 'application/x-tar' length 4056414 bytes (3.9 MB)
==================================================
downloaded 3.9 MB
* installing *binary* package ‘RSQLite’ ...
* DONE (RSQLite)
The downloaded source packages are in
‘/tmp/RtmpOoyTiF/downloaded_packages’
seems to work now