Tasks Board

Using NextJS, React, and any SQL database, develop a full stack solution for a BoardComponent with 4 columns: BACKLOG TODO DOING DONE

Considerations:

Simple design
- SOLID
- KISS
- DRY
Effective Architectural and design decisions
- Separating business rules from infrastructure details
REST api design
Testing Strategy
- Provide the right amount of unit/integration/end-to-end tests following the testing pyramid or any principle you choose.
Straightforward setup and execution

📝	We understand that all decisions in Engineering are tradeoffs, so please include a readme with your decision-making process.

Unit tests for core functionality. Task movements validations on the board
Integration tests on repositories for validating database connection and scheme.
Given we are using Next.js for route definition and the simplicity of the route, unit testing the use case should provide sufficient coverage. So end-to-end tests for api routes are not developed.
Using Object mother pattern to create test data
Board movement restrictions are defined on the domain model, since we don't expect them to change. Otherwise, we'd save the restrictions on the database.
I decided to specify the one column movement restriction on the board (instead of the task), since it looks more scalable to me.
I saved the task on localStorage as specified in the task. But we could just retrieve them from database
Used DDD
Used TDD
Used Hexagonal Architecture
Used Atomic Design for components

Dynamics columns. For simplicity I'll keep the status columns as mentioned in the task description (BACKLOG, TODO, DOING, DONE).
Using different database for dev and test.
Paginate tasks retrieval
Using drag and drop library for moving tasks.