linagora / twake-drive

The open-source alternative to Google Drive.
GNU Affero General Public License v3.0
52 stars 14 forks source link

[Improvement] Remove sortable identifiers from the users table #441

Open shepilov opened 4 months ago

shepilov commented 4 months ago

Context Right now we have to join queries in PostgreSQL like this if we want to find docs for the user

select * from ext.drive_files f
    where string_to_array(creator, '-') <@ string_to_array('11ee-ba16-ada1e820-959c-6f5013877a67', '-');

Because we rearrange string identifiers parts to make it sortable in Cassandra

TODO