Objectif

The project aims to develop a simple Content Management System (CMS) to manage words and phrases in a local SQLite database. The CMS allows administrators to view, edit, and update content easily.

Features

• View Content: Display a list of words and phrases from the local database.
• Edit Content: Edit existing words and phrases.
• Save Updates: Save edits back to the local SQLite database.
• Load Initial Data: On application start, load initial content from a remote JSON file and populate the database.

Technologies Used

• Node.js: For the backend server.
• SQLite: Local database to store words and phrases.
• Express: Web framework to create a RESTful API.
• Axios: For downloading data from an external JSON file.
• JSON: For structuring the imported data.

Features

• Load Initial Data: At application startup, data is fetched from an external JSON file and populated into the local SQLite database.
• Manage Words and Phrases: Allows the administrator to view, edit, and update words and phrases in the CMS interface.

Backend and Frontend Setup

Install dependencies:

npm install

Start the Backend and Frontend :

npm run dev

DEMO