Information Technology

SQL Antipatterns Avoiding the Pitfalls of Database Programming

---

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.

---

Availability

No copy data

Detail Information

Series Title

-

Call Number

-

Publisher

: ., 2012

Collation

1-37

Language

English

ISBN/ISSN

978-1-934356-55-5

Classification

NONE

Content Type

-

Media Type

-

Carrier Type

-

Edition

-

Subject(s)

SQL Antipatterns Avoiding the Pitfalls of Database

Specific Detail Info

-

Statement of Responsibility

-

Other version/related

File Attachment

Comments

---

You must be logged in to post a comment