Skip to contents

Data Access

Query and retrieve artist, artwork, and collection data

art_has_nft()
Check NFT minting status for badge display
get_art_opensea_url()
Fetch OpenSea listing URL for NFT marketplace link
get_art_print_url()
Fetch print store URL for e-commerce integration
get_art_purchase_urls()
Fetch purchase URLs for all artist artworks
get_artist_by_slug()
Resolve URL slug to artist profile for page routing
get_artist_collections_summary()
Fetch collections with counts for navigation menus
get_artist_index()
Retrieve full artist profile by UUID
get_artist_opensea()
Check NFT status and retrieve marketplace links
get_artist_recent_works()
Fetch recent artworks for profile page grids
get_artist_stats()
Get portfolio counts for profile headers and badges
get_artist_style_map()
Retrieve tag-to-category mapping for style filters and analytics
get_artist_tags()
Retrieve all style tags used across an artist's artworks
get_artwork_index()
Fetch core artwork record for routing and display
get_artwork_meta()
Fetch image dimensions for layout calculations
get_artwork_opensea()
Fetch NFT listing for marketplace integration
get_artwork_profile()
Fetch style tags for badges and search filters
get_artwork_profile_full()
Fetch extended profile with AI description
get_artwork_stats()
Fetch performance metrics for analytics displays
get_color_codes()
Retrieve Color Code Mapping Table
get_verification_info()
Fetch verification data for authenticity badges

Data Modifiers

Create, update, and delete records

add_artist()
Create new artist profile for onboarding
add_artwork()
Create complete artwork record from pipeline
add_collection()
Create collection container for artwork grouping
delete_collection()
Delete a collection and its settings
update_artist_benchmarks()
Recalculate percentile benchmarks after adding artworks
update_artist_stats()
Recalculate aggregate stats after artwork changes

Path Utilities

CDN URLs and asset path construction

path_art_canvas()
Get path to Procreate canvas file
path_art_main_image()
Get main artwork image path
path_artist_thumb()
Get artist thumbnail path
path_artwork_cert()
Get artwork certificate path
path_artwork_cert_thumb()
Get artwork certificate thumbnail path
path_artwork_thumb()
Get artwork thumbnail path
path_canvas_sign()
Get path to canvas signature detection image
path_cert_frame_asset()
Get certificate frame asset path
path_cert_templ_asset()
Get certificate template asset path
path_gallery_asset()
Get gallery asset path
path_image_asset()
Get CDN URL for image asset
path_local_temp_diffs()
Get local temp diffs path
path_replay_frame()
Get replay frame path
path_replay_graph()
Get replay graph path
path_vault_asset()
Get vault asset path
prefix_frames()
Get frames directory prefix
prefix_gallery()
Get gallery directory prefix
prefix_processed()
Get processed directory prefix
prefix_replay_frames()
Get replay frames directory prefix
prefix_replay_graphs()
Get replay graphs directory prefix
prefix_uploads()
Get uploads directory prefix

Application Data

Shiny app support and reactive data aggregation

get_appdata()
Aggregate all data for artwork detail page rendering

Settings

Artist preferences and collection visibility (experimental)

get_collect_visibility() experimental
Batch compute visibility for collection filtering
get_collection_settings() experimental
Fetch status and visibility for one collection
get_collections_settings() experimental
Batch fetch settings for multiple collections
is_collection_visible() experimental
Compute visibility for single collection
update_collection_settings() experimental
Change collection status or visibility override
upsert_artist_preferences() experimental
Save artist default visibility and settings

Database Interface

Low-level database access helpers

db_art_append()
Insert rows for bulk data ingestion
db_art_execute()
Execute parameterized SQL statements
db_art_get()
Run custom SQL SELECT for advanced queries
db_art_update()
Run custom SQL UPDATE/DELETE for modifications