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
-
Lazarus Wiki — SQLdb Tutorial: wiki.lazarus-ide.org/SQLdb_Tutorial1 — Step-by-step guide to connecting Lazarus to SQLite, PostgreSQL, and MySQL using SQLdb components.
-
Lazarus Wiki — Working with TDBGrid: wiki.lazarus-ide.org/Grids_Reference_Page — Reference for configuring TDBGrid columns, formatting, and events.
-
Lazarus Wiki — Data-Aware Controls: wiki.lazarus-ide.org/LCL_Data_Access — Overview of all data-aware controls: TDBEdit, TDBMemo, TDBComboBox, TDBNavigator, TDBImage, and more.
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.