19. Using SQL with various database vendors Previous topic Parent topic Child topic Next topic

Radiator's SQL modules can be used with any Relational Database that is supported by a database specific DBD module or ODBC DBD module. Some examples are: Oracle, Microsoft SQL Server, PostgreSQL, MySQL, MariaDB, SQLite, Firebird, Sybase and Informix. Many of these databases have both: you can use a database specific DBD module or DBD::ODBC to connect to them.
We have not directly tested every one of these. We have tested some of them, and this section contains some tips about using Radiator with them. We supply some simple schemas with Radiator for a few databases. See the goodies/*Create.sql files in the distribution for more information about them. You will probably want to create a more elaborate schema to handle the tasks you need, and the schemas we supply should be regarded as a starting point only. You should probably consult with a Database Analyst to maximise the performance of your SQL database.