HDBC Features

• Ability to use replacable parameters to let one query be executed multiple times (eliminates the need for an escape function)
• Ability to access returned rows by column number
• Ability to read data from the SQL server on-demand rather than reading the entire result set up front
• HUnit testsuite for each backend driver
• Well-defined standard API and easy backend driver implementation
• Lazy reading of the entire result set (think hGetContents, but for the results of SELECT) (see sFetchAllRows)
• Support for translation between Haskell and SQL types
• Support for querying database server properties
• Add-on package (hdbc-missingh) to integrate with MissingH, providing a database backend for AnyDBM.
• Support for querying metadata such as column names.
• Support for querying additional metadata (column types, etc.)