2 ms·
The array is stored in full and it's contents are also parsed and stored separately to enable the following queries (pseudo code) to be performed: Get user's s
by wilsonfiifi 13y ago
The array is stored in full and it's contents are also parsed and stored separately to enable the following queries (pseudo code) to be performed:
Get user's skills:
Select row where path == 'skills' and 'objected' column == (uuid)
Get user's skill at index 0:
Select row where path = 'skills.[0]' and 'objected' column == (uuid)
Get all users whose skills contain 'combat':
Select rows where path starts with 'skills.[*]' and 'combat' in 'values' column
- lutusp 13y agoYes, that's fine, unless you plan to use a database engine like MySQL that doesn't support arrays. You have the option of using an SQL statement that doesn't require the fields to be in the same array. In other words, don't let your logic be defined by something that databases don't support.