Category: Postgres/SQL

In a relational database, each table typically stores information about a single entity, such as ‘Student,’ ‘School,’ or ‘Teacher.’ The process of combining information stored in rows across multiple tables is achieved through a method called table join. The ANSI SQL standard defines the `JOIN … ON` command to execute table joins.

I decided to take a closer look at various lower-level technologies to improve my general knowledge about programming and the web. I used to work a lot with high-level abstractions, meta-frameworks, systems, and libraries like Next.js, GCP, TypeORM, or GraphQL. They greatly increase development speed and offer a lot of functionality out of the box,…