BraindeadSql

PRAGMA synchronous=OFF;
PRAGMA journal_mode=WAL;
PRAGMA temp_store=MEMORY;

DROP TABLE sometable;
CREATE TABLE sometable (entryid INTEGER);

BEGIN TRANSACTION;
 loop(...)  // A typical 15 loops to create my fields dynamically from a external file
 {
  ALTER TABLE ssometable ADD %s text;
 }

 loop(...) // Load data from file
 {
  INSERT INTO sometable ("entryid") VALUES ("%d"); // Create an unique id (counter++)
  UPDATE sometable SET %s=%s where entryid=%d;
  sqlite3_exec(db, query, callback, 0, &zErrMsg);
 }
COMMIT TRANSACTION;