alpha
Login
or
Join now
chanderson.tech
/
rocksky
Star
0
Fork
0
Atom
Configure Feed
Issues
Pull Requests
Commits
Tags
Feed URL
Select the types of activity you want to include in your feed.
A decentralized music tracking and discovery platform built on AT Protocol 馃幍
Star
0
Fork
0
Atom
Configure Feed
Issues
Pull Requests
Commits
Tags
Feed URL
Select the types of activity you want to include in your feed.
Overview
Issues
Pulls
Pipelines
rocksky
/
apps
/
cli
/
src
/
schema
/
at
main
16 files
Tsiry Sandratraina
Add composite index to tracks
6mo ago
8406bf6c
album-tracks.ts
Add composite index to tracks Create idx_title_artist_album_albumartist on tracks (title, artist, album, album_artist) and update the Drizzle schema, migration snapshot, and journal
6 months ago
albums.ts
Use unixepoch() for default timestamps Replace CURRENT_TIMESTAMP defaults with (unixepoch()) across schemas and migration metadata. Enhance matchTrack to also match by albumArtist and log the database query result.
6 months ago
artist-albums.ts
Use unixepoch() for default timestamps Replace CURRENT_TIMESTAMP defaults with (unixepoch()) across schemas and migration metadata. Enhance matchTrack to also match by albumArtist and log the database query result.
6 months ago
artist-genres.ts
Add unique constraints and genres schema Add genres and artist_genres tables and create unique indexes on join tables (album_tracks, artist_albums, artist_tracks, loved_tracks, user_albums/user_artists/user_tracks). Update migration SQL, snapshot and journal metadata, add PAGE_SIZE and imports in CLI sync, and tweak agent logging.
6 months ago
artist-tracks.ts
Use unixepoch() for default timestamps Replace CURRENT_TIMESTAMP defaults with (unixepoch()) across schemas and migration metadata. Enhance matchTrack to also match by albumArtist and log the database query result.
6 months ago
artists.ts
Use unixepoch() for default timestamps Replace CURRENT_TIMESTAMP defaults with (unixepoch()) across schemas and migration metadata. Enhance matchTrack to also match by albumArtist and log the database query result.
6 months ago
auth-session.ts
Use unixepoch() for default timestamps Replace CURRENT_TIMESTAMP defaults with (unixepoch()) across schemas and migration metadata. Enhance matchTrack to also match by albumArtist and log the database query result.
6 months ago
genres.ts
Use unixepoch() for default timestamps Replace CURRENT_TIMESTAMP defaults with (unixepoch()) across schemas and migration metadata. Enhance matchTrack to also match by albumArtist and log the database query result.
6 months ago
index.ts
Add unique constraints and genres schema Add genres and artist_genres tables and create unique indexes on join tables (album_tracks, artist_albums, artist_tracks, loved_tracks, user_albums/user_artists/user_tracks). Update migration SQL, snapshot and journal metadata, add PAGE_SIZE and imports in CLI sync, and tweak agent logging.
6 months ago
loved-tracks.ts
Use unixepoch() for default timestamps Replace CURRENT_TIMESTAMP defaults with (unixepoch()) across schemas and migration metadata. Enhance matchTrack to also match by albumArtist and log the database query result.
6 months ago
scrobbles.ts
Use unixepoch() for default timestamps Replace CURRENT_TIMESTAMP defaults with (unixepoch()) across schemas and migration metadata. Enhance matchTrack to also match by albumArtist and log the database query result.
6 months ago
tracks.ts
Add composite index to tracks Create idx_title_artist_album_albumartist on tracks (title, artist, album, album_artist) and update the Drizzle schema, migration snapshot, and journal
6 months ago
user-albums.ts
Use unixepoch() for default timestamps Replace CURRENT_TIMESTAMP defaults with (unixepoch()) across schemas and migration metadata. Enhance matchTrack to also match by albumArtist and log the database query result.
6 months ago
user-artists.ts
Use unixepoch() for default timestamps Replace CURRENT_TIMESTAMP defaults with (unixepoch()) across schemas and migration metadata. Enhance matchTrack to also match by albumArtist and log the database query result.
6 months ago
user-tracks.ts
Use unixepoch() for default timestamps Replace CURRENT_TIMESTAMP defaults with (unixepoch()) across schemas and migration metadata. Enhance matchTrack to also match by albumArtist and log the database query result.
6 months ago
users.ts
Use unixepoch() for default timestamps Replace CURRENT_TIMESTAMP defaults with (unixepoch()) across schemas and migration metadata. Enhance matchTrack to also match by albumArtist and log the database query result.
6 months ago