> > ---> 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 >
Thanks for these details, but what do you mean about the cardinality of the collection is not too big ? In my solution a collection can have between 5 elements and 500 elements and an element is about 256 caracter. Kind regards. 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. > > >
