search

elibom / mokai

Messaging Gateway
20 stars 15 forks source link

Adding new columns to the connection_msg table #49

Open yalomoush opened 11 years ago

yalomoush commented 11 years ago

Hi,

what if I want to add new key column like accountID to the connection_msg table. how can i add it? I think the idea of adding column thorugh the JSON (other column) is not recommended as the query using this column will affect the performance.

what about making the adding of table column dynamic. i.e. configurable through the configuration xml file?

germanescobar commented 11 years ago

The real problem is that a relational database is not the best fit for this scenario. This is why I'm working to support MongoDB which is a NoSql database so it doesn't have schema. You can even test it with some of the cloud vendors like MongoLab or MongoHQ.

Let me think about the dynamic columns. However, I think MongoDB is a much more flexible option and it also supports indexing.