R help - Aug 2023 - Book Recommendation

The SQLite is a good database to use.

https://cran.r-project.org/web/packages/RSQLite/vignettes/RSQLite.html

On Mon, Aug 28, 2023, 22:12 Stephen H. Dawson, DSL via R-help <
r-help at r-project.org> wrote:
>
> This is an academic course. The effort now is to nail down the former. I
> am pushing against a local db for the students. I prefer they focus on
> the get-and-analyze efforts and not db administration efforts.
>
>
	[[alternative HTML version deleted]]

These days I'd recommend duckdb
(https://cran.r-project.org/web/packages/duckdb/index.html) instead.
It's a similar design to RSQLite (i.e. you don't need a separate
server) but it's designed for the needs of data science.

Hadley

On Tue, Aug 29, 2023 at 9:22?AM Martin M?ller Skarbiniks Pedersen
<traxplayer at gmail.com> wrote:
>
> The SQLite is a good database to use.
>
> https://cran.r-project.org/web/packages/RSQLite/vignettes/RSQLite.html
>
> On Mon, Aug 28, 2023, 22:12 Stephen H. Dawson, DSL via R-help <
> r-help at r-project.org> wrote:
>
> >
> > This is an academic course. The effort now is to nail down the former.
I
> > am pushing against a local db for the students. I prefer they focus on
> > the get-and-analyze efforts and not db administration efforts.
> >
> >
>
>         [[alternative HTML version deleted]]
>
> ______________________________________________
> R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide
http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.


-- 
http://hadley.nz

Thanks, Martin. I appreciate your helpful assistance.


Kindest Regards,
*Stephen Dawson, DSL*
/Executive Strategy Consultant/
Business & Technology
+1 (865) 804-3454
http://www.shdawson.com


On 8/28/23 17:14, Martin M?ller Skarbiniks Pedersen
wrote:
> The SQLite is a good database to use.
>
> https://cran.r-project.org/web/packages/RSQLite/vignettes/RSQLite.html
>
> On Mon, Aug 28, 2023, 22:12 Stephen H. Dawson, DSL via R-help 
> <r-help at r-project.org> wrote:
>
>
>     This is an academic course. The effort now is to nail down the
>     former. I
>     am pushing against a local db for the students. I prefer they
>     focus on
>     the get-and-analyze efforts and not db administration efforts.
>