Allow writting numeric vectors as BLOBs

[pr0m1th3as]

The current implementation only allows numeric scalars in a dbtable to be written in sqlite table.
The following results in error

>> db = sqlite ("newdb", 'create')
>> t = dbtable (1, [1, 2], 'VariableNames', {'idx','vector_data'})
t =

  1x2 table

  idx  vector_data
  ___  ___________

  1    1  2

>> sqlwrite (db, "vector", t, 'ColumnType', {'numeric', 'numeric'});
error: error executing statement `INSERT INTO vector (idx,vector_data) VALUES
(1,1  2)` - near "2": syntax error
error: called from
    execute at line 58 column 3
    sqlwrite at line 184 column 3

It would be very convenient if we could do something like

 sqlwrite (db, "vector", t, 'ColumnType', {'numeric', 'blob'});

which currently returns the same error as above, and be able to write/read/fetch non-scalar numeric data.

[lostbard]

I guess a question here would be on how should it handle the data.
A few 'how can i do this in matlab' seem to indicate converting the data to uint8 raw data and writing that to the blob.

But then on reading the data, what it should it do ? just return that uint8 binary data?

[pr0m1th3as]

IMHO, a reasonable approach would be to add class (eg double), ndims (eg 3) and dimsize (eg [3, 4, 5]) info at the beginning of the blob so that it can be converted back from uint8 to whatever the original data was.