📋 Schedule Manager

A minimalist web app powered by Go + SQLite3 backend with a lightweight HTML/CSS frontend.

🚀 Requirements

Go (version ≥ 1.18 recommended) SQLite3

Usage

⚙️Execution

Dependencies

sudo apt update
sudo apt install -y docker.io docker-compose
sudo systemctl start docker
sudo systemctl enable docker
go get github.com/mattn/go-sqlite3
go get github.com/segmentio/kafka-go

Backend setup.

Setup Docker for Kafka

docker-compose up -d

Check docker

docker-compose ps

Initiate Go backend - Kafka Messages Appear in this terminal

cd backend
go run main.go

Frontend setup.

Open index.html

To read database queries.

cd backend
sqlite3 tasks.db

Show all tables and schema of tasks table.

.tables
.schema tasks

See all tasks

 SELECT * FROM tasks;

Delete task 3

DELETE FROM tasks WHERE id = 3;

Insert new task

INSERT INTO tasks(name) VALUES('Purge Cache');