These modules, together with such modules as Business Graphics and Wizard , makes it simple to do reports from databases as well as applications. Roxen also contains a module that uses a table stored in a SQL database for doing user authentication. Roxen needs a Pike module to be installed if it is to connect to a certain kind of SQL database. By default, modules for the free databases ODBC, mSQL, MySQL and Postgres are provided. The driver is one of informix, msql, mysql, postgres, odbc, oracle or sybase.
Some drivers treat the host differently.
The ODBC driver uses host as a name configured in the odbc.ini file. Symbolic names You do usually not want to specify a full database URL in a RXML tag. With the SQL Databases module you can give symbolic names to database URLs. This makes it unnecessary to have any database passwords in the actual web pages. It also makes it possible to change databases without changes to the pages.