Meet sqlite-zstd, a Rust library that compresses your database many fold, leading to great savings in size while conserving its search capabilities intact. As pointed out in "In Praise Of SQLite", ...

The application supports daily and weekly habits and stores habit information and completion history using SQLite. The project demonstrates Object-Oriented Programming (OOP), functional programming ...

The sixth lesson of Week 13 ("SQL and Relational Databases"). Days 85 to 89 taught the relational model, SELECT, joins, writing and schema design, and indexes — all of it through the sqlite3 shell.