TODOs

TODOs for my SQL comparison page:

• Does the command line interface auto-commit, or not
• Viewing event log
• Getting a list of schemas
• COALESCE and similar functions
• Temporary table handling
• Is MySQL's CHAR behaviour perhaps really because MySQL changes CHAR to VARCHAR under certain circumstances?
• Recursion
• IDENTITY: How to grab the value of the generated identity? (see Frans Bouma's notes here for inspiration)
• Verify if a tool like rlwrap can make the brain-dead command-line processors work reasonably (thanks to Phil Pennock).
• COLLATION support
• better, more general, coverage of row value constructors
• getting meta-information (like list of tables) in non-CLI situations (e.g. add Lennarts hint)
• add info for more products (Ingres comes to mind, as does Firebird, Mimer, SQLite and MaxDB)
• batch SQL handling
• more documentation links
• quoting/escaping strings
• explicit NULL (DB2: exception; MSSQL: required...)
• explicit AS for column aliases: required, accepted or rejected
• comments
• single-quotes
• case sensitivity
• varchar max-sizes
• bulk-inserting
• select to a new table
• blob-stuff
• available numeric data types and their precisions
• see if MySQL's GROUP_CONCAT functionality is available in other DBMSes
• BETWEEN

Will probably have to split up the page at some point. First split should probably be into SQL and command line operations.

To Troels' home page.

Version control information: $Date: 2009-12-26 23:54:54 +0100 (Sat, 26 Dec 2009) $.