The avatar for @silentworks
Andrew Smith
Public
Edited
Feb 3, 2023
Fork of Blog Post
•
1 fork
3 stars
1
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
artistsQuery = await supabase.from('artist').select('*')
Insert cell
Insert cell
Insert cell
Insert cell
artistsWithAlbumQuery = await supabase.from('artist').select(`*, album(*)`)
Insert cell
Insert cell
Insert cell
Insert cell
artistsWithAlbumColumnsQuery = await supabase.from('artist').select(`*, album(id, title, release_date)`)
Insert cell
Insert cell
Insert cell
Insert cell
artistWithAlbumFilterQuery = await supabase.from('artist').select(`*, album(id, title, release_date)`)
.gte('album.release_date', (new Date('2002-07-01')).toISOString())
.lte('album.release_date', (new Date('2010-12-01')).toISOString())
Insert cell
Insert cell
Insert cell
Insert cell
artistWithAlbumAliasQuery = await supabase.from('artist').select('*, albums:album(*)')
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
albumWithArtistQuery = await supabase.from('album').select(`*, artist(*)`)
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell

Purpose-built for displays of data

Observable is your go-to platform for exploring data and creating expressive data visualizations. Use reactive JavaScript notebooks for prototyping and a collaborative canvas for visual data exploration and dashboard creation.
Learn more