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

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

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

LISTEN / NOTIFY | SKIP LOCKED | Implementing our worker

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

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 | Eager and lazy computation | Example | Comparison | Prudence | Concept | Enforcing DuckDB operation | From stingy to lavish | Thrift | File ingestion and custom limits | Conclusion

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

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

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

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

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

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

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

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

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

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

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

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

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

Goals, and how achieved | Non-goals | Workflow

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

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

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

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

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

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

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

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

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

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

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

Prefixes | Suffixes

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

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

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

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

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

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