Hello SingleStore Community,
We are looking into options for a DBMS that can serve application purposes (CRUD), but also analytics and reporting on that data. We’re migrating away from a proprietary setup.
Currently we are looking between SingleStore and MariaDB. SS appears to have some interesting perfomance promises for large analytical workloads. On the other hand, I have some questions on things I can’t immediately find an anwser online and I’m interested to get some extra information on these topics:
How performant is the SS Rowstore engine in insert speeds compared to MyRocks for example? Any tuning best practices? Can RocksDB be added as a plugin engine to SS?
I see no option for data masking and GDPR compliance from an above-DBMS level in SS. Ideally, we’d be able to apply a sort of JSON configmap on the machine/server level that (partially) masks some fields without having to touch SQL itself through partial views for example. This would allow a better separation of strict DBA and business query roles.
For some of our applications (bi)temporal tables are in use. System-versioning by itself however would be nice already. Is this in the development scope the coming years?
Recursive CTEs are time saving when working with hierarchical data.
Lastly, is there any comparison available between the SS ColumnStore engine and the ColumnStore by MariaDB? Pro’s and cons of each, can be like a very short ELI5 post. I just can’t find much about it online.