git.net

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

Re: Using Cassandra as local db without cluster


>
> ---> 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.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.
> >
>