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),
---> Postgresql allows you tu use array type or map type with dynamic number of records, provided of course that the cardinality of the collection is not "too" big On Thu, Oct 18, 2018 at 12:31 PM Abdelkrim Fitouri <abdou....@gmail.com> wrote: > 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. >