Single Database

[ssiddireddy]

We have been experiementing first with Dokeos and now Chamilo. Every thing looked good except one which is creating a new database for every course. It is scary to see one database per course as it can cause lot of database related problems as more and more courses are added to the system. I saw that there is support for single database, but it is not recommeneded and may not work right. So please enhance the single database mode which is really important to us and I am sure for many other people too.

[Fangstrom]

Agree.

The biggest problem with multiply databases thoe is from a administration point of view i think.

It´s not that easy to get a good overview of it.

It could cause som database related problems to but with a healthy back up plan you should at least be safe.

[ssiddireddy]

Excellent! I can't wait any more to get my hands on 2.0? One database is the way to go! Thanks

[Fangstrom]

Awesome!

When do you think the 2.0 will be released?

[ywarnier]

Hi ssiddireddy,

Effectively, single database mode is not recommended in production in Chamilo 1.8, mostly because it is only a hack to allow for people to have Chamilo installed in free/cheap hosting packages (in fact, it creates the same total number of tables, which is even worst than one database per course).

Although we are totally conscious that the current mode is not a correct database design decision (it was made in early 2002), it is extremely difficult (and dangerous) to fix and to return to single database mode (we've been preparing this switch for a long time but lack highly skilled human resources to do it).

This being said, we have seen a system with 30000 courses running live on a Pentium 3 with 2GB of RAM, so I don't think this is sooo alarming altogether.

And as Kariboe said, this is fixed in Chamilo 2.0 (coming out within a few days).

Yannick Warnier, development coordinator for Chamilo 1.8

[Thayne]

First Chamilo rocks!

Most hosting companies limit the number of tables, some limit the number of databases, while others limit the size of the database.

It would be nice to have an advanced walkthrough showing how to customize chamilo for each type.

Sqlite would also be a super path to go down as most hosting companies will allow sqlite files to grow and will not limit sqlite in the same way as mysql.

[nblocry]

you cannot customize it.
it only uses one database and the number of tables depends on the number of optional applications and content objects you install.

[ssiddireddy]

We have been experiementing first with Dokeos and now Chamilo. Every thing looked good except one which is creating a new database for every course. It is scary to see one database per course as it can cause lot of database related problems as more and more courses are added to the system. I saw that there is support for single database, but it is not recommeneded and may not work right. So please enhance the single database mode which is really important to us and I am sure for many other people too.

[Fangstrom]

Agree.

The biggest problem with multiply databases thoe is from a administration point of view i think.

It´s not that easy to get a good overview of it.

It could cause som database related problems to but with a healthy back up plan you should at least be safe.

[ssiddireddy]

Excellent! I can't wait any more to get my hands on 2.0? One database is the way to go! Thanks

[Fangstrom]

Awesome!

When do you think the 2.0 will be released?

[ywarnier]

Hi ssiddireddy,

Effectively, single database mode is not recommended in production in Chamilo 1.8, mostly because it is only a hack to allow for people to have Chamilo installed in free/cheap hosting packages (in fact, it creates the same total number of tables, which is even worst than one database per course).

Although we are totally conscious that the current mode is not a correct database design decision (it was made in early 2002), it is extremely difficult (and dangerous) to fix and to return to single database mode (we've been preparing this switch for a long time but lack highly skilled human resources to do it).

This being said, we have seen a system with 30000 courses running live on a Pentium 3 with 2GB of RAM, so I don't think this is sooo alarming altogether.

And as Kariboe said, this is fixed in Chamilo 2.0 (coming out within a few days).

Yannick Warnier, development coordinator for Chamilo 1.8

[Thayne]

First Chamilo rocks!

Most hosting companies limit the number of tables, some limit the number of databases, while others limit the size of the database.

It would be nice to have an advanced walkthrough showing how to customize chamilo for each type.

Sqlite would also be a super path to go down as most hosting companies will allow sqlite files to grow and will not limit sqlite in the same way as mysql.

[nblocry]

you cannot customize it.
it only uses one database and the number of tables depends on the number of optional applications and content objects you install.