Interactive Data Analytics Web App with Ajax Filtering, Sorting & Pagination

This project demonstrates a interactive data analytics web app build with Tabulator, a powerful JavaScript library for creating tabular interfaces. It showcases connecting Tabulator to a PostgreSQL database for displaying large datasets with features like pagination, sorting, and filtering handled efficiently by the database.

Getting Started

Prerequisites:

• Node.js (version 20 or later recommended) - https://nodejs.org/
• Docker - https://www.docker.com/

Running the Demo:

1. Database

cd database
bash build.sh # build docker image
bash run.sh   # run docker container

2. Backend

cd backend
npm install # install dependencies
npm run dev # start development server

3. Frontend

cd frontend
npm install # install dependencies
npm run dev # start development server

Data

The web app shows dummy data generated with Faker.js to represent a webshop's conversion funnel.

Security

This is a demonstration project, and security best practices are not fully implemented. However, to mitigate potential SQL injection vulnerabilities, basic Ajax parameter validation with regular expressions is included.