Package index • subfoldr2

Save Items
`sbf_save_aws_files()`	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()`	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()`	Load a table from a PostgreSQL database
`sbf_load_datas_from_pg()`	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()`	Open PostgreSQL Connection
`sbf_close_pg()`	Close PostgreSQL Connection
`sbf_backup_pg()`	Save PostgreSQL backup
`sbf_create_pg()`	Create PostgreSQL database
`sbf_execute_pg()`	Execute SQL statement for PostgreSQL database
`sbf_list_tables_pg()`	List tables in a schema
`sbf_set_schema()`	Set Schema Name
`sbf_get_schema()`	Get Schema Name
`sbf_reset_schema()`	Reset Schema Name
`sbf_set_config_file()`	Set the Config File path
`sbf_get_config_file()`	Get the Config File Path
`sbf_reset_config_file()`	Reset the Config File Path
`sbf_set_config_value()`	Set the Config Value
`sbf_get_config_value()`	Get the Config File Value
`sbf_reset_config_value()`	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

Reference

Save Items

Load Items

Compare Items

Directory Operations

SQLite Database Operations

PostgreSQL Database Operations

Housekeeping

Graphic Operations

Path to Items

List Items File Paths

Misc Group

Checks if Item Exists

Getting Subs (removing )

Other