I recently followed the Next.js Dashboard tutorial (https://nextjs.org/learn/dashboard-app) and made a few modifications to run the database locally using Docker instead of Vercel's DB hosting. You can check out my repository here: https://github.com/abel-castro/nextjs-dashboard
I hope this can be useful for someone!
Happy coding!
In the world of Node.js, frameworks like NestJS have transformed the landscape of building server-side applications by introducing a scalable, maintainable, and modular architecture. Coupled with MikroORM, an intuitive TypeScript ORM, you get a powerful duo that promotes code reliability and database management. This post will guide you through setting up a simple blog application using NestJS and MikroORM.
Before we dive in, ensure you have the following installed:
First, install the NestJS CLI globally, if you haven't already:
npm install -g @nestjs/cli
Create a new project:
nest new blog-nest
Navigate to your project directory:
cd blog-nest
Install MikroORM and the PostgreSQL driver:
npm install @mikro-orm/core @mikro-orm/nestjs @mikro-orm/postgresql pg
Create a mikro-orm.config.ts at the root of your project to configure MikroORM:
import { MikroOrmModuleSyncOptions } from '@mikro-orm/nestjs';
import { Post } from './src/posts/post.entity';
const config: MikroOrmModuleSyncOptions = {
entities: [Post],
dbName: 'blog',
type: 'postgresql',
user: 'test',
password: 'test',
};
export default config;
Set up a docker-compose.yml file to run PostgreSQL:
version: '3.8'
services:
postgres:
image: postgres:latest
environment:
POSTGRES_DB: blog
POSTGRES_USER: test
POSTGRES_PASSWORD: test
ports:
- "5432:5432"
volumes:
- postgres-data:/var/lib/postgresql/data
volumes:
postgres-data:
Start your PostgreSQL database:
docker-compose up -d
Define your Post entity:
import { Entity, PrimaryKey, Property } from '@mikro-orm/core';
@Entity()
export class Post {
@PrimaryKey()
id!: number;
@Property()
title!: string;
@Property()
content!: string;
}
Create the Posts module, service, and controller to handle CRUD operations.
import { Module } from '@nestjs/common';
import { MikroOrmModule } from '@mikro-orm/nestjs';
import { PostsController } from './posts.controller';
import { PostsService } from './posts.service';
import { Post } from './post.entity';
@Module({
imports: [MikroOrmModule.forFeature([Post])],
controllers: [PostsController],
providers: [PostsService],
})
export class PostsModule {}
import { Injectable } from '@nestjs/common';
import { InjectRepository } from '@mikro-orm/nestjs';
import { EntityRepository } from '@mikro-orm/core';
import { Post } from './post.entity';
@Injectable()
export class PostsService {
constructor(
@InjectRepository(Post)
private readonly postRepository: EntityRepository<Post>
) {}
async findAll(): Promise<Post[]> {
return this.postRepository.findAll();
}
}
import { Controller, Get } from '@nestjs/common';
import { PostsService } from './posts.service';
import { Post } from './post.entity';
@Controller('posts')
export class PostsController {
constructor(private readonly postsService: PostsService) {}
@Get()
async findAll(): Promise<Post[]> {
return this.postsService.findAll();
}
}
Run your application and navigate to http://localhost:3000/api/posts to see the posts retrieved from the database:
npm run start
You've just set up a basic blog API using NestJS and MikroORM, with a PostgreSQL database running in a Docker container. This project lays the foundation for building scalable and maintainable applications with advanced features like data mapping, dependency injection, and modular architecture.
For the complete source code, check out the GitHub repository: blog-nest.
NestJS and MikroORM are powerful tools in your Node.js arsenal. By mastering them, you can greatly enhance your backend development capabilities. Happy coding!
The Sports Dashboard now displays the results of the last matchday.

I've been making some updates to the Sports Dashboard to showcase the results of the latest matchday across available leagues. My aim with this project is to provide a convenient overview of major football leagues in Europe without needing to navigate through sports news websites.
To achieve this, I've implemented a new task that retrieves results data from APIFootball, processes it into the required format, and then stores it in the database. The code is designed to be adaptable to different data providers and includes a DataProviderInterface, allowing to easy use other data providers if it is needed.
This task runs once a day, similar to the task for retrieving standings. The results are now accessible through the endpoint GET /api/sports/standings/.
Please note that since the dashboard only displays results from the last matchday, there may be instances where the data appears incomplete if not all games have been played yet.
The code is publicly available here. Enjoy!