Evan Martin (evan) wrote in evan_tech,
Evan Martin
evan
evan_tech

sql

Why do we use SQL? It seems every serious user of SQL has some abstraction layer on top of the language, either DBI-style quoting (select x from y where z=?) or a fancier object layer. I recall that at least for compilation the lexing step takes a significant fraction of the processing time. So why not feed the database some sort of preparsed/binary query, and make this human-friendly text interface just part of a frontend that converts to database-speak? (See also: Graydon's work on an SQL extension for OCaml, which would have made it a compile-time error to generate a malformed query.)
Subscribe
  • Post a new comment

    Error

    default userpic
    When you submit the form an invisible reCAPTCHA check will be performed.
    You must follow the Privacy Policy and Google Terms of use.
  • 16 comments