[5.4] Query "sets"

[alexbowers]

Currently, in the database system we have a concept of array storage as json, however, sometimes this isn't ideal. Sometimes, a simple comma separated array would be fine.

This could be covered by casting to a set. Which will convert arrays to comma separated, and the comma separated to array again.

There are ways to query this for all databases supported by Laravel. Not all are native solutions, like mysql FIND_IN_SET. However, all work.

The workaround / alternative is this:

where name like 'string%' 
or name like '%,string' 
or name like '%,string,%' 
or name like 'string'

[alexbowers]

To be added to Eloquent:

Model::whereInSet($column, $value);
Model::orWhereInSet($column, $value);
Model::whereNotInSet($column, $value);
Model::orWhereNotInSet($column, $value);

[kamui545]

IMO, I would rather stick to JSON or a separate table to do that, I think this solution could lead to performance issues.

Edit: You can probably use a regex too, in order to make it possible in 1 where clause

[alexbowers]

If you know what your limit is per column, for example 3 keywords then an
extra table with joins etc is heavier than necessary.

It also gives the option for a user to structure their app in a slightly
different way if it makes sense for them to do so.

On 8 Nov 2016 5:22 am, "Emmanuel Maggion" notifications@github.com wrote:

IMO, I would rather stick to JSON or a separate table to do that, I think
this solution could lead to performance issues

—
You are receiving this because you authored the thread.
Reply to this email directly, view it on GitHub
#293 (comment),
or mute the thread
https://github.com/notifications/unsubscribe-auth/AAzc3ltf1dG799rgKnDUxEU3-TsJ7Ol7ks5q8AcVgaJpZM4Kr1Uy
.