What is a database?

Knowledge Videos

Short animated explainers, organised by subject.

What is a database?

A database keeps data in tables of rows and columns, like a strict spreadsheet. Primary keys, why data in a file survives a restart, and asking questions with SQL.

Try it

Transcript

A database stores data in tables. A table has columns, which are the labels, and rows, which are the records. It is like a very strict spreadsheet.

Every row has a primary key, a number that is different for every row. It lets you point at exactly one row, like row two.

A database lives in a file on the disk, not in memory. So when your Go program stops and starts again, the data is still there.

A database can also answer questions quickly, like: give me all the tasks that are not done. You ask in a language called S Q L.

Remember: a database keeps data in tables of rows and columns, a primary key identifies a row, the data survives a restart, and S Q L asks questions.

More in this series

1:23

40How a web server works

A web server waits on a port for requests and sends responses. Handlers, http.HandleFunc and ListenAndServe, and seeing the request in the browser.

Goserverporthandlerhttpbeginner
1:30

41Routes, methods and status codes

A route connects a path and a method to a handler. GET, POST and DELETE, the status codes 200, 201, 400, 404 and 500, and how Go answers 404.

GorouteGETPOSTstatus code404beginner
1:19

42A JSON API in Go

An API returns data instead of pages. A Go struct becomes JSON with struct tags, a handler writes it with json.NewEncoder, and the page loads it with fetch.

GoAPIJSONstruct tagfetchbeginner
1:21

43POST and saving data

A POST request carries data in its body. Decode the JSON into a struct, keep it in a slice (lost on restart), and protect the shared slice with a mutex.

GoPOSTrequest bodymutexJSONbeginner
1:01

45SQL basics

SQL is the language for asking a database: CREATE TABLE, INSERT INTO, SELECT with WHERE and ORDER BY, then UPDATE and DELETE (always with WHERE).

SQLSELECTINSERTWHEREdatabasebeginner
1:14

46Go and databases

Go talks to a SQLite database with database/sql and a driver. Exec changes data, Query reads rows into structs, and ? placeholders pass values safely.

Godatabase/sqlSQLiteQueryExecplaceholderbeginner
1:20

47Input, validation and safety

Never trust a request: validate empty and too-long values and answer 400, why ? placeholders stop SQL injection, and keep secrets and database files out of Git.

GovalidationSQL injectionsafetygitignorebeginner