Record Detail Back
SQL Antipatterns Avoiding the Pitfalls of Database Programming
- Share to:
I hadn’t been taught SQL in school. Databases weren’t as ubiquitous as they are today, and open source brands like MySQL and PostgreSQL didn’t exist yet. But I had developed complete applications in shell, and I knew something about parsers, having done projects in classes like compiler design and computational linguistics. So, I thought about taking the job. How hard could it be to parse a single statement of a specialized language like SQL?
I found a reference for SQL and noticed immediately that this was a different sort of language from those that support statements like if() and while(), variable assignments and expressions, and perhaps functions. To call SELECT only one statement in that language is like calling an engine only one part of an automobile. Both sentences are literally true, but they certainly belie the complexity and depth of their subjects. To support execution of that single SQL statement, I realized I would have to develop all the code for a fully functional relational database management system and query engine.
Bill Karwin - Personal Name
978-1-934356-55-5
NONE
Information Technology
English
2012
1-37
LOADING LIST...
LOADING LIST...