Artist_DB
A database-driven artist management and information system.
Artist_DB is a backend-focused application for managing structured artist information through a database-driven API. It provides a foundation for storing, retrieving, and organizing artist records in a scalable relational database.
The Problem
Artist information can become difficult to manage when stored as unstructured files or disconnected datasets. A centralized database and API layer are needed to make artist records easier to query, maintain, and extend.
The Solution
Artist_DB uses a Flask backend with SQLAlchemy to provide structured API access to artist records stored in PostgreSQL. The system separates application logic from database operations, creating a cleaner foundation for future artist-management features.
System Architecture
The Flask application acts as the API layer between clients and the PostgreSQL database hosted through Neon. SQLAlchemy provides the ORM layer for database interaction, allowing artist records to be created, queried, and managed through application-level models rather than raw database operations. This creates a modular backend architecture that can be extended with authentication, richer artist metadata, and additional API functionality.
Key Implementations
- Structured artist database
- REST API for artist data
- SQLAlchemy ORM-based database operations
- PostgreSQL persistence using Neon
- Modular Flask backend architecture
- Scalable foundation for artist information management