I Built a Simple Log Aggregation and Analytics tool

#beginners #monitoring #postgres #showdev

I Built StackLens — A Simple Log Aggregation Dashboard

Logs are one of the first things developers check when something goes wrong. But when logs come from multiple services, they quickly become hard to manage.

To explore how centralized logging works, I built StackLens — a full-stack log aggregation dashboard.

The idea is simple: services send logs to a backend API, the logs are stored in PostgreSQL, and a web dashboard lets you search, filter, and analyze them.

Tech Stack

I started with PERN stack , i don't know much about technologies yet ,still exploring though.... but according to you what stack is best suitable for this that if we think about scaling this project ? i would love to hear your opinion.

Frontend

React
TypeScript
TailwindCSS
TanStack Query
React Router

Backend

Node.js
Express
PostgreSQL
Supabase (hosted Postgres)

What schema i used ?

Each log entry looks like this:

{
  "service": "auth-service",
  "level": "info",
  "message": "User authenticated successfully",
  "metadata": { "ip": "192.168.1.10" },
  "timestamp": "2026-03-02T11:39:16Z"
}