SQL back-end

ToutDoux uses an SQL back-end for tempory data storage. As a result, it can benefit from the powerful SQL language and reliable software like PostgreSQL.

ToutDoux is capable of using MySQL as a local database manager. However, since MySQL doesn't support sub-queries, it imposes an SQL-specific development on modules. This is unfortunate, since MySQL is better adapted than PostgreSQL for managing an SQL backend in a local application. Such support may come with the next version of MySQL (v4.00).

The SQL back-end requirements are :

The unix user (in this case 'toto') must be able to create and delete a database :