Book Keeper

Overview

A RESTful API built with Express and SQLite featuring a two-table schema with JOINs, complex queries, and a search endpoint.

What I learned

I learned that route ordering matters — specific routes must come before wildcards. Also hit the classic bug of SQLite boolean storage (0/1 vs true/false) and learned how FOREIGN KEY constraints and CASCADE deletes work.

Tools & Skills

Links