event_idis a Primary key to the table
Eventsand a Foreign key on the table
textand it will store anything you want if encoded in JSON.
INTEGER PRIMARY KEYis synonymous with
ROWIDwhich is an autoincrement fields that do not need to be set during insert.
EXECfunction like so:
REDISQL.EXECis a list of two elements, the string
DONEand the integer representing the number of rows modified (inserted, deleted or updated).
REDISQL.EXECagainst the database or that you can embed into a statement.
typeof the JSON stored into the columns
dataif this fields contains the string "sales" it will return the user who bought something and total of the sale.
json_extractworks also on array using a simple syntax:
$.array(eg. extract the third element of the array)