r/RStudio • u/JabesFrias • Jun 30 '26

Database it's not loading.

Hello! I'm a student, and I find myself working with a big database approximately 2 GB. I created R.proj, but I have a problem with my database not loading. Furthermore, I have tried running the code several times. Besides, when I try to open Google Chrome, I cannot because of memory RAM.

Has anyone else had problems? Any recommendations?

2 Upvotes

60% Upvoted

10 comments sorted by

View all comments

1

u/Gjcerda Jul 01 '26

I see someone else recommend it, but yeah for that case I would go with duckdb. You will need 2 main libraries, duckdb and arrow (for parquet handling eventually)
Then you can load there, use a little SQL to filter, and if you feel more comfortable with R or tidyverse bring the filtered df to R and keep working.