Skip to contents

Save Items

sbf_save_aws_files() deprecated
Download files from AWS S3
sbf_save_block()
Save Block
sbf_save_data()
Save Data
sbf_save_data_to_db()
Save Data Frame to Existing Database
sbf_save_datas()
Save Data Frames
sbf_save_datas_to_db()
Save Data Frames to Existing Database
sbf_save_db_metatable_descriptions()
Saves Meta Table Descriptions to Database
sbf_save_db_to_workbook()
Save Database to Excel Workbook
sbf_save_excel()
Save Dataframe to Excel Workbook
sbf_save_excels()
Save Excels
sbf_save_flobs_from_db()
Save flobs
sbf_save_number()
Save Number
sbf_save_numbers()
Save Numbers
sbf_save_object()
Save Object
sbf_save_objects()
Save Objects
sbf_save_plot()
Save Plot
sbf_save_png()
Save png File
sbf_save_string()
Save String
sbf_save_strings()
Save Strings
sbf_save_table()
Save Table
sbf_save_window()
Save Window
sbf_save_workbook()
Save Dataframes to Excel Workbook
sbf_save_data_to_pg() deprecated
Add data frame to PostgreSQL database

Load Items

sbf_load_block()
Load Code Block
sbf_load_blocks()
Load Blocks
sbf_load_blocks_recursive()
Load Blocks as Column in Data Frame
sbf_load_data()
Load Data
sbf_load_data_from_db()
Load Data Frame from Database
sbf_load_datas()
Load Datas
sbf_load_datas_from_db()
Load Data Frames from Database
sbf_load_datas_recursive()
Load Data Frames as List Column in Data Frame
sbf_load_db_metatable()
Load Data Frame of Meta Table from Database
sbf_load_number()
Load Number
sbf_load_numbers()
Load Numbers
sbf_load_numbers_recursive()
Load Numbers as Column in Data Frame
sbf_load_object()
Load Object
sbf_load_objects()
Load Objects
sbf_load_objects_recursive()
Load Objects as List Column in Data Frame
sbf_load_plot()
Load Plot
sbf_load_plot_data()
Load Plot Data
sbf_load_plots_data()
Load Plots Data
sbf_load_plots_data_recursive()
Load Plots Data as List Column in Data Frame
sbf_load_plots_recursive()
Load Plots as List Column in Data Frame
sbf_load_string()
Load String
sbf_load_strings()
Load Strings
sbf_load_strings_recursive()
Load Strings as Column in Data Frame
sbf_load_table()
Load Table
sbf_load_tables()
Load Tables
sbf_load_tables_recursive()
Load Data Frames as List Column in Data Frame
sbf_load_windows_recursive()
Load Window Paths as Character Column in Data Frame
sbf_load_data_from_pg() deprecated
Load a table from a PostgreSQL database
sbf_load_datas_from_pg() deprecated
Load Data Frames from PostgreSQL Database

Compare Items

sbf_compare_data()
Compare Data
sbf_compare_data_archive()
Compare Data Archive
sbf_diff_data()
Diff Data
sbf_diff_data_archive()
Diff Data Archive
sbf_diff_table()
Diff Table
sbf_is_equal_data()
Is Equal Data
sbf_is_equal_data_archive()
Is Equal Data Archive

Directory Operations

sbf_set_sub()
Set Sub Folder
sbf_reset_sub()
Reset Sub Folder
sbf_get_sub()
Get Sub Folder
sbf_set_main()
Set Main
sbf_reset_main()
Reset Main
sbf_get_main()
Get Main
sbf_set_db_name()
Set Database Name
sbf_reset_db_name()
Reset Database Name
sbf_get_db_name()
Get Database Name
sbf_reset()
Reset Main, Sub and Database Name
sbf_up_sub()
Move Up Sub Folder
sbf_add_sub()
Add Sub Folder
sbf_get_archive()
Get Archive Directory
sbf_get_workbook_name()
Get Workbook Name

SQLite Database Operations

