alpha
Login
Join now
rocksky.app
/
rocksky
Star
Starred
Star
Something went wrong. Try again.
Fork
9
Eye filled
Watch
Watching
Watch
A decentralized music tracking and discovery platform built on AT Protocol 🎵
rocksky.app
spotify
atproto
lastfm
musicbrainz
scrobbling
listenbrainz
+6 more
spotify
atproto
lastfm
musicbrainz
scrobbling
listenbrainz
Star
Starred
Star
Something went wrong. Try again.
Fork
9
Eye filled
Watch
Watching
Watch
Overview
Overview
Issues
Issues
17
Pulls
Pulls
14
Pipelines
Pipelines
rocksky
/
apps
/
api
/
drizzle
1 folder
·
56 files
at
main
Tsiry Sandratraina
·
feat!: remove history import endpoints and schema
·
3d ago
b030b462
meta
feat!: remove history import endpoints and schema
3d ago
0000_puzzling_lockheed.sql
Merge pull request #15 from tsirysndr/feat/feed-generator
9mo ago
0001_parched_random.sql
Merge pull request #15 from tsirysndr/feat/feed-generator
9mo ago
0002_robust_wong.sql
Add follows graph, DB table and endpoints
9mo ago
0003_plain_doorman.sql
add new db indexes
5mo ago
0004_feed_indexes.sql
fix(db): register all migrations and support concurrent indexes
3d ago
0005_import_jobs.sql
feat: add Last.fm CSV and Spotify JSON history import
5mo ago
0005_square_pixie.sql
fix(db): repair migration replay on fresh PostgreSQL databases
3d ago
0006_funny_johnny_blaze.sql
feat(library): add upload player with queue management and persistence
4mo ago
0007_tracks_fts.sql
feat(library): add full-text search for uploads and enrich scrobble metadata
4mo ago
0008_navidrome_indexes.sql
fix(db): register all migrations and support concurrent indexes
3d ago
0009_byo_storage.sql
feat: bring your own S3 storage (BYOS)
4mo ago
0010_mirror_sources.sql
Merge pull request #20 from tsirysndr/feat/mirroring
4mo ago
0011_tracks_isrc.sql
feat(scrobble): add optional ISRC to song + scrobble lexicons
4mo ago
0011_tracks_swap_unique_mbid_to_isrc.sql
fix(db): repair migration replay on fresh PostgreSQL databases
3d ago
0012_tracks_drop_isrc_unique.sql
feat(db): drop UNIQUE on tracks.isrc as well
4mo ago
0013_access_tokens.sql
feat(access-tokens): add user-managed personal access tokens
4mo ago
0014_scrobbles_unique_user_track_ts.sql
fix(scrobbles): prevent duplicate scrobbles across sources
4mo ago
0015_navidrome_playlists.sql
fix: playlist id collisions, profile stats, crossfade mixing
3mo ago
0016_shouts_gif.sql
Merge pull request #36 from tsirysndr/feat/shoutbox-gifs-mentions
2mo ago
0017_shouts_facets.sql
Merge pull request #36 from tsirysndr/feat/shoutbox-gifs-mentions
2mo ago
0018_notifications.sql
Merge pull request #37 from tsirysndr/feat/notifications
2mo ago
0019_user_uploads_sample_rate.sql
feat: story likes, audio-format badges, album row in miniplayer
1mo ago
0020_playlist_atproto_sync.sql
feat(playlists): source global playlists from AT-Proto records only
1mo ago
0021_navidrome_playlists_uri.sql
feat(library): mirror navidrome playlists to the user's atproto repo
1mo ago
0022_mirror_sources_push_enabled.sql
feat(mirrors): let users turn off Rocksky -> teal.fm
1mo ago
0023_junction_tables_unique.sql
fix(library): stop albums showing every track two or more times
1mo ago
0024_user_artists_mv.sql
perf(api): back circles by user_artists_mv materialized view
1mo ago
0025_tracks_key_bpm.sql
feat(analysis): key/BPM analysis for uploads via Rust + Neon bindings
1mo ago
0026_top_scrobblers_mv.sql
perf(charts): serve all-time top scrobblers from a materialized view
1mo ago
0027_scrobbles_per_day_mv.sql
perf(charts): precompute the global scrobbles-per-day series
1mo ago
0028_user_junction_user_id_idx.sql
perf(api): index the three tables read by user_id and indexed by the other one
1mo ago
0029_artists_genres_gin.sql
perf(api): index artists.genres for genre feed lookups
1mo ago
0030_user_hour_scrobbles_mv.sql
perf(charts): roll scrobbles up per hour for the ranged leaderboard
1mo ago
0031_scrobbles_artist_track_idx.sql
fix(artists): keep other artists' tracks off an artist's page
4w ago
0032_scrobbles_user_stats_idx.sql
perf(stats): serve profile counts from one index-only scan and a cache
4w ago
0033_drop_duplicate_scrobbles_indexes.sql
perf(scrobbles): drop five duplicate indexes
4w ago
0034_tracks_acoustid_fingerprint.sql
feat(analysis): fingerprint every upload so a track is known by its audio
4w ago
0035_scrobbles_wrapped_idx.sql
perf(api): optimize wrapped, profile rankings, and chart queries
2w ago
0036_scrobbles_chart_indexes.sql
perf(api): optimize wrapped, profile rankings, and chart queries
2w ago
0037_chart_totals_mv.sql
perf(api): optimize wrapped, profile rankings, and chart queries
2w ago
0038_neighbours_covering_index.sql
perf(api): optimize actor neighbours queries and caching
2w ago
0039_song_lookup_indexes.sql
Fix song and artist album query timeouts
2w ago
0040_discogs.sql
Pin the discogs migration to the public schema
2w ago
0041_discogs_credits.sql
Save Discogs release and track credits
2w ago
0042_discogs_relations.sql
Store Discogs tracklist, artists, labels, identifiers and masters
2w ago
0043_events.sql
feat(db): add events, event_artists and event_rsvps tables
1w ago
0044_event_duplicates.sql
feat(db): add event fingerprint and duplicate_of columns
1w ago
0045_event_media.sql
feat(db): store calendar event media
1w ago
0046_matching_lookup_indexes.sql
Index normalized matching lookups for MusicBrainz and ISRC
1w ago
0047_jetstream_album_uri_index.sql
Index Jetstream queue lanes and unlinked album artists
5d ago
0048_rsql_catalog_indexes.sql
Bound RSQL catalog work and index exact and wildcard filters
5d ago
0049_users_bot_moderation.sql
fix(db): add missing user bot moderation migration
3d ago
0050_users_nullable_display_name.sql
fix(db): register all migrations and support concurrent indexes
3d ago
0051_user_membership_nullable_uris.sql
fix(scrobbles): preserve nullable membership URIs across ports
3d ago
0052_remove_cloud_integrations.sql
feat!: remove Dropbox and Google Drive integrations
3d ago
0053_remove_history_import.sql
feat!: remove history import endpoints and schema
3d ago