Introduction

Start here
About Gabor
About Relational Databases
Initial setup

Basic Operations

Overview
Table operations
Fetching data
Inserting data
Updating data
Deleting data

Table joins

Overview
Join types
- Inner
- Outer

Indexes and constraints

Overview
Index types
Non index constraints

Stored procedures and triggers

Overview
Stored procedure
Trigger
Use cases

Supabase API

Overview
Auth
Fetch
Insert / Upsert
Delete
RPC - Remote procedure call

Addenda

How to read documentation pages

Practical introduction to relational databases

Indexes Compound

Jamstack Conference - Practical introduction to relational databases companion site by Gabor Javorszky. The source code is licensed MIT. The website content is licensed CC BY NC SA 4.0.