GamesPassionFR Gaming Catalog

Online catalog to have a clear view of the GamesPassionFR channel.
Currently, we have the following pages :

• /games - List of games & series published on GamesPassionFR YT channel
• /planning - Upcoming games that will be published on GamesPassionFR YT channel
• /tests - Games review on GamesPassionFR YT channel
• /stats - Statistics on GamesPassionFR YT channel
• /backlog - Games backlog on GamesPassionFR YT channel
• /links - Links related to GamesPassionFR YT channel

Getting Started

This is a Next.js project bootstrapped with create-next-app.

Run the development server:

npm run dev
# or
yarn dev
# or
pnpm dev

Open http://localhost:3000 with your browser to see the result.

This project uses next/font to automatically optimize and load Inter, a custom Google Font.
This project uses Fuse.js to offer fuzzy-search for the games.

Learn More

To learn more about Next.js, take a look at the following resources:

• Next.js Documentation - learn about Next.js features and API.
• Learn Next.js - an interactive Next.js tutorial.

You can check out the Next.js GitHub repository - your feedback and contributions are welcome!

Deploy on Vercel

The easiest way to deploy your Next.js app is to use the Vercel Platform from the creators of Next.js.

Check out our Next.js deployment documentation for more details.

Database

There is a database for managing video games, their genres, platforms, series, schedules, and associated video content. The schema consists of several interrelated tables: games, backlog, games_genres, games_schedules, genres, platforms, series, series_games, and tests.

games Table

Field	Description	Required/Optional	Example
id	Unique identifier for each game (Primary Key).	Required	1
videoId	Unique identifier for an associated video.	Optional	IOog6QKck6o
playlistId	Unique identifier for an associated playlist.	Optional	PLRfhDHeBTBJ7zlVdm21oc8ndiRGxQJy6F
title	The title of the game.	Required	Harry Potter 3
releaseDate	The release date of the game.	Required	2023-01-01
duration	The duration of the game or video content.	Optional	02:30:00
platform	Foreign key referencing the platforms table.	Required	2

backlog Table

Field	Description	Required/Optional	Example
id	Unique identifier for each backlog entry (Primary Key).	Required	1
title	The title of the game.	Required	Batman Begins
platform	Foreign key referencing the platforms table.	Optional	2
notes	Additional notes or comments about the game.	Optional	Play this first.

games_genres Table

Field	Description	Required/Optional	Example
game	Foreign key referencing the games table.	Required	1
genre	Foreign key referencing the genres table.	Required	3

games_schedules Table

Field	Description	Required/Optional	Example
id	Foreign key referencing the games table.	Required	1
availableAt	Date (and time) when the game becomes available.	Optional	2023-08-01 10:00:00
endAt	Date (and time) when the game is no longer available.	Optional	2023-12-31 23:59:59

games_dlcs Table

Field	Description	Required/Optional	Example
game	Foreign key referencing the games table.	Required	2
dlc	Foreign key referencing the games table.	Required	21
order	The order of the dlc, in the game.	Optional	1

genres Table

Field	Description	Required/Optional	Example
id	Unique identifier for each genre (Primary Key).	Required	3
name	The name of the genre.	Required	Action

platforms Table

Field	Description	Required/Optional	Example
id	Unique identifier for each platform (Primary Key).	Required	2
name	The name of the platform.	Required	PlayStation

series Table

Field	Description	Required/Optional	Example
id	Unique identifier for each series (Primary Key).	Required	1
name	The name of the series.	Required	Ratchet & Clank

series_games Table

Field	Description	Required/Optional	Example
serie	Foreign key referencing the series table.	Required	1
game	Foreign key referencing the games table.	Required	2
order	The order of the game within the series.	Optional	1

tests Table

Field	Description	Required/Optional	Example
id	Unique identifier for each test (Primary Key).	Required	1
videoId	Unique identifier for an associated video.	Optional	IOog6QKck6o
playlistId	Unique identifier for an associated playlist.	Optional	PLRfhDHeBTBJ7zlVdm21oc8ndiRGxQJy6F
title	The title of the game.	Required	Harry Potter 3
releaseDate	The release date of the test.	Required	2023-01-01
platform	Foreign key referencing the platforms table.	Required	2
duration	The duration of the test or video content.	Optional	00:30:00