Input, 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.
Transcript
Never trust what arrives in a request. A visitor can send an empty title, a huge one, or something that is not even J S O N.
Validate before you save. Check for empty values and too long ones, and answer with a four hundred and a clear message.
A bad visitor might send S Q L code as a title, to trick your database. This is called S Q L injection. Placeholders stop it, because the value is always treated as plain text.
Keep secrets, like passwords and keys, out of your code and out of Git. Put the database file and secret files in dot gitignore, and use made up data when you test.
Remember: never trust input, validate and answer with four hundred, use placeholders against injection, and keep secrets out of Git.
More in this series
1:2340How 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.
1:3041Routes, 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.
1:1942A 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.
1:2143POST 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.
1:1744What 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.
1:0145SQL 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).
1:1446Go 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.