Procedural, Semiprocedural, and Declarative Programming
This chapter is about programming and your mindset. SQL allows procedural code modules to be kept in the schema and will work inside procedural host languages. Avoid programming SQL as if it is a procedural file system language—SQL is a declarative language and requires a different mindset.
6.1 Basics of Software Engineering
The basics of software engineering do not change in SQL. They are realized differently. Most of us (with the exceptions of those rare programmers who started in LISP, APL, FP, Haskell, or other exotic languages) learned a block structured programming language that evolved from Algol-60. The same principles that apply to procedural code still apply to them.
In the late ...
Get Joe Celko's SQL for Smarties, 4th Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
