✳flâneur — a map of the web's best reading

Tables and Data | Supabase Docs

supabase.com · 2,563 words · saved by 1 readers

Tables are similar to excel spreadsheets. They contain columns and rows. For example, this table has 3 "columns" (id, name, description) and 4 "rows" of data: There are a few important differences from a spreadsheet, but it's a good starting point if you're new to Relational databases. When creating a table, it's best practice to add columns at the same time. You must define the "data type" of each column when it is created. You can add and remove columns at any time after creating a table. Supabase provides several options for creating tables. You can use the Dashboard or create them directly using SQL. We provide a SQL editor within the Dashboard, or you can connect to your database and run the SQL queries yourself. When naming tables, use lowercase and underscores instead of spaces (e.g., table_name, not Table Name). You must define the "data type" when you create a column. Every column is a predefined type. PostgreSQL provides many default types, and you can even design your own (o

Tables are where you store your data. Tables are similar to excel spreadsheets. They contain columns and rows. For example, this table has 3 "columns" ( id , name , description ) and 4 "rows" of data: id name description 1 The Phantom Menace Two Jedi escape a hostile blockade to find allies and come across a young boy who may bring balance to the Force. 2 Attack of the Clones Ten years after the invasion of Naboo, the Galactic Republic is facing a Separatist movement. 3 Revenge of the Sith As Obi-Wan pursues a new threat, Anakin acts as a double agent between the Jedi Council and Palpatine and

Explore this link on the map →

related reading