cynkra.com (@cynkra_com) 's Twitter Profile
cynkra.com

@cynkra_com

enthusiastic about working with and contributing to the R community

ID: 1226625072489803778

linkhttps://www.cynkra.com calendar_today09-02-2020 21:53:47

61 Tweet

454 Followers

203 Following

cynkra.com (@cynkra_com) 's Twitter Profile Photo

Did you know that you can explicitly generate the code for a given #rstats dm object? Use dm_paste() to print the code that creates a version of your dm object. Idea and name borrowed from @MilesMcBain's {datapasta}. cynkra.github.io/dm/reference/d… tinyurl.com/dm-paste

Did you know that you can explicitly generate the code for a given #rstats dm object? Use dm_paste() to print the code that creates a version of your dm object. Idea and name borrowed from @MilesMcBain's {datapasta}.

cynkra.github.io/dm/reference/d…

tinyurl.com/dm-paste
cynkra.com (@cynkra_com) 's Twitter Profile Photo

Filtering one or more tables of a dm object, and then applying the filters, has a cascading effect on the foreign tables, leaving only the rows that have a related entry in the filtered tables. Works both locally and remotely. cynkra.github.io/dm/articles/te… tinyurl.com/dm-filter

Filtering one or more tables of a dm object, and then applying the filters, has a cascading effect on the foreign tables, leaving only the rows that have a related entry in the filtered tables. Works both locally and remotely.

cynkra.github.io/dm/articles/te…

tinyurl.com/dm-filter
cynkra.com (@cynkra_com) 's Twitter Profile Photo

#rstats {dm} allows us to manipulate a collection of related tables (called data model). dm_wrap_tbl() wraps a whole data model into a single tibble dm by nesting child tables and packing parent tables into a chosen root table! cynkra.github.io/dm/reference/d… tinyurl.com/dm-wrapping

#rstats {dm} allows us to manipulate a collection of related tables (called data model). dm_wrap_tbl() wraps a whole data model into a single tibble dm by nesting child tables and packing parent tables into a chosen root table!

cynkra.github.io/dm/reference/d…

tinyurl.com/dm-wrapping
cynkra.com (@cynkra_com) 's Twitter Profile Photo

Which DataBase Management System does #rstats {dm} support? All of them! Postgres, MS SQL, SQLite, MariaDB, DuckDB, Oracle... {dm}'s functions are using {dbplyr} magic and are database agnostic. Migrate your dm, code still works! cynkra.github.io/dm/articles/ho… tinyurl.com/dm-database

Which DataBase Management System does #rstats {dm} support? All of them! Postgres, MS SQL, SQLite, MariaDB, DuckDB, Oracle... {dm}'s functions are using {dbplyr} magic and are database agnostic. Migrate your dm, code still works!

cynkra.github.io/dm/articles/ho…

tinyurl.com/dm-database
cynkra.com (@cynkra_com) 's Twitter Profile Photo

Turn all tables in a DB schema into a remote #rstats dm object using dm_from_src(). Upload a dm object with copy_dm_to() to a DB. Key relations are preserved in either operation for SQL Server & Postgres; other DBMS in the queue. cynkra.github.io/dm/articles/ho… tinyurl.com/dm-from-src

Turn all tables in a DB schema into a remote #rstats dm object using dm_from_src().
Upload a dm object with copy_dm_to() to a DB.
Key relations are preserved in either operation for SQL Server & Postgres; other DBMS in the queue.

cynkra.github.io/dm/articles/ho…

tinyurl.com/dm-from-src
cynkra.com (@cynkra_com) 's Twitter Profile Photo

"You’re likely to need many joins when working with data from a database... the dm package by Tobias Schieferdecker, Kirill Müller 🇺🇦 @[email protected] and Darko Bergant is a life saver" 😍 Thanks Hadley Wickham for building and maintaining a large part of the stack that makes {dm} possible in the first place!

Antoine Fabri (@antoine_fabri) 's Twitter Profile Photo

I felt it'd be bad luck to announce it before but I'm in the bus from NYC to DC, very excited to participate to my first #RStudioConf with the cynkra.com team! If you want to talk to me I definitely would love to talk to you. See you there! #rstudioconf2022 #rstats

I felt it'd be bad luck to announce it before but I'm in the bus from NYC to DC, very excited to participate to my first #RStudioConf with the <a href="/cynkra_com/">cynkra.com</a> team! If you want to talk to me I definitely would love to talk to you. See you there! #rstudioconf2022 #rstats
Patrick Schratz (@patscli) 's Twitter Profile Photo

Blogpost #2 of the day of mine on the cynkra.com blog, rather technical and long: EFS vs. NFS for RStudio on Kubernetes (AWS): Configuration and considerations cynkra.com/blog/2022-09-1… #rstats R Weekly Submit #rstudio