Search for a command to run...
Series
What is a Database? At a very basic level, a database is used to store information. We take data from some source, store it in a database (either in memory or on disk), and then retrieve that data later when we need it. Examples of data stored in dat...
In the previous discussion, we talked about the main challenges of working with PostgreSQL.Out of those challenges, we are going to focus on two important ones first: Writing efficient queries Designing the database structure (schema) In this blo...
Now that we have a basic database design, the next step is to write SQL to create our first table. In this lesson, we will create a table called cities with four columns: name country population area We will run all SQL inside Supabase using i...
In the previous section, we wrote our first SQL query to create a table in PostgreSQL. Now, let’s slow down a bit and understand what that SQL actually means. We’ll break the query into parts and understand the syntax step by step. The SQL We Wrote ...
Now that our cities table is ready, the next step is to add data into it. We want to store information about these cities: Tokyo Delhi Shanghai Sao Paulo Along with: country population area To do this, we will use SQL again. Using INSERT...
At this point, we have successfully stored data inside the cities table. Now the next step is to retrieve that data from the database. To do this, PostgreSQL provides the SELECT statement. The Basic SELECT Query The simplest way to fetch data from a...