If the schema sucks, the app sucks

Day 2 of building Criene was spent entirely on the database architecture.

I didn't write a single UI component today. Instead, I spent the whole day deep in Database Schema design.

Since Criene is about tracking discipline and streaks, the data relationship between Users, Habits, and DailyLogs needs to be bulletproof. A bad schema now means a nightmare migration later.

The Setup:

• DB: Neon (Serverless Postgres)

• ORM: Drizzle (Type safety is non-negotiable)

The database skeleton is ready. Now we have a solid foundation to build the backend (api) layer on top.

#IndieDev #Database #Postgres