Re: Using Cassandra as local db without cluster
Thanks for the infos, I will try aerospike also, they are always including a one node installation on there benchmarking and are also talking about vertical scalability. Kind regards. Le jeu. 18 oct. 2018 14:44, Aleksey Yeshchenko a écrit : > I agree with Jeff here. > > Furthermore, Cassandra should generally be your solution of last resort - > if nothing else works out. > > In your case I’d try sqlite or leveldb (or rocksdb). > > > On 18 Oct 2018, at 11:46, Jeff Jirsa wrote: > > > > I can’t think of a situation where I’d choose Cassandra as a database in > a single-host use case (if you’re sure it’ll never be more than one > machine). > > > > -- > > Jeff Jirsa > > > > > >> On Oct 18, 2018, at 12:31 PM, Abdelkrim Fitouri > 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. > > > > - > > To unsubscribe, e-mail: dev-unsubscr...@cassandra.apache.org > > For additional commands, e-mail: dev-h...@cassandra.apache.org > > > > > - > To unsubscribe, e-mail: dev-unsubscr...@cassandra.apache.org > For additional commands, e-mail: dev-h...@cassandra.apache.org > >
Re: Using Cassandra as local db without cluster
I agree with Jeff here. Furthermore, Cassandra should generally be your solution of last resort - if nothing else works out. In your case I’d try sqlite or leveldb (or rocksdb). > On 18 Oct 2018, at 11:46, Jeff Jirsa wrote: > > I can’t think of a situation where I’d choose Cassandra as a database in a > single-host use case (if you’re sure it’ll never be more than one machine). > > -- > Jeff Jirsa > > >> On Oct 18, 2018, at 12:31 PM, Abdelkrim Fitouri 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. > > - > To unsubscribe, e-mail: dev-unsubscr...@cassandra.apache.org > For additional commands, e-mail: dev-h...@cassandra.apache.org > - To unsubscribe, e-mail: dev-unsubscr...@cassandra.apache.org For additional commands, e-mail: dev-h...@cassandra.apache.org
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 > 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. > > >
Re: Using Cassandra as local db without cluster
I can’t think of a situation where I’d choose Cassandra as a database in a single-host use case (if you’re sure it’ll never be more than one machine). -- Jeff Jirsa > On Oct 18, 2018, at 12:31 PM, Abdelkrim Fitouri 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. - To unsubscribe, e-mail: dev-unsubscr...@cassandra.apache.org For additional commands, e-mail: dev-h...@cassandra.apache.org
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 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. >
Using Cassandra as local db without cluster
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.
