v11, long term. Compatibility with future versions

[kuncevic]

Thank you for great extension ⭐

This is more a question rather than an issue.

As it seems, this extension was created as a follow-up to this discussion. The current major version of Directus is 11 tho as per documentation tested with Directus 10.10.4.

I wonder if this extension has been battle-tested with v11 and if it is safe to rely on that going forward, as it seems there is still no native functionality like that.

[br41nslug]

I havent personally tested the extension with v11 yet however it should work 🤔 None of the functionalities this extension relies on have been changed since 10.10 afaik

[kuncevic]

@br41nslug yeah I see, what do you think, are there any chances similar functionality will land in directus sometime in the future?

[br41nslug]

I somewhat doubt it considering the "best" (most performant) way to implement this is on the SQL level like (in postgres):

SELECT *
FROM my_collection
ORDER BY RANDOM();

But I am not sure this is consistently supported for all database providers supported by Directus.

[kuncevic]

@br41nslug does directus support running queries like that natively?

[br41nslug]

You can from within backend extensions like this, but when using raw SQL you'll have to be sure of the underlying database compatibility if you'd want to distribute that extension

[kuncevic]

just dig a bit deeper directus/directus#12452 tho this is the best pointer I've found so far directus/directus#3312