Man pages for SCDB
Easily Access and Maintain Time-Based Versioned Data (Slowly-Changing-Dimension)
| close_connection | Close connection to the database |
| create_index | Create the indexes on table |
| create_logs_if_missing | Create a table with the SCDB log structure if it does not... |
| create_table | Create a historical table from input data |
| db_locks | Sets, queries and removes locks for database tables |
| db_timestamp | Determine the type of timestamps the database supports |
| defer_db_cleanup | Delete table at function exit |
| digest_to_checksum | Computes an checksum from columns |
| filter_keys | Filters .data according to all records in the filter |
| get_connection | Opens connection to the database |
| get_schema | Get the current schema/catalog of a database-related objects |
| get_table | Retrieves a named table from a given schema on the connection |
| get_tables | List the available tables on the connection |
| id | Convenience function for DBI::Id |
| interlace | Combine any number of tables, where each has their own time... |
| is.historical | Checks if table contains historical data |
| joins | SQL Joins |
| Logger | Logger: Complete logging to console, file and database |
| LoggerNull | LoggerNull: The no-logging Logger |
| nrow | nrow() but also works on remote tables |
| pipe | Pipe operator |
| SCDB-package | SCDB: Easily Access and Maintain Time-Based Versioned Data... |
| schema_exists | Test if a schema exists in given connection |
| slice_time | Slices a data object based on time / date |
| table_exists | Test if a table exists in database |
| unique_table_name | Create a name for a temporary table |
| unite.tbl_dbi | tidyr::unite for tbl_dbi |
| update_snapshot | Update a historical table |
