apps/api/drizzle · rocksky · Tangled

A decentralized music tracking and discovery platform built on AT Protocol 🎵 rocksky.app

spotify atproto lastfm musicbrainz scrobbling listenbrainz

rocksky apps api drizzle

1 folder · 58 files

· feat(notifications): add Android FCM and browser alerts · 1d ago

feat(notifications): add Android FCM and browser alerts

0000_puzzling_lockheed.sql

update drizzle migrations

0001_parched_random.sql

Drop feeds.did unique constraint

0002_robust_wong.sql

Add follows graph, DB table and endpoints

0003_plain_doorman.sql

add new db indexes

0004_feed_indexes.sql

fix(db): register all migrations and support concurrent indexes

0005_import_jobs.sql

feat: add Last.fm CSV and Spotify JSON history import

0005_square_pixie.sql

fix(db): repair migration replay on fresh PostgreSQL databases

0006_funny_johnny_blaze.sql

feat(library): add upload player with queue management and persistence

0007_tracks_fts.sql

feat(library): add full-text search for uploads and enrich scrobble metadata

0008_navidrome_indexes.sql

fix(db): register all migrations and support concurrent indexes

0009_byo_storage.sql

feat: bring your own S3 storage (BYOS)

0010_mirror_sources.sql

feat: mirror Last.fm, ListenBrainz, Teal.fm scrobbles into Rocksky

0011_tracks_isrc.sql

feat(scrobble): add optional ISRC to song + scrobble lexicons

0011_tracks_swap_unique_mbid_to_isrc.sql

fix(db): repair migration replay on fresh PostgreSQL databases

0012_tracks_drop_isrc_unique.sql

feat(db): drop UNIQUE on tracks.isrc as well

0013_access_tokens.sql

feat(access-tokens): add user-managed personal access tokens

0014_scrobbles_unique_user_track_ts.sql

fix(scrobbles): prevent duplicate scrobbles across sources

0015_navidrome_playlists.sql

fix: playlist id collisions, profile stats, crossfade mixing

0016_shouts_gif.sql

feat(shoutbox): add GIF/sticker/clip media + @mention & link support

0017_shouts_facets.sql

feat(shoutbox): add GIF/sticker/clip media + @mention & link support

0018_notifications.sql

feat(notifications): scalable SSE notification system + real XRPC shout/like mutations

0019_user_uploads_sample_rate.sql

feat: story likes, audio-format badges, album row in miniplayer

0020_playlist_atproto_sync.sql

feat(playlists): source global playlists from AT-Proto records only

0021_navidrome_playlists_uri.sql

feat(library): mirror navidrome playlists to the user's atproto repo

0022_mirror_sources_push_enabled.sql

feat(mirrors): let users turn off Rocksky -> teal.fm

0023_junction_tables_unique.sql

fix(library): stop albums showing every track two or more times

0024_user_artists_mv.sql

perf(api): back circles by user_artists_mv materialized view

0025_tracks_key_bpm.sql

feat(analysis): key/BPM analysis for uploads via Rust + Neon bindings

0026_top_scrobblers_mv.sql

perf(charts): serve all-time top scrobblers from a materialized view

0027_scrobbles_per_day_mv.sql

perf(charts): precompute the global scrobbles-per-day series

0028_user_junction_user_id_idx.sql

perf(api): index the three tables read by user_id and indexed by the other one

0029_artists_genres_gin.sql

perf(api): index artists.genres for genre feed lookups

0030_user_hour_scrobbles_mv.sql

perf(charts): roll scrobbles up per hour for the ranged leaderboard

0031_scrobbles_artist_track_idx.sql

fix(artists): keep other artists' tracks off an artist's page

0032_scrobbles_user_stats_idx.sql

perf(stats): serve profile counts from one index-only scan and a cache

0033_drop_duplicate_scrobbles_indexes.sql

perf(scrobbles): drop five duplicate indexes

0034_tracks_acoustid_fingerprint.sql

feat(analysis): fingerprint every upload so a track is known by its audio

0035_scrobbles_wrapped_idx.sql

perf(api): optimize wrapped, profile rankings, and chart queries

0036_scrobbles_chart_indexes.sql

perf(api): optimize wrapped, profile rankings, and chart queries

0037_chart_totals_mv.sql

perf(api): optimize wrapped, profile rankings, and chart queries

0038_neighbours_covering_index.sql

perf(api): optimize actor neighbours queries and caching

0039_song_lookup_indexes.sql

Fix song and artist album query timeouts

0040_discogs.sql

Pin the discogs migration to the public schema

0041_discogs_credits.sql

Save Discogs release and track credits

0042_discogs_relations.sql

Store Discogs tracklist, artists, labels, identifiers and masters

0043_events.sql

feat(db): add events, event_artists and event_rsvps tables

0044_event_duplicates.sql

feat(db): add event fingerprint and duplicate_of columns

0045_event_media.sql

feat(db): store calendar event media

0046_matching_lookup_indexes.sql

Index normalized matching lookups for MusicBrainz and ISRC

0047_jetstream_album_uri_index.sql

Index Jetstream queue lanes and unlinked album artists

0048_rsql_catalog_indexes.sql

Bound RSQL catalog work and index exact and wildcard filters

0049_users_bot_moderation.sql

fix(db): add missing user bot moderation migration

0050_users_nullable_display_name.sql

fix(db): register all migrations and support concurrent indexes

0051_user_membership_nullable_uris.sql

fix(scrobbles): preserve nullable membership URIs across ports

0052_remove_cloud_integrations.sql

feat!: remove Dropbox and Google Drive integrations

0053_remove_history_import.sql

feat!: remove history import endpoints and schema

0054_library_junction_covering_indexes.sql

perf(navidrome): cover reverse library membership lookups

0055_notification_devices.sql

feat(notifications): add Android FCM and browser alerts