// the find
w3cj/bytedash
A restaurant food delivery service database implemented with drizzle.
A teaching repo that models a food-delivery service database using Drizzle ORM with PostgreSQL. It exists primarily as companion code for a YouTube tutorial — the schema is reasonably well-thought-out for that purpose, covering orders, drivers, restaurants, menus, and status tracking. Not a production starter kit.
The schema design is solid for a tutorial: price is stored at both line-item and snapshot level in order_menu_item (item_price vs price), which is the correct way to handle menu price drift over time. The status_catalog pattern for order states is clean — adding a new status is a data change, not a code change. Docker Compose setup means anyone can be running against a real Postgres in under a minute. The Mermaid ER diagram in the README is genuinely useful and kept in sync with the actual schema.
Passwords are stored as plain strings in the users table — there's no indication of hashing in the schema or seed data, which is a bad habit to teach. The API layer (src/api/service.ts) is a thin example stub, not something you'd base real work on. No indexes beyond primary keys — a food delivery app with any real traffic would immediately hit performance problems on order lookups by user or driver. The repo hasn't been touched since October 2024 and targets an older drizzle-kit that already required a breaking-change migration note in the README.