I don’t have specific data related to MyRocks but SingleStore INSERT speeds are a unique strength of our system. We support truly phenomenal insert speeds. We don’t talk about it much anymore because we virtually always win against other SQL databases in INSERT/UPSERT comparisons. Here’s an older blog about it: Can S3 pipeline read new file named same as deleted file which was already processed by this pipeline?
Long story short, we can insert/upsert millions of rows per seconds pretty easily on a reasonable amount of hardware.
I’m not really sure what you’re looking for regarding masking. Perhaps you could add more details here.
We don’t currently support bi-temporal tables (time travel) as a built-in feature. You can use some application logic to model bi-temporal behavior but of course that adds application complexity. We have some interesting time series features. See FIRST, LAST, TIME_BUCKET, and SERIES TIMESTAMP features.
Recursive CTEs are actively being developed. I expect that we’ll ship them by the end of next summer, maybe sooner.
I don’t have a comparison of our columnstore engine to that of MariaDB, but ours is quite advanced and mature. We use batch-oriented and vectorized processing, SIMD instructions, and late materialization. We’re competitive with special-purpose cloud data warehouses that have state-of-the-art columnstores.
Check this out:
and this: