Replace in-memory database with SQLite
- Add SQLite driver dependency (github.com/mattn/go-sqlite3)
- Create initDB() function to initialize SQLite database with schema
- Update all API handlers to use SQL queries instead of in-memory slice
- Seed database with initial album data on first run
- Update benchmark setup to initialize database for testing
- Database file: albums.db stores persistent album data
🤖 Generated with [Claude Code](https://claude.ai/code)
Co-Authored-By: Claude <noreply@anthropic.com>
Replace in-memory database with Turso (libSQL)
- Add Turso libSQL client dependency (github.com/tursodatabase/libsql-client-go)
- Add SQLite driver for local file support (github.com/mattn/go-sqlite3)
- Replace in-memory slice with libSQL database connection
- Support both local file and remote Turso database via environment variables
- Update all API handlers to use SQL queries instead of in-memory operations
- Maintain backward compatibility with existing API endpoints
- Database file: albums.db stores persistent album data locally
Environment variables:
- TURSO_DATABASE_URL: Database URL (defaults to file:./albums.db)
- TURSO_AUTH_TOKEN: Authentication token for remote Turso database (optional)
🤖 Generated with [Claude Code](https://claude.ai/code)
Co-Authored-By: Claude <noreply@anthropic.com>