Introduction to a Small Application
Explore how to build a small PostgreSQL application by working with the Chinook database. Learn to load data using pgloader, understand the database schema, and compare the use of SQL versus classic application code for managing data and solving common programming tasks.
We'll cover the following...
We'll cover the following...
In this chapter, we’ll write a very basic application where we’re going to compare it by using either the classic application code or SQL to solve some common problems. Our goal in this chapter is to be confronted with managing SQL as part of a codebase and show when to use classic application code or SQL.
Chinook dataset
When we used the Chinook dataset first, it ...