Adding new columns to the connection_msg table

[yalomoush]

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]

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.