Introduction | Set up the development environment | Create a package | Create and configure a Git repository | Create initial NEWS.md file | The development phase | Create an R file | Create a test | Update NEWS.md | Review NEWS.md | Finalize version | Change code and commit | Prepare for release | Bump version for release | Generate release notes | After release | Tag version | Create GitHub release | Restart development

Implementation | Updating NEWS.md | Collecting NEWS | Tagging for "dev" vs. other releases

Introduction | To duckplyr | From files | From DuckDB | Materialization | To files | Memory usage | The big picture

Introduction | Eager and lazy computation | Example | Comparison | Prudence | Concept | Enforcing DuckDB operation | From stingy to lavish | Thrift | File ingestion and custom limits | Conclusion

Introduction | DuckDB mode | Relation objects | Help from dplyr | Enforce DuckDB operation | Configure fallbacks | Conclusion

Data types | Verbs | Functions within verbs | Parentheses | Comparison operators | Basic arithmetics | Math functions | Logical operators | Branching and conversion | String manipulation | Date manipulation | Aggregation | Shifting | Ranking | Special cases | Contributing | Known incompatibilities | Output order stability | sum() | Empty vectors in aggregate functions | min() and max() for logical input | n_distinct() and multiple arguments | is.na() and NaN values | Row names | Other differences

Introduction | From duckplyr to dbplyr | Call arbitrary functions in duckplyr | Conclusion

Introduction | External data with explicit qualification | Restoring dplyr methods | Own data | In other packages

Stack traces | R code | Native code | R code + native code | Limitations on Windows | Next steps | Technical details | Retrieving IPs | libbacktrace on the Mac | libbacktrace on Windows | Options not considered | Retrieving module name | Retrieving file + line | History: jointprof part 1 | Appendix | Further documentation links | Accompanying work

Overview

Digits | Basic differences | Terminal zeros | Trailing dot | Showing more digits | Fixed number of digits | Scientific notation | When is it used? | Enforce notation

Options | Per-column number formatting | Rule-based number formatting | Computing on num | Arithmetics | Mathematics | Override | Recovery

Topics documented elsewhere | Data frame subclasses | Tibble example | Data frame example

Conventions | Column extraction | Definition of x[[j]] | Definition of x$name | Column subsetting | Definition of x[j] | Definition of x[, j] | Definition of x[, j, drop = TRUE] | Row subsetting | Definition of x[i, ] | Definition of x[i, , drop = TRUE] | Row and column subsetting | Definition of x[] and x[,] | Definition of x[i, j] | Definition of x[[i, j]] | Column update | Definition of x[[j]] <- a | Definition of x$name <- a | Column subassignment: x[j] <- a | a is a list or data frame | a is a matrix or array | a is another type of vector | a is NULL | a is not a vector | Row subassignment: x[i, ] <- list(...) | Row and column subassignment | Definition of x[i, j] <- a | Definition of x[[i, j]] <- a

Creating | Coercion | Tibbles vs data frames | Printing | Subsetting | Recycling | Arithmetic operations

TL;DR | Project root | A simple example | Relative paths to a stable root | Example A: From vignettes | Example B: From tests/testthat | Summary of Examples A and B | Criteria | Shortcuts | Fixed root | testthat files | Another example: custom testing utilities | Summary | Acknowledgement

Header | Tweak header | Restyle header | Footer | Restyle footer | Compute additional info beforehand | Row IDs | Body | Tweak pillar composition | Tweak display of compound pillars | Restyle body

Requirements | Overview | Initialization | Setup | Header, body, footer | Colonnade | Creating pillar objects | Pillar lists | Simple pillars | Components | Formatting pillars

Basic functionality | Declare the location of the current script | Use project-relative paths | Situation report | What if the working directory is wrong? | Extra safety | Conflicts with other packages | Specify a unique identifier | Beyond here | Change project root | Under the hood: rprojroot

rmarkdown starts in a subdirectory | here always uses project-relative paths

Creating a dm object | Selecting tables | Linking tables by adding keys | Visualizing a data model | Accessing a data model as a table | Operations on table data within a dm | Checking constraints | Next Steps | Standing on the shoulders of giants

Copy models or copy tables? | Copying and persisting individual tables | Adding local data frames to an RDBMS | Persisting a relational model with copy_dm_to() | Conclusion | Further Reading

Building a dm from a subset of tables | Defining Primary and Foreign Keys | Serializing a dm object | Transient nature of operations | Performing operations on tables by "zooming" | Downloading data | Persisting results | Conclusion | Further reading

Creating a dm object from data frames | Adding Tables | A dm is a list | Defining Keys | Primary Keys | Foreign Keys | Visualization | Integrity Checks | Programming | Conclusion | Further reading

The dm_rows_* process | Usage | dm_rows_insert() | dm_rows_update() | dm_rows_delete() | dm_rows_patch() | dm_rows_upsert() | Conclusion | Further Reading

1. Data Frames and Tables | 2. Data Model | 3. Primary Keys | 4. Foreign Keys | 5. Referential Integrity | 6. Normalization | 7. Relational Databases | Conclusion | Further reading

Class dm | Examples of dm objects | Pass the tables directly | Start with an empty dm | Coerce a list of tables | Turn tables from a src into a dm | Low-level construction | Access tables | Primary keys of dm objects | Foreign keys

Data: nycflights13 | Filtering a dm object | How it works | Filtering Examples | SQL statements behind filtering a dm object on a database

Prefixes | Suffixes

Data: nycflights13 | Joining a dm object | How it works | Joining Examples

Enabling {dplyr}-workflow within a dm | Examples | Use case 1: Add a new column to an existing table | Use case 2: Creation of a surrogate key | Use case 3: Disentangle dm | Use case 4: Add summary table to dm | Use case 5: Joining tables | Use case 6: Retrieve all tables

