osdir.com

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Using Cassandra as local db without cluster


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.abf@xxxxxxxxx>
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.
>