poses a challenge for database tools such as SQL editors and query builders.
When faced with multiple databases, data tool developers typically either take
"least common denominator" approach and give minimal support for all databases,
or "hard code" deep support for one SQL dialect.
The SQL Development Tools project within the Eclipse Data Tools Platform
provides a new approach. The SQL Development Tools project includes a
and components that can provide deep support in data tools for any number of
databases and SQL dialects. This talk will give an overview of the SQL
models, and editor components, and how to use and extend them to create more
sophisticated SQL-aware data tools. Also included will be an introduction to
the new Query Builder tool being added to the SQL Development Tools project,
which makes use of these components.
Brian Payton, a software developer in IBM Information Management Software, has been developing database tools, particularly query builders, throughout his 20-plus years at IBM. He co-leads the SQL Development Tools project within the Eclipse Data Tools Platform project. Mr. Payton has a B.S. in Computer Science from California Polytechnic University, San Luis Obispo, and works at IBMâ€™s Silicon Valley Laboratory.