Hello, I am wondering if using cassandra as one local database without the cluster capabilities has a sens, (i cannot do multi node cluster due to a technical constraint)
I have an application with a purpose to store a dynamic number of colones on each rows (thing that i cannot do with classical relational database), and i don't want to use documents based nosql database to avoid using Json marshal and unmarshal treatments... Does cassandra with only one node and with a well designer model based on queries and partition keys can lead to best performance than postgresql ? Does cassandra have some limitation about the size of data ? about the number of partition on a node ? Thanks for any details or help. -- Best Regards.
