Here is the thing. I'm modelling User entity and got to problem with
searching trough user columns.
CREATE TABLE users (
user_uuid uuid PRIMARY KEY,
date_created timestamp,
password varchar,
username varchar,
name varchar,
first_name varchar,
last_name varchar,
email varchar,
I think there is just a few solutions.
- Secondary index on username
- CF used as an index (store username as row and all the uuid of users with
this username as columns)
- Get all the data and filter after (really poor performances depending on
the size of the data set)
I can't see an other way