Database schema for Chamilo 1.9.4

A lot of people have been asking for a database schema of Chamilo 1.9. Here it is. The editable format can be found in the documents for Chamilo LMS: http://support.chamilo.org/documents/57 The image itself weights 3.2MB and has a few colours…

More Details
Profiling MySQL/MariaDB queries

If you ever face an optimization issue in MySQL or MariaDB and want to know how to measure/benchmark the differences in execution between two queries, you should definitely know about the set profiling=1; command. Here is how it works: mysql>…

More Details
Database schema for Dokeos 1.8.6

The new database schema sheets are available for Dokeos 1.8.6. Considering we are now finalizing the first RC release, these schemas are final and can be considered complete until 1.8.7 is out. These diagrams have been made with Dia and…

More Details
Installing OpenERP on Ubuntu – Creating databases

Following up on my last piece of news about the update put in the OpenERP wiki about installation under Ubuntu, we have come across a problem today (we are still in our testing phase) as we couldn’t create more databases….

More Details