Changes required when updating from version 0.0.5 to 0.0.6 | Replace cdm with dm | Be careful with methods for dm: tbl, [[, $

Testing key constraints | Testing cardinalities between two tables | Examples | Table surgery

Enabling {dplyr}-workflow within a dm | Examples | Use case 1: Add a new column to an existing table | Use case 2: Creation of a surrogate key | Use case 3: Disentangle dm | Use case 4: Add summary table to dm | Use case 5: Joining tables | Tip: Accessing the zoomed table | Possible pitfalls and caveats

LISTEN / NOTIFY | SKIP LOCKED | Implementing our worker

Character encoding | UTF-8 | ASCII | Latin-1 | Translating to UTF-8 | The readtext package | Summary

Testing a new backend | Testing an existing backend | External testing | Preparation | Testing

Creating a new database | Loading data | Queries | Batched queries | Multiple parameterised queries | Statements

Version | Introduction | DBI Classes and Methods | Class DBIObject | Class DBIDriver | Class DBIConnection | Class DBIResult | Data Type Mappings | Utilities | Open Issues and Limitations | Resources

Computing with Distributed Data | A Common Interface | Interface Classes | Class dbManager | Class dbConnection | Class dbResult | Class dbResultSet | Data Type Mappings | Open Issues | Limitations | Other Approaches | Open Database Connectivity (ODBC) | Java Database Connectivity (JDBC) | CORBA and a 3-tier Architecture | Resources | Acknowledgements | The S Version 4 Definitions

Who this tutorial is for | How to run more complex queries using DBI | How to read part of a table from a database | How to use parameters (safely) in SQL queries | Quoting | Parameterized queries | SQL data manipulation - UPDATE, DELETE and friends | SQL transactions with DBI | Conclusion

Getting started | Testing | Driver | Connection | Results | SQL methods | Metadata methods | Full DBI compliance

Who this tutorial is for | How to connect to a database using DBI | Secure password storage | How to retrieve column names for a table | Read a table into a data frame | Read only selected rows and columns into a data frame | How to end a DBMS session | Conclusion | Further Reading

Who this tutorial is for | Rationale | New classes and generics | Prepare | Read all rows from a table | Run queries | Prepared queries | Manual flow | Writing data | Appending data | Conclusion

Initial setup and dev workflow | Code formatting | Code organization | Naming conventions | Vector classes | Coercion functions | Protection | Protect list | Unwind Protect

1. What are the underlying types of cpp11 objects? | 2. How do I add elements to a list? | 3. Does cpp11 support default arguments? | 4. How do I create a new empty list? | 5. How do I retrieve (named) elements from a named vector/list? | 6. How can I tell whether a vector is named? | 7. How do I return a cpp11::writable::logicals object with only a FALSE value? | 8. How do I create a new empty environment? | 9. How do I assign and retrieve values in an environment? What happens if I try to get a value that doesn't exist? | 10. How can I create a cpp11:raws from a std::string? | 11. How can I create a std::string from a cpp11::writable::string? | 12. What are the types for C++ iterators? | 13. My code has using namespace std, why do I still have to include std:: in the signatures of [[cpp11::register]] functions? | 14. How do I modify a vector in place? | 15. Should I call cpp11::unwind_protect() manually? | Destructors | Nested unwind_protect() | 16. Ok but I really want to call cpp11::unwind_protect() manually

Introduction | Outline | Prerequisites | Getting started with C++ | No inputs, scalar output | Scalar input, scalar output | Vector input, scalar output | Vector input, vector output | Using cpp_source | Exercises | Other classes | Lists and data frames | Functions | Attributes | Missing values | Scalars | Integers | Doubles | Strings | Boolean | Vectors | Standard Template Library | Using iterators | Algorithms | Data structures | Vectors | Sets | Case studies | Gibbs sampler | R vectorisation versus C++ vectorisation | Using cpp11 in a package | Learning more

Motivations | Copy-on-write semantics | Improve safety | C safety | C++ safety | Altrep support | Altrep benchmarks | UTF-8 everywhere | C++11 features | Simpler implementation | Compilation speed | Header only | Vendoring | Protection | Growing vectors | Conclusion

Instalación | Uso de igraph | Crear un grafo | IDs de vértices y aristas | Añadir y borrar vértices y aristas | Construcción de grafos | Establecer y recuperar atributos | Propiedades estructurales de los grafos | Búsqueda de vértices y aristas basada en atributos | Selección de vértices | Selección de aristas | Tratar un grafo como una matriz de adyacencia | Diseños y graficación | Algoritmos de diseño | Dibujar un grafo utilizando un diseño | Atributos de los vértices para graficar | Atributos de las aristas para graficar | Argumentos más comunes de plot() | igraph y el mundo exterior | Dónde ir a continuación | Información de la sesión

Installation | Usage | Creating a graph | Vertex and edge IDs | Adding/deleting vertices and edges | Constructing graphs | Setting and retrieving attributes | Structural properties of graphs | Querying vertices and edges based on attributes | Selecting vertices | Selecting edges | Treating a graph as an adjacency matrix | Layouts and plotting | Layout algorithms | Drawing a graph using a layout | Vertex attributes controlling graph plots | Edge attributes controlling graph plots | Generic arguments of plot() | igraph and the outside world | Where to go next | Session info

Overview | Example values | Implementation

Goals, and how achieved | Non-goals | Workflow

Getting started | Cheatsheet | Vectors | Other objects | Functions | R functions | Unsupported Rcpp features | RNGs | Common issues when converting | STL includes | Strict headers | R API includes | Type aliases | Logical vector construction

Installation & setup | Functions | Full fledge usage | FAQ & edge cases