Does MemSQL have k value storage just like Redis? According to this image I keep seeing, it does. I just can’t figure out how to query it or what the structure really looks like.
Would the same in MemSQL be rowstore or columnstore or singlestore? They all three seem alike, but Rowstore and Singlestore seem like the ones that are most like Redis. I need them to be in-memory!
I’m confused and can’t find the answers in the docs.
Thank you!
To make a key/value store (like Redis), create a table with 2 columns: a varchar primary key column and a varbinary or longtext value column depending on if you’re storing text or non-text data. See Data Types · SingleStore Documentation Because you’ll likely only lookup by primary key, any table type would work. For very large tables, rowstore is best for transactional use (random reads & writes), and columnstore is best for analytical use (bulk reads & writes). Singlestore is a new feature in MemSQL 7.0 that removes this choice, dynamically assuming the proper table type based on usage.
Okay, thank you so much!