Database DesignThinking in entitiesLesson 16 / 69

What is a database?

Docs15 min

What is a database?

Files hold data badly the moment two things need it at once. A database is a program whose whole job is storing data safely and handing it back fast:

  • It persists — data survives restarts.
  • It concurrent — many readers and writers at once without corruption.
  • It queries — ask questions in SQL instead of writing search code.

In this roadmap you will use PostgreSQL — the same engine behind this very app. Everything you design in this course becomes real tables in the next courses, so treat every diagram as a rehearsal for production.

Exercise

Write down three things an app you use stores about you. For each, guess: is it a fact about you, or a fact about an event involving you?