cosmopterix

Named after the Cosmopteriginae family of moths.

A set of Docker containers for each of the main database platforms providing a common framework for creating and configuring test databases.

The framework makes it easy to compare the same set of SQL queries across all of the database platforms to see how they handle different query constructs, enabling us to test if proposed changes to the ADQL language will be implemetable on all of the target platforms.

Cross platform SQL tests :

• OFFSET and LIMIT
• MOD for -ve numbers
• Unnamed-columns

Working containers for :

• PostgreSQL
• MySQL
• MariaDB
• Apache Derby
• HyperSQL

Work in progress for :

• Oracle Xe
• SQLite

Plans for :

• SQLServer
• Firebird
• Sybase
• DB2
• Qserv
• SpiderEngine
• Oracle TimesTen

The work involved in this project has received funding from the following sources :

• The European Community's Seventh Framework Programme (FP7-SPACE-2013-1) under grant agreement n°606740, Gaia GENIUS
• The European Commission Framework Programme Horizon 2020 Research and Innovation action under grant agreement n°653477, ASTERICS
• The UK Science and Technology Facilities Council under grant numbers ST/M001989/1, ST/M007812/1, and ST/N005813/1