Fullstack FAQ CRUD App

A full-stack FAQ management system built with React, Node.js, Express, and PostgreSQL. This application allows users to create, read, update, and delete FAQs through a sleek admin panel and view them with a multi-select accordion UI.

---

Features

• Full CRUD (Create, Read, Update, Delete) functionality for FAQs
• Admin panel for managing FAQs
• Multi-select accordion UI to view FAQs
• Responsive and user-friendly interface
• Backend powered by Node.js, Express, and PostgreSQL
• Frontend built with React and TypeScript
• Toast notifications for feedback on operations

---

Tech Stack

• Frontend: React, TypeScript, CSS Modules
• Backend: Node.js, Express
• Database: PostgreSQL
• Other: React Toastify, CORS, pg (PostgreSQL client for Node.js)

---

Getting Started

Prerequisites

• Node.js and npm installed
• PostgreSQL installed and running

Installation

1. Clone the repo:

git clone https://github.com/rayan495/fullstack-faq-crud-app.git
cd fullstack-faq-crud-app

2. Setup Backend:

cd fq-backend
npm install

3. Setup Frontend:

cd project1
npm install

Running the app

1. Backend

cd faq-backend
npm run dev

2. Frontend

cd project1
npm start

---

Database Schema

CREATE TABLE faqs (
  id SERIAL PRIMARY KEY,
  question TEXT NOT NULL,
  answer TEXT NOT NULL,
  created_at TIMESTAMP DEFAULT NOW(),
  updated_at TIMESTAMP DEFAULT NOW()
);

---

Usage

• Use the admin panel to add, update, or delete FAQs.
• View FAQs on the main page using the accordion component.
• Toggle multi-select on/off to expand multiple FAQs.

---