Skip to contents

Data Access

Query and retrieve artist, artwork, and collection data

artHasNFT()
Check NFT minting status for badge display
getArtistOpensea()
Check NFT status and retrieve marketplace links
getArtistStyleMap()
Retrieve tag-to-category mapping for style filters and analytics
getArtworkIndex()
Fetch core artwork record for routing and display
getArtworkMeta()
Fetch image dimensions for layout calculations
getArtworkOpensea()
Fetch NFT listing for marketplace integration
getArtworkProfile()
Fetch style tags for badges and search filters
getArtworkProfileFull()
Fetch extended profile with AI description
getArtworkStats()
Fetch performance metrics for analytics displays
getImageRaster()
Get Image Color Raster
getVerificationInfo()
Fetch verification data for authenticity badges
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_recent_works()
Fetch recent artworks for profile page grids
get_artist_stats()
Get portfolio counts for profile headers and badges

Data Modifiers

Create, update, and delete records

addArtwork()
Create complete artwork record from pipeline
addCollection()
Create collection container for artwork grouping
updateArtistBenchmarks()
Recalculate percentile benchmarks after adding artworks
updateArtistStats()
Recalculate aggregate stats after artwork changes

Path Utilities

CDN URLs and asset path construction

pathArtCanvas()
Get path to Procreate canvas file
pathArtMainImage()
Get main artwork image path
pathArtistThumb()
Get artist thumbnail path
pathArtworkCert()
Get artwork certificate path
pathArtworkCertThumb()
Get artwork certificate thumbnail path
pathArtworkThumb()
Get artwork thumbnail path
pathCertFrameAsset()
Get certificate frame asset path
pathCertTemplAsset()
Get certificate template asset path
pathGalleryAsset()
Get gallery asset path
pathImageAsset()
Get CDN URL for image asset
pathLocalTempDiffs()
Get local temp diffs path
pathReplayFrame()
Get replay frame path
pathReplayGraph()
Get replay graph path
pathVaultAsset()
Get vault asset path
prefixFrames()
Get frames directory prefix
prefixGallery()
Get gallery directory prefix
prefixProcessed()
Get processed directory prefix
prefixReplayFrames()
Get replay frames directory prefix
prefixReplayGraphs()
Get replay graphs directory prefix
prefixUploads()
Get uploads directory prefix

Application Data

Shiny app support and reactive data aggregation

getAppdata()
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

dbArtAppend()
Insert rows for bulk data ingestion
dbArtGet()
Run custom SQL SELECT for advanced queries
dbArtUpdate()
Run custom SQL UPDATE/DELETE for modifications