Chapter 31 Further Reading

SQLite

  • SQLite Official Documentation: sqlite.org/docs.html — The definitive reference for SQLite syntax, data types, functions, and features. Particularly useful: the SQL syntax diagrams and the page on date/time functions.

  • SQLite Tutorial: sqlitetutorial.net — Beginner-friendly tutorial covering CREATE TABLE, INSERT, SELECT, UPDATE, DELETE, JOIN, GROUP BY, and subqueries with interactive examples.

Lazarus Database Programming

SQL and Database Design

  • Ben Forta, "SQL in 10 Minutes" (5th edition) — A concise, practical introduction to SQL. Each lesson takes about 10 minutes and covers one concept with examples.

  • C.J. Date, "An Introduction to Database Systems" — The comprehensive academic treatment of relational database theory. Covers normalization, relational algebra, and database design in depth.

  • OWASP SQL Injection Prevention Cheat Sheet: cheatsheetseries.owasp.org/cheatsheets/SQL_Injection_Prevention_Cheat_Sheet.html — Essential security reading. Explains SQL injection attacks and the parameterized query defense.

PostgreSQL and MySQL

  • PostgreSQL Documentation: postgresql.org/docs/ — If you graduate from SQLite to PostgreSQL, this is the reference.

  • MySQL Documentation: dev.mysql.com/doc/ — Reference for MySQL-specific syntax and features.

  • Free Pascal Wiki — SQLdb Connectors: wiki.freepascal.org/SQLdb_Package — Lists all available database connectors for Free Pascal, including PostgreSQL, MySQL, ODBC, Oracle, and Firebird.