sbf_open_db()
Open SQLite Database Connection
sbf_close_db()
Close Database Connection
sbf_copy_db()
Copy SQLite Database
sbf_query_db()
Query Existing Database
sbf_create_db()
Create SQLite Database
sbf_execute_db()
Execute SQL Statement on Existing Database
sbf_upload_flobs_to_db()
Upload flobs
sbf_add_blob_column_to_db()
Add blob column

PostgreSQL Database Operations

sbf_open_pg() deprecated
Open PostgreSQL Connection
sbf_close_pg() deprecated
Close PostgreSQL Connection
sbf_backup_pg() deprecated
Save PostgreSQL backup
sbf_create_pg() deprecated
Create PostgreSQL database
sbf_execute_pg() deprecated
Execute SQL statement for PostgreSQL database
sbf_list_tables_pg() deprecated
List tables in a schema
sbf_set_schema() deprecated
Set Schema Name
sbf_get_schema() deprecated
Get Schema Name
sbf_reset_schema() deprecated
Reset Schema Name
sbf_set_config_file() deprecated
Set the Config File path
sbf_get_config_file() deprecated
Get the Config File Path
sbf_reset_config_file() deprecated
Reset the Config File Path
sbf_set_config_value() deprecated
Set the Config Value
sbf_get_config_value() deprecated
Get the Config File Value
sbf_reset_config_value() deprecated
Reset the Config File Value

Housekeeping

sbf_archive_main()
Archive Main Folder
sbf_unarchive_main()
Unarchive Main Folder
sbf_rm_main()
Remove Main
sbf_rm_flobs()
Delete Flobs Subdfolder

Graphic Operations

sbf_open_pdf()
Open PDF Device
sbf_close_pdf()
Close PDF Device
sbf_open_window()
Open Graphics Window
sbf_close_window()
Close Window
sbf_close_windows()
Close Windows

Path to Items

sbf_path_block()
Path to Code Block
sbf_path_data()
Path to Data
sbf_path_db()
Path to Database
sbf_path_number()
Path to Number
sbf_path_object()
Path to Object
sbf_path_plot()
Path to Plot
sbf_path_string()
Path to String
sbf_path_table()
Path to Table
sbf_path_window()
Path to Window

List Items File Paths

sbf_list_blocks()
Gets List of Block Files as a Character Vector
sbf_list_datas()
Gets List of Data Files as a Character Vector
sbf_list_dbs()
Gets List of Database Files as a Character Vector
sbf_list_numbers()
Gets List of Number Files as a Character Vector
sbf_list_objects()
Gets List of Object Files as a Character Vector
sbf_list_plots()
Gets List of Plot Files as a Character Vector
sbf_list_strings()
Gets List of String Files as a Character Vector
sbf_list_tables()
Gets List of Data Files as a Character Vector
sbf_list_windows()
Gets List of Window Files as a Character Vector

Misc Group

sbf_write_datas_to_xlsx()
Write Datas to Excel File
sbf_basename_sans_ext()
Extension-less Base File Names
sbf_print()
Print ggplot Object

Checks if Item Exists

sbf_block_exists()
Code Block Exists
sbf_data_exists()
Data Exists
sbf_number_exists()
Number Exists
sbf_object_exists()
Object Exists
sbf_plot_exists()
Plot Exists
sbf_string_exists()
String Exists
sbf_table_exists()
Table Exists

Getting Subs (removing )

sbf_subs_block_recursive()
Gets Subs of a Block as a Character Vector
sbf_subs_data_recursive()
Gets Subs of a Data Frame as a Character Vector
sbf_subs_number_recursive()
Gets Subs of a Number as a Character Vector
sbf_subs_object_recursive()
Gets Subs of an Object as a Character Vector
sbf_subs_plot_recursive()
Gets Subs of a Plot as a Character Vector
sbf_subs_string_recursive()
Gets Subs of a String as a Character Vector
sbf_subs_table_recursive()
Gets Subs of a Table as a Character Vector
sbf_subs_window_recursive()
Gets Subs of a Window as a Character Vector

Other

sbf_save_gpkg()
Save sf data frame to Geopackage
sbf_save_gpkgs()
Save sf data frames to Geopackages