// the find
felipengeletrica/photostore
Shop for cameras and accessories deploying in c and SQLITE database
A console-based camera shop inventory system written in C with SQLite, implemented as a university-style exercise. It handles cameras and accessories with a many-to-many join table, cascade deletes, and basic CRUD via a terminal menu. Zero stars, last touched 2024 — this is a learning project, not a tool anyone would adopt.
Bundles sqlite3.c directly so there are no external dependencies beyond a C compiler and make. Uses transactions for multi-table inserts, which is the correct approach. Cascade delete is wired at the schema level rather than handled in application code. The Makefile build is straightforward and the directory layout separates db from application logic.
No input validation anywhere visible — raw user strings going into SQL queries is an SQL injection waiting to happen in a production context. Option 10 wipes the entire database with no confirmation prompt beyond a parenthetical warning in the menu. The schema is baked into an 'initialize DB' menu option rather than proper migration files, so schema changes mean destroying all data. No tests, no error handling beyond whatever SQLite returns, and the README is half menu screenshots.