𝗖𝗼𝗻𝘁𝗶𝗻𝘂𝗮𝘁𝗶𝗼𝗻: 𝗧𝗮𝗯𝗹𝗲𝘀, 𝗖𝗥𝗨𝗗, 𝗮𝗻𝗱 𝗙𝗼𝗿𝗲𝗶𝗴𝗻 𝗞𝗲𝘆𝘀

𝗖𝗼𝗻𝘁𝗶𝗻𝘂𝗮𝘁𝗶𝗼𝗻: 𝗧𝗮𝗯𝗹𝗲𝘀, 𝗖𝗥𝗨𝗗, 𝗮𝗻𝗱 𝗙𝗼𝗿𝗲𝗶𝗴𝗻 𝗞𝗲𝘆𝘀

I use React and Supabase. Define your data shape before you write queries.

PostgreSQL basics:

• SERIAL handles ID auto-increment.
• DEFAULT fills in missing values.
• NOT NULL makes a field required.
• UNIQUE stops duplicate values.

You use four main operations:

• INSERT to add data.
• SELECT to read data.
• UPDATE to change data.
• DELETE to remove data.

Always use WHERE with UPDATE and DELETE. You will change or erase every row if you forget.

Real apps use multiple tables. A project belongs to a client. Foreign keys link these tables. This keeps your data clean. The database stops you from adding a project to a client who does not exist.

Prisma provides a JavaScript API for these tasks. You do not need to write raw SQL.

Building in public. Week 3 of 16.

Source: https://dev.to/chinwuba_jeffrey/continuation-tables-crud-and-foreign-keys-1o1e