Vectorized insert? about matlab-sqlite3-driver HOT 3 CLOSED

Well, the current design aims at storing structured data (i.e., struct array) but not a simple vector since they usually don't need to be indexed by database. If you like, I'd recommend storing vectors as a BLOB using serialization. https://github.com/kyamagu/matlab-serialization

from matlab-sqlite3-driver.

Using transactions helps a bit.

I was evaluating sqlite to use as a data interchange format (vs. text files). For these files, I want easy append functionality and vector writes.

Using transactions helps.

sqlite3.execute(db,'begin transaction');
for i=1:numel(v);
    sqlite3.execute(db,'insert into v(v) values (?)', v(i));
end
sqlite3.execute(db,'commit');

from matlab-sqlite3-driver.

If the vector is not too long, you can also generate comma-separated values in insert statement.

values = sprintf('(%g),', v);
sqlite3.execute(['insert into v(v) values ', values(1:end-1)]);

from matlab-sqlite3-driver.